| | |
| | | |
| | | 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() }); // 收料组织 |
| | |
| | | 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 |