public ActionResult Add(hx_td_adminuser t) { var userpass = t.userpass; t = (hx_td_adminuser)Utils.ValidateModelClass(t); // t.userpass = DESEncrypt.Encrypt(userpass.Trim(), ConfigurationManager.AppSettings["KEYS"].ToString()); t.userpass = Utils.MD5(userpass.Trim()); t.province = "0"; t.city = "0"; t.email = ""; t.datetime = DateTime.Now; t.lastLoginTime = DateTime.Now; t.loginTimes = 0; t.area_id = 0; ef.hx_td_adminuser.Add(t); int id = ef.SaveChanges(); if (id > 0) { return(Content(StringAlert.Alert("操作成功", "/admin/AdminUser/index"), "text/html")); } else { return(Content(StringAlert.Alert("操作失败"), "text/html")); } }
public ActionResult Editor(hx_td_adminuser p) { string[] proNames; if (string.IsNullOrEmpty(p.userpass)) { proNames = new string[] { "trueName", "worknum", "sex", "tel", "phone_number", "department_id", "state" }; } else { p.userpass = Utils.MD5(p.userpass); proNames = new string[] { "trueName", "worknum", "sex", "tel", "phone_number", "department_id", "state", "userpass" }; } p = (hx_td_adminuser)Utils.ValidateModelClass(p); DbEntityEntry entry = ef.Entry <hx_td_adminuser>(p); entry.State = EntityState.Unchanged; foreach (string ProName in proNames) { entry.Property(ProName).IsModified = true; } int i = ef.SaveChanges(); if (i > 0) { return(Content(StringAlert.Alert("操作成功", "/admin/AdminUser/index"), "text/html")); } else { return(Content(StringAlert.Alert("操作失败"), "text/html")); } }
public ActionResult Editor(int id) { hx_td_adminuser model = (from a in ef.hx_td_adminuser where a.adminuserid == id select a).SingleOrDefault(); ViewBag.department = new SelectListByEF().GetDepartmentDropDownList(0, "0", "请选择"); ViewBag.id = id; return(View(model)); }
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)); }
public ActionResult GetUserLeftLimit() { var userid = Utils.GetAdmUserID(); 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(); //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()) && a.level < 4).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()); } } } return(View(dic)); }