Blazor实战——Known框架增删改查导

秒速五厘米 2024-03-16 17:49 23阅读 0赞

### 1. 前后端共用 ###

#### 1.1. 创建实体类 ####

*  在KIMS项目Entities文件夹下创建KmGoods实体类
 *  该类继承EntityBase类
 *  属性使用Column特性描述，用于生成页面字段和数据校验

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>public class KmGoods : EntityBase</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[Column("商品类型", "", true, "1", "50")]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public string? Type { get; set; }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>......</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[Column("库存下限", "", false)]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public decimal? MinStock { get; set; }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>......</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[Column("备注", "", false)]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public string? Note { get; set; }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

#### 1.2. 创建Client类 ####

*  在KIMS项目Clients文件夹下创建GoodsClient类
 *  该类是前后端数据交互接口，继承BaseClient类
 *  该类只需提供分页查询、删除和保存，导入功能由框架统一异步处理

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>public class GoodsClient : BaseClient</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public GoodsClient(Context context) : base(context) { }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public Task&lt;PagingResult&lt;KmGoods&gt;&gt; QueryGoodsesAsync(PagingCriteria criteria) =&gt; Context.QueryAsync&lt;KmGoods&gt;("Goods/QueryGoodses", criteria);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public Task&lt;Result&gt; DeleteGoodsesAsync(List&lt;KmGoods&gt; models) =&gt; Context.PostAsync("Goods/DeleteGoodses", models);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public Task&lt;Result&gt; SaveGoodsAsync(object model) =&gt; Context.PostAsync("Goods/SaveGoods", model);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

### 2. 前端 ###

#### 2.1. 创建List页面 ####

*  在KIMS.Razor项目BaseData文件夹下创建GoodsList类
 *  该类是数据列表页面，继承WebGridView<KmGoods, GoodsForm>类
 *  列表页面按钮和栏位在框架模块管理中配置

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>class GoodsList : WebGridView&lt;KmGoods, GoodsForm&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//分页查询</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>protected override Task&lt;PagingResult&lt;KmGoods&gt;&gt; OnQueryData(PagingCriteria criteria)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return Client.Goods.QueryGoodsesAsync(criteria);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//表格栏位格式化显示</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>protected override void FormatColumns()</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Column(c =&gt; c.Type).Select(new SelectOption { Codes = AppDictionary.GoodsType });</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Column(c =&gt; c.TaxRate).Template((b, r) =&gt; b.Text(r.TaxRate?.ToString("P")));</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public void New() =&gt; ShowForm();//新增按钮方法</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public void DeleteM() =&gt; OnDeleteM(Client.Goods.DeleteGoodsesAsync);//批量删除按钮方法</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public void Edit(KmGoods row) =&gt; ShowForm(row);//编辑操作方法</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public void Delete(KmGoods row) =&gt; OnDelete(row, Client.Goods.DeleteGoodsesAsync);//删除操作方法</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

#### 2.2. 创建Form页面 ####

*  在KIMS.Razor项目BaseData\\Forms文件夹下创建GoodsForm类
 *  该类是数据编辑和查看明细页面，继承WebForm类

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>[Dialog(800, 420)]//设置对话框大小</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>class GoodsForm : WebForm&lt;KmGoods&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//表单布局</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>protected override void BuildFields(FieldBuilder&lt;KmGoods&gt; builder)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Hidden(f =&gt; f.Id);//隐藏字段</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Table(table =&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.ColGroup(15, 35, 15, 35);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.Tr(attr =&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field&lt;Text&gt;(f =&gt; f.Code).Enabled(TModel.IsNew).Build();//编码，编辑时灰显</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field&lt;Text&gt;(f =&gt; f.Name).Build();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>});</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.Tr(attr =&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field&lt;Select&gt;(f =&gt; f.Type).Set(f =&gt; f.Codes, AppDictionary.GoodsType).Build();//下拉框</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field&lt;Select&gt;(f =&gt; f.Unit).Set(f =&gt; f.Codes, AppDictionary.GoodsUnit).Build();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>});</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.Tr(attr =&gt; builder.Field&lt;Text&gt;(f =&gt; f.Model).ColSpan(3).Build());</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.Tr(attr =&gt; builder.Field&lt;RadioList&gt;(f =&gt; f.TaxRate).ColSpan(3).Set(f =&gt; f.Items, AppDictionary.TaxRates).Build());//单选按钮</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.Tr(attr =&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field&lt;Number&gt;(f =&gt; f.MinStock).Build();//数值框</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field&lt;Number&gt;(f =&gt; f.MaxStock).Build();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>});</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.Tr(attr =&gt; builder.Field&lt;TextArea&gt;(f =&gt; f.Note).ColSpan(3).Build());//文本域</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>});</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//表单底部按钮</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>protected override void BuildButtons(RenderTreeBuilder builder)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Button(FormButton.Save, Callback(OnSave), !ReadOnly);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>base.BuildButtons(builder);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//保存按钮方法</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>private void OnSave() =&gt; SubmitAsync(Client.Goods.SaveGoodsAsync);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

### 3. 后端 ###

#### 3.1. 创建Controller类 ####

*  在KIMS.Core项目Controllers文件夹下创建GoodsController类
 *  该类为服务端WebApi，继承BaseController类

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>[Route("[controller]")]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public class GoodsController : BaseController</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>private GoodsService Service =&gt; new(Context);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[HttpPost("[action]")]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public PagingResult&lt;KmGoods&gt; QueryGoodses([FromBody] PagingCriteria criteria) =&gt; Service.QueryGoodses(criteria);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[HttpPost("[action]")]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public Result DeleteGoodses([FromBody] List&lt;KmGoods&gt; models) =&gt; Service.DeleteGoodses(models);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[HttpPost("[action]")]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public Result SaveGoods([FromBody] object model) =&gt; Service.SaveGoods(GetDynamicModel(model));//转成dynamic类型</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

