| | |
| | | { |
| | | public class ClsSc_MouldScrapInBill:DBUtility.ClsXt_BaseBill |
| | | { |
| | | public Model.ClsSc_MouldStockBillMain omodel = new Model.ClsSc_MouldStockBillMain(); |
| | | public List<Model.ClsSc_MouldStockBillSub> DetailColl = new List<Model.ClsSc_MouldStockBillSub>(); |
| | | public Models.ClsSc_MouldStockBillMain omodel = new Models.ClsSc_MouldStockBillMain(); |
| | | public List<Models.ClsSc_MouldStockBillSub> DetailColl = new List<Models.ClsSc_MouldStockBillSub>(); |
| | | |
| | | public ClsSc_MouldScrapInBill() |
| | | { |
| | |
| | | DeleteBillSub(lngBillKey); |
| | | //插入子表 |
| | | omodel.HInterID = lngBillKey; |
| | | foreach (Model.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | foreach (Models.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Sc_MouldStockBillSub " + |
| | | " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + |
| | |
| | | // } |
| | | //} |
| | | DataSet Ds; |
| | | foreach (Model.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | foreach (Models.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | { |
| | | Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBill_CheckKF " + omodel.HInterID + "," + oSub.HMaterID + "," + oSub.HWHID + "," + oSub.HSPID + ", 1", "gy_czygl"); |
| | | if (Ds.Tables[0].Rows.Count == 0) |
| | |
| | | |
| | | ") "); |
| | | //插入子表 |
| | | foreach (Model.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | foreach (Models.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | { |
| | | |
| | | oCn.RunProc("Insert into Sc_MouldStockBillSub " + |
| | |
| | | //} |
| | | // |
| | | DataSet Ds; |
| | | foreach (Model.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | foreach (Models.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | { |
| | | Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBill_CheckKF " + omodel.HInterID + "," + oSub.HMaterID + "," + oSub.HWHID + "," + oSub.HSPID + ", 1", "gy_czygl"); |
| | | if (Ds.Tables[0].Rows.Count == 0) |
| | |
| | | DetailColl.Clear();//清空 |
| | | for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) |
| | | { |
| | | Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub(); |
| | | Models.ClsSc_MouldStockBillSub oSub = new Models.ClsSc_MouldStockBillSub(); |
| | | // 固定赋值=============================================== |
| | | oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]); |
| | | oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]); |