| | |
|---|
| | | |
|---|
| | | //判断未关联数量是否为0 |
|---|
| | | //安瑞：AIS20220914133941 瑞与琪：AIS20220308151944 本地：AIS20210811135644 夏宝：AIS20211130140219 |
|---|
| | | DataSet ds = oCn.RunProcReturn($"select T1.hqty-T1.hrelationqty+q.FMRBQTY as hqty,单据号,物料编码 from H_v_SRM_POOrderBillList t1 left join AIS20210811135644..T_PUR_POORDERENTRY_R q on q.FENTRYID=t1.HEntryID where hentryid in ({string.Join(", ", entryList)}) ", "H_v_SRM_POOrderBillList"); |
|---|
| | | DataSet ds = oCn.RunProcReturn($"select T1.hqty-T1.hrelationqty+q.FMRBQTY as hqty,单据号,物料编码 from H_v_SRM_POOrderBillList t1 left join AIS20220308151944..T_PUR_POORDERENTRY_R q on q.FENTRYID=t1.HEntryID where hentryid in ({string.Join(", ", entryList)}) ", "H_v_SRM_POOrderBillList"); |
|---|
| | | DataTable dt = ds.Tables[0]; |
|---|
| | | if (dt.Rows.Count > 0) |
|---|
| | | { |
|---|
