📄 frmpeoplemanage.cs
字号:
this.Label19 = new System.Windows.Forms.Label();
this.Label18 = new System.Windows.Forms.Label();
this.Label17 = new System.Windows.Forms.Label();
this.Label16 = new System.Windows.Forms.Label();
this.Label15 = new System.Windows.Forms.Label();
this.Label14 = new System.Windows.Forms.Label();
this.Label13 = new System.Windows.Forms.Label();
this.Label12 = new System.Windows.Forms.Label();
this.Label11 = new System.Windows.Forms.Label();
this.Label10 = new System.Windows.Forms.Label();
this.Label9 = new System.Windows.Forms.Label();
this.Label8 = new System.Windows.Forms.Label();
this.Label7 = new System.Windows.Forms.Label();
this.Label6 = new System.Windows.Forms.Label();
this.Label5 = new System.Windows.Forms.Label();
this.Label4 = new System.Windows.Forms.Label();
this.Label3 = new System.Windows.Forms.Label();
this.Label2 = new System.Windows.Forms.Label();
this.Label1 = new System.Windows.Forms.Label();
this.TextBox12 = new System.Windows.Forms.TextBox();
this.SqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.ToolBar1 = new System.Windows.Forms.ToolBar();
this.tbbSave = new System.Windows.Forms.ToolBarButton();
this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.dgdPeopleInfo)).BeginInit();
this.grbPeople.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.SuspendLayout();
//
// SqlDeleteCommand1
//
this.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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.SqlDeleteCommand1.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));
//
// ImageList1
//
this.ImageList1.ImageSize = new System.Drawing.Size(16, 16);
this.ImageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("ImageList1.ImageStream")));
this.ImageList1.TransparentColor = System.Drawing.Color.Transparent;
//
// SqlSelectCommand1
//
this.SqlSelectCommand1.CommandText = "SELECT 内部编号, 职员编号, 姓名, 姓名简码, 性别, 出生日期, 年龄, 籍贯, 民族, 文化程度, 毕业学校, 健康状况, 婚姻状况, 身份证号码," +
" 家庭电话, 办公电话, 手机, 电子邮件地址, 职工账号, 单位编号, 备注 FROM 职员基本信息表";
//
// dgdPeopleInfo
//
this.dgdPeopleInfo.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.dgdPeopleInfo.CaptionVisible = false;
this.dgdPeopleInfo.DataMember = "";
this.dgdPeopleInfo.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dgdPeopleInfo.Location = new System.Drawing.Point(-4, 36);
this.dgdPeopleInfo.Name = "dgdPeopleInfo";
this.dgdPeopleInfo.Size = new System.Drawing.Size(604, 130);
this.dgdPeopleInfo.TabIndex = 17;
this.dgdPeopleInfo.CurrentCellChanged += new System.EventHandler(this.dgdPeopleInfo_CurrentCellChanged);
//
// SqlInsertCommand1
//
this.SqlInsertCommand1.CommandText = @"INSERT INTO 职员基本信息表(职员编号, 姓名, 姓名简码, 性别, 出生日期, 年龄, 籍贯, 民族, 文化程度, 毕业学校, 健康状况, 婚姻状况, 身份证号码, 家庭电话, 办公电话, 手机, 电子邮件地址, 职工账号, 单位编号, 备注) VALUES (@职员编号, @姓名, @姓名简码, @性别, @出生日期, @年龄, @籍贯, @民族, @文化程度, @毕业学校, @健康状况, @婚姻状况, @身份证号码, @家庭电话, @办公电话, @手机, @电子邮件地址, @职工账号, @单位编号, @备注); SELECT 内部编号, 职员编号, 姓名, 姓名简码, 性别, 出生日期, 年龄, 籍贯, 民族, 文化程度, 毕业学校, 健康状况, 婚姻状况, 身份证号码, 家庭电话, 办公电话, 手机, 电子邮件地址, 职工账号, 单位编号, 备注 FROM 职员基本信息表 WHERE (职员编号 = @职员编号)";
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职员编号", System.Data.SqlDbType.VarChar, 30, "职员编号"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名简码", System.Data.SqlDbType.VarChar, 10, "姓名简码"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@性别", System.Data.SqlDbType.VarChar, 2, "性别"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出生日期", System.Data.SqlDbType.Int, 4, "出生日期"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@年龄", System.Data.SqlDbType.Int, 4, "年龄"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@籍贯", System.Data.SqlDbType.VarChar, 50, "籍贯"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@民族", System.Data.SqlDbType.VarChar, 20, "民族"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@文化程度", System.Data.SqlDbType.VarChar, 50, "文化程度"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@毕业学校", System.Data.SqlDbType.VarChar, 100, "毕业学校"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@健康状况", System.Data.SqlDbType.VarChar, 50, "健康状况"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@婚姻状况", System.Data.SqlDbType.VarChar, 10, "婚姻状况"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@身份证号码", System.Data.SqlDbType.VarChar, 18, "身份证号码"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@家庭电话", System.Data.SqlDbType.VarChar, 50, "家庭电话"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@办公电话", System.Data.SqlDbType.VarChar, 50, "办公电话"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@手机", System.Data.SqlDbType.VarChar, 50, "手机"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电子邮件地址", System.Data.SqlDbType.VarChar, 50, "电子邮件地址"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职工账号", System.Data.SqlDbType.VarChar, 20, "职工账号"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位编号", System.Data.SqlDbType.VarChar, 20, "单位编号"));
this.SqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"));
//
// tbbDel
//
this.tbbDel.ImageIndex = 1;
//
// grbPeople
//
this.grbPeople.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.grbPeople.Controls.Add(this.cbbDepCode);
this.grbPeople.Controls.Add(this.cbbSex);
this.grbPeople.Controls.Add(this.cbbNature);
this.grbPeople.Controls.Add(this.cbbCity);
this.grbPeople.Controls.Add(this.TextBox17);
this.grbPeople.Controls.Add(this.TextBox16);
this.grbPeople.Controls.Add(this.TextBox15);
this.grbPeople.Controls.Add(this.TextBox14);
this.grbPeople.Controls.Add(this.TextBox13);
this.grbPeople.Controls.Add(this.TextBox11);
this.grbPeople.Controls.Add(this.TextBox10);
this.grbPeople.Controls.Add(this.TextBox9);
this.grbPeople.Controls.Add(this.TextBox8);
this.grbPeople.Controls.Add(this.TextBox7);
this.grbPeople.Controls.Add(this.TextBox6);
this.grbPeople.Controls.Add(this.TextBox5);
this.grbPeople.Controls.Add(this.TextBox4);
this.grbPeople.Controls.Add(this.TextBox3);
this.grbPeople.Controls.Add(this.TextBox2);
this.grbPeople.Controls.Add(this.TextBox1);
this.grbPeople.Controls.Add(this.Label20);
this.grbPeople.Controls.Add(this.Label19);
this.grbPeople.Controls.Add(this.Label18);
this.grbPeople.Controls.Add(this.Label17);
this.grbPeople.Controls.Add(this.Label16);
this.grbPeople.Controls.Add(this.Label15);
this.grbPeople.Controls.Add(this.Label14);
this.grbPeople.Controls.Add(this.Label13);
this.grbPeople.Controls.Add(this.Label12);
this.grbPeople.Controls.Add(this.Label11);
this.grbPeople.Controls.Add(this.Label10);
this.grbPeople.Controls.Add(this.Label9);
this.grbPeople.Controls.Add(this.Label8);
this.grbPeople.Controls.Add(this.Label7);
this.grbPeople.Controls.Add(this.Label6);
this.grbPeople.Controls.Add(this.Label5);
this.grbPeople.Controls.Add(this.Label4);
this.grbPeople.Controls.Add(this.Label3);
this.grbPeople.Controls.Add(this.Label2);
this.grbPeople.Controls.Add(this.Label1);
this.grbPeople.Controls.Add(this.TextBox12);
this.grbPeople.Location = new System.Drawing.Point(-8, 166);
this.grbPeople.Name = "grbPeople";
this.grbPeople.Size = new System.Drawing.Size(608, 161);
this.grbPeople.TabIndex = 16;
this.grbPeople.TabStop = false;
//
// cbbDepCode
//
this.cbbDepCode.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "职员基本信息表.单位编号"));
this.cbbDepCode.Location = new System.Drawing.Point(328, 128);
this.cbbDepCode.Name = "cbbDepCode";
this.cbbDepCode.Size = new System.Drawing.Size(64, 20);
this.cbbDepCode.TabIndex = 40;
this.cbbDepCode.TextChanged += new System.EventHandler(this.cbbDepCode_TextChanged);
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -