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