public UploadFileViewModel DownloadVWGFileModel(NoVerifyGetVWGFileModel request) { UploadFileViewModel _ufvm = new UploadFileViewModel(); var _year = null == request.year || request.year == 0 ? DateTime.Now.Year : request.year; var name = RealName + _year + "“村级防汛防台工作组”模板" + DateTime.Now.ToString("MMddhhmmss") + new Random(DateTime.Now.Second).Next(10000); var filesavepath = "Files/" + RealName + "/WorkingGroup"; var _fileExits = System.Web.HttpContext.Current.Server.MapPath("~/" + filesavepath); if (!Directory.Exists(_fileExits)) { Directory.CreateDirectory(_fileExits); } var path = System.Web.HttpContext.Current.Server.MapPath("~/" + filesavepath + "/" + name + ".xls"); /*******************************/ HSSFWorkbook workBook = new HSSFWorkbook(); createSheet1(workBook, "村级防汛防台工作组"); //获取行政村名录 var createxcel = new creatExcel(); List <string> cunList = new List <string>(); using (var db = DbFactory.Open()) { cunList = db.Select <ADCDInfo>(x => x.adcd.StartsWith(adcd.Substring(0, 9)) && x.adcd != adcd).Select(x => x.adnm).ToList(); } createxcel.setSheet3(workBook, "行政村名录", cunList); using (FileStream file = new FileStream(path, FileMode.Create)) { workBook.Write(file);//创建Excel文件。 file.Close(); } _ufvm.fileSrc = filesavepath + "/" + name + ".xls"; /*******************************/ return(_ufvm); }
public ExportExeclCountryPerson GetExportExecl(GetExportExecl requset) { using (var db = DbFactory.Open()) { var info = new ExportExeclCountryPerson(); var filesavepath = "Upload/Export"; var name = DateTime.Now.ToString("yyyyMMddHHmmssfff"); // DateTime.Now.Ticks.ToString(); var fileSrc = ""; var filePath = System.Web.HttpContext.Current.Server.MapPath("~/" + filesavepath); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); //创建该文件夹 } var createxcel = new creatExcel(); var dt = new DataTable(); //转成Excel导出使用 var arr = new ArrayList(); //不需要导出的列 索引添加到ArrayList里 从0开始 var sheetName = ""; //工作表名 var arrs = new string[] { }; var arrName = new string[] { }; if (requset.typeId == 6) { sheetName = requset.year + "县级防汛防台责任人"; var bulider = db.From <CountryPerson>().Where(x => x.Year == requset.year).LeftJoin <CountryPerson, UserInfo>((x, y) => x.Country == y.RealName).And(x => x.Country == RealName); var list = db.Select <CountryPersonServiceModel>(bulider); if (list.Count > 0) { arr.Clear(); arr.Add(0); arr.Add(6); //list转table dt = Common.ListHelper.ListToDataTable(list, arr); arrs = ConfigurationManager.AppSettings["添加县级防汛防台责任人"].Split('|'); arrName = arrs[0].Split(','); //创建table的头 if (dt.Columns.Contains("CreateTime")) { dt.Columns.Remove("CreateTime"); } if (dt.Columns.Contains("checkresult")) { dt.Columns.Remove("checkresult"); } if (dt.Columns.Contains("adnmparent")) { dt.Columns.Remove("adnmparent"); } if (dt.Columns.Contains("adnm")) { dt.Columns.Remove("adnm"); } if (dt.Columns.Contains("adcd")) { dt.Columns.Remove("adcd"); } for (var i = 0; i < dt.Columns.Count; i++) { dt.Columns[i].Caption = arrName[i]; } } else { info.IsSuccess = false; info.DownUrl = ""; return(info); } var path = System.Web.HttpContext.Current.Server.MapPath("~/" + filesavepath + "/" + sheetName + "-" + name + ".xls"); fileSrc = filesavepath + "/" + sheetName + "-" + name + ".xls"; byte[] data = createxcel.DataTableToExcel(dt, sheetName, requset.mergeCellNum, requset.mergeCellContent); if (!File.Exists(path)) { FileStream fs = new FileStream(path, FileMode.CreateNew); fs.Write(data, 0, data.Length); fs.Close(); info.DownUrl = fileSrc; info.IsSuccess = true; } return(info); } else { info.IsSuccess = false; info.DownUrl = ""; return(info); } } }