/// <summary>
/// 动态列
/// </summary>
public void Execute()
{
string excelPath = Directory.GetCurrentDirectory() + "\\..\\Template\\合同材料导入模版-配置化XML.xlsx";
string path = Directory.GetCurrentDirectory() + "\\..\\Template\\合同基本信息.xml";
//代码注释
//代码注释
ImportByConfig <ExcelRowModel> import = new ImportByConfig <ExcelRowModel>(path, 1);
import.Execute(excelPath);
EntityProxy.GenerateProxy(import.ExcelGlobalDTO);
//代码注释
Export <ExcelRowModel> export = new Export <ExcelRowModel>();
export.Execute(import.ExcelGlobalDTO);
}
/// <summary>
/// 构造函数初始化
/// </summary>
public Excel()
{
Import = new Import <TEntity>();
ImportByConfig = new ImportByConfig <TEntity>();
Export = new Export <TEntity>();
}
/// <summary>
/// 动态列
/// </summary>
public void ExportByDynamicColumn()
{
string excelPath = Directory.GetCurrentDirectory() + "\\..\\Template\\合同材料导入模版-配置化.xls";
//代码注释
//代码注释
ColumnModel columnModel = new ColumnModel();
columnModel.ColumnName = "材料名称";
columnModel.ColumnValidations = new List <ColumnValidationModel>();
columnModel.ColumnValidations.Add(new ColumnValidationModel()
{
ValidationTypeEnum = ValidationTypeEnum.Required,
RequiredAttribute = new RequiredAttribute()
{
ErrorMessage = "材料名称必填"
}
});
columnModel.ColumnValidations.Add(new ColumnValidationModel()
{
ValidationTypeEnum = ValidationTypeEnum.Length,
LengthAttribute = new LengthAttribute(256)
{
ErrorMessage = "长度必须小于或等于256"
}
});
//代码注释
//代码注释
ColumnModel columnCountModel = new ColumnModel();
columnCountModel.ColumnName = "数量";
columnCountModel.ColumnValidations = new List <ColumnValidationModel>();
columnCountModel.ColumnValidations.Add(new ColumnValidationModel()
{
ValidationTypeEnum = ValidationTypeEnum.Required,
RequiredAttribute = new RequiredAttribute()
{
ErrorMessage = "数量必填"
}
});
//代码注释
//代码注释
ImportByConfig <ExcelRowModel> import = new ImportByConfig <ExcelRowModel>(1);
import.ExcelGlobalDTO.SetDefaultSheet("合同材料");
ExcelSheetModel <ExcelRowModel> sheetModel = import.ExcelGlobalDTO.Sheets.FirstOrDefault();
//代码注释
//代码注释
sheetModel.ColumnConfig = new List <ColumnModel>()
{
columnModel,
columnCountModel
};
import.ExcelGlobalDTO.Sheets.Add(sheetModel);
//代码注释
//代码注释
import.Execute(excelPath);
//代码注释
Export <ExcelRowModel> export = new Export <ExcelRowModel>();
export.Execute(import.ExcelGlobalDTO);
}
