| | |
| | | long HConveyCompID = mainList[0].HConveyCompID;//运输公司 |
| | | long HConveyMoney = (long)mainList[0].HConveyMoney;//运费 |
| | | long HDFflag = Convert.ToInt32(mainList[0].HDFflag); //是否垫付 |
| | | |
| | | long HProjectID = mainList[0].HProjectID;//工程项目 |
| | | |
| | | string HBillType = mainList[0].HBillType; |
| | | string HBillSubType = mainList[0].HBillSubType; |
| | |
| | | ,HAddress,HSSID,HCurID,HWHID,HExRate,HEmpID,HExplanation,HInnerBillNo,HSeOrderBillNo_M |
| | | ,HConveyTypeID,HConveyCompID,HConveyMoney,HLinkMan,HLinkPhone |
| | | ,HSALEORGID,HDELIVERYORGID,HOWNERID,HOWNERTYPEID |
| | | ,HChecker,HCheckDate,HCloseMan,HCloseDate,HERPInterID,HERPBillType,HDFflag) |
| | | ,HChecker,HCheckDate,HCloseMan,HCloseDate,HERPInterID,HERPBillType,HDFflag,HProjectID) |
| | | values(" + HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1402 + "','" + |
| | | 1402 + "','" + HDate + "','" + HBillNo + "'," + HBillStatus + "," + HCusID + |
| | | "," + HManagerID + "," + HDeptID + ",'" + HRemark + "','" + HMaker + "','" + HMakeDate + |
| | | "','" + HAddress + "'," + HSSID + "," + HCurID + "," + HWHID + "," + HExRate + "," + HEmpID + ",'" + |
| | | HExplanation + "','" + HInnerBillNo + "','" + HSeOrderBillNo_M + "','" + HConveyTypeID + "','" + HConveyCompID + "','" + HConveyMoney + "','" + HLinkMan + "','" + HLinkPhone + "'," + HSALEORGID + "," + HDELIVERYORGID + "," + HOWNERID + ",'" |
| | | + HOWNERTYPEID + "','" + HChecker + "','" + HCheckDate + "','" + HCloseMan + "','" + HCloseDate + "'," + HERPInterID + |
| | | ",'" + HERPBillType + "'," + HDFflag + ")"; |
| | | ",'" + HERPBillType + "'," + HDFflag + ",'"+ HProjectID + "')"; |
| | | |
| | | oCN.RunProc(sql); |
| | | |
| | |
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
| | | ",HCusID='" + HCusID + "', HCurID='" + HCurID + "', HWHID = '" + HWHID |
| | | + "',HExRate='" + HExRate + "',HEmpID='" + HEmpID + "',HSeOrderBillNo_M='" + HSeOrderBillNo_M + "',HManagerID='" + HManagerID + "',HDeptID='" + HDeptID + "',HOWNERID='" + HOWNERID |
| | | + "',HAddress='" + HAddress + "' where HInterID=" + HInterID; |
| | | + "',HAddress='" + HAddress + "',HProjectID='"+ HProjectID + "' where HInterID=" + HInterID; |
| | | oCN.RunProc(sql); |
| | | |
| | | //删除子表 |