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