public List <M_Permission> getCheckState(int UTID) { List <M_Permission> d = new List <M_Permission>(); try { string sql = "select MID,UTID from M_Permission where UTID=" + UTID + ""; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null); while (reader.Read()) { M_Permission mp = new M_Permission(); //mp.PID = (int)reader["PID"]; U_UserType ut = new U_UserType(); ut.UTID = (int)reader["UTID"]; mp.UTID = ut; M_MeauInfo mm = new M_MeauInfo(); mm.MID = (int)reader["MID"]; mp.MID = mm; d.Add(mp); } } catch (Exception) { throw; } return(d); }
protected void Page_Load(object sender, EventArgs e) { if (function.isAjax()) { string codes = Request.Form["Codes"]; string nodeid = Request.Form["NodeID"]; string str = ""; int id = DataConverter.CLng(Request.Form["ID"]); if (codes != "") { str = Add(codes, id, nodeid); } else { str = Del(id); } Response.Write(str); Response.End(); } if (!IsPostBack) { M_Permission structMod = perbll.SelReturnModel(Mid); OATopNodeID_T.Text = bup.GetNodeIDs(Mid, "OATop"); OADelNodeID_T.Text = bup.GetNodeIDs(Mid, "OADel"); OAEditNodeID_T.Text = bup.GetNodeIDs(Mid, "OAEdit"); RoleName.Text = structMod.RoleName; RoleInfo.Text = structMod.Info; Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "I/Main.aspx'>工作台</a></li><li><a href='UserManage.aspx'>用户管理</a></li><li><a href='../Addon/StructList.aspx'>组织结构</a></li><li class='active'><a href='" + Request.RawUrl + "'>权限设置</a></li>"); } }
/// <summary> /// 列举模型字段 /// </summary> protected void Modellistload() { int id = DataConverter.CLng(Request.QueryString["id"]); M_Permission pinfo = pll.GetSelect(id); string fieldlistvalues = "";// pinfo.Fieldlist; string tempfield = "," + fieldlistvalues + ","; DataTable mtable = mll.GetList(); for (int i = 0; i < mtable.Rows.Count; i++) { DataList_LB.Items.Add(new ListItem(mtable.Rows[i]["ModelName"].ToString(), mtable.Rows[i]["ModelID"].ToString())); } string fields = ""; DataTable mtables = mll.GetList(); for (int i = 0; i < mtables.Rows.Count; i++) { fields += "<optgroup label=\"" + mtable.Rows[i]["ModelName"].ToString() + "\">"; DataTable modefields = fll.GetModelFieldList(DataConverter.CLng(mtable.Rows[i]["ModelID"].ToString())); for (int ii = 0; ii < modefields.Rows.Count; ii++) { //字段默认选中 string selecttxt = ""; if (tempfield.IndexOf("," + modefields.Rows[ii]["FieldID"].ToString() + ",") > -1) { selecttxt = "selected=\"selected\""; } fields += "<option " + selecttxt + " value=\"" + modefields.Rows[ii]["FieldID"].ToString() + "\">" + modefields.Rows[ii]["FieldAlias"].ToString() + "</option>"; } } fields = "<select multiple=\"multiple\" class=\"tdbg\" name=\"Fieldlist\" size=\"4\" style=\"height:284px;width:216px;\">" + fields + "</select>"; Label2.Text = fields; }
protected string Add(string codes, int id, string nodeid) { M_Permission perMod = perbll.SelReturnModel(id); perMod.Auth_OA = codes; perbll.GetUpdate(perMod); return("1"); }
protected void Button1_Click(object sender, EventArgs e) { int id = DataConverter.CLng(Request.QueryString["id"]); if (id > 0) { string Item = Request.Form["Item"] == null ? "" : Request.Form["Item"]; if (Item != "") { if (Item.IndexOf(",") > -1) { string[] str = Item.Split(new string[] { "," }, StringSplitOptions.None); for (int i = 0; i < str.Length; i++) { int spid = DataConverter.CLng(str[i]); M_Permission pinfo = pll.GetSelect(spid); string Ugroup = pinfo.UserGroup; if (Ugroup != "")//不为空 { //判断是否存在 string newgroup = Ugroup; if (newgroup.IndexOf("," + id + ",") < 0) { Ugroup = Ugroup + "," + id + ","; } } else //为空 { Ugroup = "," + id.ToString() + ","; } pinfo.UserGroup = Ugroup; pll.GetUpdate(pinfo); } } else { int spid = DataConverter.CLng(Item); M_Permission pinfo = pll.GetSelect(spid); string Ugroup = pinfo.UserGroup; if (Ugroup != "")//不为空 { string newgroup = Ugroup; if (newgroup.IndexOf("," + id + ",") < 0) { Ugroup = Ugroup + "," + id + ","; } } else //为空 { Ugroup = "," + id.ToString() + ","; } pinfo.UserGroup = Ugroup; pll.GetUpdate(pinfo); } } } Response.Write("<script language=javascript>window.close();opener.location.reload();</script>"); }
public IActionResult UserRoleAdd() { M_Permission model = new M_Permission(); if (Mid > 0) { model = urBll.SelReturnModel(Mid); } return(View(model)); }
public bool InsertUpdate(M_Permission model) { if (model.ID > 0) { GetUpdate(model); } else { GetInsert(model); } return(true); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Mid < 1) { function.WriteErrMsg("未指定角色"); } M_Permission perMod = perBll.SelReturnModel(Mid); MyBind(); Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "Main.aspx'>工作台</a></li><li><a href='AdminManage.aspx'>用户管理</a></li><li><a href='PermissionInfo.aspx'>角色管理</a></li><li class='active'>" + perMod.RoleName + "</li> [<a href='javascript:;' id='selUsers'>新增会员</a>]"); } }
public IActionResult UserRoleAdd_Submit(M_Permission model) { M_Permission urMod = new M_Permission(); if (Mid > 0) { urMod = urBll.SelReturnModel(Mid); } urMod.RoleName = model.RoleName; urMod.Info = model.Info; if (urMod.ID > 0) { urBll.GetUpdate(urMod); } else { urBll.GetInsert(urMod); } return(WriteOK("操作成功", "UserRole")); }
public string GetCodes() { M_Permission perMod = perbll.SelReturnModel(Mid); return(perMod.Auth_OA); }
protected void Page_Load(object sender, EventArgs e) { if (!B_ARoleAuth.Check(ZLEnum.Auth.user, "UserManage")) { function.WriteErrMsg("没有权限进行此项操作"); } string menu = Request.QueryString["menu"]; int id = DataConverter.CLng(Request.QueryString["id"]); if (!IsPostBack) { nodelistload(0); tdtext.Visible = false; tdlist.Visible = false; if (menu == "edit") { M_Permission pinfo = pll.GetSelect(id); this.txtID.Value = pinfo.ID.ToString(); this.txtRoleName.Text = pinfo.RoleName.ToString(); this.txtInfo.Text = pinfo.Info.ToString(); this.txtPrecedence.Text = pinfo.Precedence.ToString(); DataSet ds = function.XmlToTable(pinfo.Perlist); if (ds.Tables.Count > 0) { #region 设置选择节点 string nodelistvalues = ds.Tables[0].Rows[0]["Nodelist"].ToString(); nodelistvalues = nodelistvalues.TrimEnd(new char[] { ',' }); nodelistvalues = nodelistvalues.TrimStart(new char[] { ',' }); //节点默认选中 SelectList(Nodelist_LB, nodelistvalues); #endregion #region 设置选择模型字段 fieldlistvalues = ds.Tables[0].Rows[0]["Fieldlist"].ToString(); fieldlistvalues = fieldlistvalues.TrimEnd(new char[] { ',' }); fieldlistvalues = fieldlistvalues.TrimStart(new char[] { ',' }); Modellistload(); #endregion #region 设置模型表 string datalistvalues = ds.Tables[0].Rows[0]["DataList"].ToString(); datalistvalues = datalistvalues.TrimEnd(new char[] { ',' }); datalistvalues = datalistvalues.TrimStart(new char[] { ',' }); //数据库列表默认选中 SelectList(DataList_LB, datalistvalues); #endregion #region 设置时段浏览 if (DataConverter.CLng(ds.Tables[0].Rows[0]["Time"].ToString()) == 1) { rblTime.SelectedIndex = 0; rblTime_SelectedIndexChanged(null, null); //月份 string Month = ds.Tables[0].Rows[0]["Month"].ToString(); Month = Month.TrimEnd(new char[] { ',' }); Month = Month.TrimStart(new char[] { ',' }); SelectList(cblMonth, Month); //日期 string Day = ds.Tables[0].Rows[0]["Day"].ToString(); Day = Day.TrimEnd(new char[] { ',' }); Day = Day.TrimStart(new char[] { ',' }); SelectList(cblDay, Day); //小时 string Hour = ds.Tables[0].Rows[0]["Hour"].ToString(); Hour = Hour.TrimEnd(new char[] { ',' }); Hour = Hour.TrimStart(new char[] { ',' }); SelectList(cblHour, Hour); //星期 string Weeks = ds.Tables[0].Rows[0]["Weeks"].ToString(); Weeks = Weeks.TrimEnd(new char[] { ',' }); Weeks = Weeks.TrimStart(new char[] { ',' }); SelectList(cblWeeks, Weeks); } else { rblTime.SelectedIndex = 1; rblTime_SelectedIndexChanged(null, null); } #endregion #region 设置内容操作 //允许内容浏览 if (ds.Tables[0].Rows[0]["ViewContent"].ToString() == "1") { this.ViewContent.SelectedValue = "1"; } else { this.ViewContent.SelectedValue = "0"; } //允许列表浏览 if (ds.Tables[0].Rows[0]["ListContent"].ToString() == "1") { this.ListContent.SelectedValue = "1"; } else { this.ListContent.SelectedValue = "0"; } //允许新增发布 if (ds.Tables[0].Rows[0]["AddContent"].ToString() == "1") { this.AddContent.SelectedValue = "1"; } else { this.AddContent.SelectedValue = "0"; } //允许编辑修改 if (ds.Tables[0].Rows[0]["ModefiyContent"].ToString() == "1") { this.ModefiyContent.SelectedValue = "1"; } else { this.ModefiyContent.SelectedValue = "0"; } //允许删除内容 if (ds.Tables[0].Rows[0]["DeleteContent"].ToString() == "1") { this.DeleteContent.SelectedValue = "1"; } else { this.DeleteContent.SelectedValue = "0"; } //允许评论权限 if (ds.Tables[0].Rows[0]["AddComm"].ToString() == "1") { this.AddComm.SelectedValue = "1"; } else { this.AddComm.SelectedValue = "0"; } #endregion } if (pinfo.IsTrue == true) { this.txtIsTrue.SelectedValue = "1"; } else { this.txtIsTrue.SelectedValue = "0"; } this.type = "修改角色"; this.Button1.Text = "修改角色"; } else { Modellistload(); } this.txtID.Value = id.ToString(); Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "Main.aspx'>工作台</a></li><li><a href='UserManage.aspx'>用户管理</a></li><li><a href='PermissionInfo.aspx'>角色管理</a></li><li>添加角色</li>"); } }
public int GetInsert(M_Permission model) { return(DBCenter.Insert(model)); }
public bool GetUpdate(M_Permission model) { return(DBCenter.UpdateByID(model, model.ID)); }
public int GetInsert(M_Permission model) { return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }
public bool GetUpdate(M_Permission model) { return(Sql.UpdateByIDs(TbName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters())); }