| | |
|---|
| | | { |
|---|
| | | //查询主表 |
|---|
| | | DataSet Ds ; |
|---|
| | | Ds = oCn.RunProcReturn("Select * from Sc_MouldRepairWorkBillMain Where HInterID=" + lngBillKey.ToString(), "Sc_MouldRepairWorkBillMain"); |
|---|
| | | Ds = oCn.RunProcReturn("Select * from Sc_MouldRepairSendWorkBill Where HInterID=" + lngBillKey.ToString(), "Sc_MouldRepairSendWorkBill"); |
|---|
| | | if(Ds.Tables[0].Rows.Count==0) |
|---|
| | | { |
|---|
| | | sReturn = "单据未找到！"; |
|---|
| | |
|---|
| | | |
|---|
| | | //循环 |
|---|
| | | DataSet DsSub ; |
|---|
| | | DsSub = oCn.RunProcReturn("Select * from Sc_MouldRepairWorkBillSub Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ", "Sc_MouldRepairWorkBillSub"); |
|---|
| | | DsSub = oCn.RunProcReturn("Select * from Sc_MouldRepairSendWorkBillSub Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ", "Sc_MouldRepairSendWorkBillSub"); |
|---|
| | | DetailColl.Clear();//清空 |
|---|
| | | for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) |
|---|
| | | { |
|---|
