?? amendstafferinfo.cs
字號:
// label14
//
this.label14.Location = new System.Drawing.Point(352, 16);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(48, 16);
this.label14.TabIndex = 19;
this.label14.Text = "民族";
//
// label15
//
this.label15.Location = new System.Drawing.Point(472, 16);
this.label15.Name = "label15";
this.label15.Size = new System.Drawing.Size(48, 16);
this.label15.TabIndex = 19;
this.label15.Text = "籍貫";
//
// label16
//
this.label16.Location = new System.Drawing.Point(272, 19);
this.label16.Name = "label16";
this.label16.Size = new System.Drawing.Size(48, 16);
this.label16.TabIndex = 19;
this.label16.Text = "性別";
//
// label17
//
this.label17.Location = new System.Drawing.Point(16, 192);
this.label17.Name = "label17";
this.label17.Size = new System.Drawing.Size(80, 16);
this.label17.TabIndex = 19;
this.label17.Text = "電子郵件地址";
//
// label18
//
this.label18.Location = new System.Drawing.Point(192, 19);
this.label18.Name = "label18";
this.label18.Size = new System.Drawing.Size(56, 16);
this.label18.TabIndex = 19;
this.label18.Text = "姓名簡碼";
//
// label19
//
this.label19.Location = new System.Drawing.Point(240, 194);
this.label19.Name = "label19";
this.label19.Size = new System.Drawing.Size(64, 16);
this.label19.TabIndex = 19;
this.label19.Text = "職工賬號";
//
// label21
//
this.label21.Location = new System.Drawing.Point(16, 250);
this.label21.Name = "label21";
this.label21.Size = new System.Drawing.Size(32, 16);
this.label21.TabIndex = 19;
this.label21.Text = "備注";
//
// label20
//
this.label20.Location = new System.Drawing.Point(464, 194);
this.label20.Name = "label20";
this.label20.Size = new System.Drawing.Size(64, 16);
this.label20.TabIndex = 19;
this.label20.Text = "單位名稱";
//
// toolBar1
//
this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
this.toolBarFirst,
this.toolBarPre,
this.toolBarNext,
this.toolBarLast,
this.tbarBtnNew,
this.tbarBtnDelete,
this.toolBarSubmit,
this.toolBarCancel,
this.toolBarQuit});
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(642, 41);
this.toolBar1.TabIndex = 24;
this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
//
// toolBarFirst
//
this.toolBarFirst.ImageIndex = 0;
this.toolBarFirst.Text = "首記錄";
this.toolBarFirst.ToolTipText = "首記錄";
//
// toolBarPre
//
this.toolBarPre.ImageIndex = 1;
this.toolBarPre.Text = "上一記錄";
this.toolBarPre.ToolTipText = "上一記錄";
//
// toolBarNext
//
this.toolBarNext.ImageIndex = 2;
this.toolBarNext.Text = "下一記錄";
this.toolBarNext.ToolTipText = "下一記錄";
//
// toolBarLast
//
this.toolBarLast.ImageIndex = 3;
this.toolBarLast.Text = "尾記錄";
this.toolBarLast.ToolTipText = "尾記錄";
//
// tbarBtnNew
//
this.tbarBtnNew.ImageIndex = 4;
this.tbarBtnNew.Text = "新增記錄";
this.tbarBtnNew.ToolTipText = "新增記錄";
//
// tbarBtnDelete
//
this.tbarBtnDelete.ImageIndex = 5;
this.tbarBtnDelete.Text = "刪除記錄";
this.tbarBtnDelete.ToolTipText = "刪除記錄";
//
// toolBarSubmit
//
this.toolBarSubmit.ImageIndex = 6;
this.toolBarSubmit.Text = "提交修改";
this.toolBarSubmit.ToolTipText = "提交修改";
//
// toolBarCancel
//
this.toolBarCancel.ImageIndex = 7;
this.toolBarCancel.Text = "取消修改";
this.toolBarCancel.ToolTipText = "取消修改";
//
// toolBarQuit
//
this.toolBarQuit.ImageIndex = 8;
this.toolBarQuit.Text = "退出";
this.toolBarQuit.ToolTipText = "退出";
//
// 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;
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
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("備注", "備注")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// 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.Connection = this.sqlConnection2;
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));
//
// sqlConnection2
//
this.sqlConnection2.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hrmbook;";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 職員基本信息表(職員編號, 姓名, 姓名簡碼, 性別, 出生日期, 年齡, 籍貫, 民族, 文化程度, 畢業學校, 健康狀況, 婚姻狀況, 身份證號碼, 家庭電話, 辦公電話, 手機, 電子郵件地址, 職工賬號, 單位編號, 備注) VALUES (@職員編號, @姓名, @姓名簡碼, @性別, @出生日期, @年齡, @籍貫, @民族, @文化程度, @畢業學校, @健康狀況, @婚姻狀況, @身份證號碼, @家庭電話, @辦公電話, @手機, @電子郵件地址, @職工賬號, @單位編號, @備注); SELECT 內部編號, 職員編號, 姓名, 姓名簡碼, 性別, 出生日期, 年齡, 籍貫, 民族, 文化程度, 畢業學校, 健康狀況, 婚姻狀況, 身份證號碼, 家庭電話, 辦公電話, 手機, 電子郵件地址, 職工賬號, 單位編號, 備注 FROM 職員基本信息表 WHERE (職員編號 = @職員編號)";
this.sqlInsertCommand1.Connection = this.sqlConnection2;
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, "備注"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 內部編號, 職員編號, 姓名, 姓名簡碼, 性別, 出生日期, 年齡, 籍貫, 民族, 文化程度, 畢業學校, 健康狀況, 婚姻狀況, 身份證號碼," +
" 家庭電話, 辦公電話, 手機, 電子郵件地址, 職工賬號, 單位編號, 備注 FROM 職員基本信息表";
this.sqlSelectCommand1.Connection = this.sqlConnection2;
//
// 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.Connection = this.sqlConnection2;
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, "年齡"));
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -