| | |
| | | ",HEmpID=" + omodel.HEmpID.ToString() + |
| | | ",HCurID=" + omodel.HCurID.ToString() + |
| | | ",HExRate=" + omodel.HExRate.ToString() + |
| | | ",HEarnestRate=" + omodel.HEarnestRate.ToString() + |
| | | ",HManagerID=" + omodel.HManagerID.ToString() + |
| | | ",HSellSID=" + omodel.HSellSID.ToString() + |
| | | ",HSSID=" + omodel.HSSID.ToString() + |
| | |
| | | //鎻掑叆涓昏〃 |
| | | string mainSql = "Insert Into Xs_SeOrderBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HBillStatus,HExplanation" + |
| | | ",HInterID,HBillNo,HDate,HInnerBillNo,HAddress,HDeptID,HCusID,HEmpID,HCurID,HExRate,HManagerID,HSellSID,HSSID,HSSDate,HPayCusID,HRemark,HOrgID,HMaker,HMakeDate,HLinkMan,HLinkPhone" + |
| | | ",HInterID,HBillNo,HDate,HInnerBillNo,HAddress,HDeptID,HCusID,HEmpID,HCurID,HExRate,HEarnestRate,HManagerID,HSellSID,HSSID,HSSDate,HPayCusID,HRemark,HOrgID,HMaker,HMakeDate,HLinkMan,HLinkPhone" + |
| | | ",HERPInterID,HERPBillType,HSALEORGID,HSALEGROUPID,HRECEIVEID,HSETTLEID,HCHARGEID,HHEADLOCID,HRECCONTACTID,HCORRESPONDORGID,HBUSINESSTYPE) " + |
| | | "values(" + |
| | | "" + omodel.HYear + |
| | |
| | | "," + omodel.HEmpID + |
| | | "," + omodel.HCurID + |
| | | "," + omodel.HExRate + |
| | | "," + omodel.HEarnestRate + |
| | | "," + omodel.HManagerID + |
| | | "," + omodel.HSellSID + |
| | | "," + omodel.HSSID + |
| | |
| | | omodel.HCusID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCusID"]); |
| | | omodel.HCurID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCurID"]); |
| | | omodel.HExRate = DBUtility.ClsPub.isSingle(Ds.Tables[0].Rows[0]["HExRate"]); |
| | | omodel.HEarnestRate = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HEarnestRate"]); |
| | | omodel.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"]); |
| | | omodel.HManagerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HManagerID"]); |
| | | omodel.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HDeptID"]); |