| | |
| | | BillOld.MvarItemKey = "Sc_MouldUpperBillMain"; |
| | | //删除前控制========================================= |
| | | DataSet ds2; |
| | | string sql1 = "exec h_p_Sc_MouldUpperBill_BeforeDelCtrl " + Convert.ToInt32(HInterID) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'"; |
| | | string sql1 = "exec h_p_Sc_MouldUpperBill_BeforeDelCtrl " + Convert.ToInt32(hmainid) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'"; |
| | | ds2 = oCN.RunProcReturn(sql1, "h_p_Sc_MouldUpperBill_BeforeDelCtrl"); |
| | | if (ds2 == null || ds2.Tables.Count == 0 || ds2.Tables[0].Rows.Count == 0) |
| | | { |
| | |
| | | oCN.RunProc("delete from Sc_MouldUpperBillSub where HInterID=" + hmainid + " and HEntryID=" + hsubid); |
| | | |
| | | //删除后控制========================================= |
| | | string sql2 = "exec h_p_Sc_MouldUpperBill_AfterDelCtrl " + Convert.ToInt32(HInterID) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'"; |
| | | string sql2 = "exec h_p_Sc_MouldUpperBill_AfterDelCtrl " + Convert.ToInt32(hmainid) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'"; |
| | | ds2 = oCN.RunProcReturn(sql2, "h_p_Sc_MouldUpperBill_AfterDelCtrl"); |
| | | if (ds2 == null || ds2.Tables.Count == 0 || ds2.Tables[0].Rows.Count == 0) |
| | | { |
| | |
| | | BillOld.MvarItemKey = "Sc_MouldLowerBillMain"; |
| | | //删除前控制========================================= |
| | | DataSet ds2; |
| | | string sql1 = "exec h_p_Sc_MouldLowerBill_BeforeDelCtrl " + Convert.ToInt32(HInterID) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'"; |
| | | string sql1 = "exec h_p_Sc_MouldLowerBill_BeforeDelCtrl " + Convert.ToInt32(hmainid) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'"; |
| | | ds2 = oCN.RunProcReturn(sql1, "h_p_Sc_MouldLowerBill_BeforeDelCtrl"); |
| | | if (ds2 == null || ds2.Tables.Count == 0 || ds2.Tables[0].Rows.Count == 0) |
| | | { |
| | |
| | | oCN.RunProc("delete from Sc_MouldLowerBillSub where HInterID=" + hmainid + " and HEntryID=" + hsubid); |
| | | |
| | | //删除后控制========================================= |
| | | string sql2 = "exec h_p_Sc_MouldLowerBill_AfterDelCtrl " + Convert.ToInt32(HInterID) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'"; |
| | | string sql2 = "exec h_p_Sc_MouldLowerBill_AfterDelCtrl " + Convert.ToInt32(hmainid) + ",'" + ds.Tables[0].Rows[0]["HBillNo"] + "','" + user + "'"; |
| | | ds2 = oCN.RunProcReturn(sql2, "h_p_Sc_MouldLowerBill_AfterDelCtrl"); |
| | | if (ds2 == null || ds2.Tables.Count == 0 || ds2.Tables[0].Rows.Count == 0) |
| | | { |