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