/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.cn = new System.Data.SqlClient.SqlConnection();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.ds1 = new LIMS.ds();
((System.ComponentModel.ISupportInitialize)(this.ds1)).BeginInit();
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT ID, 检校设备编号, 检定费用, 校准费用, 修理费用, 配件费用, 应交费用, 实交费用, 交费日期 FROM 检校费用";
this.sqlSelectCommand1.Connection = this.cn;
//
// cn
//
this.cn.ConnectionString = "workstation id=QDMT;packet size=4096;user id=sa;integrated security=SSPI;data sou" +
"rce=\".\";persist security info=False;initial catalog=lims";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 检校费用(检校设备编号, 检定费用, 校准费用, 修理费用, 配件费用, 应交费用, 实交费用, 交费日期) VALUES (@检校设备编" +
"号, @检定费用, @校准费用, @修理费用, @配件费用, @应交费用, @实交费用, @交费日期); SELECT ID, 检校设备编号, 检定费用, 校准" +
"费用, 修理费用, 配件费用, 应交费用, 实交费用, 交费日期 FROM 检校费用 WHERE (ID = @@IDENTITY)";
this.sqlInsertCommand1.Connection = this.cn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@检校设备编号", System.Data.SqlDbType.NVarChar, 50, "检校设备编号"));
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.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.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.DateTime, 8, "交费日期"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 检校费用 SET 检校设备编号 = @检校设备编号, 检定费用 = @检定费用, 校准费用 = @校准费用, 修理费用 = @修理费用, 配件费用 = @配件费用, 应交费用 = @应交费用, 实交费用 = @实交费用, 交费日期 = @交费日期 WHERE (ID = @Original_ID) 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); SELECT ID, 检校设备编号, 检定费用, 校准费用, 修理费用, 配件费用, 应交费用, 实交费用, 交费日期 FROM 检校费用 WHERE (ID = @ID)";
this.sqlUpdateCommand1.Connection = this.cn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@检校设备编号", System.Data.SqlDbType.NVarChar, 50, "检校设备编号"));
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.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.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.DateTime, 8, "交费日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_交费日期", System.Data.SqlDbType.DateTime, 8, 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.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.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.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.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.NVarChar, 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("@ID", System.Data.SqlDbType.Int, 4, "ID"));
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 检校费用 WHERE (ID = @Original_ID) 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.cn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_交费日期", System.Data.SqlDbType.DateTime, 8, 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.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.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.NVarChar, 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));
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "检校费用", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
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.da.UpdateCommand = this.sqlUpdateCommand1;
//
// ds1
//
this.ds1.DataSetName = "ds";
this.ds1.Locale = new System.Globalization.CultureInfo("zh-CN");
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.ds1)).EndInit();
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlDataAdapter2 = new System.Data.SqlClient.SqlDataAdapter();
this.ds1 = new LIMS.ds();
((System.ComponentModel.ISupportInitialize)(this.ds1)).BeginInit();
this.RadioButtonList1.SelectedIndexChanged += new System.EventHandler(this.RadioButtonList1_SelectedIndexChanged);
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT ID, 角色ID, 权限ID FROM 角色权限";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=QDMT;packet size=4096;user id=sa;integrated security=SSPI;data sou" +
"rce=\".\";persist security info=False;initial catalog=lims";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 角色权限(角色ID, 权限ID) VALUES (@角色ID, @权限ID); SELECT ID, 角色ID, 权限ID FROM 角色" +
"权限 WHERE (ID = @@IDENTITY)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@角色ID", System.Data.SqlDbType.Int, 4, "角色ID"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限ID", System.Data.SqlDbType.Int, 4, "权限ID"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "UPDATE 角色权限 SET 角色ID = @角色ID, 权限ID = @权限ID WHERE (ID = @Original_ID) AND (权限ID = " +
"@Original_权限ID) AND (角色ID = @Original_角色ID); SELECT ID, 角色ID, 权限ID FROM 角色权限 WHE" +
"RE (ID = @ID)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@角色ID", System.Data.SqlDbType.Int, 4, "角色ID"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限ID", System.Data.SqlDbType.Int, 4, "权限ID"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_权限ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "权限ID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_角色ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "角色ID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 角色权限 WHERE (ID = @Original_ID) AND (权限ID = @Original_权限ID) AND (角色ID " +
"= @Original_角色ID)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_权限ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "权限ID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_角色ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "角色ID", 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", "角色权限", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("角色ID", "角色ID"),
new System.Data.Common.DataColumnMapping("权限ID", "权限ID")
})
});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT ID, 权限模块名, 类别, 菜单级别, 菜单项目ID, 链接地址, 备注 FROM 权限模块";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "INSERT INTO 权限模块(权限模块名, 类别, 菜单级别, 菜单项目ID, 链接地址, 备注) VALUES (@权限模块名, @类别, @菜单级别, @" +
"菜单项目ID, @链接地址, @备注); SELECT ID, 权限模块名, 类别, 菜单级别, 菜单项目ID, 链接地址, 备注 FROM 权限模块 WHER" +
"E (ID = @@IDENTITY)";
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限模块名", System.Data.SqlDbType.NVarChar, 50, "权限模块名"));
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("@菜单项目ID", System.Data.SqlDbType.Int, 4, "菜单项目ID"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@链接地址", System.Data.SqlDbType.NVarChar, 1000, "链接地址"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.NVarChar, 1073741823, "备注"));
//
// sqlUpdateCommand2
//
this.sqlUpdateCommand2.CommandText = @"UPDATE 权限模块 SET 权限模块名 = @权限模块名, 类别 = @类别, 菜单级别 = @菜单级别, 菜单项目ID = @菜单项目ID, 链接地址 = @链接地址, 备注 = @备注 WHERE (ID = @Original_ID) AND (权限模块名 = @Original_权限模块名) AND (类别 = @Original_类别) AND (菜单级别 = @Original_菜单级别 OR @Original_菜单级别 IS NULL AND 菜单级别 IS NULL) AND (菜单项目ID = @Original_菜单项目ID OR @Original_菜单项目ID IS NULL AND 菜单项目ID IS NULL) AND (链接地址 = @Original_链接地址 OR @Original_链接地址 IS NULL AND 链接地址 IS NULL); SELECT ID, 权限模块名, 类别, 菜单级别, 菜单项目ID, 链接地址, 备注 FROM 权限模块 WHERE (ID = @ID)";
this.sqlUpdateCommand2.Connection = this.sqlConnection1;
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限模块名", System.Data.SqlDbType.NVarChar, 50, "权限模块名"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类别", System.Data.SqlDbType.Int, 4, "类别"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@菜单级别", System.Data.SqlDbType.Int, 4, "菜单级别"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@菜单项目ID", System.Data.SqlDbType.Int, 4, "菜单项目ID"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@链接地址", System.Data.SqlDbType.NVarChar, 1000, "链接地址"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.NVarChar, 1073741823, "备注"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_权限模块名", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "权限模块名", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_菜单项目ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "菜单项目ID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_链接地址", System.Data.SqlDbType.NVarChar, 1000, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "链接地址", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
//
// sqlDeleteCommand2
//
this.sqlDeleteCommand2.CommandText = @"DELETE FROM 权限模块 WHERE (ID = @Original_ID) AND (权限模块名 = @Original_权限模块名) AND (类别 = @Original_类别) AND (菜单级别 = @Original_菜单级别 OR @Original_菜单级别 IS NULL AND 菜单级别 IS NULL) AND (菜单项目ID = @Original_菜单项目ID OR @Original_菜单项目ID IS NULL AND 菜单项目ID 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_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_权限模块名", System.Data.SqlDbType.NVarChar, 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_菜单项目ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "菜单项目ID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_链接地址", System.Data.SqlDbType.NVarChar, 1000, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "链接地址", 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", "权限模块", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("权限模块名", "权限模块名"),
new System.Data.Common.DataColumnMapping("类别", "类别"),
new System.Data.Common.DataColumnMapping("菜单级别", "菜单级别"),
new System.Data.Common.DataColumnMapping("菜单项目ID", "菜单项目ID"),
new System.Data.Common.DataColumnMapping("链接地址", "链接地址"),
new System.Data.Common.DataColumnMapping("备注", "备注")
})
});
this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand2;
//
// ds1
//
this.ds1.DataSetName = "ds";
this.ds1.Locale = new System.Globalization.CultureInfo("zh-CN");
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.ds1)).EndInit();
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.cn = new System.Data.SqlClient.SqlConnection();
this.da = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.ds1 = new LIMS.ds();
((System.ComponentModel.ISupportInitialize)(this.ds1)).BeginInit();
//
// cn
//
this.cn.ConnectionString = "workstation id=QDMT;packet size=4096;integrated security=SSPI;data source=\".\";per" +
"sist security info=False;initial catalog=official";
//
// da
//
this.da.DeleteCommand = this.sqlDeleteCommand1;
this.da.InsertCommand = this.sqlInsertCommand1;
this.da.SelectCommand = this.sqlSelectCommand1;
this.da.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "党群机关", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
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("是否要求具有2年以上基层工作经历", "是否要求具有2年以上基层工作经历"),
new System.Data.Common.DataColumnMapping("其他条件", "其他条件"),
new System.Data.Common.DataColumnMapping("备注", "备注")
})
});
this.da.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 党群机关 WHERE (ID = @Original_ID) 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 (是否要求具有2年以上基层工作经历 = @Original_是否要求具有2年以上基层工作经历 OR @Original_是否要求具有2年以上基层工作经历 IS NULL AND 是否要求具有2年以上基层工作经历 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.cn;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_专业", System.Data.SqlDbType.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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_是否要求具有2年以上基层工作经历", System.Data.SqlDbType.NVarChar, 255, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否要求具有2年以上基层工作经历", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_用人______司局", System.Data.SqlDbType.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 党群机关(单位, [用人 司局], 职位名称, 职位简介, 职位编号, 考试类别, 招考人数, 专业, 学历, 政治面貌, 是否要求具有2年以上基层工作经历, 其他条件, 备注) VALUES (@单位, @Param1, @职位名称, @职位简介, @职位编号, @考试类别, @招考人数, @专业, @学历, @政治面貌, @是否要求具有2年以上基层工作经历, @其他条件, @备注); SELECT TOP 100 ID, 单位, [用人 司局], 职位名称, 职位简介, 职位编号, 考试类别, 招考人数, 专业, 学历, 政治面貌, 是否要求具有2年以上基层工作经历, 其他条件, 备注 FROM 党群机关 WHERE (ID = @@IDENTITY)";
this.sqlInsertCommand1.Connection = this.cn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位", System.Data.SqlDbType.NVarChar, 255, "单位"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.NVarChar, 255, "用人 司局"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职位名称", System.Data.SqlDbType.NVarChar, 255, "职位名称"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职位简介", System.Data.SqlDbType.NVarChar, 255, "职位简介"));
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.NVarChar, 255, "考试类别"));
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.NVarChar, 255, "专业"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@学历", System.Data.SqlDbType.NVarChar, 255, "学历"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@政治面貌", System.Data.SqlDbType.NVarChar, 255, "政治面貌"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否要求具有2年以上基层工作经历", System.Data.SqlDbType.NVarChar, 255, "是否要求具有2年以上基层工作经历"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@其他条件", System.Data.SqlDbType.NVarChar, 255, "其他条件"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.NVarChar, 255, "备注"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT TOP 100 ID, 单位, [用人 司局], 职位名称, 职位简介, 职位编号, 考试类别, 招考人数, 专业, 学历, 政治面貌, " +
"是否要求具有2年以上基层工作经历, 其他条件, 备注 FROM 党群机关";
this.sqlSelectCommand1.Connection = this.cn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 党群机关 SET 单位 = @单位, [用人 司局] = @Param2, 职位名称 = @职位名称, 职位简介 = @职位简介, 职位编号 = @职位编号, 考试类别 = @考试类别, 招考人数 = @招考人数, 专业 = @专业, 学历 = @学历, 政治面貌 = @政治面貌, 是否要求具有2年以上基层工作经历 = @是否要求具有2年以上基层工作经历, 其他条件 = @其他条件, 备注 = @备注 WHERE (ID = @Original_ID) 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 (是否要求具有2年以上基层工作经历 = @Original_是否要求具有2年以上基层工作经历 OR @Original_是否要求具有2年以上基层工作经历 IS NULL AND 是否要求具有2年以上基层工作经历 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); SELECT TOP 100 ID, 单位, [用人 司局], 职位名称, 职位简介, 职位编号, 考试类别, 招考人数, 专业, 学历, 政治面貌, 是否要求具有2年以上基层工作经历, 其他条件, 备注 FROM 党群机关 WHERE (ID = @ID)";
this.sqlUpdateCommand1.Connection = this.cn;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位", System.Data.SqlDbType.NVarChar, 255, "单位"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.NVarChar, 255, "用人 司局"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职位名称", System.Data.SqlDbType.NVarChar, 255, "职位名称"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@职位简介", System.Data.SqlDbType.NVarChar, 255, "职位简介"));
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.NVarChar, 255, "考试类别"));
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.NVarChar, 255, "专业"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@学历", System.Data.SqlDbType.NVarChar, 255, "学历"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@政治面貌", System.Data.SqlDbType.NVarChar, 255, "政治面貌"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否要求具有2年以上基层工作经历", System.Data.SqlDbType.NVarChar, 255, "是否要求具有2年以上基层工作经历"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@其他条件", System.Data.SqlDbType.NVarChar, 255, "其他条件"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.NVarChar, 255, "备注"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_专业", System.Data.SqlDbType.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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_是否要求具有2年以上基层工作经历", System.Data.SqlDbType.NVarChar, 255, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否要求具有2年以上基层工作经历", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_用人______司局", System.Data.SqlDbType.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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.NVarChar, 255, 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("@ID", System.Data.SqlDbType.Int, 4, "ID"));
//
// ds1
//
this.ds1.DataSetName = "ds";
this.ds1.Locale = new System.Globalization.CultureInfo("zh-CN");
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.ds1)).EndInit();
}
