/// <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);
}
