| | |
| | | |
| | | model.Add("FBILLTYPEID", new JObject() { ["Fnumber"] = fTypeName }); //单据类型 |
| | | if (dr["FTYPENAME"].ToString().Contains("委外")) |
| | | model.Add("FBusinessType", "WW"); //单据编号 |
| | | model.Add("FBusinessType", "WW"); //业务类型 |
| | | model.Add("FBILLNO", dr["HBillNo"].ToString()); //单据编号 |
| | | model.Add("FDate", DateTime.Now.ToString("yyyy-MM-dd")); //通知日期 |
| | | model.Add("FStockOrgId", new JObject() { ["Fnumber"] = dr["FRECEIVENUMBER"].ToString() }); // 收料组织 |
| | |
| | | model.Add("FSupplierId", new JObject() { ["Fnumber"] = dr["FSUPPLIERNUMBER"].ToString() }); //供应商 |
| | | model.Add("FPURCHASERID", new JObject() { ["Fnumber"] = dr["FPURCHASERNUMBER"].ToString() }); //采购员 |
| | | model.Add("F_xbkf_Base", new JObject() { ["Fnumber"] = dr["FRECEIVEMENNUMBER"].ToString() }); //收料员 |
| | | model.Add("FOwnerTypeIdHead", "BD_OwnerOrg");// 货主类型 |
| | | model.Add("FOwnerTypeIdHead", "BD_Supplier");// 货主类型 |
| | | model.Add("FOwnerIdHead", new JObject() { ["Fnumber"] = dr["FPURCHASEORGNUMBER"].ToString() });//货主 |
| | | model.Add("F_XBKF_COMBO", dr["F_xbkf_Combo1"].ToString());//是否有票 |
| | | JArray Fentity = new JArray(); |
| | |
| | | string FID = JObject.Parse(result)["Result"]["Id"].ToString(); |
| | | |
| | | string updateSql = string.Format(@" |
| | | update a set |
| | | a.HERPInterID = {0} , |
| | | a.HERPBillNO ='{1}' |
| | | from Cg_POInStockBillMain a |
| | | join Cg_POInStockBillSub b on a.hinterid = b.hinterid |
| | | where b.HInterID = ({2}) |
| | | and b. HSOURCEINTERID = {3} |
| | | and a.HERPInterID = 0 |
| | | ", FID, FBillNo, dr["HINTERID"].ToString(), dr["FID"].ToString()); |
| | | update a set |
| | | a.HERPInterID = {0} , |
| | | a.HERPBillNO ='{1}' |
| | | from Cg_POInStockBillMain a |
| | | join Cg_POInStockBillSub b on a.hinterid = b.hinterid |
| | | where b.HInterID = ({2}) |
| | | and b. HSOURCEINTERID = {3} |
| | | and a.HERPInterID = 0 |
| | | ", FID, FBillNo, dr["HINTERID"].ToString(), dr["FID"].ToString()); |
| | | oCn.RunProc(updateSql); |
| | | } |
| | | else |