コード例 #1
0
ファイル: RoleManagement.aspx.cs プロジェクト: oakop01/LIMS-1
 /// <summary>
 /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 /// 此方法的内容。
 /// </summary>
 private void InitializeComponent()
 {
     this.cn                = new System.Data.SqlClient.SqlConnection();
     this.daRole            = 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.sm1               = new LIMS.SystemManagement.SM();
     this.daPermission      = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand();
     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.sm1)).BeginInit();
     this.dgRole.UpdateCellBatch  += new Infragistics.WebUI.UltraWebGrid.UpdateCellBatchEventHandler(this.dgRole_UpdateCellBatch);
     this.dgRole.DeleteRowBatch   += new Infragistics.WebUI.UltraWebGrid.DeleteRowBatchEventHandler(this.dgRole_DeleteRowBatch);
     this.dgRole.AddRowBatch      += new Infragistics.WebUI.UltraWebGrid.AddRowBatchEventHandler(this.dgRole_AddRowBatch);
     this.ConfirmRole.Click       += new Infragistics.WebUI.WebDataInput.ClickHandler(this.ConfirmRole_Click);
     this.CancelRole.Click        += new Infragistics.WebUI.WebDataInput.ClickHandler(this.CancelRole_Click);
     this.ModifyPermission.Click  += new Infragistics.WebUI.WebDataInput.ClickHandler(this.ModifyPermission_Click);
     this.ConfirmPermission.Click += new Infragistics.WebUI.WebDataInput.ClickHandler(this.ConfirmPermission_Click);
     this.CancelPermission.Click  += new Infragistics.WebUI.WebDataInput.ClickHandler(this.CancelPermission_Click);
     //
     // 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";
     //
     // daRole
     //
     this.daRole.DeleteCommand = this.sqlDeleteCommand1;
     this.daRole.InsertCommand = this.sqlInsertCommand1;
     this.daRole.SelectCommand = this.sqlSelectCommand1;
     this.daRole.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("角色描述", "角色描述")
         })
     });
     this.daRole.UpdateCommand = this.sqlUpdateCommand1;
     //
     // sqlDeleteCommand1
     //
     this.sqlDeleteCommand1.CommandText = "DELETE FROM 角色 WHERE (ID = @Original_ID) 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, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "角色名称", System.Data.DataRowVersion.Original, null));
     //
     // sqlInsertCommand1
     //
     this.sqlInsertCommand1.CommandText = "INSERT INTO 角色(角色名称, 角色描述) VALUES (@角色名称, @角色描述); SELECT ID, 角色名称, 角色描述 FROM 角色 W" +
                                          "HERE (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.NVarChar, 1073741823, "角色描述"));
     //
     // sqlSelectCommand1
     //
     this.sqlSelectCommand1.CommandText = "SELECT ID, 角色名称, 角色描述 FROM 角色";
     this.sqlSelectCommand1.Connection  = this.cn;
     //
     // sqlUpdateCommand1
     //
     this.sqlUpdateCommand1.CommandText = "UPDATE 角色 SET 角色名称 = @角色名称, 角色描述 = @角色描述 WHERE (ID = @Original_ID) AND (角色名称 = @O" +
                                          "riginal_角色名称 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.NVarChar, 1073741823, "角色描述"));
     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, 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("@ID", System.Data.SqlDbType.Int, 4, "ID"));
     //
     // sm1
     //
     this.sm1.DataSetName = "SM";
     this.sm1.Locale      = new System.Globalization.CultureInfo("zh-CN");
     //
     // daPermission
     //
     this.daPermission.DeleteCommand = this.sqlDeleteCommand2;
     this.daPermission.InsertCommand = this.sqlInsertCommand2;
     this.daPermission.SelectCommand = this.sqlSelectCommand2;
     this.daPermission.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("ID", "ID")
         })
     });
     this.daPermission.UpdateCommand = this.sqlUpdateCommand2;
     //
     // sqlDeleteCommand2
     //
     this.sqlDeleteCommand2.CommandText = "DELETE FROM 权限模块 WHERE (ID = @Original_ID) AND (权限模块名 = @Original_权限模块名)";
     this.sqlDeleteCommand2.Connection  = this.cn;
     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));
     //
     // sqlInsertCommand2
     //
     this.sqlInsertCommand2.CommandText = "INSERT INTO 权限模块(权限模块名) VALUES (@权限模块名); SELECT 权限模块名, ID FROM 权限模块 WHERE (ID = @" +
                                          "@IDENTITY)";
     this.sqlInsertCommand2.Connection = this.cn;
     this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限模块名", System.Data.SqlDbType.NVarChar, 50, "权限模块名"));
     //
     // sqlSelectCommand2
     //
     this.sqlSelectCommand2.CommandText = "SELECT 权限模块名, ID FROM 权限模块";
     this.sqlSelectCommand2.Connection  = this.cn;
     //
     // sqlUpdateCommand2
     //
     this.sqlUpdateCommand2.CommandText = "UPDATE 权限模块 SET 权限模块名 = @权限模块名 WHERE (ID = @Original_ID) AND (权限模块名 = @Original_权" +
                                          "限模块名); SELECT 权限模块名, ID FROM 权限模块 WHERE (ID = @ID)";
     this.sqlUpdateCommand2.Connection = this.cn;
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@权限模块名", System.Data.SqlDbType.NVarChar, 50, "权限模块名"));
     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("@ID", System.Data.SqlDbType.Int, 4, "ID"));
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.sm1)).EndInit();
 }
