private void CreateLog() { IList <InWarehouseDetailDetail> iwddEnts = InWarehouseDetailDetail.FindAll();//入库 foreach (InWarehouseDetailDetail iwddEnt in iwddEnts) { StockLog slEnt = new StockLog(); InWarehouse iwEnt = null; if (!string.IsNullOrEmpty(iwddEnt.InWarehouseDetailId)) { slEnt.InOrOutDetailId = iwddEnt.InWarehouseDetailId; InWarehouseDetail iwdEnt = InWarehouseDetail.Find(iwddEnt.InWarehouseDetailId); iwEnt = InWarehouse.Find(iwdEnt.InWarehouseId); } else { slEnt.InOrOutDetailId = iwddEnt.OtherInWarehouseDetailId; OtherInWarehouseDetail oiwdEnt = OtherInWarehouseDetail.Find(iwddEnt.OtherInWarehouseDetailId); iwEnt = InWarehouse.Find(oiwdEnt.InWarehouseId); } slEnt.InOrOutBillNo = iwEnt.InWarehouseNo; slEnt.OperateType = "产品入库"; slEnt.WarehouseId = iwEnt.WarehouseId; slEnt.WarehouseName = iwEnt.WarehouseName; //IList<StockInfo> siEnts = StockInfo.FindAllByProperties(StockInfo.Prop_ProductId, iwddEnt.ProductId, StockInfo.Prop_WarehouseId, iwEnt.WarehouseId); //if (siEnts.Count > 0) //{ // slEnt.StockQuantity = siEnts[0].StockQuantity; //} slEnt.Quantity = iwddEnt.Quantity; slEnt.ProductId = iwddEnt.ProductId; Product pEnt = Product.TryFind(iwddEnt.ProductId); if (pEnt != null) { slEnt.ProductName = pEnt.Name; slEnt.ProductCode = pEnt.Code; slEnt.ProductIsbn = pEnt.Isbn; slEnt.ProductPcn = pEnt.Pcn; slEnt.CreateId = iwddEnt.CreateId; slEnt.CreateName = iwddEnt.CreateName; slEnt.CreateTime = iwddEnt.CreateTime; slEnt.DoCreate(); } } //生成出库日志 IList <DelieryOrderPart> dopEnts = DelieryOrderPart.FindAllByProperty(DelieryOrderPart.Prop_State, "已出库"); foreach (DelieryOrderPart dopEnt in dopEnts) { StockLog slEnt = new StockLog(); slEnt.InOrOutDetailId = dopEnt.Id; DeliveryOrder doEnt = DeliveryOrder.Find(dopEnt.DId); slEnt.InOrOutBillNo = doEnt.Number; slEnt.OperateType = "产品出库"; slEnt.WarehouseId = doEnt.WarehouseId; slEnt.WarehouseName = doEnt.WarehouseName; //IList<StockInfo> siEnts = StockInfo.FindAllByProperties(StockInfo.Prop_ProductId, iwddEnt.ProductId, StockInfo.Prop_WarehouseId, iwEnt.WarehouseId); //if (siEnts.Count > 0) //{ // slEnt.StockQuantity = siEnts[0].StockQuantity; //} slEnt.Quantity = dopEnt.OutCount; if (!string.IsNullOrEmpty(dopEnt.ProductId)) { slEnt.ProductId = dopEnt.ProductId; Product pEnt = Product.TryFind(dopEnt.ProductId); if (pEnt != null) { slEnt.ProductName = pEnt.Name; slEnt.ProductCode = pEnt.Code; slEnt.ProductIsbn = pEnt.Isbn; slEnt.ProductPcn = pEnt.Pcn; slEnt.CreateId = dopEnt.CreateId; slEnt.CreateName = dopEnt.CreateName; slEnt.CreateTime = dopEnt.CreateTime; slEnt.DoCreate(); } } } //盘点操作库存日志 string sql = "select * from SHHG_AimExamine..StockCheckDetail where StockCheckResult!='正常' and StockCheckState='盘点结束'"; IList <EasyDictionary> scdDics = DataHelper.QueryDictList(sql); foreach (EasyDictionary scdDic in scdDics) { StockLog slEnt = new StockLog(); slEnt.InOrOutDetailId = scdDic.Get <string>("Id"); StockCheck scEnt = StockCheck.Find(scdDic.Get <string>("StockCheckId")); slEnt.InOrOutBillNo = scEnt.StockCheckNo; slEnt.OperateType = "库存盘点"; slEnt.WarehouseId = scEnt.WarehouseId; slEnt.WarehouseName = scEnt.WarehouseName; slEnt.StockQuantity = scdDic.Get <Int32>("StockQuantity"); slEnt.Quantity = scdDic.Get <Int32>("StockCheckQuantity") - scdDic.Get <Int32>("StockQuantity"); slEnt.ProductId = scdDic.Get <string>("ProductId"); Product pEnt = Product.TryFind(slEnt.ProductId); if (pEnt != null) { slEnt.ProductName = pEnt.Name; slEnt.ProductCode = pEnt.Code; slEnt.ProductIsbn = pEnt.Isbn; slEnt.ProductPcn = pEnt.Pcn; slEnt.CreateId = scEnt.CreateId; slEnt.CreateName = scEnt.CreateName; slEnt.CreateTime = scEnt.CreateTime; slEnt.DoCreate(); } } }
protected void Page_Load(object sender, EventArgs e) { op = RequestData.Get <string>("op"); id = RequestData.Get <string>("id"); switch (RequestActionString) { case "IsIsbn": string val = RequestData.Get <string>("Value"); IList <Product> proEnts = Product.FindAll("from Product where Isbn='" + val + "'"); if (proEnts.Count > 0) { PageState.Add("IsIsbn", true); } else { PageState.Add("IsIsbn", false); } break; case "GetPackageInfo": string Isbn = RequestData.Get <string>("Isbn"); sql = "select * from SHHG_AimExamine..Products where FirstSkinIsbn='" + Isbn + "' and FirstSkinCapacity is not null"; IList <EasyDictionary> dics = DataHelper.QueryDictList(sql); if (dics.Count > 0) { PageState.Add("ProductIsbn", dics[0].Get <string>("Isbn").ToUpper()); PageState.Add("ProductQuan", dics[0].Get <int>("FirstSkinCapacity")); } sql = "select * from SHHG_AimExamine..Products where SecondSkinIsbn='" + Isbn + "' and SecondSkinCapacity is not null"; dics = DataHelper.QueryDictList(sql); if (dics.Count > 0) { PageState.Add("ProductIsbn", dics[0].Get <string>("Isbn").ToUpper()); PageState.Add("ProductQuan", dics[0].Get <int>("SecondSkinCapacity")); } break; case "ScanSkin": //判断包装编号是否存在 string skinNo = RequestData.Get <string>("SkinNo"); IList <Skin> sEnts = Skin.FindAll("from Skin where SkinNo='" + skinNo + "'"); if (sEnts.Count > 0) //如果该包装的记录不存在 { PageState.Add("SkinExist", true); } else { PageState.Add("SkinExist", false); } break; case "ScanCompressor": string seriesNo = RequestData.Get <string>("SeriesNo"); IList <Compressor> cEnts = Compressor.FindAll("from Compressor where SeriesNo='" + seriesNo + "'"); if (cEnts.Count == 0) { PageState.Add("CompressorExist", false); } else { PageState.Add("CompressorExist", true); } break; case "InWarehouse": InWarehouse iwEnt = InWarehouse.TryFind(id); IList <string> entStrList = RequestData.GetList <string>("data"); if (entStrList != null && entStrList.Count > 0) { for (int j = 0; j < entStrList.Count; j++) { Newtonsoft.Json.Linq.JObject objL = JsonHelper.GetObject <Newtonsoft.Json.Linq.JObject>(entStrList[j]); if (Convert.ToInt32(objL.Value <string>("ActuallyQuantity")) > 0) //只有输入了入库数量才会增加实际入库记录 { InWarehouseDetailDetail iwddEnt = new InWarehouseDetailDetail(); //新建一个实际入库详细信息 if (iwEnt.InWarehouseType == "采购入库") { iwddEnt.InWarehouseDetailId = objL.Value <string>("Id"); iwddEnt.PurchaseOrderDetailId = objL.Value <string>("PurchaseOrderDetailId"); } else //其他入库的情形 { iwddEnt.OtherInWarehouseDetailId = objL.Value <string>("Id"); } iwddEnt.Quantity = Convert.ToInt32(objL.Value <string>("ActuallyQuantity")); iwddEnt.ProductId = objL.Value <string>("ProductId"); iwddEnt.Remark = objL.Value <string>("Remark"); iwddEnt.DoCreate(); StockLog slEnt = new StockLog(); //创建库存变更日志 slEnt.InOrOutDetailId = objL.Value <string>("Id"); slEnt.InOrOutBillNo = iwEnt.InWarehouseNo; slEnt.OperateType = "产品入库"; slEnt.WarehouseId = iwEnt.WarehouseId; slEnt.WarehouseName = iwEnt.WarehouseName; IList <StockInfo> siEnts = StockInfo.FindAllByProperties(StockInfo.Prop_ProductId, objL.Value <string>("ProductId"), StockInfo.Prop_WarehouseId, iwEnt.WarehouseId); if (siEnts.Count > 0) { slEnt.StockQuantity = siEnts[0].StockQuantity; } slEnt.Quantity = Convert.ToInt32(objL.Value <string>("ActuallyQuantity")); slEnt.ProductId = objL.Value <string>("ProductId"); Product pEnt = Product.Find(objL.Value <string>("ProductId")); slEnt.ProductName = pEnt.Name; slEnt.ProductCode = pEnt.Code; slEnt.ProductIsbn = pEnt.Isbn; slEnt.ProductPcn = pEnt.Pcn; slEnt.DoCreate(); ProcessSkin(objL.Value <string>("SkinArray"), objL.Value <string>("ISBN"), iwEnt.Id); ProcessCompressor(objL.Value <string>("SeriesArray"), objL.Value <string>("ISBN"), iwEnt.Id); processremark(objL.Value <string>("Remark"), pEnt, iwEnt.Id); //如果实际入库数量和未入库的数量相等 则入库状态为已入库 if (objL.Value <string>("ActuallyQuantity") == objL.Value <string>("NoIn")) { if (iwEnt.InWarehouseType == "采购入库") { InWarehouseDetail iwdEnt = InWarehouseDetail.Find(objL.Value <string>("Id")); if (!string.IsNullOrEmpty(objL.Value <string>("SkinArray"))) { iwdEnt.SkinArray = objL.Value <string>("SkinArray").ToString(); } if (!string.IsNullOrEmpty(objL.Value <string>("SeriesArray"))) { iwdEnt.SeriesArray = objL.Value <string>("SeriesArray").ToString(); } iwdEnt.InWarehouseState = "已入库"; iwdEnt.DoUpdate(); } else { OtherInWarehouseDetail oiwdEnt = OtherInWarehouseDetail.Find(objL.Value <string>("Id")); oiwdEnt.InWarehouseState = "已入库"; if (!string.IsNullOrEmpty(objL.Value <string>("SkinArray"))) { oiwdEnt.SkinArray = objL.Value <string>("SkinArray").ToString(); } if (!string.IsNullOrEmpty(objL.Value <string>("SeriesArray"))) { oiwdEnt.SeriesArray = objL.Value <string>("SeriesArray").ToString(); } oiwdEnt.DoUpdate(); } } else //如果未入库的数量不等于现在输入的数量。只更新包装和压缩机序列号集合 { if (iwEnt.InWarehouseType == "采购入库") { InWarehouseDetail iwdEnt = InWarehouseDetail.Find(objL.Value <string>("Id")); iwdEnt.Remark = objL.Value <string>("Remark"); if (!string.IsNullOrEmpty(objL.Value <string>("SkinArray"))) { iwdEnt.SkinArray = objL.Value <string>("SkinArray").ToString(); } if (!string.IsNullOrEmpty(objL.Value <string>("SeriesArray"))) { iwdEnt.SeriesArray = objL.Value <string>("SeriesArray").ToString(); } iwdEnt.DoUpdate(); } else { OtherInWarehouseDetail oiwdEnt = OtherInWarehouseDetail.Find(objL.Value <string>("Id")); oiwdEnt.Remark = objL.Value <string>("Remark"); if (!string.IsNullOrEmpty(objL.Value <string>("SkinArray"))) { oiwdEnt.SkinArray = objL.Value <string>("SkinArray").ToString(); } if (!string.IsNullOrEmpty(objL.Value <string>("SeriesArray"))) { oiwdEnt.SeriesArray = objL.Value <string>("SeriesArray").ToString(); } oiwdEnt.DoUpdate(); } } //修改库存 InStorage(iwddEnt.ProductId, iwddEnt.Quantity.Value, iwEnt.WarehouseId); } } } ProcessInWarehouse(iwEnt); if (iwEnt.InWarehouseType == "采购入库") //处理采购单和采购单详细 { ProcessPurchaseOrderAndDetail(iwEnt); } break; default: DoSelect(); break; } }