#### 3.2. 创建Service类 ####

*  在KIMS.Core项目Services文件夹下创建GoodsService类
 *  该类为业务逻辑服务类，继承ServiceBase类

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>class GoodsService : ServiceBase</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal GoodsService(Context context) : base(context) { }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//分页查询</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal PagingResult&lt;KmGoods&gt; QueryGoodses(PagingCriteria criteria)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return GoodsRepository.QueryGoodses(Database, criteria);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//删除数据</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal Result DeleteGoodses(List&lt;KmGoods&gt; models)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (models == null || models.Count == 0)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return Result.Error(Language.SelectOneAtLeast);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//此处增加删除数据校验</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return Database.Transaction(Language.Delete, db =&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>foreach (var item in models)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>db.Delete(item);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>});</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//保存数据</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal Result SaveGoods(dynamic model)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var entity = Database.QueryById&lt;KmGoods&gt;((string)model.Id);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>entity ??= new KmGoods { CompNo = CurrentUser.CompNo };</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>entity.FillModel(model);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var vr = entity.Validate();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (vr.IsValid)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (GoodsRepository.ExistsGoods(Database, entity))</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return Result.Error("商品编码已存在。");</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (!vr.IsValid)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return vr;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return Database.Transaction(Language.Save, db =&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (entity.IsNew)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>entity.Code = GetGoodsMaxNo(db);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>db.Save(entity);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}, entity.Id);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//获取商品最大编码</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>private static string GetGoodsMaxNo(Database db)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var prefix = "G";</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var maxNo = GoodsRepository.GetGoodsMaxNo(db, prefix);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (string.IsNullOrWhiteSpace(maxNo))</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>maxNo = $"{prefix}0000";</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return GetMaxFormNo(prefix, maxNo);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

#### 3.3. 创建Repository类 ####

*  在KIMS.Core项目Repositories文件夹下创建GoodsRepository类
 *  该类为数据访问类

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>class GoodsRepository</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//分页查询</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal static PagingResult&lt;KmGoods&gt; QueryGoodses(Database db, PagingCriteria criteria)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var sql = "select * from KmGoods where CompNo=@CompNo";</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return db.QueryPage&lt;KmGoods&gt;(sql, criteria);//查询条件自动绑定</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//获取商品最大编码</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal static string GetGoodsMaxNo(Database db, string prefix)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var sql = $"select max(Code) from KmGoods where CompNo=@CompNo and Code like '{prefix}%'";</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return db.Scalar&lt;string&gt;(sql, new { db.User.CompNo });</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//判断商品是否已存在</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal static bool ExistsGoods(Database db, KmGoods entity)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var sql = "select count(*) from KmGoods where Id&lt;&gt;@Id and Code=@Code";</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return db.Scalar&lt;int&gt;(sql, new { entity.Id, entity.Code }) &gt; 0;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

#### 3.4. 创建Import类 ####

*  在KIMS.Core项目Imports文件夹下创建KmGoodsImport类（约定：类名以实体类名+Import）
 *  该类为数据异步导入处理类，由框架自动调用，继承BaseImport类

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>class KmGoodsImport : BaseImport</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public KmGoodsImport(Database database) : base(database) { }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//定义导入栏位，自动生成导入规范</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public override List&lt;ImportColumn&gt; Columns</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>get</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return new List&lt;ImportColumn&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>new ImportColumn("商品类型", true),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>new ImportColumn("商品编码", true),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>new ImportColumn("商品名称", true),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>new ImportColumn("计量单位", true),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>new ImportColumn("规格型号", true),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>new ImportColumn("税率"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>new ImportColumn("库存下限"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>new ImportColumn("库存上限"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>new ImportColumn("备注")</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>};</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//异步导入处理逻辑</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public override Result Execute(SysFile file)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var models = new List&lt;KmGoods&gt;();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var result = ImportHelper.ReadFile(file, row =&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var model = new KmGoods</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>CompNo = file.CompNo,</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Type = row.GetValue("商品类型"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Code = row.GetValue("商品编码"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Name = row.GetValue("商品名称"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Unit = row.GetValue("计量单位"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Model = row.GetValue("规格型号"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>TaxRate = row.GetValue&lt;decimal?&gt;("税率"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>MinStock = row.GetValue&lt;decimal?&gt;("库存下限"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>MaxStock = row.GetValue&lt;decimal?&gt;("库存上限"),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Note = row.GetValue("备注")</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>};</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var vr = model.Validate();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (vr.IsValid)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (models.Exists(m =&gt; m.Code == model.Code))</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>vr.AddError("商品编码不能重复！");</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>else if (GoodsRepository.ExistsGoods(Database, model))</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>vr.AddError($"系统已经存在该商品编码！");</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (!vr.IsValid)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>row.ErrorMessage = vr.Message;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>else</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>models.Add(model);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>});</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (!result.IsValid)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return result;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return Database.Transaction("导入", db =&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>foreach (var item in models)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>db.Save(item);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>});</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

### 4. 运行测试 ###

*  运行效果如下
    
    ![ec8330c395bde23c6ccba1bf859bae33.png][]

[ec8330c395bde23c6ccba1bf859bae33.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/134c44155a914a67b048049c7f88f7c8.png