コード例 #2
0
 /// <summary>
 /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 /// 此方法的内容。
 /// </summary>
 private void InitializeComponent()
 {
     this.cn                = new System.Data.SqlClient.SqlConnection();
     this.daPermission      = 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.sm1               = new LIMS.SystemManagement.SM();
     this.daPermissionType  = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand();
     this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
     this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand();
     this.daMenu            = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlDeleteCommand3 = new System.Data.SqlClient.SqlCommand();
     this.sqlInsertCommand3 = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
     this.sqlUpdateCommand3 = new System.Data.SqlClient.SqlCommand();
     ((System.ComponentModel.ISupportInitialize)(this.sm1)).BeginInit();
     this.dgPermission.UpdateCellBatch += new Infragistics.WebUI.UltraWebGrid.UpdateCellBatchEventHandler(this.dgPermission_UpdateCellBatch);
     this.dgPermission.DeleteRowBatch  += new Infragistics.WebUI.UltraWebGrid.DeleteRowBatchEventHandler(this.dgPermission_DeleteRowBatch);
     this.dgPermission.AddRowBatch     += new Infragistics.WebUI.UltraWebGrid.AddRowBatchEventHandler(this.dgPermission_AddRowBatch);
     this.Sumbit.Click += new Infragistics.WebUI.WebDataInput.ClickHandler(this.Sumbit_Click);
     this.Cancel.Click += new Infragistics.WebUI.WebDataInput.ClickHandler(this.Cancel_Click);
     //
     // 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";
     //
     // daPermission
     //
     this.daPermission.DeleteCommand = this.sqlDeleteCommand1;
     this.daPermission.InsertCommand = this.sqlInsertCommand1;
     this.daPermission.SelectCommand = this.sqlSelectCommand1;
     this.daPermission.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.daPermission.UpdateCommand = this.sqlUpdateCommand1;
     //
     // sqlDeleteCommand1
     //
     this.sqlDeleteCommand1.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.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, 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_菜单项目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, 1000, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "链接地址", System.Data.DataRowVersion.Original, null));
     //
     // sqlInsertCommand1
     //
     this.sqlInsertCommand1.CommandText = "INSERT INTO 权限模块(权限模块名, 类别, 菜单级别, 菜单项目ID, 链接地址, 备注) VALUES (@权限模块名, @类别, @菜单级别, @" +
                                          "菜单项目ID, @链接地址, @备注); SELECT ID, 权限模块名, 类别, 菜单级别, 菜单项目ID, 链接地址, 备注 FROM 权限模块 WHER" +
                                          "E (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("@菜单项目ID", System.Data.SqlDbType.Int, 4, "菜单项目ID"));
     this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@链接地址", System.Data.SqlDbType.NVarChar, 1000, "链接地址"));
     this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.NVarChar, 1073741823, "备注"));
     //
     // sqlSelectCommand1
     //
     this.sqlSelectCommand1.CommandText = "SELECT ID, 权限模块名, 类别, 菜单级别, 菜单项目ID, 链接地址, 备注 FROM 权限模块";
     this.sqlSelectCommand1.Connection  = this.cn;
     //
     // sqlUpdateCommand1
     //
     this.sqlUpdateCommand1.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.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("@菜单项目ID", System.Data.SqlDbType.Int, 4, "菜单项目ID"));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@链接地址", System.Data.SqlDbType.NVarChar, 1000, "链接地址"));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.NVarChar, 1073741823, "备注"));
     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, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "权限模块名", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类别", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类别", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_菜单级别", System.Data.SqlDbType.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_菜单项目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, 1000, 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"));
     //
     // sm1
     //
     this.sm1.DataSetName = "SM";
     this.sm1.Locale      = new System.Globalization.CultureInfo("zh-CN");
     //
     // daPermissionType
     //
     this.daPermissionType.DeleteCommand = this.sqlDeleteCommand2;
     this.daPermissionType.InsertCommand = this.sqlInsertCommand2;
     this.daPermissionType.SelectCommand = this.sqlSelectCommand2;
     this.daPermissionType.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("Type", "Type")
         })
     });
     this.daPermissionType.UpdateCommand = this.sqlUpdateCommand2;
     //
     // sqlDeleteCommand2
     //
     this.sqlDeleteCommand2.CommandText = "DELETE FROM 权限类别 WHERE (ID = @Original_ID) AND (类别 = @Original_Type OR @Original_" +
                                          "Type IS NULL AND 类别 IS NULL)";
     this.sqlDeleteCommand2.Connection = this.cn;
     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_Type", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Type", System.Data.DataRowVersion.Original, null));
     //
     // sqlInsertCommand2
     //
     this.sqlInsertCommand2.CommandText = "INSERT INTO 权限类别(类别) VALUES (@类别); SELECT ID, 类别 AS Type FROM 权限类别 WHERE (ID = @@" +
                                          "IDENTITY)";
     this.sqlInsertCommand2.Connection = this.cn;
     this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类别", System.Data.SqlDbType.NVarChar, 50, "Type"));
     //
     // sqlSelectCommand2
     //
     this.sqlSelectCommand2.CommandText = "SELECT ID, 类别 AS Type FROM 权限类别";
     this.sqlSelectCommand2.Connection  = this.cn;
     //
     // sqlUpdateCommand2
     //
     this.sqlUpdateCommand2.CommandText = "UPDATE 权限类别 SET 类别 = @类别 WHERE (ID = @Original_ID) AND (类别 = @Original_Type OR @O" +
                                          "riginal_Type IS NULL AND 类别 IS NULL); SELECT ID, 类别 AS Type FROM 权限类别 WHERE (ID " +
                                          "= @ID)";
     this.sqlUpdateCommand2.Connection = this.cn;
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类别", System.Data.SqlDbType.NVarChar, 50, "Type"));
     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_Type", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Type", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
     //
     // daMenu
     //
     this.daMenu.DeleteCommand = this.sqlDeleteCommand3;
     this.daMenu.InsertCommand = this.sqlInsertCommand3;
     this.daMenu.SelectCommand = this.sqlSelectCommand3;
     this.daMenu.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("item", "item")
         })
     });
     this.daMenu.UpdateCommand = this.sqlUpdateCommand3;
     //
     // sqlDeleteCommand3
     //
     this.sqlDeleteCommand3.CommandText = "DELETE FROM 菜单 WHERE (ID = @Original_ID) AND (菜单项目名 = @Original_item OR @Original" +
                                          "_item IS NULL AND 菜单项目名 IS NULL)";
     this.sqlDeleteCommand3.Connection = this.cn;
     this.sqlDeleteCommand3.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.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_item", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "item", System.Data.DataRowVersion.Original, null));
     //
     // sqlInsertCommand3
     //
     this.sqlInsertCommand3.CommandText = "INSERT INTO 菜单(菜单项目名) VALUES (@菜单项目名); SELECT ID, 菜单项目名 AS item FROM 菜单 WHERE (ID" +
                                          " = @@IDENTITY)";
     this.sqlInsertCommand3.Connection = this.cn;
     this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@菜单项目名", System.Data.SqlDbType.NVarChar, 50, "item"));
     //
     // sqlSelectCommand3
     //
     this.sqlSelectCommand3.CommandText = "SELECT ID, 菜单项目名 AS item FROM 菜单";
     this.sqlSelectCommand3.Connection  = this.cn;
     //
     // sqlUpdateCommand3
     //
     this.sqlUpdateCommand3.CommandText = "UPDATE 菜单 SET 菜单项目名 = @菜单项目名 WHERE (ID = @Original_ID) AND (菜单项目名 = @Original_ite" +
                                          "m OR @Original_item IS NULL AND 菜单项目名 IS NULL); SELECT ID, 菜单项目名 AS item FROM 菜单" +
                                          " WHERE (ID = @ID)";
     this.sqlUpdateCommand3.Connection = this.cn;
     this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@菜单项目名", System.Data.SqlDbType.NVarChar, 50, "item"));
     this.sqlUpdateCommand3.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.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_item", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "item", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.sm1)).EndInit();
 }
