public ActionResult ExportZhuijia(string ModelType = "", string ProjectName = "", string ProjectShortName = "", string SupplierName = "", int pageNum = 1, int pageSize = 20)
{
var lst = service.HuizongbiaoSearch_Shoudong(ModelType, ProjectName, ProjectShortName, SupplierName);
string absPath = Server.MapPath(basePath);
if (!Directory.Exists(absPath))
{
Directory.CreateDirectory(absPath);
}
string createFileName = "汇总表_追加" + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xlsx";
string path = absPath + createFileName;
string templateFile = Server.MapPath(tempPath + "zhuijia" + suffix);
System.IO.File.Copy(templateFile, path);
if (lst.Count == 0)
{
throw new Exception("没有可以导出的数据");
}
HuizongbiaoExport export = new HuizongbiaoExport();
export.ExportZhuijia(path, lst);
return(Json(new { ExportPath = path }));
}
public ActionResult ExportHuizongbiao(string ModelType = "", string ProjectName = "", string ProjectShortName = "", string SupplierName = "", string ServiceTrade = "")
{
string zip = "";
string absPath = Server.MapPath(basePath);
string createFloader = absPath + DateTime.Now.ToString("yyyyMMddHHmmssfff") + "\\";
if (!Directory.Exists(createFloader))
{
Directory.CreateDirectory(createFloader);
}
foreach (string key in QuotationTypeAndText.Keys)
{
#region ===========导出单类型汇总表
string quotationType = key;
List <Object> lst = new List <Object>();
if (quotationType == "Zhixing")
{
lst.AddRange(service.HuizongbiaoSearch_Zhixing(ModelType, ProjectName, ProjectShortName, SupplierName));
}
else if (quotationType == "Fuhe")
{
lst.AddRange(service.HuizongbiaoSearch_Fuhe(ModelType, ProjectName, ProjectShortName, SupplierName));
}
else if (quotationType == "Biancheng")
{
lst.AddRange(service.HuizongbiaoSearch_Biancheng(ModelType, ProjectName, ProjectShortName, SupplierName));
}
else if (quotationType == "Yanjiu")
{
lst.AddRange(service.HuizongbiaoSearch_Yanjiu(ModelType, ProjectName, ProjectShortName, SupplierName));
}
else if (quotationType == "Zhichi")
{
lst.AddRange(service.HuizongbiaoSearch_Zhichi(ModelType, ProjectName, ProjectShortName, SupplierName));
}
else if (quotationType == "Qita1")
{
lst.AddRange(service.HuizongbiaoSearch_Qita1(ModelType, ProjectName, ProjectShortName, SupplierName, ServiceTrade));
}
else if (quotationType == "Qita2")
{
lst.AddRange(service.HuizongbiaoSearch_Qita2(ModelType, ProjectName, ProjectShortName, SupplierName, ServiceTrade));
}
else if (quotationType == "Chezhan")
{
lst.AddRange(service.HuizongbiaoSearch_Chezhan(ModelType, ProjectName, ProjectShortName, SupplierName));
}
if (ModelType != "业务")
{
if (quotationType == "Qita1")
{
quotationType = "Youxingshangpincaigou";
}
else if (quotationType == "Qita2")
{
quotationType = "Wuxingshangpincaigou";
}
}
string createFileName = "汇总表_" + quotationType + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xlsx";
string path = createFloader + createFileName;
string templateFile = Server.MapPath(tempPath + quotationType + suffix);
System.IO.File.Copy(templateFile, path);
if (lst.Count == 0)
{
continue;
}
HuizongbiaoExport export = new HuizongbiaoExport();
MethodInfo method = null;
method = export.GetType().GetMethod("Export" + quotationType);
if (method != null)
{
method.Invoke(export, new object[] { path, lst });
}
#endregion
}
string zipName = absPath + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + "_确认单" + ".zip";
List <FileInfo> fileList = new List <FileInfo>();
foreach (string file in Directory.GetFiles(createFloader))
{
fileList.Add(new FileInfo(file));
}
Compress(fileList, zipName, 9, 100);
zip = zipName;
return(Json(new { ExportPath = zip }));
}
