public ActionResult MyCustomPostBack(string type, JArray gridFields, JObject typeParams, int gridIndex, int gridPageSize) { var Grid1 = UIHelper.Grid("Grid1"); string sql = string.Empty; var ttbSearch = UIHelper.TwinTriggerBox("ttbSearchMessage"); if (type == "trigger1") { ttbSearch.Text(String.Empty); ttbSearch.ShowTrigger1(false); } else if (type == "trigger2") { ttbSearch.ShowTrigger1(true); var triggerValue = typeParams.Value <string>("triggerValue"); sql = " and (Name like '%" + triggerValue + "%' or Title like '%" + triggerValue + "%')"; } Hashtable table = Sys_PowersDal.Search(gridIndex, gridPageSize, "Name", "DESC", sql); Grid1.DataSource(table["data"], gridFields); Grid1.RecordCount(Int32.Parse(table["total"].ToString())); Grid1.PageSize(gridPageSize); return(UIHelper.Result()); }
private void UpdateGrid(JArray Grid1_fields, int gridIndex, int gridPageSize) { var Grid1 = UIHelper.Grid("Grid1"); string sql = string.Empty; //sql = sql + " and FDictID = " + Grid1_selectedRows; Hashtable table = Sys_PowersDal.Search(gridIndex, gridPageSize, "Name", "DESC", sql); Grid1.DataSource(table["data"], Grid1_fields); Grid1.RecordCount(Int32.Parse(table["total"].ToString())); }
public ActionResult Index() { ViewBag.CorePowerNew = CheckPower("CorePowerNew"); ViewBag.CorePowerEdit = CheckPower("CorePowerEdit"); ViewBag.CorePowerDelete = CheckPower("CorePowerDelete"); Hashtable table = Sys_PowersDal.Search(0, 20, "Name", "DESC", ""); ViewBag.Grid1DataSource = table["data"]; ViewBag.Grid1RecordCount = Int32.Parse(table["total"].ToString()); return(View()); }
private string RolePower_GetRolePowerIds(string grid1SelectedRowID) { //// 当前选中角色拥有的权限列表 DataTable dt = Sys_PowersDal.SearchRolePowerTable(" RoleID=" + grid1SelectedRowID); var q = from z in dt.AsEnumerable() select new { RoleID = z.Field <int>("RoleID"), PowerID = z.Field <int>("PowerID") }; return(new JArray(q.Select(x => x.PowerID)).ToString(Newtonsoft.Json.Formatting.None)); }
public ActionResult Grid1_PageIndexChanged(JArray Grid1_fields, int Grid1_pageIndex, int gridPageSize) { var Grid1 = UIHelper.Grid("Grid1"); string sql = string.Empty; //sql = sql + " and FDictID = " + selectedRowId; Hashtable table = Sys_PowersDal.Search(Grid1_pageIndex, gridPageSize, "Name", "DESC", sql); Grid1.DataSource(table["data"], Grid1_fields); Grid1.RecordCount(Int32.Parse(table["total"].ToString())); return(UIHelper.Result()); }
/// <summary> /// 获取当前登录用户拥有的全部权限列表 /// </summary> /// <param name="roleIDs"></param> /// <returns></returns> protected List <string> GetRolePowerNames() { // 将用户拥有的权限列表保存在Session中,这样就避免每个请求多次查询数据库 if (Session["UserPowerList"] == null) { List <string> rolePowerNames = new List <string>(); // 超级管理员拥有所有权限 if (GetIdentityName() == "admin") { ArrayList PowerNames = Sys_PowersDal.GetPowerNameList(); foreach (Hashtable a in PowerNames) { rolePowerNames.Add(a["Name"].ToString()); } } else { if (User.Identity.IsAuthenticated) { FormsAuthenticationTicket ticket = ((FormsIdentity)User.Identity).Ticket; string userData = ticket.UserData; if (!String.IsNullOrEmpty(userData)) { ArrayList PowerNames = Sys_PowersDal.GetPowerNameList(userData); if (PowerNames != null) { foreach (Hashtable a in PowerNames) { rolePowerNames.Add(a["Name"].ToString()); } } } } } Session["UserPowerList"] = rolePowerNames; } return((List <string>)Session["UserPowerList"]); }
public ActionResult btnCreate_Click() { try { string fname = Request["tbxName"]; int ParentID = Convert.ToInt32(Request["ddlParent"]); int SortIndex = Convert.ToInt32(Request["tbxSortIndex"]); Hashtable hasDataID = new Hashtable(); hasDataID = Sys_PowersDal.Get(Request["tbxViewPower"].ToString(), "A"); int ViewPowerID = 0; if (hasDataID != null) { ViewPowerID = Convert.ToInt32(hasDataID["FID"].ToString()); } string Url = Request["tbxUrl"]; string Icon = Request["tbxIcon"]; string Remark = Request["tbxRemark"]; sys_Menus model = new sys_Menus(); model.Name = fname; model.ParentID = ParentID == -1 ? 0 : ParentID; model.SortIndex = SortIndex; model.ViewPowerID = ViewPowerID; model.ImageUrl = Icon; model.NavigateUrl = Url; model.Remark = Remark; db.sys_Menus.Add(model); db.SaveChanges(); ShowNotify("添加成功!"); // 关闭本窗体(触发窗体的关闭事件) PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } catch { ShowNotify("添加失败!"); } return(UIHelper.Result()); }
public ActionResult Grid1_RowSelect(string selectedRowId, JArray Grid2_fields) { // 当前选中角色拥有的权限列表 _currentRolePowers.Clear(); Hashtable table = Sys_PowersDal.SearchRolePower(0, 0, "Name", "DESC", " and RoleID=" + selectedRowId); DataTable dt = (DataTable)table["data"]; for (int i = 0; i < dt.Rows.Count; i++) { string powerName = dt.Rows[i]["Name"].ToString();; if (!_currentRolePowers.ContainsKey(powerName)) { _currentRolePowers.Add(powerName, true); } } Hashtable tableGroup = Sys_PowersDal.SearchGroupName(0, 0, "GroupName", "ASC", ""); DataTable dtGroup = (DataTable)tableGroup["data"]; UIHelper.Grid("Grid2").DataSource(dtGroup, Grid2_fields); return(UIHelper.Result()); }
private List <GroupPowerViewModel> RolePower_GetData() { string sql1 = string.Empty; string sql2 = string.Empty; if (GetUserType().Equals("3")) //如果登录用户是客户 { sql1 = sql1 + " IsCustomerLook=1"; sql2 = sql2 + " and b.IsCustomerLook=1"; } Hashtable tableGroup = Sys_PowersDal.SearchGroupName(0, 0, "GroupName", "ASC", sql1); DataTable dtGroup = (DataTable)tableGroup["data"]; List <GroupPowerViewModel> groupPowers = new List <GroupPowerViewModel>(); for (int i = 0; i < dtGroup.Rows.Count; i++) { var groupPower = new GroupPowerViewModel(); groupPower.GroupName = dtGroup.Rows[i][0].ToString(); Hashtable table = Sys_PowersDal.SearchGroupList(0, 0, "Name", "DESC", " and a.GroupName='" + dtGroup.Rows[i][0].ToString() + "'" + sql2); DataTable dt = (DataTable)table["data"]; JArray ja = new JArray(); for (int j = 0; j < dt.Rows.Count; j++) { JObject jo = new JObject(); jo.Add("id", dt.Rows[j]["ID"].ToString()); jo.Add("name", dt.Rows[j]["Name"].ToString()); jo.Add("title", dt.Rows[j]["Title"].ToString()); ja.Add(jo); } groupPower.Powers = ja; groupPowers.Add(groupPower); } return(groupPowers); }
public ActionResult RolePower_Grid2_DoPostBack(JArray Grid1_fields, JArray Grid2_fields, string Grid2_sortField, string Grid2_sortDirection, string actionType, string ttbSearchCustomer, int selectedRoleId, JArray selectedPowerIds) { // 保存角色权限时,不需要重新加载表格数据 if (actionType == "ttbSearchCustomer") { string sql1 = ""; if (!ttbSearchCustomer.Equals("")) { sql1 = " and RType=1 and b.Name='" + ttbSearchCustomer + "'"; } else { sql1 = " and RType=0"; } DataTable dt1 = sys_rolesDal.SearchTable(sql1); if (dt1.Rows.Count > 0) { selectedRoleId = Convert.ToInt32(dt1.Rows[0]["ID"].ToString()); } else { selectedRoleId = 0; } var grid1UI = UIHelper.Grid("Grid1"); grid1UI.DataSource(dt1, Grid1_fields); grid1UI.SelectedRowIndexArray(0); PageContext.RegisterStartupScript("updateRolePowers(" + RolePower_GetRolePowerIds(selectedRoleId.ToString()) + ");"); return(UIHelper.Result()); } else if (actionType == "saveall") { if (selectedRoleId == 0) { Alert.ShowInTop("请选择角色再进行权限设置!"); } else { //// 在操作之前进行权限检查 if (!CheckPower("CoreRolePowerEdit")) { CheckPowerFailWithAlert(); return(UIHelper.Result()); } // 当前角色新的权限列表 int[] newPowerIDs = selectedPowerIds.ToObject <int[]>(); Sys_PowersDal dal = new Sys_PowersDal(); dal.DeleteRowerPower(selectedRoleId); foreach (var item in newPowerIDs) { Hashtable hasData = new Hashtable(); hasData["RoleID"] = selectedRoleId; //tbxName.Text; hasData["PowerID"] = item; //tbxGroupName.Text; Sys_PowersDal.InsertRolePowers(hasData); } Alert.ShowInTop("当前角色的权限更新成功!"); } } else { var grid2UI = UIHelper.Grid("Grid2"); grid2UI.DataSource(RolePower_GetData(), Grid2_fields); // 更新当前角色的权限 PageContext.RegisterStartupScript("updateRolePowers(" + RolePower_GetRolePowerIds(selectedRoleId.ToString()) + ");"); } return(UIHelper.Result()); }