| | |
| | | ",HInnerBillNo = '" + omodel.HInnerBillNo + "'" + |
| | | ",HCarriage = " + omodel.HCarriage + "" + |
| | | ",HCheckStatusMan = '" + omodel.HCheckStatusMan + "'" + |
| | | ",HProjectID = '" + omodel.HProjectID.ToString() + "'" + |
| | | ",HGroupID = '" + omodel.HGroupID.ToString() + "'" + |
| | | ",HPriceType = '" + omodel.HPriceType + "'" + |
| | | " where HInterID = " + lngBillKey; |
| | | //鏇存柊涓昏〃 |
| | | oCn.RunProc(mainSql); |
| | |
| | | ",HDeptID,HManagerID,HEmpID,HSupID,HSecManagerID,HKeeperID,HWHID,HSCWHID,HCurID,HExRate,HSellSID,HLinkMan,HLinkPhone" + |
| | | ",HSeOrderBillNo" + |
| | | ",HConveyCompID,HConveyTypeID,HConveyMoney" + |
| | | ",HExplanation,HInnerBillNo,HRedBlueFlag,HCarriage,HCheckStatusMan" + |
| | | ",HExplanation,HInnerBillNo,HRedBlueFlag,HCarriage,HCheckStatusMan,HProjectID,HGroupID,HPriceType" + |
| | | ") " + |
| | | "values(" + |
| | | "" + omodel.HInterID.ToString() + "" + |
| | |
| | | "," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + "" + |
| | | "," + omodel.HCarriage + "" + |
| | | ",'" + omodel.HCheckStatusMan + "'" + |
| | | ",'" + omodel.HProjectID.ToString() + "'" + |
| | | ",'" + omodel.HGroupID.ToString() + "'" + |
| | | ",'" + omodel.HPriceType + "'" + |
| | | ") "; |
| | | |
| | | oCn.RunProc(mainSql); |