📄 staffmanage.designer.cs
字号:
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText");
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@staffId", System.Data.SqlDbType.VarChar, 0, "staffId"),
new System.Data.SqlClient.SqlParameter("@staffName", System.Data.SqlDbType.VarChar, 0, "staffName"),
new System.Data.SqlClient.SqlParameter("@sex", System.Data.SqlDbType.Char, 0, "sex"),
new System.Data.SqlClient.SqlParameter("@Home", System.Data.SqlDbType.VarChar, 0, "Home"),
new System.Data.SqlClient.SqlParameter("@diploma", System.Data.SqlDbType.VarChar, 0, "diploma"),
new System.Data.SqlClient.SqlParameter("@kind", System.Data.SqlDbType.VarChar, 0, "kind"),
new System.Data.SqlClient.SqlParameter("@salary", System.Data.SqlDbType.Float, 0, "salary"),
new System.Data.SqlClient.SqlParameter("@Phone", System.Data.SqlDbType.Char, 0, "Phone"),
new System.Data.SqlClient.SqlParameter("@address", System.Data.SqlDbType.VarChar, 0, "address"),
new System.Data.SqlClient.SqlParameter("@identify", System.Data.SqlDbType.Char, 0, "identify"),
new System.Data.SqlClient.SqlParameter("@beginDate", System.Data.SqlDbType.DateTime, 0, "beginDate"),
new System.Data.SqlClient.SqlParameter("@staffText", System.Data.SqlDbType.VarChar, 0, "staffText"),
new System.Data.SqlClient.SqlParameter("@Original_staffId", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffId", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_staffName", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffName", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_sex", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "sex", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Home", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Home", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Home", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Home", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_diploma", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "diploma", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_diploma", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "diploma", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_kind", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "kind", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_kind", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "kind", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_salary", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "salary", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_salary", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "salary", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Phone", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Phone", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Phone", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Phone", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_address", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_address", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_identify", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "identify", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_identify", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "identify", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_beginDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "beginDate", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_beginDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "beginDate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_staffText", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "staffText", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_staffText", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffText", System.Data.DataRowVersion.Original, null)});
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = resources.GetString("sqlDeleteCommand1.CommandText");
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_staffId", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffId", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_staffName", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffName", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_sex", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "sex", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Home", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Home", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Home", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Home", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_diploma", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "diploma", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_diploma", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "diploma", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_kind", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "kind", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_kind", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "kind", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_salary", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "salary", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_salary", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "salary", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Phone", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Phone", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Phone", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Phone", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_address", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_address", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_identify", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "identify", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_identify", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "identify", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_beginDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "beginDate", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_beginDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "beginDate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_staffText", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "staffText", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_staffText", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffText", System.Data.DataRowVersion.Original, null)});
//
// 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", "staff", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("staffId", "员工ID"),
new System.Data.Common.DataColumnMapping("staffName", "姓名"),
new System.Data.Common.DataColumnMapping("sex", "性别"),
new System.Data.Common.DataColumnMapping("Home", "籍贯"),
new System.Data.Common.DataColumnMapping("diploma", "学历"),
new System.Data.Common.DataColumnMapping("kind", "类别"),
new System.Data.Common.DataColumnMapping("salary", "工资"),
new System.Data.Common.DataColumnMapping("Phone", "联系电话"),
new System.Data.Common.DataColumnMapping("address", "联系地址"),
new System.Data.Common.DataColumnMapping("identify", "身份证"),
new System.Data.Common.DataColumnMapping("beginDate", "聘用日期"),
new System.Data.Common.DataColumnMapping("staffText", "备注")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT staffId, staffName, sex, Home, diploma, kind, salary, Phone, address, " +
"identify, beginDate, staffText\r\nFROM staff";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = resources.GetString("sqlInsertCommand2.CommandText");
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@staffId", System.Data.SqlDbType.VarChar, 0, "staffId"),
new System.Data.SqlClient.SqlParameter("@staffName", System.Data.SqlDbType.VarChar, 0, "staffName"),
new System.Data.SqlClient.SqlParameter("@sex", System.Data.SqlDbType.Char, 0, "sex"),
new System.Data.SqlClient.SqlParameter("@Home", System.Data.SqlDbType.VarChar, 0, "Home"),
new System.Data.SqlClient.SqlParameter("@diploma", System.Data.SqlDbType.VarChar, 0, "diploma"),
new System.Data.SqlClient.SqlParameter("@kind", System.Data.SqlDbType.VarChar, 0, "kind"),
new System.Data.SqlClient.SqlParameter("@salary", System.Data.SqlDbType.Float, 0, "salary"),
new System.Data.SqlClient.SqlParameter("@Phone", System.Data.SqlDbType.Char, 0, "Phone"),
new System.Data.SqlClient.SqlParameter("@address", System.Data.SqlDbType.VarChar, 0, "address"),
new System.Data.SqlClient.SqlParameter("@identify", System.Data.SqlDbType.Char, 0, "identify"),
new System.Data.SqlClient.SqlParameter("@beginDate", System.Data.SqlDbType.DateTime, 0, "beginDate"),
new System.Data.SqlClient.SqlParameter("@staffText", System.Data.SqlDbType.VarChar, 0, "staffText")});
//
// sqlUpdateCommand2
//
this.sqlUpdateCommand2.CommandText = resources.GetString("sqlUpdateCommand2.CommandText");
this.sqlUpdateCommand2.Connection = this.sqlConnection1;
this.sqlUpdateCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@staffId", System.Data.SqlDbType.VarChar, 0, "staffId"),
new System.Data.SqlClient.SqlParameter("@staffName", System.Data.SqlDbType.VarChar, 0, "staffName"),
new System.Data.SqlClient.SqlParameter("@sex", System.Data.SqlDbType.Char, 0, "sex"),
new System.Data.SqlClient.SqlParameter("@Home", System.Data.SqlDbType.VarChar, 0, "Home"),
new System.Data.SqlClient.SqlParameter("@diploma", System.Data.SqlDbType.VarChar, 0, "diploma"),
new System.Data.SqlClient.SqlParameter("@kind", System.Data.SqlDbType.VarChar, 0, "kind"),
new System.Data.SqlClient.SqlParameter("@salary", System.Data.SqlDbType.Float, 0, "salary"),
new System.Data.SqlClient.SqlParameter("@Phone", System.Data.SqlDbType.Char, 0, "Phone"),
new System.Data.SqlClient.SqlParameter("@address", System.Data.SqlDbType.VarChar, 0, "address"),
new System.Data.SqlClient.SqlParameter("@identify", System.Data.SqlDbType.Char, 0, "identify"),
new System.Data.SqlClient.SqlParameter("@beginDate", System.Data.SqlDbType.DateTime, 0, "beginDate"),
new System.Data.SqlClient.SqlParameter("@staffText", System.Data.SqlDbType.VarChar, 0, "staffText"),
new System.Data.SqlClient.SqlParameter("@Original_staffId", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffId", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_staffName", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffName", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_sex", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "sex", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Home", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Home", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Home", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Home", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_diploma", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "diploma", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_diploma", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "diploma", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_kind", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "kind", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_kind", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "kind", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_salary", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "salary", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_salary", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "salary", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Phone", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Phone", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Phone", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Phone", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_address", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_address", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_identify", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "identify", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_identify", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "identify", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_beginDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "beginDate", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_beginDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "beginDate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_staffText", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "staffText", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_staffText", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffText", System.Data.DataRowVersion.Original, null)});
//
// sqlDeleteCommand2
//
this.sqlDeleteCommand2.CommandText = resources.GetString("sqlDeleteCommand2.CommandText");
this.sqlDeleteCommand2.Connection = this.sqlConnection1;
this.sqlDeleteCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_staffId", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffId", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_staffName", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffName", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_sex", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "sex", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Home", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Home", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Home", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Home", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_diploma", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "diploma", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_diploma", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "diploma", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_kind", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "kind", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_kind", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "kind", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_salary", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "salary", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_salary", System.Data.SqlDbType.Float, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "salary", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Phone", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Phone", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Phone", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Phone", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_address", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_address", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "address", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_identify", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "identify", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_identify", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "identify", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_beginDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "beginDate", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_beginDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "beginDate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_staffText", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "staffText", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_staffText", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "staffText", System.Data.DataRowVersion.Original, null)});
//
// sqlDataAdapter2
//
this.sqlDataAdapter2.DeleteCommand = this.sqlDeleteCommand2;
this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2;
this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;
this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "staffAdd", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("staffId", "员工ID"),
new System.Data.Common.DataColumnMapping("staffName", "姓名"),
new System.Data.Common.DataColumnMapping("sex", "性别"),
new System.Data.Common.DataColumnMapping("Home", "籍贯"),
new System.Data.Common.DataColumnMapping("diploma", "学历"),
new System.Data.Common.DataColumnMapping("kind", "类别"),
new System.Data.Com⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -