//绑定数据源 protected void BindGrid() { BLL.tb_SYS_RoleMenu bllRoleMenu = new BLL.tb_SYS_RoleMenu(); DataSet dsRoleMenu = bllRoleMenu.GetList(Request.QueryString["ID"], "MenuNO"); //此处DAL层GetList()方法已重写 DataTable dtSource = PublicMethod.sortToTree(dsRoleMenu.Tables[0], "MenuNO", "MenuID", "ParentID"); foreach (DataRow dr in dtSource.Rows) { dr["AuthorizationInsert"] = (dr["AuthorizationInsert"].ToString() == "1") ? true : false; dr["AuthorizationSelect"] = (dr["AuthorizationSelect"].ToString() == "1") ? true : false; dr["AuthorizationUpdate"] = (dr["AuthorizationUpdate"].ToString() == "1") ? true : false; dr["AuthorizationDelete"] = (dr["AuthorizationDelete"].ToString() == "1") ? true : false; } gridAuthorization.DataSource = dtSource; gridAuthorization.DataBind(); }
//保存修改 protected void btnSave_Click(object sender, EventArgs e) { bool checkState; FineUI.CheckBoxField checkField; Model.tb_SYS_RoleMenu modelRoleMenu = new Model.tb_SYS_RoleMenu(); BLL.tb_SYS_RoleMenu bllRoleMenu = new BLL.tb_SYS_RoleMenu(); for (int i = 0; i < gridAuthorization.RecordCount; i++) { checkField = (FineUI.CheckBoxField)gridAuthorization.FindColumn("AuthorizationSelect_1"); checkState = checkField.GetCheckedState(i); if (checkState == false) { if (gridAuthorization.DataKeys[i][1] != null) { bllRoleMenu.Delete("ID='" + gridAuthorization.DataKeys[i][1].ToString() + "'"); } continue; } modelRoleMenu.RoleID = Request.QueryString["ID"]; modelRoleMenu.MenuID = gridAuthorization.DataKeys[i][0].ToString(); modelRoleMenu.AuthorizationInsert = (((FineUI.CheckBoxField)gridAuthorization.FindColumn("AuthorizationInsert_1")).GetCheckedState(i)) ? "1" : "0"; modelRoleMenu.AuthorizationUpdate = (((FineUI.CheckBoxField)gridAuthorization.FindColumn("AuthorizationUpdate_1")).GetCheckedState(i)) ? "1" : "0"; modelRoleMenu.AuthorizationDelete = (((FineUI.CheckBoxField)gridAuthorization.FindColumn("AuthorizationDelete_1")).GetCheckedState(i)) ? "1" : "0"; if (gridAuthorization.DataKeys[i][1] != null) { modelRoleMenu.ID = gridAuthorization.DataKeys[i][1].ToString(); modelRoleMenu.UpdateID = Session["AccountID"].ToString(); modelRoleMenu.UpdateTime = DateTime.Now; bllRoleMenu.Update(modelRoleMenu); } else { modelRoleMenu.ID = Guid.NewGuid().ToString(); modelRoleMenu.CreateID = Session["AccountID"].ToString(); modelRoleMenu.CreateTime = DateTime.Now; bllRoleMenu.Add(modelRoleMenu); } } saveXml(); //btnBack_Click(sender, e); BindGrid(); }
//删除选中记录集 protected void btnDelete_Click(object sender, EventArgs e) { string id = gridRole.DataKeys[gridRole.SelectedRowIndex][0].ToString(); BLL.tb_SYS_Role bllRole = new BLL.tb_SYS_Role(); string result = bllRole.Delete(id); if (result == "0") { Alert.ShowInTop("删除成功", "提示信息", MessageBoxIcon.Information); BindGrid(); } else { hdfMarkRawNO.Text = gridRole.SelectedRowIndex.ToString(); Alert.ShowInTop("该项被其他项引用,不能删除!", "提示信息", MessageBoxIcon.Error, "highlightRows();"); } BLL.tb_SYS_RoleXML bllRoleXML = new BLL.tb_SYS_RoleXML(); bllRoleXML.Delete(id); BLL.tb_SYS_RoleMenu bllRoleMenu = new BLL.tb_SYS_RoleMenu(); bllRoleMenu.Delete("RoleID='" + id + "'"); }