public JsonResult GetAuthorityGroup() { try { BLL.gigade.Model.Vendor vendorModel = new BLL.gigade.Model.Vendor(); vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"]; _vendor = new VendorMgr(connectionString); string callId = _vendor.GetSingle(vendorModel).vendor_email; AuthorityQuery query = new AuthorityQuery { Type = 1, CallId = callId }; functionGroupMgr = new FunctionVGroupMgr(connectionString); List<Function> functions = functionGroupMgr.CallerAuthorityQuery(query); var result = from f in functions group f by f.FunctionGroup into fgroup select new { Id = fgroup.Min(m => m.RowId), Text = fgroup.Key }; return Json(result); } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } return Json("[]"); }
public HttpResponseBase GetAuthorityFun(string id) { string json = string.Empty; try { BLL.gigade.Model.Vendor vendorModel = new BLL.gigade.Model.Vendor(); vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"]; _vendor = new VendorMgr(connectionString); string callId = _vendor.GetSingle(vendorModel).vendor_email; AuthorityQuery query = new AuthorityQuery { Type = 1, CallId = callId }; if (!string.IsNullOrEmpty(id)) { query.RowId = Convert.ToInt32(id); } functionGroupMgr = new FunctionVGroupMgr(connectionString); List<Function> functions = functionGroupMgr.CallerAuthorityQuery(query); StringBuilder strJson = new StringBuilder("["); foreach (Function fun in functions) { strJson.Append("{"); strJson.AppendFormat("text:\"{0}\",url:\"{1}\",id:\"{2}\",iconCls:\"{3}\",leaf:true", fun.FunctionName, fun.FunctionCode, fun.RowId, fun.IconCls); strJson.Append("}"); } strJson.Append("]"); json = strJson.ToString().Replace("}{", "},{"); } catch (Exception ex) { json = "[]"; Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetFgroupAuthority(int type=1) { string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Form["RowId"])) { //所有模組、按鈕 functionMgr = new FunctionMgr(connectionString); List<Function> all = functionMgr.Query(new Function(), type, Convert.ToInt32(Request.Form["RowId"])); //該組別擁有權限的模組、按鈕 functionGroupMgr = new FunctionGroupMgr(connectionString); AuthorityQuery query = new AuthorityQuery { GroupId = Convert.ToInt32(Request.Form["RowId"]) }; List<Function> functions = functionGroupMgr.GroupAuthorityQuery(query, type); //所有模組 var groups = from f in all where f.FunctionType == 1 group f by f.FunctionGroup into fgroup select new { Fgroup = fgroup.Key }; //所有頁面 var pages = from f in all where f.FunctionType!=2 select f; //所有按鈕 var tools = from f in all where f.FunctionType == 2 select f; StringBuilder strJson = new StringBuilder("["); foreach (var g in groups) { strJson.Append("{FunctionGroup:\"" + g.Fgroup + "\",items:["); foreach (var p in pages.Where(m=>m.FunctionGroup==g.Fgroup)) { bool isAuth = functions.Where(m => m.RowId == p.RowId).Count() > 0; strJson.Append("{RowId:" + p.RowId + ",Name:\"" + p.FunctionName + "\",checked:\"" + isAuth + "\",tools:["); foreach (var t in tools.Where(m=>m.TopValue==p.RowId)) { isAuth = functions.Where(m => m.RowId == t.RowId).Count() > 0; strJson.Append("{RowId:" + t.RowId + ",Name:\"" + t.FunctionName + "\",checked:\"" + isAuth + "\"}"); } strJson.Append("]}"); } strJson.Append("]}"); } strJson.Append("]"); json = strJson.ToString().Replace("}{", "},{"); } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public JsonResult GetAuthorityToolByUrl() { try { if (!string.IsNullOrEmpty(Request.Form["Url"])) { functionMgr = new FunctionMgr(connectionString); Function fun = functionMgr.Query(new Function { FunctionCode = Request.Form["Url"] }).FirstOrDefault(); if (fun != null) { string callId = (Session["caller"] as Caller).user_email; AuthorityQuery query = new AuthorityQuery { Type = 2, CallId = callId }; query.RowId = fun.RowId; functionGroupMgr = new FunctionGroupMgr(connectionString); List<Function> functions = functionGroupMgr.CallerAuthorityQuery(query); var result = from f in functions select new { id = f.FunctionCode, isEdit = f.UEdit }; return Json(result); } } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } return Json(""); }
public JsonResult GetAuthorityTool() { try { BLL.gigade.Model.Vendor vendorModel = (BLL.gigade.Model.Vendor)Session["vendor"]; string callId = vendorModel.vendor_email; AuthorityQuery query = new AuthorityQuery { Type = 2, CallId = callId }; if (!string.IsNullOrEmpty(Request.Form["RowId"])) { query.RowId = Convert.ToInt32(Request.Form["RowId"]); functionGroupMgr = new FunctionVGroupMgr(connectionString); List<Function> functions = functionGroupMgr.CallerAuthorityQuery(query); var result = from f in functions select new { id = f.FunctionCode }; return Json(result); } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } return Json(""); }