Blazor实战——Known框架多表增删改查

古城微笑少年丶 2024-03-22 21:56 120阅读 0赞

## 多表增删改查示例 ##

本章介绍学习多张表增、删、改、查功能如何实现，下面以销货出库单作为示例，该业务栏位如下：

> **销货出库单栏位**
> 
>  *  销货单号、销货日期、状态、客户、备注
> 
> **销货出库单明细栏位**
> 
>  *  商品编码、商品名称、规格型号、数量、单位、单价、金额

该示例适用于出货明细数量较小情况，单据表头和表体组合查询和提交。

对于出货明细数量较大的情况，建议表头与表体分开查询和提交，表体采用分页查询。

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

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

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

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>//销货出库单</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public class KmBill : 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? BillNo { get; set; }</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? BillDate { get; set; }</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></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//出货明细，为了降低代码量，扩展实体类，不再创建DTO类</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//此处使用虚属性，ORM映射SQL时忽略该属性</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public virtual List&lt;KmBillList&gt;? Lists { get; set; }</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 class KmBillList : EntityBase</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[Column("销货单ID", "", true, "1", "50")]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public string? HeadId { get; set; }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[Column("商品编码", "", true, "1", "50")]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public string? Code { get; set; }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[Column("数量", "", false)]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public decimal? Qty { get; set; }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[Column("单价", "", false)]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public decimal? Price { get; set; }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[Column("金额", "", false)]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public decimal? Amount { get; set; }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//如下虚属性用于关联商品资料表查询显示</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public virtual string? Name { get; set; } //商品名称</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public virtual string? Model { get; set; } //规格型号</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public virtual string? Unit { get; set; } //计量单位</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

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

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

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>public class BillClient : ClientBase</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public BillClient(Context context) : base(context) { }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public Task&lt;PagingResult&lt;KmBill&gt;&gt; QueryBillsAsync(PagingCriteria criteria) =&gt; Context.QueryAsync&lt;KmBill&gt;("Bill/QueryBills", criteria);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public Task&lt;Result&gt; DeleteBillsAsync(List&lt;KmBill&gt; models) =&gt; Context.PostAsync("Bill/DeleteBills", models);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public Task&lt;KmBill&gt; GetBillAsync(string id) =&gt; Context.GetAsync&lt;KmBill&gt;($"Bill/GetBill?id={id}");</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public Task&lt;Result&gt; SaveBillAsync(KmBill model) =&gt; Context.PostAsync("Bill/SaveBill", model);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

### 2. 前端 ###

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

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

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>class BillList : WebGridView&lt;KmBill, BillForm&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>protected override Task InitPageAsync()</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>Column(c =&gt; c.BillNo).Template((b, r) =&gt; b.Link(r.BillNo, Callback(() =&gt; View(r))));</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Column(c =&gt; c.Status).Template(BillStatusCell);//显示状态标签</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return base.InitPageAsync();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//分页查询</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>protected override Task&lt;PagingResult&lt;KmBill&gt;&gt; OnQueryData(PagingCriteria criteria)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return Client.Bill.QueryBillsAsync(criteria);</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; DeleteRows(Client.Bill.DeleteBillsAsync);//批量删除按钮方法</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public void Edit(KmBill row) =&gt; ShowForm(row);//编辑操作方法</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public void Delete(KmBill row) =&gt; DeleteRow(row, Client.Bill.DeleteBillsAsync);//删除操作方法</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

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

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

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>[Dialog(980, 580)]//设置对话框大小</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>class BillForm : WebForm&lt;KmBill&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>private KmBill? head;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//初始化表单，查询表头表体组合数据</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>protected override async Task InitFormAsync()</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var model = TModel;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>head = await Client.Bill.GetBillAsync(model.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>protected override void BuildFields(FieldBuilder&lt;KmBill&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(11, 25, 11, 25, 11, 17);</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>//销货单号不可编辑，自动生成编号</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.Field&lt;Text&gt;(f =&gt; f.BillNo).Enabled(false).Build();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.Field&lt;Date&gt;(f =&gt; f.BillDate).Build();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.Field&lt;Text&gt;(f =&gt; f.Status).Enabled(false).Build();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>});</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>table.Tr(attr =&gt; table.Field&lt;TextArea&gt;(f =&gt; f.Note).ColSpan(5).Build());</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.FormList&lt;BillListGrid&gt;("商品明细", "", attr =&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>attr.Set(c =&gt; c.ReadOnly, ReadOnly)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>.Set(c =&gt; c.Data, head?.Lists);//设置表体数据</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>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()</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>SubmitAsync(data =&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>head?.FillModel(data);//自动填充表单修改数据</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return Client.Bill.SaveBillAsync(head);</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>

#### 2.3. 创建表体页面 ####