コード例 #3
0
 /// <summary>
 /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 /// 此方法的内容。
 /// </summary>
 private void InitializeComponent()
 {
     this.cn                = new System.Data.SqlClient.SqlConnection();
     this.daUser            = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
     this.daRoleOfUser      = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
     this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
     this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
     this.sm1               = new LIMS.SystemManagement.SM();
     this.daRole            = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand();
     this.sqlInsertCommand3 = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
     this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand();
     ((System.ComponentModel.ISupportInitialize)(this.sm1)).BeginInit();
     this.dgRoleOfUser.UpdateCellBatch += new Infragistics.WebUI.UltraWebGrid.UpdateCellBatchEventHandler(this.dgRoleOfUser_UpdateCellBatch);
     this.dgRoleOfUser.DeleteRowBatch  += new Infragistics.WebUI.UltraWebGrid.DeleteRowBatchEventHandler(this.dgRoleOfUser_DeleteRowBatch);
     this.dgRoleOfUser.AddRowBatch     += new Infragistics.WebUI.UltraWebGrid.AddRowBatchEventHandler(this.dgRoleOfUser_AddRowBatch);
     this.Confirm.Click += new Infragistics.WebUI.WebDataInput.ClickHandler(this.Confirm_Click);
     //
     // 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";
     //
     // daUser
     //
     this.daUser.InsertCommand = this.sqlInsertCommand1;
     this.daUser.SelectCommand = this.sqlSelectCommand1;
     this.daUser.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("ID", "ID")
         })
     });
     //
     // sqlInsertCommand1
     //
     this.sqlInsertCommand1.CommandText = "INSERT INTO 用户信息(用户名, 姓名, 性别, 科室) VALUES (@用户名, @姓名, @性别, @科室); SELECT 用户名, 姓名, 性" +
                                          "别, 科室, ID FROM 用户信息";
     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("@姓名", System.Data.SqlDbType.NVarChar, 10, "姓名"));
     this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@性别", System.Data.SqlDbType.NVarChar, 5, "性别"));
     this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@科室", System.Data.SqlDbType.NVarChar, 50, "科室"));
     //
     // sqlSelectCommand1
     //
     this.sqlSelectCommand1.CommandText = "SELECT 用户名, 姓名, 性别, 科室, ID FROM 用户信息";
     this.sqlSelectCommand1.Connection  = this.cn;
     //
     // daRoleOfUser
     //
     this.daRoleOfUser.DeleteCommand = this.sqlDeleteCommand1;
     this.daRoleOfUser.InsertCommand = this.sqlInsertCommand2;
     this.daRoleOfUser.SelectCommand = this.sqlSelectCommand2;
     this.daRoleOfUser.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("用户角色", "用户角色")
         })
     });
     this.daRoleOfUser.UpdateCommand = this.sqlUpdateCommand1;
     //
     // sqlDeleteCommand1
     //
     this.sqlDeleteCommand1.CommandText = "DELETE FROM 用户角色 WHERE (ID = @Original_ID) AND (用户ID = @Original_用户ID OR @Origina" +
                                          "l_用户ID IS NULL AND 用户ID IS NULL) AND (角色ID = @Original_用户角色)";
     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_用户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.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "用户角色", System.Data.DataRowVersion.Original, null));
     //
     // sqlInsertCommand2
     //
     this.sqlInsertCommand2.CommandText = "INSERT INTO 用户角色(用户ID, 角色ID) VALUES (@用户ID, @角色ID); SELECT ID, 用户ID, 角色ID AS 用户角色" +
                                          " FROM 用户角色 WHERE (ID = @@IDENTITY)";
     this.sqlInsertCommand2.Connection = this.cn;
     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("@角色ID", System.Data.SqlDbType.Int, 4, "用户角色"));
     //
     // sqlSelectCommand2
     //
     this.sqlSelectCommand2.CommandText = "SELECT ID, 用户ID, 角色ID AS 用户角色 FROM 用户角色";
     this.sqlSelectCommand2.Connection  = this.cn;
     //
     // sqlUpdateCommand1
     //
     this.sqlUpdateCommand1.CommandText = "UPDATE 用户角色 SET 用户ID = @用户ID, 角色ID = @角色ID WHERE (ID = @Original_ID) AND (用户ID = " +
                                          "@Original_用户ID OR @Original_用户ID IS NULL AND 用户ID IS NULL) AND (角色ID = @Original" +
                                          "_用户角色); SELECT ID, 用户ID, 角色ID AS 用户角色 FROM 用户角色 WHERE (ID = @ID)";
     this.sqlUpdateCommand1.Connection = this.cn;
     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, "用户角色"));
     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_用户角色", 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"));
     //
     // sm1
     //
     this.sm1.DataSetName = "SM";
     this.sm1.Locale      = new System.Globalization.CultureInfo("zh-CN");
     //
     // daRole
     //
     this.daRole.DeleteCommand = this.sqlDeleteCommand2;
     this.daRole.InsertCommand = this.sqlInsertCommand3;
     this.daRole.SelectCommand = this.sqlSelectCommand3;
     this.daRole.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("role", "role"),
             new System.Data.Common.DataColumnMapping("description", "description")
         })
     });
     this.daRole.UpdateCommand = this.sqlUpdateCommand2;
     //
     // sqlDeleteCommand2
     //
     this.sqlDeleteCommand2.CommandText = "DELETE FROM 角色 WHERE (ID = @Original_ID) AND (角色名称 = @Original_role OR @Original_" +
                                          "role IS NULL AND 角色名称 IS NULL)";
     this.sqlDeleteCommand2.Connection = this.cn;
     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_role", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "role", System.Data.DataRowVersion.Original, null));
     //
     // sqlInsertCommand3
     //
     this.sqlInsertCommand3.CommandText = "INSERT INTO 角色(角色名称, 角色描述) VALUES (@角色名称, @角色描述); SELECT ID, 角色名称 AS role, 角色描述 A" +
                                          "S description FROM 角色 WHERE (ID = @@IDENTITY)";
     this.sqlInsertCommand3.Connection = this.cn;
     this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@角色名称", System.Data.SqlDbType.NVarChar, 50, "role"));
     this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@角色描述", System.Data.SqlDbType.NVarChar, 1073741823, "description"));
     //
     // sqlSelectCommand3
     //
     this.sqlSelectCommand3.CommandText = "SELECT ID, 角色名称 AS role, 角色描述 AS description FROM 角色";
     this.sqlSelectCommand3.Connection  = this.cn;
     //
     // sqlUpdateCommand2
     //
     this.sqlUpdateCommand2.CommandText = "UPDATE 角色 SET 角色名称 = @角色名称, 角色描述 = @角色描述 WHERE (ID = @Original_ID) AND (角色名称 = @O" +
                                          "riginal_role OR @Original_role IS NULL AND 角色名称 IS NULL); SELECT ID, 角色名称 AS rol" +
                                          "e, 角色描述 AS description FROM 角色 WHERE (ID = @ID)";
     this.sqlUpdateCommand2.Connection = this.cn;
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@角色名称", System.Data.SqlDbType.NVarChar, 50, "role"));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@角色描述", System.Data.SqlDbType.NVarChar, 1073741823, "description"));
     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_role", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "role", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.sm1)).EndInit();
 }