📄 frmpeoplemanage.cs
字号:
this.TextBox12.Size = new System.Drawing.Size(64, 21);
this.TextBox12.TabIndex = 27;
this.TextBox12.Text = "";
//
// SqlUpdateCommand1
//
this.SqlUpdateCommand1.CommandText = "UPDATE 职员基本信息表 SET 职员编号 = @职员编号, 姓名 = @姓名, 姓名简码 = @姓名简码, 性别 = @性别, 出生日期 = @出生日期, " +
"年龄 = @年龄, 籍贯 = @籍贯, 民族 = @民族, 文化程度 = @文化程度, 毕业学校 = @毕业学校, 健康状况 = @健康状况, 婚姻状况 = @" +
"婚姻状况, 身份证号码 = @身份证号码, 家庭电话 = @家庭电话, 办公电话 = @办公电话, 手机 = @手机, 电子邮件地址 = @电子邮件地址, 职工" +
"账号 = @职工账号, 单位编号 = @单位编号, 备注 = @备注 WHERE (职员编号 = @Original_职员编号) AND (健康状况 = @Or" +
"iginal_健康状况 OR @Original_健康状况 IS NULL AND 健康状况 IS NULL) AND (出生日期 = @Original_出生" +
"日期 OR @Original_出生日期 IS NULL AND 出生日期 IS NULL) AND (办公电话 = @Original_办公电话 OR @Or" +
"iginal_办公电话 IS NULL AND 办公电话 IS NULL) AND (单位编号 = @Original_单位编号 OR @Original_单位" +
"编号 IS NULL AND 单位编号 IS NULL) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND " +
"备注 IS NULL) AND (姓名 = @Original_姓名) AND (姓名简码 = @Original_姓名简码 OR @Original_姓名简码" +
" IS NULL AND 姓名简码 IS NULL) AND (婚姻状况 = @Original_婚姻状况 OR @Original_婚姻状况 IS NULL " +
"AND 婚姻状况 IS NULL) AND (家庭电话 = @Original_家庭电话 OR @Original_家庭电话 IS NULL AND 家庭电话 " +
"IS NULL) AND (年龄 = @Original_年龄 OR @Original_年龄 IS NULL AND 年龄 IS NULL) AND (性别 " +
"= @Original_性别 OR @Original_性别 IS NULL AND 性别 IS NULL) AND (手机 = @Original_手机 OR" +
" @Original_手机 IS NULL AND 手机 IS NULL) AND (文化程度 = @Original_文化程度 OR @Original_文化" +
"程度 IS NULL AND 文化程度 IS NULL) AND (毕业学校 = @Original_毕业学校 OR @Original_毕业学校 IS NUL" +
"L AND 毕业学校 IS NULL) AND (民族 = @Original_民族 OR @Original_民族 IS NULL AND 民族 IS NUL" +
"L) AND (电子邮件地址 = @Original_电子邮件地址 OR @Original_电子邮件地址 IS NULL AND 电子邮件地址 IS NULL" +
") AND (籍贯 = @Original_籍贯 OR @Original_籍贯 IS NULL AND 籍贯 IS NULL) AND (职工账号 = @Or" +
"iginal_职工账号 OR @Original_职工账号 IS NULL AND 职工账号 IS NULL) AND (身份证号码 = @Original_身" +
"份证号码 OR @Original_身份证号码 IS NULL AND 身份证号码 IS NULL); SELECT 内部编号, 职员编号, 姓名, 姓名简码," +
" 性别, 出生日期, 年龄, 籍贯, 民族, 文化程度, 毕业学校, 健康状况, 婚姻状况, 身份证号码, 家庭电话, 办公电话, 手机, 电子邮件地址, 职工" +
"账号, 单位编号, 备注 FROM 职员基本信息表 WHERE (职员编号 = @职员编号)";
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职员编号", System.Data.SqlDbType.VarChar, 30, "职员编号"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名简码", System.Data.SqlDbType.VarChar, 10, "姓名简码"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@性别", System.Data.SqlDbType.VarChar, 2, "性别"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出生日期", System.Data.SqlDbType.Int, 4, "出生日期"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@年龄", System.Data.SqlDbType.Int, 4, "年龄"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@籍贯", System.Data.SqlDbType.VarChar, 50, "籍贯"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@民族", System.Data.SqlDbType.VarChar, 20, "民族"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@文化程度", System.Data.SqlDbType.VarChar, 50, "文化程度"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@毕业学校", System.Data.SqlDbType.VarChar, 100, "毕业学校"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@健康状况", System.Data.SqlDbType.VarChar, 50, "健康状况"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@婚姻状况", System.Data.SqlDbType.VarChar, 10, "婚姻状况"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@身份证号码", System.Data.SqlDbType.VarChar, 18, "身份证号码"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@家庭电话", System.Data.SqlDbType.VarChar, 50, "家庭电话"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@办公电话", System.Data.SqlDbType.VarChar, 50, "办公电话"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@手机", System.Data.SqlDbType.VarChar, 50, "手机"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电子邮件地址", System.Data.SqlDbType.VarChar, 50, "电子邮件地址"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职工账号", System.Data.SqlDbType.VarChar, 20, "职工账号"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位编号", System.Data.SqlDbType.VarChar, 20, "单位编号"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职员编号", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职员编号", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_健康状况", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "健康状况", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_出生日期", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "出生日期", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_办公电话", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "办公电话", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位编号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位编号", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "备注", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名简码", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名简码", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_婚姻状况", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "婚姻状况", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_家庭电话", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "家庭电话", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_年龄", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "年龄", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_性别", System.Data.SqlDbType.VarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "性别", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_手机", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "手机", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_文化程度", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "文化程度", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_毕业学校", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "毕业学校", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_民族", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "民族", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电子邮件地址", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电子邮件地址", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_籍贯", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "籍贯", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职工账号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职工账号", System.Data.DataRowVersion.Original, null));
this.SqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_身份证号码", System.Data.SqlDbType.VarChar, 18, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "身份证号码", System.Data.DataRowVersion.Original, null));
//
// ToolBar1
//
this.ToolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
this.tbbSave,
this.tbbDel});
this.ToolBar1.ButtonSize = new System.Drawing.Size(23, 22);
this.ToolBar1.DropDownArrows = true;
this.ToolBar1.ImageList = this.ImageList1;
this.ToolBar1.Location = new System.Drawing.Point(0, 0);
this.ToolBar1.Name = "ToolBar1";
this.ToolBar1.ShowToolTips = true;
this.ToolBar1.Size = new System.Drawing.Size(592, 28);
this.ToolBar1.TabIndex = 15;
this.ToolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.ToolBar1_ButtonClick);
//
// tbbSave
//
this.tbbSave.ImageIndex = 0;
this.tbbSave.ToolTipText = "保存修改记录或新增记录";
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand2;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand2;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand2;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "职员基本信息表", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("内部编号", "内部编号"),
new System.Data.Common.DataColumnMapping("职员编号", "职员编号"),
new System.Data.Common.DataColumnMapping("姓名", "姓名"),
new System.Data.Common.DataColumnMapping("姓名简码", "姓名简码"),
new System.Data.Common.DataColumnMapping("性别", "性别"),
new System.Data.Common.DataColumnMapping("出生日期", "出生日期"),
new System.Data.Common.DataColumnMapping("年龄", "年龄"),
new System.Data.Common.DataColumnMapping("籍贯", "籍贯"),
new System.Data.Common.DataColumnMapping("民族", "民族"),
new System.Data.Common.DataColumnMapping("文化程度", "文化程度"),
new System.Data.Common.DataColumnMapping("毕业学校", "毕业学校"),
new System.Data.Common.DataColumnMapping("健康状况", "健康状况"),
new System.Data.Common.DataColumnMapping("婚姻状况", "婚姻状况"),
new System.Data.Common.DataColumnMapping("身份证号码", "身份证号码"),
new System.Data.Common.DataColumnMapping("家庭电话", "家庭电话"),
new System.Data.Common.DataColumnMapping("办公电话", "办公电话"),
new System.Data.Common.DataColumnMapping("手机", "手机"),
new System.Data.Common.DataColumnMapping("电子邮件地址", "电子邮件地址"),
new System.Data.Common.DataColumnMapping("职工账号", "职工账号"),
new System.Data.Common.DataColumnMapping("单位编号", "单位编号"),
new System.Data.Common.DataColumnMapping("备注", "备注")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand2;
//
// sqlDeleteCommand2
//
this.sqlDeleteCommand2.CommandText = @"DELETE FROM 职员基本信息表 WHERE (职员编号 = @Original_职员编号) AND (健康状况 = @Original_健康状况 OR @Original_健康状况 IS NULL AND 健康状况 IS NULL) AND (内部编号 = @Original_内部编号) AND (出生日期 = @Original_出生日期 OR @Original_出生日期 IS NULL AND 出生日期 IS NULL) AND (办公电话 = @Original_办公电话 OR @Original_办公电话 IS NULL AND 办公电话 IS NULL) AND (单位编号 = @Original_单位编号 OR @Original_单位编号 IS NULL AND 单位编号 IS NULL) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (姓名 = @Original_姓名) AND (姓名简码 = @Original_姓名简码 OR @Original_姓名简码 IS NULL AND 姓名简码 IS NULL) AND (婚姻状况 = @Original_婚姻状况 OR @Original_婚姻状况 IS NULL AND 婚姻状况 IS NULL) AND (家庭电话 = @Original_家庭电话 OR @Original_家庭电话 IS NULL AND 家庭电话 IS NULL) AND (年龄 = @Original_年龄 OR @Original_年龄 IS NULL AND 年龄 IS NULL) AND (性别 = @Original_性别 OR @Original_性别 IS NULL AND 性别 IS NULL) AND (手机 = @Original_手机 OR @Original_手机 IS NULL AND 手机 IS NULL) AND (文化程度 = @Original_文化程度 OR @Original_文化程度 IS NULL AND 文化程度 IS NULL) AND (毕业学校 = @Original_毕业学校 OR @Original_毕业学校 IS NULL AND 毕业学校 IS NULL) AND (民族 = @Original_民族 OR @Original_民族 IS NULL AND 民族 IS NULL) AND (电子邮件地址 = @Original_电子邮件地址 OR @Original_电子邮件地址 IS NULL AND 电子邮件地址 IS NULL) AND (籍贯 = @Original_籍贯 OR @Original_籍贯 IS NULL AND 籍贯 IS NULL) AND (职工账号 = @Original_职工账号 OR @Original_职工账号 IS NULL AND 职工账号 IS NULL) AND (身份证号码 = @Original_身份证号码 OR @Original_身份证号码 IS NULL AND 身份证号码 IS NULL)";
this.sqlDeleteCommand2.Connection = this.sqlConnection1;
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职员编号", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职员编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_健康状况", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "健康状况", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_内部编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "内部编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_出生日期", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "出生日期", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_办公电话", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "办公电话", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位编号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "备注", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名简码", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名简码", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_婚姻状况", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "婚姻状况", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_家庭电话", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "家庭电话", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_年龄", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "年龄", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_性别", System.Data.SqlDbType.VarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "性别", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_手机", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "手机", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_文化程度", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "文化程度", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_毕业学校", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "毕业学校", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_民族", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "民族", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电子邮件地址", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电子邮件地址", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_籍贯", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "籍贯", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_职工账号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "职工账号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_身份证号码", System.Data.SqlDbType.VarChar, 18, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "身份证号码", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=ACER;packet size=4096;integrated security=SSPI;data source=ACER;pe" +
"rsist security info=False;initial catalog=hrmbook";
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = @"INSERT INTO 职员基本信息表(职员编号, 姓名, 姓名简码, 性别, 出生日期, 年龄, 籍贯, 民族, 文化程度, 毕业学校, 健康状况, 婚姻状况, 身份证号码, 家庭电话, 办公电话, 手机, 电子邮件地址, 职工账号, 单位编号, 备注) VALUES (@职员编号, @姓名, @姓名简码, @性别, @出生日期, @年龄, @籍贯, @民族, @文化程度, @毕业学校, @健康状况, @婚姻状况, @身份证号码, @家庭电话, @办公电话, @手机, @电子邮件地址, @职工账号, @单位编号, @备注); SELECT 内部编号, 职员编号, 姓名, 姓名简码, 性别, 出生日期, 年龄, 籍贯, 民族, 文化程度, 毕业学校, 健康状况, 婚姻状况, 身份证号码, 家庭电话, 办公电话, 手机, 电子邮件地址, 职工账号, 单位编号, 备注 FROM 职员基本信息表 WHERE (职员编号 = @职员编号)";
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职员编号", System.Data.SqlDbType.VarChar, 30, "职员编号"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名简码", System.Data.SqlDbType.VarChar, 10, "姓名简码"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@性别", System.Data.SqlDbType.VarChar, 2, "性别"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出生日期", System.Data.SqlDbType.Int, 4, "出生日期"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@年龄", System.Data.SqlDbType.Int, 4, "年龄"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@籍贯", System.Data.SqlDbType.VarChar, 50, "籍贯"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@民族", System.Data.SqlDbType.VarChar, 20, "民族"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@文化程度", System.Data.SqlDbType.VarChar, 50, "文化程度"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@毕业学校", System.Data.SqlDbType.VarChar, 100, "毕业学校"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@健康状况", System.Data.SqlDbType.VarChar, 50, "健康状况"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@婚姻状况", System.Data.SqlDbType.VarChar, 10, "婚姻状况"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@身份证号码", System.Data.SqlDbType.VarChar, 18, "身份证号码"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@家庭电话", System.Data.SqlDbType.VarChar, 50, "家庭电话"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@办公电话", System.Data.SqlDbType.VarChar, 50, "办公电话"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@手机", System.Data.SqlDbType.VarChar, 50, "手机"));
this.sqlInsertCommand2.Parameter⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -