| | |
| | | ") "); |
| | | |
| | | //反写产量汇报单临时表关联字段信息 |
| | | string sql = string.Format(@"update Sc_ICMOBillWorkQtyStatus_Tmp set |
| | | HICMOReportInterID ='" + omodel.HInterID + |
| | | "', HICMOReportBillNo='" + omodel.HBillNo + |
| | | string sql = string.Format(@"update Sc_ICMOBillWorkQtyStatus_Tmp set " + |
| | | " HICMOReportBillNo ='" + omodel.HBillNo + |
| | | "', HRelationInterID='" + omodel.HInterID + |
| | | "', HRelationEntryID='" + oSub.HEntryID + |
| | | "' from Sc_ICMOBillWorkQtyStatus_Tmp a where a.HICMOBillNo='" + DetailColl[0].HICMOBillNo + "' and a.HSourceID='" + DetailColl[0].HSourceID + "' and HICMOInterID='" + DetailColl[0].HICMOInterID + "' and a.HICMOEntryID='" + DetailColl[0].HICMOEntryID + "' and HRelationInterID='0'"); |
| | | oCn.RunProc(sql); |
| | | |
| | | //反写质量汇报单临时表关联字段信息 |
| | | string sql2 = string.Format(@"update Sc_ICMOBillQualityStatus_Tmp set " + |
| | | " HRelationBillNo ='" + omodel.HBillNo + |
| | | "', HRelationInterID='" + omodel.HInterID + |
| | | "' from Sc_ICMOBillQualityStatus_Tmp a where a.HICMOBillNo='" + DetailColl[0].HICMOBillNo + "' and a.HSourceID='" + DetailColl[0].HSourceID + "' and HICMOInterID='" + DetailColl[0].HICMOInterID + "' and a.HICMOEntryID='" + DetailColl[0].HICMOEntryID + "' and HRelationInterID='0'"); |
| | | oCn.RunProc(sql2); |
| | | } |
| | | // |
| | | //foreach (Model.ClsSc_ICMOReportBillSub oSub in DetailColl) |
| | |
| | | FentityModel.Add("FMoEntryId", item["FMoEntryId"].ToString());//生产订单分录号 |
| | | FentityModel.Add("FBaseUnitID", new JObject() { ["FNumber"] = item["FBaseUnitID"].ToString() });//单位 |
| | | FentityModel.Add("FSTOCKINORGID", new JObject() { ["FNumber"] = item["FSTOCKINORGID"].ToString() });//入库组织 |
| | | FentityModel.Add("FBOMID", new JObject() { ["FNumber"] = item["FBOMID"].ToString() });// BOM版本 |
| | | FentityModel.Add("FOwnerTypeId", item["FOwnerTypeId"].ToString());// 货主类型 |
| | | FentityModel.Add("FOwnerId", new JObject() { ["FNumber"] = item["FOwnerId"].ToString() });// 货主 |
| | | FentityModel.Add("FSTOCKID", new JObject() { ["FNumber"] = item["FSTOCKID"].ToString() });//仓库 |
| | |
| | | FentityModel.Add("FBASEFINISHQTY", item["FBASEFINISHQTY"].ToString());//基本单位完成数量 |
| | | FentityModel.Add("FFINISHQTY", item["FFINISHQTY"].ToString());//完成数量 |
| | | FentityModel.Add("FLot", new JObject() { ["FNumber"] = item["FLot"].ToString() });//批号 |
| | | FentityModel.Add("FBOMID", new JObject() { ["FNumber"] = item["FBOMID"].ToString() });// BOM版本 |
| | | |
| | | //sJson_BatchNo + |
| | | //sJson_StockPlace + |