public List <SelectSumAppUserList> GetSelectSumAppUserList2(RouteSumAppUser2 request)
{
if (AdcdHelper.GetByAdcdRole(request.adcd) == "省级")
{
return(GetProvinceList2(request.adcd, request.adcdName));
//userSql += " and a.adcd like '33%'";
//appSql += " and b.adcd like '33%'";
}
return(null);
}
public FileResult DownSumExcel()
{
RouteSumAppUser2 model = new RouteSumAppUser2();
model.adcd = adcd;
model.adcdName = "浙江省";
List <SelectSumAppUserList> list = logic.GetSelectSumAppUserList2(model);
list = list.OrderBy(x => x.adcdId).ToList();
list = ArrangeHelper.GetList(list);
List <string> title = new List <string>();
title.Add("单位名称");
title.Add("责任人总人数");
title.Add("已注册人数");
HSSFWorkbook book = ExcelHelper.CreateExecl(title, list);
string strdate = "APP注册人员统计" + DateTime.Now.ToString("yyyyMMddhhmmss");//获取当前
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
return(File(ms, "application/vnd.ms-excel", strdate + ".xls"));
}
public List <SelectSumAppUserList> Get(RouteSumAppUser2 request)
{
return(logic.GetSelectSumAppUserList2(request));
}
