今天接到用户的需求,物流分摊费用保存在销货单主表中,但物流人员需要看到从表的销货明细包含哪些产品和数量。主从表设计: 先看看效果吧:
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 Det