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 UploadFileViewModel GET(NoVerifyGetVWGFileModel request) { return(NoVerifyVillageWorkingGroupManage.DownloadVWGFileModel(request)); }