/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">模块实体类</param> /// <returns></returns> public int UpdateModule(RedGlovePermission.Model.RGP_Modules model) { int ret = 0; if (!UpdateExists(model.ModuleID, model.ModuleTag)) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RGP_Modules set "); strSql.Append("ModuleTypeID=?ModuleTypeID,"); strSql.Append("ModuleName=?ModuleName,"); strSql.Append("ModuleTag=?ModuleTag,"); strSql.Append("ModuleURL=?ModuleURL,"); strSql.Append("ModuleDisabled=?ModuleDisabled,"); strSql.Append("ModuleOrder=?ModuleOrder,"); strSql.Append("ModuleDescription=?ModuleDescription"); strSql.Append(" where ModuleID=?ModuleID "); MySqlParameter[] parameters = { new MySqlParameter("?ModuleID", MySqlDbType.Int32, 11), new MySqlParameter("?ModuleTypeID", MySqlDbType.Int32, 11), new MySqlParameter("?ModuleName", MySqlDbType.VarChar, 30), new MySqlParameter("?ModuleTag", MySqlDbType.VarChar, 50), new MySqlParameter("?ModuleURL", MySqlDbType.VarChar, 500), new MySqlParameter("?ModuleDisabled", MySqlDbType.Bit, 1), new MySqlParameter("?ModuleOrder", MySqlDbType.Int32, 11), new MySqlParameter("?ModuleDescription", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.ModuleID; parameters[1].Value = model.ModuleTypeID; parameters[2].Value = model.ModuleName; parameters[3].Value = model.ModuleTag; parameters[4].Value = model.ModuleURL; parameters[5].Value = model.ModuleDisabled; parameters[6].Value = model.ModuleOrder; parameters[7].Value = model.ModuleDescription; if (RedGlovePermission.DBUtility.MySqlHelper.ExecuteSql(strSql.ToString(), parameters) >= 1) { ret = 1; } } else { ret = 2; } return(ret); }
/// <summary> /// 增加一个模块 /// </summary> /// <param name="model">模块实体类</param> /// <returns></returns> public int CreateModule(RedGlovePermission.Model.RGP_Modules model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RGP_Modules("); strSql.Append("ModuleTypeID,ModuleName,ModuleTag,ModuleURL,ModuleDisabled,ModuleOrder,ModuleDescription,IsMenu)"); strSql.Append(" values ("); strSql.Append("?ModuleTypeID,?ModuleName,?ModuleTag,?ModuleURL,?ModuleDisabled,?ModuleOrder,?ModuleDescription,?IsMenu)"); strSql.Append(";select LAST_INSERT_ID()"); MySqlParameter[] parameters = { new MySqlParameter("?ModuleTypeID", MySqlDbType.Int32, 11), new MySqlParameter("?ModuleName", MySqlDbType.VarChar, 30), new MySqlParameter("?ModuleTag", MySqlDbType.VarChar, 50), new MySqlParameter("?ModuleURL", MySqlDbType.VarChar, 500), new MySqlParameter("?ModuleDisabled", MySqlDbType.Bit, 1), new MySqlParameter("?ModuleOrder", MySqlDbType.Int32, 11), new MySqlParameter("?ModuleDescription", MySqlDbType.VarChar, 50), new MySqlParameter("?IsMenu", MySqlDbType.Bit, 1) }; parameters[0].Value = model.ModuleTypeID; parameters[1].Value = model.ModuleName; parameters[2].Value = model.ModuleTag; parameters[3].Value = model.ModuleURL; parameters[4].Value = model.ModuleDisabled; parameters[5].Value = model.ModuleOrder; parameters[6].Value = model.ModuleDescription; parameters[7].Value = model.IsMenu; object obj = RedGlovePermission.DBUtility.MySqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一个模块 /// </summary> /// <param name="model">模块实体类</param> /// <returns></returns> public int CreateModule(RedGlovePermission.Model.RGP_Modules model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RGP_Modules("); strSql.Append("ModuleTypeID,ModuleName,ModuleTag,ModuleURL,ModuleDisabled,ModuleOrder,ModuleDescription,IsMenu)"); strSql.Append(" values ("); strSql.Append("@ModuleTypeID,@ModuleName,@ModuleTag,@ModuleURL,@ModuleDisabled,@ModuleOrder,@ModuleDescription,@IsMenu)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ModuleTypeID", SqlDbType.Int, 4), new SqlParameter("@ModuleName", SqlDbType.NVarChar, 30), new SqlParameter("@ModuleTag", SqlDbType.NVarChar, 50), new SqlParameter("@ModuleURL", SqlDbType.NVarChar, 500), new SqlParameter("@ModuleDisabled", SqlDbType.Bit, 1), new SqlParameter("@ModuleOrder", SqlDbType.Int, 4), new SqlParameter("@ModuleDescription", SqlDbType.NVarChar, 50), new SqlParameter("@IsMenu", SqlDbType.Bit, 1) }; parameters[0].Value = model.ModuleTypeID; parameters[1].Value = model.ModuleName; parameters[2].Value = model.ModuleTag; parameters[3].Value = model.ModuleURL; parameters[4].Value = model.ModuleDisabled; parameters[5].Value = model.ModuleOrder; parameters[6].Value = model.ModuleDescription; parameters[7].Value = model.IsMenu; object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个模块实体 /// </summary> /// <param name="ModuleID">模块ID</param> /// <returns></returns> public RedGlovePermission.Model.RGP_Modules GetModuleModel(int ModuleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from RGP_Modules "); strSql.Append(" where ModuleID=?ModuleID "); MySqlParameter[] parameters = { new MySqlParameter("?ModuleID", MySqlDbType.Int32,11)}; parameters[0].Value = ModuleID; RedGlovePermission.Model.RGP_Modules model = new RedGlovePermission.Model.RGP_Modules(); DataSet ds = RedGlovePermission.DBUtility.MySqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ModuleID"].ToString() != "") { model.ModuleID = int.Parse(ds.Tables[0].Rows[0]["ModuleID"].ToString()); } if (ds.Tables[0].Rows[0]["ModuleTypeID"].ToString() != "") { model.ModuleTypeID = int.Parse(ds.Tables[0].Rows[0]["ModuleTypeID"].ToString()); } model.ModuleName = ds.Tables[0].Rows[0]["ModuleName"].ToString(); model.ModuleTag = ds.Tables[0].Rows[0]["ModuleTag"].ToString(); model.ModuleURL = ds.Tables[0].Rows[0]["ModuleURL"].ToString(); if (ds.Tables[0].Rows[0]["ModuleDisabled"].ToString() != "") { if ((ds.Tables[0].Rows[0]["ModuleDisabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["ModuleDisabled"].ToString().ToLower() == "true")) { model.ModuleDisabled = true; } else { model.ModuleDisabled = false; } } if (ds.Tables[0].Rows[0]["ModuleOrder"].ToString() != "") { model.ModuleOrder = int.Parse(ds.Tables[0].Rows[0]["ModuleOrder"].ToString()); } model.ModuleDescription = ds.Tables[0].Rows[0]["ModuleDescription"].ToString(); if (ds.Tables[0].Rows[0]["IsMenu"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsMenu"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsMenu"].ToString().ToLower() == "true")) { model.IsMenu = true; } else { model.IsMenu = false; } } return model; } else { return null; } }
/// <summary> /// 更新模块信息 /// </summary> protected void btn_update_Click(object sender, EventArgs e) { RedGlovePermission.Model.RGP_Modules model = new RedGlovePermission.Model.RGP_Modules(); model.ModuleID = int.Parse(M_ID.Text); model.ModuleTypeID = int.Parse(ModuleType.SelectedValue); model.ModuleName = txt_Name.Text.Trim(); model.ModuleTag = txt_tag.Text.Trim(); model.ModuleURL = txt_url.Text.Trim(); if (txt_state.SelectedValue == "0") { model.ModuleDisabled = false; } else { model.ModuleDisabled = true; } model.ModuleOrder = int.Parse(txt_order.Text.Trim()); model.ModuleDescription = txt_Description.Text.Trim(); if (IsMenu.SelectedValue == "0") { model.IsMenu = false; } else { model.IsMenu = true; } string[] vstr = Request.Form["verifystate"].Split(','); switch (bll.UpdateModule(model)) { case 1: ArrayList list = new ArrayList(); //建立事务列表 int n = int.Parse(AuthorityNum.Text); for (int i = 0; i < n; i++) { //判断权限是否有变化 if (vstr[i] != Request.Form["Alist" + i.ToString()].ToString()) { string item = string.Empty; item = item + model.ModuleID.ToString() + "|" + Request.Form["Atag" + i.ToString()].ToString() + "|" + Request.Form["Alist" + i.ToString()].ToString(); //判断插入增加还是删除 list.Add(item); } } //权限更新是否成功! if (bll.UpdateAuthorityList(list)) { BindPermissionUpdate(model.ModuleID); BindOrder(); ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_true") + "');", true); } else { ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_false") + "');", true); } break; case 2: ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_Iscaption") + "');", true); break; default: ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_false") + "');", true); break; } }
/// <summary> /// 保存新增模块信息 /// </summary> protected void btn_save_Click(object sender, EventArgs e) { RedGlovePermission.Model.RGP_Modules model = new RedGlovePermission.Model.RGP_Modules(); model.ModuleTypeID = int.Parse(ModuleType.SelectedValue); model.ModuleName = txt_Name.Text.Trim(); model.ModuleTag = txt_tag.Text.Trim(); model.ModuleURL = txt_url.Text.Trim(); if (txt_state.SelectedValue == "0") { model.ModuleDisabled = true; } else { model.ModuleDisabled = true; } model.ModuleOrder = int.Parse(txt_order.Text.Trim()); model.ModuleDescription = txt_Description.Text.Trim(); if (IsMenu.SelectedValue == "0") { model.IsMenu = false; } else { model.IsMenu = true; } if (!bll.ModuleExists(txt_tag.Text.Trim())) { int RowID = bll.CreateModule(model); //返回模块ID; if (RowID != 0) //添加OK { ArrayList list = new ArrayList(); //建立事务列表 int n = int.Parse(AuthorityNum.Text); for (int i = 0; i < n; i++) { if (Request.Form["Alist" + i.ToString()].ToString() == "1")//如果允许则插入记录 { string item = string.Empty; item = item + RowID.ToString() + "|" + Request.Form["Atag" + i.ToString()].ToString(); list.Add(item); } } //权限加入是否成功! if (bll.CreateAuthorityList(list)) { clearTxt(); if (!Glist.Visible) { Glist.Visible = true; } BindOrder(); AddPanel.Visible = false; ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_true") + "');", true); } else { ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "');", true); } } else { ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "');", true); } } else { ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_Iscaption") + "');", true); } }
/// <summary> /// 更新时初始化权限 /// </summary> /// <param name="ModuleID"></param> public void BindPermissionUpdate(int ModuleID) { #region 模块数据绑定 RedGlovePermission.Model.RGP_Modules model = new RedGlovePermission.Model.RGP_Modules(); model = bll.GetModuleModel(ModuleID); M_ID.Text = model.ModuleID.ToString(); ModuleType.SelectedValue = model.ModuleTypeID.ToString(); txt_Name.Text = model.ModuleName; txt_tag.Text = model.ModuleTag; txt_url.Text = model.ModuleURL; if (model.ModuleDisabled) { txt_state.SelectedIndex = 0; } else { txt_state.SelectedIndex = 1; } txt_order.Text = model.ModuleOrder.ToString(); txt_Description.Text = model.ModuleDescription; if (model.IsMenu) { IsMenu.SelectedIndex = 0; } else { IsMenu.SelectedIndex = 1; } #endregion #region 权限数据绑定 StringBuilder strState = new StringBuilder(); //状态 StringBuilder strTag = new StringBuilder(); //标识 StringBuilder strVerify = new StringBuilder(); //对比状态 RedGlovePermission.BLL.RGP_AuthorityDir Abll = new RedGlovePermission.BLL.RGP_AuthorityDir(); DataSet MALDS = bll.GetAuthorityList(ModuleID); DataSet ds = Abll.GetAuthorityList("", "order by AuthorityOrder asc"); int rcount = ds.Tables[0].Rows.Count; AuthorityNum.Text = rcount.ToString(); if (rcount == 0) { divstate.InnerHtml = ResourceManager.GetString("Pub_Msg_norecord"); } else { strVerify.Append("<input type=\"hidden\" name=\"verifystate\" id=\"verifystate\" value=\""); strState.Append("<table width=\"340\" border=\"0\" cellpadding=\"0\" cellspacing=\"2\">"); for (int i = 0; i < rcount; i++) { bool v = false; for (int k = 0; k < MALDS.Tables[0].Rows.Count; k++) { if (MALDS.Tables[0].Rows[k]["AuthorityTag"].ToString() == ds.Tables[0].Rows[i]["AuthorityTag"].ToString()) { v = true; break; } } if ((i + 1) % 2 != 0) { #region 左边 if (v)//是否为可以使用的权限 { strState.Append("<tr><td width=\"50\"><span class=\"RoleTitle\">" + ResourceManager.GetString(ds.Tables[0].Rows[i]["AuthorityName"].ToString()) + "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString() + "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString() + "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" checked=\"checked\" />" + "<label for=\"Alist" + i.ToString() + "_0\">" + ResourceManager.GetString("Pub_State_enabled") + "</label></td><td>" + "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" />" + "<label for=\"Alist" + i.ToString() + "_1\">" + ResourceManager.GetString("Pub_State_disable") + "</label></td></tr></table></td>"); strVerify.Append("1,"); } else { strState.Append("<tr><td width=\"50\"><span class=\"RoleTitle\">" + ResourceManager.GetString(ds.Tables[0].Rows[i]["AuthorityName"].ToString()) + "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString() + "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString() + "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" />" + "<label for=\"Alist" + i.ToString() + "_0\">" + ResourceManager.GetString("Pub_State_enabled") + "</label></td><td>" + "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" checked=\"checked\" />" + "<label for=\"Alist" + i.ToString() + "_1\">" + ResourceManager.GetString("Pub_State_disable") + "</label></td></tr></table></td>"); strVerify.Append("0,"); } #endregion } else { #region 右边 if (v)//是否为可以使用的权限 { strState.Append("<td width=\"50\"><span class=\"RoleTitle\">" + ResourceManager.GetString(ds.Tables[0].Rows[i]["AuthorityName"].ToString()) + "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString() + "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString() + "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" checked=\"checked\" />" + "<label for=\"Alist" + i.ToString() + "_0\">" + ResourceManager.GetString("Pub_State_enabled") + "</label></td><td>" + "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" />" + "<label for=\"Alist" + i.ToString() + "_1\">" + ResourceManager.GetString("Pub_State_disable") + "</label></td></tr></table></td></tr>"); strVerify.Append("1,"); } else { strState.Append("<td width=\"50\"><span class=\"RoleTitle\">" + ResourceManager.GetString(ds.Tables[0].Rows[i]["AuthorityName"].ToString()) + "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString() + "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString() + "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" />" + "<label for=\"Alist" + i.ToString() + "_0\">" + ResourceManager.GetString("Pub_State_enabled") + "</label></td><td>" + "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" checked=\"checked\" />" + "<label for=\"Alist" + i.ToString() + "_1\">" + ResourceManager.GetString("Pub_State_disable") + "</label></td></tr></table></td></tr>"); strVerify.Append("0,"); } #endregion } //写入标识 strTag.Append("<input type=\"hidden\" name=\"Atag" + i.ToString() + "\" id=\"Atag" + i.ToString() + "\" value=\"" + ds.Tables[0].Rows[i]["AuthorityTag"] + "\" />"); } strVerify.Append("\" />"); if ((rcount) % 2 == 0) { strState.Append("</table>"); } else { strState.Append("<td width=\"50\"> </td><td width=\"100\"> </td></tr></table>"); } divstate.InnerHtml = strState.ToString() + strTag.ToString() + strVerify.ToString(); } #endregion }
/// <summary> /// 得到一个模块实体 /// </summary> /// <param name="ModuleID">模块ID</param> /// <returns></returns> public RedGlovePermission.Model.RGP_Modules GetModuleModel(int ModuleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from RGP_Modules "); strSql.Append(" where ModuleID=?ModuleID "); MySqlParameter[] parameters = { new MySqlParameter("?ModuleID", MySqlDbType.Int32, 11) }; parameters[0].Value = ModuleID; RedGlovePermission.Model.RGP_Modules model = new RedGlovePermission.Model.RGP_Modules(); DataSet ds = RedGlovePermission.DBUtility.MySqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ModuleID"].ToString() != "") { model.ModuleID = int.Parse(ds.Tables[0].Rows[0]["ModuleID"].ToString()); } if (ds.Tables[0].Rows[0]["ModuleTypeID"].ToString() != "") { model.ModuleTypeID = int.Parse(ds.Tables[0].Rows[0]["ModuleTypeID"].ToString()); } model.ModuleName = ds.Tables[0].Rows[0]["ModuleName"].ToString(); model.ModuleTag = ds.Tables[0].Rows[0]["ModuleTag"].ToString(); model.ModuleURL = ds.Tables[0].Rows[0]["ModuleURL"].ToString(); if (ds.Tables[0].Rows[0]["ModuleDisabled"].ToString() != "") { if ((ds.Tables[0].Rows[0]["ModuleDisabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["ModuleDisabled"].ToString().ToLower() == "true")) { model.ModuleDisabled = true; } else { model.ModuleDisabled = false; } } if (ds.Tables[0].Rows[0]["ModuleOrder"].ToString() != "") { model.ModuleOrder = int.Parse(ds.Tables[0].Rows[0]["ModuleOrder"].ToString()); } model.ModuleDescription = ds.Tables[0].Rows[0]["ModuleDescription"].ToString(); if (ds.Tables[0].Rows[0]["IsMenu"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsMenu"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsMenu"].ToString().ToLower() == "true")) { model.IsMenu = true; } else { model.IsMenu = false; } } return(model); } else { return(null); } }
/// <summary> /// 更新模块信息 /// </summary> protected void btn_update_Click(object sender, EventArgs e) { RedGlovePermission.Model.RGP_Modules model = new RedGlovePermission.Model.RGP_Modules(); model.ModuleID = int.Parse(M_ID.Text); model.ModuleTypeID = int.Parse(ModuleType.SelectedValue); model.ModuleName = txt_Name.Text.Trim(); model.ModuleTag = txt_tag.Text.Trim(); model.ModuleURL = txt_url.Text.Trim(); if (txt_state.SelectedValue == "0") { model.ModuleDisabled = false; } else { model.ModuleDisabled = true; } model.ModuleOrder = int.Parse(txt_order.Text.Trim()); model.ModuleDescription = txt_Description.Text.Trim(); if (IsMenu.SelectedValue == "0") { model.IsMenu = false; } else { model.IsMenu = true; } string[] vstr = Request.Form["verifystate"].Split(','); switch (bll.UpdateModule(model)) { case 1: ArrayList list = new ArrayList();//建立事务列表 int n = int.Parse(AuthorityNum.Text); for (int i = 0; i < n; i++) { //判断权限是否有变化 if (vstr[i] != Request.Form["Alist" + i.ToString()].ToString()) { string item = string.Empty; item = item + model.ModuleID.ToString() + "|" + Request.Form["Atag" + i.ToString()].ToString() + "|" + Request.Form["Alist" + i.ToString()].ToString();//判断插入增加还是删除 list.Add(item); } } //权限更新是否成功! if (bll.UpdateAuthorityList(list)) { BindPermissionUpdate(model.ModuleID); BindOrder(); ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_true") + "');", true); } else { ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_false") + "');", true); } break; case 2: ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_Iscaption") + "');", true); break; default: ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_false") + "');", true); break; } }
/// <summary> /// 保存新增模块信息 /// </summary> protected void btn_save_Click(object sender, EventArgs e) { RedGlovePermission.Model.RGP_Modules model = new RedGlovePermission.Model.RGP_Modules(); model.ModuleTypeID = int.Parse(ModuleType.SelectedValue); model.ModuleName = txt_Name.Text.Trim(); model.ModuleTag = txt_tag.Text.Trim(); model.ModuleURL = txt_url.Text.Trim(); if (txt_state.SelectedValue == "0") { model.ModuleDisabled = true; } else { model.ModuleDisabled = true; } model.ModuleOrder = int.Parse(txt_order.Text.Trim()); model.ModuleDescription = txt_Description.Text.Trim(); if (IsMenu.SelectedValue == "0") { model.IsMenu = false; } else { model.IsMenu = true; } if (!bll.ModuleExists(txt_tag.Text.Trim())) { int RowID = bll.CreateModule(model);//返回模块ID; if (RowID != 0)//添加OK { ArrayList list = new ArrayList();//建立事务列表 int n = int.Parse(AuthorityNum.Text); for (int i = 0; i < n; i++) { if (Request.Form["Alist" + i.ToString()].ToString() == "1")//如果允许则插入记录 { string item = string.Empty; item = item + RowID.ToString() + "|" + Request.Form["Atag" + i.ToString()].ToString(); list.Add(item); } } //权限加入是否成功! if (bll.CreateAuthorityList(list)) { clearTxt(); if (!Glist.Visible) Glist.Visible = true; BindOrder(); AddPanel.Visible = false; ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_true") + "');", true); } else { ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "');", true); } } else { ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "');", true); } } else { ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_Iscaption") + "');", true); } }
/// <summary> /// 更新时初始化权限 /// </summary> /// <param name="ModuleID"></param> public void BindPermissionUpdate(int ModuleID) { #region 模块数据绑定 RedGlovePermission.Model.RGP_Modules model = new RedGlovePermission.Model.RGP_Modules(); model = bll.GetModuleModel(ModuleID); M_ID.Text = model.ModuleID.ToString(); ModuleType.SelectedValue = model.ModuleTypeID.ToString(); txt_Name.Text = model.ModuleName; txt_tag.Text = model.ModuleTag; txt_url.Text = model.ModuleURL; if (model.ModuleDisabled) { txt_state.SelectedIndex = 0; } else { txt_state.SelectedIndex = 1; } txt_order.Text = model.ModuleOrder.ToString(); txt_Description.Text = model.ModuleDescription; if (model.IsMenu) { IsMenu.SelectedIndex = 0; } else { IsMenu.SelectedIndex = 1; } #endregion #region 权限数据绑定 StringBuilder strState = new StringBuilder();//状态 StringBuilder strTag = new StringBuilder();//标识 StringBuilder strVerify = new StringBuilder();//对比状态 RedGlovePermission.BLL.RGP_AuthorityDir Abll = new RedGlovePermission.BLL.RGP_AuthorityDir(); DataSet MALDS = bll.GetAuthorityList(ModuleID); DataSet ds = Abll.GetAuthorityList("", "order by AuthorityOrder asc"); int rcount=ds.Tables[0].Rows.Count; AuthorityNum.Text = rcount.ToString(); if (rcount == 0) { divstate.InnerHtml = ResourceManager.GetString("Pub_Msg_norecord"); } else { strVerify.Append("<input type=\"hidden\" name=\"verifystate\" id=\"verifystate\" value=\""); strState.Append("<table width=\"340\" border=\"0\" cellpadding=\"0\" cellspacing=\"2\">"); for (int i = 0; i < rcount; i++) { bool v = false; for (int k = 0; k < MALDS.Tables[0].Rows.Count; k++) { if (MALDS.Tables[0].Rows[k]["AuthorityTag"].ToString() == ds.Tables[0].Rows[i]["AuthorityTag"].ToString()) { v = true; break; } } if ((i + 1) % 2 != 0) { #region 左边 if (v)//是否为可以使用的权限 { strState.Append("<tr><td width=\"50\"><span class=\"RoleTitle\">" + ResourceManager.GetString(ds.Tables[0].Rows[i]["AuthorityName"].ToString()) + "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString() + "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString() + "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" checked=\"checked\" />" + "<label for=\"Alist" + i.ToString() + "_0\">" + ResourceManager.GetString("Pub_State_enabled") + "</label></td><td>" + "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" />" + "<label for=\"Alist" + i.ToString() + "_1\">" + ResourceManager.GetString("Pub_State_disable") + "</label></td></tr></table></td>"); strVerify.Append("1,"); } else { strState.Append("<tr><td width=\"50\"><span class=\"RoleTitle\">" + ResourceManager.GetString(ds.Tables[0].Rows[i]["AuthorityName"].ToString()) + "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString() + "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString() + "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" />" + "<label for=\"Alist" + i.ToString() + "_0\">" + ResourceManager.GetString("Pub_State_enabled") + "</label></td><td>" + "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" checked=\"checked\" />" + "<label for=\"Alist" + i.ToString() + "_1\">" + ResourceManager.GetString("Pub_State_disable") + "</label></td></tr></table></td>"); strVerify.Append("0,"); } #endregion } else { #region 右边 if (v)//是否为可以使用的权限 { strState.Append("<td width=\"50\"><span class=\"RoleTitle\">" + ResourceManager.GetString(ds.Tables[0].Rows[i]["AuthorityName"].ToString()) + "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString() + "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString() + "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" checked=\"checked\" />" + "<label for=\"Alist" + i.ToString() + "_0\">" + ResourceManager.GetString("Pub_State_enabled") + "</label></td><td>" + "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" />" + "<label for=\"Alist" + i.ToString() + "_1\">" + ResourceManager.GetString("Pub_State_disable") + "</label></td></tr></table></td></tr>"); strVerify.Append("1,"); } else { strState.Append("<td width=\"50\"><span class=\"RoleTitle\">" + ResourceManager.GetString(ds.Tables[0].Rows[i]["AuthorityName"].ToString()) + "</span></td><td width=\"100\"><table id=\"Alist" + i.ToString() + "\" border=\"0\"><tr><td><input id=\"Alist" + i.ToString() + "_0\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"1\" />" + "<label for=\"Alist" + i.ToString() + "_0\">" + ResourceManager.GetString("Pub_State_enabled") + "</label></td><td>" + "<input id=\"Alist" + i.ToString() + "_1\" type=\"radio\" name=\"Alist" + i.ToString() + "\" value=\"0\" checked=\"checked\" />" + "<label for=\"Alist" + i.ToString() + "_1\">" + ResourceManager.GetString("Pub_State_disable") + "</label></td></tr></table></td></tr>"); strVerify.Append("0,"); } #endregion } //写入标识 strTag.Append("<input type=\"hidden\" name=\"Atag" + i.ToString() + "\" id=\"Atag" + i.ToString() + "\" value=\"" + ds.Tables[0].Rows[i]["AuthorityTag"] + "\" />"); } strVerify.Append("\" />"); if ((rcount) % 2 == 0) { strState.Append("</table>"); } else { strState.Append("<td width=\"50\"> </td><td width=\"100\"> </td></tr></table>"); } divstate.InnerHtml = strState.ToString() + strTag.ToString() + strVerify.ToString(); } #endregion }