/// <summary>
/// 生成盘点清单
/// </summary>
/// <returns></returns>
public DownLoadFileModel BuildInventoryList()
{
DownLoadFileModel dlfm = new DownLoadFileModel(2);
//AssetNumber, EquipmentName, EquipmentSpec, ManufacturingNumber, MaintenanceDate, SafekeepDepartment, AssetType
List <FileFieldMapping> fieldmappping = new List <FileFieldMapping>()
{
new FileFieldMapping("Number", "项次"),
new FileFieldMapping("AssetNumber", "编号"),
new FileFieldMapping("EquipmentName", "名称"),
new FileFieldMapping("EquipmentSpec", "规格型号/厂名"),
new FileFieldMapping("ManufacturingNumber", "制造编号"),
new FileFieldMapping("MaintenanceDate", "登录日期"),
new FileFieldMapping("SafekeepDepartment", "部门"),
new FileFieldMapping("AssetType", "资产分类")
};
var datas = CrudFactory.EquipmentCrud.FindBy(new QueryEquipmentDto()
{
SearchMode = 6
});
if (datas == null || datas.Count == 0)
{
return(new DownLoadFileModel().Default());
}
var dataTableGrouping = datas.GetGroupList <EquipmentModel>("SafekeepDepartment");
return(dataTableGrouping.ExportToExcelMultiSheets <EquipmentModel>(fieldmappping).CreateDownLoadExcelFileModel("设备盘点清单"));
}
public FileResult LoadQualifiedCertificateFile(string suppliserId, string eligibleCertificate)
{
//Excel
DownLoadFileModel dlfm = PurchaseService.PurSupplierManager.CertificateManager.GetSupQuaCertificateDLFM(SiteRootPath, suppliserId, eligibleCertificate);
return(this.DownLoadFile(dlfm));
}
/// <summary>
/// 获取工序Excel模板
/// </summary>
/// <param name="documentPath"></param>
/// <returns></returns>
public DownLoadFileModel GetProductFlowTemplate(string documentPath)
{
DownLoadFileModel dlfm = new DownLoadFileModel();
dlfm.FilePath = documentPath;
return(dlfm);
}
/// <summary>
/// 获取工序Excel模板
/// </summary>
/// <param name="documentPath"></param>
/// <returns></returns>
public DownLoadFileModel GetIqcInspectionItemConfigTemplate(string documentPath, string fileDownLoadName)
{
DownLoadFileModel dlfm = new DownLoadFileModel();
dlfm.FilePath = documentPath;
dlfm.FileDownLoadName = fileDownLoadName;
return(dlfm);
}
/// <summary>
/// 给定文件路径进行下载
/// </summary>
/// <param name="downLoadFileModel"></param>
/// <returns></returns>
private FileResult CreateFilePathDLFM(DownLoadFileModel downLoadFileModel)
{
if (!System.IO.File.Exists(downLoadFileModel.FilePath))
{
downLoadFileModel = new DownLoadFileModel().Default(string.Format("{0}不存在！", downLoadFileModel.FilePath));
return(File(downLoadFileModel.FileContnet, downLoadFileModel.ContentType, downLoadFileModel.FileDownLoadName));
}
return(File(downLoadFileModel.FilePath, downLoadFileModel.ContentType, downLoadFileModel.FileDownLoadName));
}
/// <summary>
/// 给定字节进行下载
/// </summary>
/// <param name="downLoadFileModel"></param>
/// <returns></returns>
private FileResult CreateFileContnetDLFM(DownLoadFileModel downLoadFileModel)
{
if (downLoadFileModel.FileContnet == null)
{
downLoadFileModel = new DownLoadFileModel().Default("文件内容不能为null！");
return(File(downLoadFileModel.FileContnet, downLoadFileModel.ContentType, downLoadFileModel.FileDownLoadName));
}
return(File(downLoadFileModel.FileContnet, downLoadFileModel.ContentType, downLoadFileModel.FileDownLoadName));
}
/// <summary>
/// 给定文件流进行下载
/// </summary>
/// <param name="downLoadFileModel"></param>
/// <returns></returns>
private FileResult CreateFileStreamDLFM(DownLoadFileModel downLoadFileModel)
{
if (downLoadFileModel.FileStream == null)
{
downLoadFileModel = new DownLoadFileModel().Default("文件流不能为null！");
return(File(downLoadFileModel.FileContnet, downLoadFileModel.ContentType, downLoadFileModel.FileDownLoadName));
}
///
downLoadFileModel.FileStream.Seek(0, SeekOrigin.Begin);
return(File(downLoadFileModel.FileStream, downLoadFileModel.ContentType, downLoadFileModel.FileDownLoadName));
}
/// <summary>
/// 下载文件
/// </summary>
/// <param name="siteRootPath">根路径</param>
/// <param name="supplierId">供应商Id</param>
/// <param name="eligibleCertificate">证书名称</param>
/// <returns></returns>
public DownLoadFileModel GetSupQuaCertificateDLFM(string siteRootPath, string supplierId, string eligibleCertificate)
{
DownLoadFileModel dlfm = new DownLoadFileModel();
var model = SupplierCrudFactory.SupplierQualifiedCertificateCrud.GetQualifiedCertificateModelBy(supplierId, eligibleCertificate);
if (model == null || model.CertificateFileName == null || model.FilePath == null)
{
return(dlfm.Default());
}
return(dlfm.CreateInstance(model.CertificateFileName,
siteRootPath.GetDownLoadFilePath(model.FilePath),
model.CertificateFileName.GetDownLoadContentType()));
}
///// <summary>
///// 导出数据到Excel文件中
///// </summary>
///// <typeparam name="T">泛型类型</typeparam>
///// <param name="dataSource">数据源</param>
///// <param name="xlsSheetName">Sheet表名称</param>
///// <param name="xlsFileName">Excel文件名称,包括扩展名</param>
///// <returns></returns>
//protected FileResult ExportToExcel<T>(List<T> dataSource, string xlsSheetName, string xlsFileName) where T : class
//{
// MemoryStream ms = dataSource.ExportToExcel<T>(xlsSheetName);
// ms.Seek(0, SeekOrigin.Begin);
// return File(ms, "application/vnd.ms-excel", xlsFileName + ".xls");
//}
///// <summary>
///// 导出数据到Excel文件中
///// </summary>
///// <param name="ms">文件流</param>
///// <param name="xlsSheetName">Sheet表名称</param>
///// <param name="xlsFileName">Excel文件名称,包括扩展名</param>
///// <returns></returns>
//protected FileResult ExportToExcel(MemoryStream ms, string xlsSheetName, string xlsFileName)
//{
// ms.Seek(0, SeekOrigin.Begin);
// return File(ms, "application/vnd.ms-excel", xlsFileName + ".xls");
//}
/// <summary>
/// 下载文件
/// </summary>
/// <param name="downLoadFileModel"></param>
/// <returns></returns>
protected FileResult DownLoadFile(DownLoadFileModel downLoadFileModel)
{
try
{
switch (downLoadFileModel.HandleMode)
{
case 0:
return(CreateFilePathDLFM(downLoadFileModel));
case 1:
return(CreateFileContnetDLFM(downLoadFileModel));
case 2:
return(CreateFileStreamDLFM(downLoadFileModel));
default:
return(File(downLoadFileModel.FileContnet, downLoadFileModel.ContentType, downLoadFileModel.FileDownLoadName));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public FileResult GetExceptionFile(string exceptionId)
{
DownLoadFileModel dlfm = exceptionId.CreateExceptionDownLoadFileModel();
return(this.DownLoadFile(dlfm));
}
){kind=link}
){kind=link}