public IActionResult WrokReport(int traid) { DataAccess.TASM_TRAVELManager mannager = new TASM_TRAVELManager(); var model = mannager.SelectByTraid(traid); return(SuccessResult(model)); }
public IActionResult ExportExcelUnion(string date, string keyword = "") { TASM_TRAVELManager manager = new TASM_TRAVELManager(); DateTime time = DateTime.Now; if (!string.IsNullOrEmpty(date)) { time = DateTime.Parse(date); } List <DirectionModel> list = new List <DirectionModel>(); manager.ListBaseUser(time, keyword, ref list); HSSFWorkbook excelBook = new HSSFWorkbook(); //创建工作簿Excel ISheet sheet1 = excelBook.CreateSheet("动向信息表"); IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("工号"); row1.CreateCell(1).SetCellValue("姓名"); row1.CreateCell(2).SetCellValue("部门"); row1.CreateCell(3).SetCellValue("职务"); row1.CreateCell(4).SetCellValue("电话"); row1.CreateCell(5).SetCellValue("当月出差天数"); for (int i = 0; i < list.Count(); i++) { NPOI.SS.UserModel.IRow rowTemp = sheet1.CreateRow(i + 1); rowTemp.CreateCell(0).SetCellValue(list[i].WORK_ID); rowTemp.CreateCell(1).SetCellValue(list[i].USER_NAME); rowTemp.CreateCell(2).SetCellValue(list[i].DEPARTMENT); rowTemp.CreateCell(3).SetCellValue(list[i].DTNAME); rowTemp.CreateCell(4).SetCellValue(list[i].MOBILE); rowTemp.CreateCell(5).SetCellValue(list[i].MOUNTHCOUNT); } var fileName = "动向信息" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-ffff") + ".xls";//文件名 //将Excel表格转化为流,输出 MemoryStream bookStream = new MemoryStream(); excelBook.Write(bookStream); bookStream.Seek(0, SeekOrigin.Begin); return(File(bookStream, "application/vnd.ms-excel", fileName)); }
public IActionResult ListCander(int userid, string date) { DateTime time = DateTime.Now; if (!string.IsNullOrEmpty(date)) { time = DateTime.Parse(date); } TASM_TRAVELManager manager = new TASM_TRAVELManager(); List <DirectionCanderModel> list = new List <DirectionCanderModel>(); manager.ListByMonth(userid, time, ref list); return(SuccessResultList(list)); }
public IActionResult List(string date, string keyword, int pageIndex, int pageSize) { TASM_TRAVELManager manager = new TASM_TRAVELManager(); SqlSugar.PageModel p = new SqlSugar.PageModel(); p.PageIndex = pageIndex; p.PageSize = pageSize; DateTime time = DateTime.Now; if (!string.IsNullOrEmpty(date)) { time = DateTime.Parse(date); } List <DirectionModel> list = new List <DirectionModel>(); manager.ListBaseUser(time, keyword, ref p, ref list); return(SuccessResultList(list, p)); }
public IActionResult ExportExcelAll(string date, string keyword = "") { DateTime?time = null; if (!string.IsNullOrEmpty(date)) { time = DateTime.Parse(date); } TASM_TRAVELManager manager = new TASM_TRAVELManager(); List <DirectionCanderModel> list = new List <DirectionCanderModel>(); manager.ListAllByDate(time, keyword, ref list); HSSFWorkbook excelBook = new HSSFWorkbook(); //创建工作簿Excel ISheet sheet1 = excelBook.CreateSheet("动向信息表"); IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("工号"); row1.CreateCell(1).SetCellValue("姓名"); row1.CreateCell(2).SetCellValue("部门"); row1.CreateCell(3).SetCellValue("报告类型"); row1.CreateCell(4).SetCellValue("时间"); row1.CreateCell(5).SetCellValue("项目名称"); row1.CreateCell(6).SetCellValue("项目编号"); row1.CreateCell(7).SetCellValue("设备名称"); row1.CreateCell(8).SetCellValue("设备数量"); row1.CreateCell(9).SetCellValue("工单名称"); row1.CreateCell(10).SetCellValue("地址"); row1.CreateCell(11).SetCellValue("日报"); row1.CreateCell(12).SetCellValue("需求协助"); row1.CreateCell(13).SetCellValue("售后人员"); for (int i = 0; i < list.Count(); i++) { NPOI.SS.UserModel.IRow rowTemp = sheet1.CreateRow(i + 1); rowTemp.CreateCell(0).SetCellValue(list[i].WORK_ID); rowTemp.CreateCell(1).SetCellValue(list[i].USER_NAME); rowTemp.CreateCell(2).SetCellValue(list[i].DEPARTMENT); rowTemp.CreateCell(3).SetCellValue(list[i].TYPE == 0?"早报":"晚报"); rowTemp.CreateCell(4).SetCellValue(list[i].CREATETIME.ToString("yyyy-MM-dd HH:mm:ss")); rowTemp.CreateCell(5).SetCellValue(list[i].PROJECTNAME); rowTemp.CreateCell(6).SetCellValue(list[i].PROJECTCODE); rowTemp.CreateCell(7).SetCellValue(list[i].MACHINENAME); rowTemp.CreateCell(8).SetCellValue(list[i].MACHINE_COUNT.ToString()); rowTemp.CreateCell(9).SetCellValue(list[i].SUPPORT_NAME); rowTemp.CreateCell(10).SetCellValue(list[i].ADDRESS); rowTemp.CreateCell(11).SetCellValue(list[i].CONTENT); rowTemp.CreateCell(12).SetCellValue(list[i].MACHINEASSIST); rowTemp.CreateCell(13).SetCellValue(list[i].REMARKS); } var fileName = "动向信息" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-ffff") + ".xls";//文件名 //将Excel表格转化为流,输出 MemoryStream bookStream = new MemoryStream(); excelBook.Write(bookStream); bookStream.Seek(0, SeekOrigin.Begin); return(File(bookStream, "application/vnd.ms-excel", fileName)); }