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);
}
}
}
public ExportExeclCountryPerson Get(GetExportExecl requset)
{
return(CountryPerson.GetExportExecl(requset));
}
