| | |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | if (HProcID == "90") |
|---|
| | | if (HProcID == "90" || HProcID== "102") |
|---|
| | | { |
|---|
| | | DataSet dataSet = oCN.RunProcReturn(@"exec h_p_Sc_ProcessExchangeBillList2 '" + HBarCode + "'," + HProcID, "h_p_Sc_ProcessExchangeBillList2"); |
|---|
| | | if (dataSet.Tables[0].Rows.Count > 0) |
|---|
| | |
|---|
| | | "(HInterID,HEntryID,HBillNo_bak,HSourceBillNo,HSourceInterID,HSourceEntryID,HMaterID" + |
|---|
| | | ",HProdOrgID,HSourceBillType,HAuxPropID,HProcID,HQty,HBatchNo,HBarCode,HMTONo,HPlanMode) " + |
|---|
| | | " values(" + HInterID + "," + (i + 1) + ",'" + HBillNo + "','" + tempList[i].HProcExchBillNo + "'," + tempList[i].HProcExchInterID + "," + tempList[i].HProcExchEntryID + "," + tempList[i].HMaterID + |
|---|
| | | ",'" + HOrgID + "','',0," + HProcID + "," + tempList[i].HQty + ",'"+ tempList[i].HBatchNo + "','" + tempList[i].HBarCode + "','','') "); |
|---|
| | | ",'" + HOrgID + "','',0," + tempList[i].HProcID + "," + tempList[i].HQty + ",'"+ tempList[i].HBatchNo + "','" + tempList[i].HBarCode + "','','') "); |
|---|
| | | } |
|---|
| | | |
|---|
| | | oCN.Commit(); |
|---|
