| | |
| | | { |
| | | 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 |
| | | { |
| | | |
| | |
| | | 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 |
| | | { |
| | |
| | | ",HUpDateDate=getdate()" + |
| | | //======================================== |
| | | ",HOrgID=" + omodel.HOrgID + |
| | | ",HStockORGID=" + omodel.HOrgID + |
| | | |
| | | ",HEmpID=" + omodel.HEmpID.ToString() + |
| | | ",HSupID=" + omodel.HSupID.ToString() + |
| | |
| | | oCn.RunProc("Insert Into Kf_ICStockBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate,HOrgID" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate,HOrgID,HStockORGID" + |
| | | ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID"+ |
| | | ",HSecManagerID,HSellSID,HCurID" + |
| | | ",HLinkMan,HLinkPhone" + |
| | |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | "," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'" + |
| | | ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" + "," + omodel.HOrgID + |
| | | ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" + "," + omodel.HOrgID + "," + omodel.HOrgID + |
| | | ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + |
| | | "," + omodel.HSecManagerID.ToString() + "," + omodel.HSellSID.ToString() + "," + omodel.HCurID.ToString() + |
| | | ",'" + omodel.HLinkMan + "','" + omodel.HLinkPhone + "'" + |