今天接到用户的需求,物流分摊费用保存在销货单主表中,但物流人员需要看到从表的销货明细包含哪些产品和数量。主从表设计:
先看看效果吧:
![这里写图片描述](https://i-blog.csdnimg.cn/blog_migrate/9f36a128e03a9532cd6a7135800f3855.png)
private void GetDataList()
{
string sb = GetSQL();
try
{
DBCon db = new DBCon(this.company);
//销货单
DataSet MatserDs = SqlHelper.ExecuteDataset(db.StringConnection(), CommandType.Text, sb.ToString());
DataTable MatserDt = MatserDs.Tables[0];
MatserDt.TableName = "Matser";
if (MatserDt.Rows.Count > 0)
{
//销货明细
string subSQL = "Select TH003 序号,TH004 品号,TH005 品名,TH006 规格,TH008 数量,TH001+Rtrim(TH002) AS DetailID FROM COPTH ";
DataSet DetailDs = SqlHelper.ExecuteDataset(db.StringConnection()