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