*  在KIMS.Razor项目BillData\\Forms文件夹下创建BillListGrid类
 *  该类是表体数据编辑表格，继承EditGrid类

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>//可编辑表体组件</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>class BillListGrid : EditGrid&lt;KmBillList&gt;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public BillListGrid()</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>OrderBy = nameof(KmBillList.ItemNo);//默认排序</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Name = "商品明细";</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 OnInitializedAsync()</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//如下栏位有Edit方法为可编辑栏位，否则不可编辑</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var builder = new ColumnBuilder&lt;KmBillList&gt;();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//商品库存选择器，弹出对话框查询商品库存，双击选择要出库的商品</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field(r =&gt; r.Code).Edit(new GoodsStock(), OnCodeChanged);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field(r =&gt; r.Name);//不可编辑</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field(r =&gt; r.Model);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field(r =&gt; r.Qty).Edit&lt;Number&gt;(OnQtyChanged);//可编辑</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field(r =&gt; r.Unit);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field(r =&gt; r.Price).Edit&lt;Number&gt;(OnPriceChanged);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field(r =&gt; r.Amount).IsSum().Edit&lt;Number&gt;(OnAmountChanged);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>builder.Field(r =&gt; r.Note).Edit();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Columns = builder.ToColumns();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return base.OnInitializedAsync();</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 OnCodeChanged(KmBillList row, object value)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var g = value as StockInfo;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>row.Type = g?.Type;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>row.Code = g?.Code;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>row.Name = g?.Name;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>row.Model = g?.Model;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>row.Unit = g?.Unit;</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 OnQtyChanged(KmBillList row, object value)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var qty = Utils.ConvertTo&lt;decimal&gt;(value);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>row.Amount = Utils.Round(qty * (row.Price ?? 0), 2);</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 OnPriceChanged(KmBillList row, object value)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var price = Utils.ConvertTo&lt;decimal&gt;(value);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>row.Amount = Utils.Round(price * row.Qty, 2);</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 OnAmountChanged(KmBillList row, object value)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var amount = Utils.ConvertTo&lt;decimal&gt;(value);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>row.Price = row.Qty == 0 ? 0 : Utils.Round(amount / row.Qty, 2);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

### 3. 后端 ###

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

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

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>[Route("[controller]")]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public class BillController : BaseController</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>private BillService 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;KmBill&gt; QueryBills([FromBody] PagingCriteria criteria) =&gt; Service.QueryBills(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 DeleteBills([FromBody] List&lt;KmBill&gt; models) =&gt; Service.DeleteBills(models);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>[HttpGet("[action]")]</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>public KmBill GetBill([FromQuery] string id) =&gt; Service.GetBill(id);</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 SaveBill([FromBody] KmBill model) =&gt; Service.SaveBill(model);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

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

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

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>class BillService : ServiceBase</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal BillService(Context context) : base(context) { }</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//分页查询</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal PagingResult&lt;KmBill&gt; QueryBills(PagingCriteria criteria)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return BillRepository.QueryBills(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 DeleteBills(List&lt;KmBill&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>//删除表体</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>BillRepository.DeleteBillLists(db, item.Id);</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 KmBill GetBill(string id)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (string.IsNullOrEmpty(id))//id为空返回默认值</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return GetDefaultBill();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var entity = Database.QueryById&lt;KmBill&gt;(id);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (entity == null)//为空返回默认值</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>entity = GetDefaultBill();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>else//否则组装表体数据返回</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>entity.Lists = BillRepository.GetBillLists(Database, id);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return entity;</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 SaveBill(KmBill model)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (model == null)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return Result.Error("不能提交空数据！");</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></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>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 (model.IsNew)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>model.BillNo = GetBillMaxNo(db);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//清空表体合计数据</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>model.TotalAmount = 0;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>model.GoodsName = string.Empty;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//先删除表体，再插入表体</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>BillRepository.DeleteBillLists(db, model.Id);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (model.Lists != null &amp;&amp; model.Lists.Count &gt; 0)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var index = 0;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var lists = new List&lt;KmBillList&gt;();</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>foreach (var item in model.Lists)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>item.HeadId = model.Id;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>item.ItemNo = ++index;</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>db.Insert(item);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>lists.Add(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>model.TotalAmount = lists.Sum(l =&gt; l.Amount);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>model.GoodsName = string.Join(",", lists.Select(l =&gt; l.Name));</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>db.Save(model);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}, model);</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 KmBill GetDefaultBill()</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return new KmBill</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>BillNo = GetBillMaxNo(Database),</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>BillDate = DateTime.Now,</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Status = "暂存",</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>Lists = new List&lt;JxBillList&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>//获取销货单最大编号</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>private static string GetBillMaxNo(Database db)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var prefix = $"S{DateTime.Now:yyyy}";</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var maxNo = BillRepository.GetBillMaxNo(db, prefix);</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>if (string.IsNullOrWhiteSpace(maxNo))</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>maxNo = $"{prefix}00000";</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文件夹下创建BillRepository类
 *  该类为数据访问类

<table> 
 <tbody> 
  <tr> 
   <td></td> 
   <td><code>class BillRepository</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//Head</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//分页查询</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal static PagingResult&lt;KmBill&gt; QueryBills(Database db, PagingCriteria criteria)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var sql = "select * from KmBill where CompNo=@CompNo";</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return db.QueryPage&lt;KmBill&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 GetBillMaxNo(Database db, string prefix)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var sql = $"select max(BillNo) from KmBill where CompNo=@CompNo and BillNo 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>//List</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//根据表头ID获取表体数据</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal static List&lt;KmBillList&gt; GetBillLists(Database db, string headId)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//关联商品资料表查询商品信息</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var sql = "select a.*,b.Name,b.Model,b.Unit from KmBillList a,KmGoods b where a.Code=b.Code and HeadId=@headId";</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>return db.QueryList&lt;KmBillList&gt;(sql, new { headId });</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>//根据表头ID删除表体数据</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>internal static void DeleteBillLists(Database db, string headId)</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>{ </code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>var sql = "delete from KmBillList where HeadId=@headId";</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>db.Execute(sql, new { headId });</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td><code>}</code></td> 
  </tr> 
 </tbody> 
</table>

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

*  运行效果如下

![输入图片说明][3e9948afb351dcecd116f23c4ddbd136.png]

![输入图片说明][14af172a1f1ecb5bb398ba30075d8b48.png]

[3e9948afb351dcecd116f23c4ddbd136.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/c17cd19dce974eef8ba7e91cbfe7fb7b.png
[14af172a1f1ecb5bb398ba30075d8b48.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/e1fd2f24cf06414bb9eb06ccf479f8da.png