| | |
| | | public override void DeleteRelation(ref string sReturn, Int64 lngBillKey) |
| | | { |
| | | //æ¶æéç¥å éæéç¥å å
³èæ°é |
| | | //try |
| | | //{ |
| | | // if (omodel.HMainSourceBillType == "åè´§éç¥å") |
| | | // { |
| | | // oCn.RunProc("exec h_p_Xs_UpDateSeOutStockRelation_Del " + lngBillKey.ToString()); |
| | | // } |
| | | // else if (omodel.HMainSourceBillType == "éè´§éç¥å") |
| | | // { |
| | | // oCn.RunProc("exec h_p_Xs_UpDateSeOutStockRelation_Back_Del " + lngBillKey.ToString()); |
| | | // } |
| | | // else if (DetailColl[0].HSourceBillType == "1401") //éå®è®¢å |
| | | // { |
| | | // oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_Delete " + lngBillKey.ToString()); |
| | | // } |
| | | // else |
| | | // { |
| | | try |
| | | { |
| | | if (DetailColl[0].HSourceBillType == "1401") //éå®è®¢å |
| | | { |
| | | oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellBack_Delete " + lngBillKey.ToString()); |
| | | } |
| | | else |
| | | { |
| | | |
| | | // } |
| | | //} |
| | | //catch (Exception e) |
| | | //{ |
| | | // throw (e); |
| | | //} |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | //æ°å¢å
³è |
| | | public override void AddNewRelation(ref string sReturn, Int64 lngBillKey) |
| | | { |
| | | //æ¶æéç¥å éæéç¥å å
³èæ°é |
| | | //try |
| | | //{ |
| | | // if (omodel.HMainSourceBillType == "åè´§éç¥å") |
| | | // { |
| | | // oCn.RunProc("exec h_p_Xs_UpDateSeOutStockRelation_Add " + lngBillKey.ToString()); |
| | | // } |
| | | // else if (omodel.HMainSourceBillType == "éè´§éç¥å") |
| | | // { |
| | | // oCn.RunProc("exec h_p_Xs_UpDateSeOutStockRelation_Back_Add " + lngBillKey.ToString()); |
| | | // } |
| | | // else if(DetailColl[0].HSourceBillType == "1401") //éå®è®¢å |
| | | // { |
| | | // oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_Add " + lngBillKey.ToString()); |
| | | // } |
| | | // else |
| | | // { |
| | | try |
| | | { |
| | | if (DetailColl[0].HSourceBillType == "1401") //éå®è®¢å |
| | | { |
| | | oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellBack_Add " + lngBillKey.ToString()); |
| | | } |
| | | else |
| | | { |
| | | |
| | | // } |
| | | //} |
| | | //catch (Exception e) |
| | | //{ |
| | | // throw (e); |
| | | //} |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | //ä¿®æ¹åæ® |
| | |
| | | " where HInterID = " + lngBillKey; |
| | | //æ´æ°ä¸»è¡¨ |
| | | oCn.RunProc(mainSql); |
| | | //å é¤å
³è |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | | //å é¤å表 |
| | | DeleteBillSub(lngBillKey); |
| | | //æå
¥å表 |
| | |
| | | |
| | | oCn.RunProc(subSql); |
| | | } |
| | | |
| | | //æ´æ°è®¢åå
³èæ°é |
| | | AddNewRelation(ref sReturn, omodel.HInterID); |
| | | //æ§å¶å
³èæ°é |
| | | //=========================ä¿ååæ§å¶ |
| | | DataSet ds2 = oCn.RunProcReturn("exec h_p_Kf_SellOutBackBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_Kf_SellOutBackBill_AfterSaveCtrl"); |
| | | if (ds2 == null) |
| | |
| | | |
| | | } |
| | | |
| | | //æ´æ°è®¢åå
³èæ°é |
| | | AddNewRelation(ref sReturn, omodel.HInterID); |
| | | //æ§å¶å
³èæ°é |
| | | |
| | | //=========================ä¿ååæ§å¶ |
| | | DataSet ds2 = oCn.RunProcReturn("exec h_p_Kf_SellOutBackBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_Kf_SellOutBackBill_AfterSaveCtrl"); |
| | | if (ds2 == null) |