public ActionResult DepartmentLimit(int departmentid) { //List<IGrouping<int, V_DepUserLimitInfo>> groupList = ef.V_DepUserLimitInfo.Where(a => a.isDel == 0 && (a.departmentId==departmentid || a.departmentId==null)).GroupBy(m => m.ParentId).ToList(); //Dictionary<int, List<V_DepUserLimitInfo>> dic = new Dictionary<int, List<V_DepUserLimitInfo>>(); //List<IGrouping<int, hx_AdminLimitInfo>> groupList = ef.hx_AdminLimitInfo.Where(a => a.isDel == 0).GroupBy(m => m.ParentId).ToList(); //Dictionary<int, List<hx_AdminLimitInfo>> dic = new Dictionary<int, List<hx_AdminLimitInfo>>(); //if (groupList != null && groupList.Count() > 0) //{ // foreach (var item in groupList) // { // dic.Add(item.Key, item.ToList()); // } //} hx_td_department dep = (from a in ef.hx_td_department where a.department_id == departmentid select a).SingleOrDefault(); if (dep == null || dep.department_id < 1) { return(Content(StringAlert.Alert("没有找到对应的部门信息!"), "text/html")); } Dictionary <int, List <hx_AdminLimitInfo> > dic = new ChuanglitouP2P.BLL.EF.UserLimitByEF().GetDepartmentLimit((int)dep.parentid); ViewBag.departmentid = departmentid; return(View(dic)); }
public ActionResult UserLimit(int userid) { Dictionary <int, List <hx_AdminLimitInfo> > dic = new Dictionary <int, List <hx_AdminLimitInfo> >(); hx_td_adminuser user = (from u in ef.hx_td_adminuser where u.adminuserid == userid select u).SingleOrDefault(); if (user == null || user.adminuserid < 1) { return(Content(StringAlert.Alert("没有找到相关的用户信息!"), "text/html")); } ////var sql = string.Format("", user.department_id); //StringBuilder sql = new StringBuilder(); //sql.Append("WITH treeTB(id) as("); //sql.AppendFormat("select limitId from hx_DepUserLimit where departmentId='{0}' ", user.department_id); //sql.Append(" union all "); //sql.Append("select ParentId from hx_AdminLimitInfo inner join treeTB ON hx_AdminLimitInfo.id=treeTB.id)"); //sql.Append("select * from treeTB;"); //DataTable dt = DbHelperSQL.GET_DataTable_List(sql.ToString()); //if (dt != null && dt.Rows.Count > 0) //{ // string ids = ""; // foreach (DataRow dr in dt.Rows) // { // if (ids.Length>0) // { // ids = ids + ","; // } // ids = ids + dr["id"].ToString(); // } // List<IGrouping<int, hx_AdminLimitInfo>> groupList = ef.hx_AdminLimitInfo.Where(a => a.isDel == 0 && ids.Contains(a.id.ToString())).GroupBy(m => m.ParentId).ToList(); // dic = new Dictionary<int, List<hx_AdminLimitInfo>>(); // if (groupList != null && groupList.Count() > 0) // { // foreach (var item in groupList) // { // dic.Add(item.Key, item.ToList()); // } // } //} dic = new ChuanglitouP2P.BLL.EF.UserLimitByEF().GetDepartmentLimit((int)user.department_id); ViewBag.userid = userid; ViewBag.department_id = user.department_id; return(View(dic)); }