/// <summary> /// 得到所有用户信息(含模糊查询) /// </summary> /// <param name="dto"></param> /// <returns></returns> public ActionResult GetUser(UserSearchDTO dto) { ResultData <List <UserResultDTO> > result = null; result = UserAuthorityProvider.GetUser(dto); return(Json(new { total = result.Count, rows = result.Object }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出用户信息 /// </summary> /// <param name="dto"></param> /// <returns></returns> public ActionResult ExportUser(UserSearchDTO dto) { string result = null; List <UserResultDTO> pp = null; dto.page = 1; dto.rows = 10000000; pp = UserAuthorityProvider.GetUser(dto).Object; string strTemplateFile = Server.MapPath(@"~/TempLate/UserTemplate.xlsx"); string strGenarateDir = Server.MapPath(@"~/TempFile"); string strGenarateFile = Guid.NewGuid().ToString("N") + ".xlsx"; string strExportFile = strGenarateDir + "\\" + strGenarateFile; List <object> ratelist = new List <object>(); pp.ForEach(g => { Models.Model.Excel.ExcelUser er = new Models.Model.Excel.ExcelUser(); er.状态 = g.IsActivestr; er.用户编号 = g.UserCode; er.用户名称 = g.FullName; er.手机号 = g.PhoneNumber; er.邮箱 = g.Email; er.角色 = g.UserRoleName; er.经销商 = g.UserDistributorstr; er.到期日 = g.StopTime != null ? g.StopTime.Value.ToString("yyyy-MM-dd") : ""; er.停用日期 = g.NoActiveTime != null ? g.NoActiveTime.Value.ToString("yyyy-MM-dd") : ""; string quanx = ""; g.UserAuthority.Where(p => p.StructureID.Length == 3).ToList().ForEach(a => { quanx += a.StructureName + "["; g.UserAuthority.Where(p => p.StructureID.Length == 6 && p.StructureID.StartsWith(a.StructureID)).ToList().ForEach(b => { quanx += b.StructureName + "("; g.UserAuthority.Where(p => p.StructureID.Length == 9 && p.StructureID.StartsWith(b.StructureID)).ToList().ForEach(c => { quanx += c.StructureName + ","; }); quanx += "),"; }); quanx += "],"; }); er.权限 = quanx; ratelist.Add(er); }); if (Common.ExcelHelper.Export(strTemplateFile, strGenarateDir, strGenarateFile, ratelist, "Sheet1")) { result = strGenarateFile; } return(Json(result)); }
/// <summary> /// 得到所有客户模块管理员人员 /// </summary> /// <returns></returns> public ActionResult GetCustomerAdminList() { UserSearchDTO dto = new UserSearchDTO(); dto.RoleIDlist = new List <int?>() { 98 }; dto.page = 1; dto.rows = 10000000; ResultData <List <UserResultDTO> > result = null; result = UserAuthorityProvider.GetUser(dto); return(Json(result.Object, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 记录短信登录 /// </summary> /// <param name="PhoneNumber"></param> /// <param name="SendContent"></param> /// <returns></returns> public static bool SaveMessageLog(string PhoneNumber, string SendContent = null) { bool result = false; UserSearchDTO dto = new UserSearchDTO(); dto.PhoneNumber = PhoneNumber; dto.page = 1; dto.rows = 1; var user = UserAuthorityProvider.GetUser(dto); List <MessageOperateDTO> msgdtolist = new List <MessageOperateDTO>(); msgdtolist.Add(new MessageOperateDTO { UserID = user.Object.Select(m => m.UserID).FirstOrDefault(), SendTime = DateTime.Now, MessageType = 0 }); TCSOFT.DMS.WebMain.Models.Provider.CommonProvider.AddMessageStat(msgdtolist); return(result); }
private bool CheckUserInfo(object obj) { bool result = true; List <ExcelUser> exceldto = (List <ExcelUser>)obj; UserSearchDTO dto = new UserSearchDTO(); dto.rows = 100000000; dto.page = 1; var UserInfoList = UserAuthorityProvider.GetUser(dto); DistributorSearchDTO disdto = new DistributorSearchDTO(); disdto.page = 1; disdto.rows = 1000000000; var distributorlist = DistributorProvider.GetDistributorList(disdto);//所有经销商 RoleSearchDTO roleSearch = new RoleSearchDTO(); var rolelist = UserAuthorityProvider.GetRoleList(roleSearch); string strimporter = ((UserLoginDTO)Session["UserLoginInfo"]).FullName; foreach (var p in exceldto) { StringBuilder sb = new StringBuilder(); if (String.IsNullOrEmpty(p.UserCode)) { sb.Append("用户编号不可为空! "); } else { var UserID = UserInfoList.Object.Where(m => m.UserCode == p.UserCode).Select(m => m.UserID).FirstOrDefault(); if (UserID != null) { p.UserID = UserID; p.UpLogic = 2; } else { p.UpLogic = 1; } } if (String.IsNullOrEmpty(p.Email)) { sb.Append("用户邮箱不可为空! "); } if (String.IsNullOrEmpty(p.PhoneNumber)) { sb.Append("用户手机号不可为空! "); } else { //手机号在此不做唯一性判断。 //var PhoneNumber = UserInfoList.Object.Where(m => m.PhoneNumber == p.PhoneNumber).Select(m => m.PhoneNumber).FirstOrDefault(); //if (PhoneNumber != null) //{ // sb.Append("用户手机号不可重复"); //} } if (String.IsNullOrEmpty(p.DistributorNamestr)) { //sb.Append("所属经销商不可为空!"); } else { foreach (var dis in p.DistributorNamelist) { var exist = distributorlist.Object.Where(m => m.DistributorName == dis).FirstOrDefault(); if (exist == null) { sb.Append("经销商名称填写错误!错误名称为" + dis + "请检查!"); } else { } } } if (String.IsNullOrEmpty(p.RoleNamestr)) { //sb.Append("用户角色不可为空! "); } else { foreach (var role in p.RoleNamelist) { var exist = rolelist.Where(m => m.RoleName == role).FirstOrDefault(); if (exist == null) { sb.Append("角色" + role + "不存在!"); } } } if (String.IsNullOrEmpty(p.StopTime)) { sb.Append("使用的截止日期不可为空! "); } p.Importer = strimporter; if (sb.Length > 0) { p.CheckInfo = sb.ToString(); result = false; } } return(result); }