/// <summary>
/// 得到用户统计
/// </summary>
/// <returns></returns>
public ActionResult GetUsersStatList(UsersStatSearchDTO dto)
{
ResultData <List <UsersStatModel> > result = new ResultData <List <UsersStatModel> >();
result = SystemProvider.GetUsersStatList(dto);
return(Json(new { total = result.Count, rows = result.Object }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 导出用户统计
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public ActionResult ExportUsersStat(UsersStatSearchDTO dto)
{
string result = null;
dto.page = 1;
dto.rows = 10000000;
List <UsersStatModel> pp = null;
pp = SystemProvider.GetUsersStatList(dto).Object;
string strTemplateFile = Server.MapPath(@"~/TempLate/UsersStatTemplate.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.ExcelUsersStat er = new Models.Model.Excel.ExcelUsersStat();
er.部门 = g.DepartName;
er.用户名称 = g.FullName;
er.用户类型 = g.UserTypeName;
er.手机号 = g.PhoneNumber;
er.经销商 = g.UserDistributorstr;
er.使用模块 = g.UseModel;
er.使用时间 = g.UseModelTime.HasValue?g.UseModelTime.Value.ToString("yyyy-MM-dd HH:mm:ss"):null;
ratelist.Add(er);
});
if (Common.ExcelHelper.Export(strTemplateFile, strGenarateDir, strGenarateFile, ratelist, "Sheet1"))
{
result = strGenarateFile;
}
return(Json(result));
}