| | |
|---|
| | | string HInnerBillNo = mainList[0].HInnerBillNo;//内部单据号 |
|---|
| | | long HWHID = mainList[0].HWHID;//仓库 |
|---|
| | | long HProjectID = mainList[0].HProjectID;//仓库 |
|---|
| | | |
|---|
| | | string HLinkMan = mainList[0].HLinkMan;//联系人 |
|---|
| | | string HLinkPhone = mainList[0].HLinkPhone;//联系人电话 |
|---|
| | | List<ClsCg_POOrderBillMain> mainList2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POOrderBillMain>>(msg2); |
|---|
| | | DateTime dt = DateTime.Now; |
|---|
| | | long HPURCHASEORGID = mainList2[0].HOrgID; |
|---|
| | |
|---|
| | | ,HMaker,HMakeDate |
|---|
| | | ,HERPInterID,HERPBillType,HPURCHASEORGID |
|---|
| | | ,HPURCHASERGROUPID,HPROVIDERID,HSETTLEID,HCHARGEID,HBUSINESSTYPE,HPROVIDERADDRESS,HCORRESPONDORGID,HPROVIDERCONTACTID |
|---|
| | | ,HWHID,HProjectID) |
|---|
| | | ,HWHID,HProjectID,HLinkMan,HLinkPhone) |
|---|
| | | values(" + HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1102 + "','" + |
|---|
| | | 1102 + "','" + HDate + "','" + HBillNo + "','" + HBillStatus + "','" + HAddress + |
|---|
| | | "'," + HSSID + ",'" + HSSDate + "'," + HPSStyleID + "," + HSupID + "," + HCurID + |
|---|
| | | "," + HExRate + "," + HEmpID + "," + HManagerID + "," + HDeptID + ",'" + HExplanation + "','" + HRemark + "','" + HInnerBillNo + "','" + HMaker + "',getdate()" + "," + HERPInterID + ",'" + HERPBillType + "'," + HPURCHASEORGID + "," + HPURCHASERGROUPID + "," |
|---|
| | | + HPROVIDERID + "," + HSETTLEID + "," + HCHARGEID + ",'" + HBUSINESSTYPE + "','" + HPROVIDERADDRESS + "'," |
|---|
| | | + HCORRESPONDORGID + "," + HPROVIDERCONTACTID + "," |
|---|
| | | + HWHID+","+ HProjectID + ")"); |
|---|
| | | + HWHID+","+ HProjectID +",'"+HLinkMan+"','"+HLinkPhone+"'"+")"); |
|---|
| | | } |
|---|
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
|---|
| | | { //修改 |
|---|
| | |
|---|
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
|---|
| | | ",HSSID=" + HSSID + ",HPSStyleID=" + HPSStyleID + ",HSupID=" + HSupID + ",HCurID=" + HCurID |
|---|
| | | + ",HExRate=" + HExRate + ",HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID |
|---|
| | | + ",HAddress='" + HAddress + "',HSSDate='" + HSSDate + "',HWHID="+ HWHID + ",HProjectID="+ HProjectID + " where HInterID=" + HInterID); |
|---|
| | | + ",HAddress='" + HAddress + "',HSSDate='" + HSSDate + "',HWHID="+ HWHID + ",HProjectID="+ HProjectID +",HLinkMan = '"+HLinkMan+"',HLinkPhone = '"+HLinkPhone+ "' where HInterID=" + HInterID); |
|---|
| | | |
|---|
| | | //删除子表 |
|---|
| | | oCN.RunProc("delete from Cg_POOrderBillSub where HInterID='" + HInterID + "'"); |
|---|
