public static string getstuAllInfoToExcle()
{
int code = 1;
string message = "返回数据成功";
List <StuAllInfo> ListUser = new List <StuAllInfo>();
using (StuAllInfoBLL bll = new StuAllInfoBLL())
{
ListUser = bll.getStuAllInfo();
}
XlsDocument xls = new XlsDocument();//建立excle工作表
if (ListUser.Count != 0)
{
xls.FileName = DateTime.Now.ToString("u").Replace(":", "-").Replace("Z", "") + ".xls";
Worksheet sheet = xls.Workbook.Worksheets.Add("考生数据");
Cells cells = sheet.Cells;
cells.Add(1, 1, "身份证号");
cells.Add(1, 2, "姓名");
cells.Add(1, 3, "性别");
cells.Add(1, 4, "准考证号");
cells.Add(1, 5, "手机号");
cells.Add(1, 6, "第一志愿");
cells.Add(1, 7, "第二志愿");
for (int i = 2; i < ListUser.Count; i++)
{
cells.Add(i, 1, ListUser[i - 2].Sfzh);
cells.Add(i, 2, ListUser[i - 2].StuName);
cells.Add(i, 3, ListUser[i - 2].Xb == 1 ? "男" : "女");
cells.Add(i, 4, ListUser[i - 2].Zkzh);
cells.Add(i, 5, ListUser[i - 2].Mobile);
if (ListUser[i - 2].FrsZY != null)
{
cells.Add(i, 6, getZymcByZydm(ListUser[i - 2].FrsZY));
}
if (ListUser[i - 2].SecZY != null)
{
if (ListUser[i - 2].SecZY.Trim().Length != 0)
{
cells.Add(i, 7, getZymcByZydm(ListUser[i - 2].SecZY));
}
cells.Add(i, 7, getZymcByZydm(ListUser[i - 2].SecZY));
}
}
xls.Save(HttpContext.Current.Server.MapPath("~/uploads") + "//");
}
return(JsonConvert.SerializeObject(new
{
code = code,
message = message,
filePath = "uploads/" + xls.FileName,
}));
}
public static string getAllStu()
{
int code = 1;
string message = "success";
List <StuAllInfo> listUser = new List <StuAllInfo>();
using (StuAllInfoBLL bll = new StuAllInfoBLL())
{
listUser = bll.getStuAllInfo();
}
XlsDocument xls = new XlsDocument();
if (listUser.Count != 0)
{
xls.FileName = DateTime.Now.ToString("u").Replace(":", "_").Replace(" ", "_") + ".xls";
Worksheet sheet = xls.Workbook.Worksheets.Add("考生数据");
Cells cells = sheet.Cells;
cells.Add(1, 1, "身份证号");
cells.Add(1, 2, "姓名");
cells.Add(1, 3, "准考证");
cells.Add(1, 4, "性别");
cells.Add(1, 5, "手机号");
cells.Add(1, 6, "第一志愿");
cells.Add(1, 7, "第二志愿");
for (int i = 1; i <= listUser.Count; i++)
{
cells.Add(i + 1, 1, listUser[i - 1].Sfzh);
cells.Add(i + 1, 2, listUser[i - 1].StuName);
cells.Add(i + 1, 3, listUser[i - 1].Zkzh);
cells.Add(i + 1, 4, listUser[i - 1].Xb == 1 ? "男" : "女");
cells.Add(i + 1, 5, listUser[i - 1].Mobile);
if (listUser[i - 1].FrsZY != null)
{
cells.Add(i + 1, 6, getZymcByZybh(listUser[i - 1].FrsZY));
}
if (listUser[i - 1].SecZY != null)
{
if (listUser[i - 1].SecZY.Trim().Length != 0)
{
cells.Add(i + 1, 7, getZymcByZybh(listUser[i - 1].SecZY));
}
}
}
xls.Save(HttpContext.Current.Server.MapPath("~/uploads") + "//");
}
return(JsonConvert.SerializeObject(
new { code = code, message = message, filePath = "uploads/" + xls.FileName }));
}
