批量打印学生信息表.docx

资源描述

批量打印学生信息表.docx

《批量打印学生信息表.docx》由会员分享，可在线阅读，更多相关《批量打印学生信息表.docx（18页珍藏版）》请在冰豆网上搜索。

批量打印学生信息表.docx

批量打印学生信息表

代码：

usingSystem;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Data;

usingSystem.Drawing;

usingSystem.Linq;

usingSystem.Text;

usingSystem.Windows.Forms;

usingSystem.Data.SqlClient;

usingSystem.IO;

namespacePrintStuResume

{

publicpartialclassfrmMain:

Form

{

publicfrmMain（）

{

InitializeComponent（）;

}

#region定义全局变量及对象

stringstrCon="DataSource=（local）;Database=db_04;Uid=sa;Pwd=;";

publicstaticstringstrName="";

publicstaticstringstrSex="";

publicstaticstringstrBirthday="";

publicstaticstringstrNPlace="";

publicstaticstringstrAddress="";

publicstaticstringstrNation="";

publicstaticstringstrSGao="";

publicstaticstringstrTZhong="";

publicstaticstringstrHunYin="";

publicstaticImageimgPhoto=null;

publicstaticstringstrGZJL="";

publicstaticstringstrBYYX="";

publicstaticstringstrXUELLI="";

publicstaticstringstrBYSJ="";

publicstaticstringstrZHUANYE="";

publicstaticstringstrWAIYU="";

publicstaticstringstrYPZW="";

publicstaticstringstrGZNX="";

publicstaticstringstrQZLX="";

publicstaticstringstrSalary="";

publicstaticstringstrGZDQ="";

publicstaticstringstrTECHANG="";

publicstaticstringstrTel="";

publicstaticstringstrEmail="";

SqlConnectionsqlcon;

SqlCommandsqlcmd;

SqlDataAdaptersqlda;

DataSetmyds;

#endregion

//窗体初始化时，自动编号并显示所有学生信息

privatevoidForm1_Load（objectsender,EventArgse）

{

sqlcon=getCon（）;

SqlCommandsqlcmd=newSqlCommand（"proc_AutoID",sqlcon）;

sqlcmd.CommandType=CommandType.StoredProcedure;

SqlParameteroutValue=sqlcmd.Parameters.Add（"@newID",SqlDbType.VarChar,20）;

outValue.Direction=ParameterDirection.Output;

sqlcmd.ExecuteNonQuery（）;

sqlcon.Close（）;

txtID.Text=outValue.Value.ToString（）;

dgvInfo.DataSource=SelectStuInfo（"",""）.Tables[0];

cboxHunYin.SelectedIndex=cboxNation.SelectedIndex=cboxQZLX.SelectedIndex=cboxSex.SelectedIndex=cboxXueLi.SelectedIndex=0;

}

//选择学生头像

privatevoidbutton1_Click（objectsender,EventArgse）

{

//定义可选择的头像类型

openFileDialog1.Filter="*.jpg,*jpeg,*.bmp,*.ico,*.png,*.tif,*.wmf|*.jpg;*jpeg;*.bmp;*.ico;*.png;*.tif;*.wmf";

openFileDialog1.Title="选择头像";

//判断是否选择了头像

if（openFileDialog1.ShowDialog（）==DialogResult.OK）

{

//显示选择的学生头像

pictureBox1.Image=Image.FromFile（openFileDialog1.FileName）;

}

//添加学生信息

privatevoidbutton2_Click（objectsender,EventArgse）

{

sqlcon=getCon（）;

sqlcmd=newSqlCommand（"proc_InsertStuInfo",sqlcon）;

sqlcmd.CommandType=CommandType.StoredProcedure;

sqlcmd.Parameters.Add（"@id",SqlDbType.VarChar,20）.Value=txtID.Text;

sqlcmd.Parameters.Add（"@name",SqlDbType.VarChar,20）.Value=txtName.Text;

sqlcmd.Parameters.Add（"@sex",SqlDbType.Char,4）.Value=cboxSex.Text;

sqlcmd.Parameters.Add（"@birthday",SqlDbType.SmallDateTime）.Value=Convert.ToDateTime（mtxtBirthday.Text）;

sqlcmd.Parameters.Add（"@nplace",SqlDbType.VarChar,200）.Value=txtNPlace.Text;

sqlcmd.Parameters.Add（"@address",SqlDbType.VarChar,200）.Value=txtAddress.Text;

sqlcmd.Parameters.Add（"@nation",SqlDbType.VarChar,20）.Value=cboxNation.Text;

sqlcmd.Parameters.Add（"@sgao",SqlDbType.Int）.Value=Convert.ToInt32（txtShenGao.Text）;

sqlcmd.Parameters.Add（"@tzhong",SqlDbType.Int）.Value=Convert.ToInt32（txtTiZhong.Text）;

sqlcmd.Parameters.Add（"@hunyin",SqlDbType.Char,4）.Value=cboxHunYin.Text;

if（openFileDialog1.FileName!

=""）

{

FileStreamFStream=newFileStream（openFileDialog1.FileName,FileMode.Open,FileAccess.Read）;

BinaryReaderBReader=newBinaryReader（FStream）;

byte[]byteImage=BReader.ReadBytes（（int）FStream.Length）;

sqlcmd.Parameters.Add（"@photo",SqlDbType.Image）.Value=byteImage;

}

else

sqlcmd.Parameters.Add（"@photo",SqlDbType.Image）.Value=null;

sqlcmd.Parameters.Add（"@gzjl",SqlDbType.Text）.Value=rtxtGZJL.Text;

sqlcmd.Parameters.Add（"@byyx",SqlDbType.VarChar,100）.Value=txtBYYX.Text;

sqlcmd.Parameters.Add（"@xueli",SqlDbType.Char,10）.Value=cboxXueLi.Text;

sqlcmd.Parameters.Add（"@rxsj",SqlDbType.SmallDateTime）.Value=Convert.ToDateTime（mtxtRXSJ.Text）;

sqlcmd.Parameters.Add（"@bysj",SqlDbType.SmallDateTime）.Value=Convert.ToDateTime（mtxtBYSJ.Text）;

sqlcmd.Parameters.Add（"@zhuanye",SqlDbType.VarChar,50）.Value=txtZhuanYe.Text;

sqlcmd.Parameters.Add（"@waiyu",SqlDbType.VarChar,20）.Value=txtWaiYu.Text;

sqlcmd.Parameters.Add（"@ypzw",SqlDbType.VarChar,50）.Value=txtYPZW.Text;

sqlcmd.Parameters.Add（"@gznx",SqlDbType.Int）.Value=Convert.ToInt32（txtGZNX.Text）;

sqlcmd.Parameters.Add（"@qzlx",SqlDbType.Char,4）.Value=cboxQZLX.Text;

sqlcmd.Parameters.Add（"@salary",SqlDbType.Int）.Value=Convert.ToInt32（txtSalary.Text）;

sqlcmd.Parameters.Add（"@gzdq",SqlDbType.VarChar,50）.Value=txtGZDQ.Text;

sqlcmd.Parameters.Add（"@techang",SqlDbType.Text）.Value=rtxtTC.Text;

sqlcmd.Parameters.Add（"@tel",SqlDbType.VarChar,20）.Value=txtTel.Text;

sqlcmd.Parameters.Add（"@email",SqlDbType.VarChar,50）.Value=txtEmail.Text;

SqlParameterreturnValue=sqlcmd.Parameters.Add（"@returnValue",SqlDbType.Int）;

returnValue.Direction=ParameterDirection.ReturnValue;

sqlcmd.ExecuteNonQuery（）;

sqlcon.Close（）;

intint_returnValue=（int）returnValue.Value;

if（int_returnValue==0）

MessageBox.Show（"已经存在该学生编号！

","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning）;

else

MessageBox.Show（"学生信息——添加成功！

","提示",MessageBoxButtons.OK,MessageBoxIcon.Information）;

dgvInfo.DataSource=SelectStuInfo（"",""）.Tables[0];

}

//修改学生信息

privatevoidbutton3_Click（objectsender,EventArgse）

{

try

{

sqlcon=getCon（）;

sqlcmd=newSqlCommand（"proc_UpdateStuInfo",sqlcon）;