public ActionResult Edit(System.Int64? id, string act) { Z10DepotProduct entity = null; if (id.HasValue && id > 0) { if (act == "detail") { if ((_crud & Zippy.SaaS.Entity.CRUD.Read) != Zippy.SaaS.Entity.CRUD.Read) return RedirectToAction("NoPermission", "Error"); ViewData["VTitle"] = "查看库存产品信息"; ViewData["IsDetail"] = true; } else { if ((_crud & Zippy.SaaS.Entity.CRUD.Update) != Zippy.SaaS.Entity.CRUD.Update) return RedirectToAction("NoPermission", "Error"); ViewData["VTitle"] = "修改库存产品信息"; } entity = Z10DepotProductHelper.Create(db, id.Value); ViewData["DepotOptions"] = EAP.Logic.Z10.HtmlHelper.DepotSelectOptions(_tenant.TenantID.Value, entity.DepotID, db); ViewData["ProductTitle"] = db.FindUnique<Z01Beetle.Entity.Z01Product>("ProductID=@ProductID and TenantID=@TenantID", "Title", db.CreateParameter("ProductID", entity.ProductID), db.CreateParameter("TenantID", _tenant.TenantID.Value)); } else { if ((_crud & Zippy.SaaS.Entity.CRUD.Create) != Zippy.SaaS.Entity.CRUD.Create) return RedirectToAction("NoPermission", "Error"); ViewData["VTitle"] = "新增库存产品"; entity = new Z10DepotProduct(); ViewData["DepotOptions"] = EAP.Logic.Z10.HtmlHelper.DepotSelectOptions(_tenant.TenantID.Value, db); } string returnUrl = Request["ReturnUrl"]; if (returnUrl.IsNullOrEmpty()) returnUrl = "/" + _ContollerName; ViewData["ReturnUrl"] = returnUrl; return View(entity); }
public ActionResult EditDepotProduct(System.Int64?id) { if ((_crud & Zippy.SaaS.Entity.CRUD.Create) != Zippy.SaaS.Entity.CRUD.Create) { return(RedirectToAction("NoPermission", "Error")); } Z10DepotProduct entity = null; if (id.HasValue && id > 0) { if ((_crud & Zippy.SaaS.Entity.CRUD.Update) != Zippy.SaaS.Entity.CRUD.Update) { return(RedirectToAction("NoPermission", "Error")); } ViewData["VTitle"] = "修改库存信息"; entity = Z10DepotProductHelper.Create(db, id.Value); } else { if ((_crud & Zippy.SaaS.Entity.CRUD.Create) != Zippy.SaaS.Entity.CRUD.Create) { return(RedirectToAction("NoPermission", "Error")); } ViewData["VTitle"] = "新增库存商品"; entity = new Z10DepotProduct(); } return(View(entity)); }
public ActionResult Details(System.Int64 id) { if ((_crud & Zippy.SaaS.Entity.CRUD.Read) != Zippy.SaaS.Entity.CRUD.Read) { return(RedirectToAction("NoPermission", "Error")); } Z10DepotProduct entity = Z10DepotProductHelper.Create(db, id); return(View(entity)); }
public ActionResult Edit(System.Int64?id, Z10DepotProduct entity) { entity.DepotProductID = id; ValidateZ10DepotProduct(entity); if (!ModelState.IsValid) { return(View(entity)); } try { if (id.HasValue && id > 0) { if ((_crud & Zippy.SaaS.Entity.CRUD.Update) != Zippy.SaaS.Entity.CRUD.Update) { return(RedirectToAction("NoPermission", "Error")); } //仓库和商品不允许修改 entity.DepotID = null; entity.ProductID = null; db.Update(entity); } else { if ((_crud & Zippy.SaaS.Entity.CRUD.Create) != Zippy.SaaS.Entity.CRUD.Create) { return(RedirectToAction("NoPermission", "Error")); } if (db.Exists <Z10DepotProduct>("DepotID=@DepotID and ProductID=@ProductID and TenantID=@TenantID", db.CreateParameter("DepotID", entity.DepotID), db.CreateParameter("ProductID", entity.ProductID), db.CreateParameter("TenantID", _tenant.TenantID.Value))) { ViewData["DepotOptions"] = EAP.Logic.Z10.HtmlHelper.DepotSelectOptions(_tenant.TenantID.Value, entity.DepotID, db); ViewData["ProductTitle"] = db.FindUnique <Z01Beetle.Entity.Z01Product>("ProductID=@ProductID and TenantID=@TenantID", "Title", db.CreateParameter("ProductID", entity.ProductID), db.CreateParameter("TenantID", _tenant.TenantID.Value)); ModelState.AddModelError("这个仓库已经有此种商品。", "这个仓库已经有此种商品。"); return(View(entity)); } entity.DepotProductID = null; entity.TenantID = _tenant.TenantID; db.Insert(entity); } return(Return()); } catch { return(View(entity)); } }
public ActionResult SaveProduct_S3(decimal count, decimal?price, long pid, long?did, string color, string size) { if (count <= 0) { return(Content("数量必须大于0。")); } var Price = price ?? 0; EAP.Logic.DictResponse res = new Logic.DictResponse(); var tenantID = _tenant.TenantID.Value; //更新商品库 if (!db.Exists <Z10DepotProduct>("ProductID=@ProductID and DepotID=@DepotID and TenantID=@TenantID", db.CreateParameter("ProductID", pid), db.CreateParameter("DepotID", did ?? 0), db.CreateParameter("TenantID", tenantID))) { Z10DepotProduct xProduct = new Z10DepotProduct(); xProduct.TenantID = tenantID; xProduct.ProductID = pid; xProduct.DepotID = did ?? 0; xProduct.StockSum = count; xProduct.InSum = count; xProduct.Creator = _user.UserID.Value; db.Insert(xProduct); } else { string sqlUpdateDepot = "update Z10DepotProduct set StockSum=StockSum + @itemHappened, InSum=InSum + @itemHappened" + " where ProductID=@ProductID and DepotID=@DepotID"; db.ExecuteNonQuery(sqlUpdateDepot, db.CreateParameter("itemHappened", count), db.CreateParameter("ProductID", pid), db.CreateParameter("DepotID", did ?? 0)); } //更新库存详情 Z10DepotProductDetail dpd = new Z10DepotProductDetail(); dpd.TenantID = tenantID; dpd.ProductID = pid; dpd.DepotID = did ?? 0; dpd.OrderID = 0; dpd.StockSum = count; dpd.InSum = count; dpd.ExtColor = color; dpd.ExtSize = size; dpd.PriceStock = Price; dpd.Creator = _user.UserID.Value; db.Insert(dpd); res._state = true; return(Content(res.ToJson())); }
public ActionResult Edit(System.Int64?id, string act) { Z10DepotProduct entity = null; if (id.HasValue && id > 0) { if (act == "detail") { if ((_crud & Zippy.SaaS.Entity.CRUD.Read) != Zippy.SaaS.Entity.CRUD.Read) { return(RedirectToAction("NoPermission", "Error")); } ViewData["VTitle"] = "查看库存产品信息"; ViewData["IsDetail"] = true; } else { if ((_crud & Zippy.SaaS.Entity.CRUD.Update) != Zippy.SaaS.Entity.CRUD.Update) { return(RedirectToAction("NoPermission", "Error")); } ViewData["VTitle"] = "修改库存产品信息"; } entity = Z10DepotProductHelper.Create(db, id.Value); ViewData["DepotOptions"] = EAP.Logic.Z10.HtmlHelper.DepotSelectOptions(_tenant.TenantID.Value, entity.DepotID, db); ViewData["ProductTitle"] = db.FindUnique <Z01Beetle.Entity.Z01Product>("ProductID=@ProductID and TenantID=@TenantID", "Title", db.CreateParameter("ProductID", entity.ProductID), db.CreateParameter("TenantID", _tenant.TenantID.Value)); } else { if ((_crud & Zippy.SaaS.Entity.CRUD.Create) != Zippy.SaaS.Entity.CRUD.Create) { return(RedirectToAction("NoPermission", "Error")); } ViewData["VTitle"] = "新增库存产品"; entity = new Z10DepotProduct(); ViewData["DepotOptions"] = EAP.Logic.Z10.HtmlHelper.DepotSelectOptions(_tenant.TenantID.Value, db); } string returnUrl = Request["ReturnUrl"]; if (returnUrl.IsNullOrEmpty()) { returnUrl = "/" + _ContollerName; } ViewData["ReturnUrl"] = returnUrl; return(View(entity)); }
protected void ValidateZ10DepotProduct(Z10DepotProduct entity) { }
/// <summary> /// 表示 [仓库] 对应的实体 /// </summary> public static Z10Depot GetDepotIDEntity(Zippy.Data.IDalProvider db, Z10DepotProduct entity) { return db.FindUnique<Z10Depot>("DepotID=@DepotID", db.CreateParameter("DepotID", entity.DepotID)); }
public static int Insert(Zippy.Data.IDalProvider db, Z10DepotProduct entity) { int rtn = db.Insert(entity); return rtn; }
public ActionResult Edit(System.Int64? id, Z10DepotProduct entity) { entity.DepotProductID = id; ValidateZ10DepotProduct(entity); if (!ModelState.IsValid) return View(entity); try { if (id.HasValue && id > 0) { if ((_crud & Zippy.SaaS.Entity.CRUD.Update) != Zippy.SaaS.Entity.CRUD.Update) return RedirectToAction("NoPermission", "Error"); //仓库和商品不允许修改 entity.DepotID = null; entity.ProductID = null; db.Update(entity); } else { if ((_crud & Zippy.SaaS.Entity.CRUD.Create) != Zippy.SaaS.Entity.CRUD.Create) return RedirectToAction("NoPermission", "Error"); if (db.Exists<Z10DepotProduct>("DepotID=@DepotID and ProductID=@ProductID and TenantID=@TenantID", db.CreateParameter("DepotID", entity.DepotID), db.CreateParameter("ProductID", entity.ProductID), db.CreateParameter("TenantID", _tenant.TenantID.Value))) { ViewData["DepotOptions"] = EAP.Logic.Z10.HtmlHelper.DepotSelectOptions(_tenant.TenantID.Value, entity.DepotID, db); ViewData["ProductTitle"] = db.FindUnique<Z01Beetle.Entity.Z01Product>("ProductID=@ProductID and TenantID=@TenantID", "Title", db.CreateParameter("ProductID", entity.ProductID), db.CreateParameter("TenantID", _tenant.TenantID.Value)); ModelState.AddModelError("这个仓库已经有此种商品。", "这个仓库已经有此种商品。"); return View(entity); } entity.DepotProductID = null; entity.TenantID = _tenant.TenantID; db.Insert(entity); } return Return(); } catch { return View(entity); } }
public static int Update(Zippy.Data.IDalProvider db, Z10DepotProduct entity) { return db.Update(entity); }
/// <summary> /// 采购出入库 /// </summary> /// <param name="tenantID">租户</param> /// <param name="userID">操作者</param> /// <param name="oStatus">当前状态</param> /// <param name="hsItemCount">各个商品的具体入库数量</param> /// <param name="db"></param> /// <returns></returns> public bool InOutDepot(Guid tenantID, Guid userID, EAP.Logic.Z10.OrderStatus oStatus, Hashtable hsItemCount, Zippy.Data.IDalProvider db) { throw new Exception("这个入库方式需要商榷。"); int orderSts = Z10Order.OrderStatus ?? 0; if ((orderSts & (int)EAP.Logic.Z10.OrderStatus.Outted) == (int)EAP.Logic.Z10.OrderStatus.Inned || (orderSts & (int)EAP.Logic.Z10.OrderStatus.Finished) == (int)EAP.Logic.Z10.OrderStatus.Finished || (orderSts & (int)EAP.Logic.Z10.OrderStatus.Archived) == (int)EAP.Logic.Z10.OrderStatus.Archived) { throw new Exception("已经出入库的订单,已经结束的订单和已经存档的订单不能出入库。"); } Z10Order xorder = new Z10Order(); xorder.OrderID = Z10Order.OrderID; if (oStatus == OrderStatus.Inned && ((Z10Order.OrderStatus ?? 0) & (int)OrderStatus.InnedSome) == (int)OrderStatus.InnedSome) { oStatus = oStatus & (~OrderStatus.InnedSome); xorder.OrderStatus = (Z10Order.OrderStatus ?? 0) & (~(int)OrderStatus.InnedSome); xorder.OrderStatus = (xorder.OrderStatus ?? 0) | (int)oStatus; } else if (oStatus == OrderStatus.Outted && ((Z10Order.OrderStatus ?? 0) & (int)OrderStatus.OuttedSome) == (int)OrderStatus.OuttedSome) { oStatus = oStatus & (~OrderStatus.OuttedSome); xorder.OrderStatus = (Z10Order.OrderStatus ?? 0) & (~(int)OrderStatus.OuttedSome); xorder.OrderStatus = (xorder.OrderStatus ?? 0) | (int)oStatus; } else { xorder.OrderStatus = (Z10Order.OrderStatus ?? 0) | (int)oStatus; } db.Update(xorder); Z10DepotFlow dflow = new Z10DepotFlow(); foreach (Z10OrderItem item in Items) { decimal itemHappened = hsItemCount[item.ItemID].ToDecimal(); if ((oStatus & OrderStatus.Outted) == OrderStatus.Outted || (oStatus & OrderStatus.OuttedSome) == OrderStatus.OuttedSome) db.ColAdd<Z10OrderItem>("CountHappend2", itemHappened, item.ItemID); else db.ColAdd<Z10OrderItem>("CountHappend", itemHappened, item.ItemID); if (item.CountHappend != 0 || item.CountHappend2 != 0) { dflow.FlowID = null; dflow.OrderID = Z10Order.OrderID; dflow.Count = itemHappened; dflow.DepotID = item.DepotID; dflow.Creator = userID; dflow.ProductID = item.ProductID; dflow.TenantID = tenantID; db.Insert(dflow); if (!db.Exists<Z10DepotProduct>("ProductID=@ProductID and DepotID=@DepotID and TenantID=@TenantID", db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID), db.CreateParameter("TenantID", tenantID))) { Z10DepotProduct xProduct = new Z10DepotProduct(); xProduct.TenantID = tenantID; xProduct.ProductID = item.ProductID; xProduct.DepotID = item.DepotID; xProduct.StockSum = itemHappened; db.Insert(xProduct); } else { string sqlUpdateDepot = "update Z10DepotProduct set StockSum=StockSum + @itemHappened, InSum=InSum + @itemHappened" + " where ProductID=@ProductID and DepotID=@DepotID"; db.ExecuteNonQuery(sqlUpdateDepot, db.CreateParameter("itemHappened", itemHappened), db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID)); } } } return true; }
public static int Insert(Zippy.Data.IDalProvider db, Z10DepotProduct entity) { int rtn = db.Insert(entity); return(rtn); }
/// <summary> /// 采购出入库 /// </summary> /// <param name="tenantID">租户</param> /// <param name="userID">操作者</param> /// <param name="oStatus">当前状态</param> /// <param name="hsItemCount">各个商品的具体入库数量</param> /// <param name="db"></param> /// <returns></returns> public bool InOutDepot(Guid tenantID, Guid userID, EAP.Logic.Z10.OrderStatus oStatus, Hashtable hsItemCount, Zippy.Data.IDalProvider db) { throw new Exception("这个入库方式需要商榷。"); int orderSts = Z10Order.OrderStatus ?? 0; if ((orderSts & (int)EAP.Logic.Z10.OrderStatus.Outted) == (int)EAP.Logic.Z10.OrderStatus.Inned || (orderSts & (int)EAP.Logic.Z10.OrderStatus.Finished) == (int)EAP.Logic.Z10.OrderStatus.Finished || (orderSts & (int)EAP.Logic.Z10.OrderStatus.Archived) == (int)EAP.Logic.Z10.OrderStatus.Archived) { throw new Exception("已经出入库的订单,已经结束的订单和已经存档的订单不能出入库。"); } Z10Order xorder = new Z10Order(); xorder.OrderID = Z10Order.OrderID; if (oStatus == OrderStatus.Inned && ((Z10Order.OrderStatus ?? 0) & (int)OrderStatus.InnedSome) == (int)OrderStatus.InnedSome) { oStatus = oStatus & (~OrderStatus.InnedSome); xorder.OrderStatus = (Z10Order.OrderStatus ?? 0) & (~(int)OrderStatus.InnedSome); xorder.OrderStatus = (xorder.OrderStatus ?? 0) | (int)oStatus; } else if (oStatus == OrderStatus.Outted && ((Z10Order.OrderStatus ?? 0) & (int)OrderStatus.OuttedSome) == (int)OrderStatus.OuttedSome) { oStatus = oStatus & (~OrderStatus.OuttedSome); xorder.OrderStatus = (Z10Order.OrderStatus ?? 0) & (~(int)OrderStatus.OuttedSome); xorder.OrderStatus = (xorder.OrderStatus ?? 0) | (int)oStatus; } else { xorder.OrderStatus = (Z10Order.OrderStatus ?? 0) | (int)oStatus; } db.Update(xorder); Z10DepotFlow dflow = new Z10DepotFlow(); foreach (Z10OrderItem item in Items) { decimal itemHappened = hsItemCount[item.ItemID].ToDecimal(); if ((oStatus & OrderStatus.Outted) == OrderStatus.Outted || (oStatus & OrderStatus.OuttedSome) == OrderStatus.OuttedSome) { db.ColAdd <Z10OrderItem>("CountHappend2", itemHappened, item.ItemID); } else { db.ColAdd <Z10OrderItem>("CountHappend", itemHappened, item.ItemID); } if (item.CountHappend != 0 || item.CountHappend2 != 0) { dflow.FlowID = null; dflow.OrderID = Z10Order.OrderID; dflow.Count = itemHappened; dflow.DepotID = item.DepotID; dflow.Creator = userID; dflow.ProductID = item.ProductID; dflow.TenantID = tenantID; db.Insert(dflow); if (!db.Exists <Z10DepotProduct>("ProductID=@ProductID and DepotID=@DepotID and TenantID=@TenantID", db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID), db.CreateParameter("TenantID", tenantID))) { Z10DepotProduct xProduct = new Z10DepotProduct(); xProduct.TenantID = tenantID; xProduct.ProductID = item.ProductID; xProduct.DepotID = item.DepotID; xProduct.StockSum = itemHappened; db.Insert(xProduct); } else { string sqlUpdateDepot = "update Z10DepotProduct set StockSum=StockSum + @itemHappened, InSum=InSum + @itemHappened" + " where ProductID=@ProductID and DepotID=@DepotID"; db.ExecuteNonQuery(sqlUpdateDepot, db.CreateParameter("itemHappened", itemHappened), db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID)); } } } return(true); }
public ActionResult SaveProduct_S3(decimal count, decimal? price, long pid, long? did, string color, string size) { if (count <= 0) { return Content("数量必须大于0。"); } var Price = price ?? 0; EAP.Logic.DictResponse res = new Logic.DictResponse(); var tenantID = _tenant.TenantID.Value; //更新商品库 if (!db.Exists<Z10DepotProduct>("ProductID=@ProductID and DepotID=@DepotID and TenantID=@TenantID", db.CreateParameter("ProductID", pid), db.CreateParameter("DepotID", did ?? 0), db.CreateParameter("TenantID", tenantID))) { Z10DepotProduct xProduct = new Z10DepotProduct(); xProduct.TenantID = tenantID; xProduct.ProductID = pid; xProduct.DepotID = did ?? 0; xProduct.StockSum = count; xProduct.InSum = count; xProduct.Creator = _user.UserID.Value; db.Insert(xProduct); } else { string sqlUpdateDepot = "update Z10DepotProduct set StockSum=StockSum + @itemHappened, InSum=InSum + @itemHappened" + " where ProductID=@ProductID and DepotID=@DepotID"; db.ExecuteNonQuery(sqlUpdateDepot, db.CreateParameter("itemHappened", count), db.CreateParameter("ProductID", pid), db.CreateParameter("DepotID", did ?? 0)); } //更新库存详情 Z10DepotProductDetail dpd = new Z10DepotProductDetail(); dpd.TenantID = tenantID; dpd.ProductID = pid; dpd.DepotID = did ?? 0; dpd.OrderID = 0; dpd.StockSum = count; dpd.InSum = count; dpd.ExtColor = color; dpd.ExtSize = size; dpd.PriceStock = Price; dpd.Creator = _user.UserID.Value; db.Insert(dpd); res._state = true; return Content(res.ToJson()); }
public ActionResult EditDepotProduct(System.Int64? id) { if ((_crud & Zippy.SaaS.Entity.CRUD.Create) != Zippy.SaaS.Entity.CRUD.Create) return RedirectToAction("NoPermission", "Error"); Z10DepotProduct entity = null; if (id.HasValue && id > 0) { if ((_crud & Zippy.SaaS.Entity.CRUD.Update) != Zippy.SaaS.Entity.CRUD.Update) return RedirectToAction("NoPermission", "Error"); ViewData["VTitle"] = "修改库存信息"; entity = Z10DepotProductHelper.Create(db, id.Value); } else { if ((_crud & Zippy.SaaS.Entity.CRUD.Create) != Zippy.SaaS.Entity.CRUD.Create) return RedirectToAction("NoPermission", "Error"); ViewData["VTitle"] = "新增库存商品"; entity = new Z10DepotProduct(); } return View(entity); }
/// <summary> /// 单项入库和出库(按照明细一个一个的入库) /// </summary> /// <param name="tenantID"></param> /// <param name="userID"></param> /// <param name="item"></param> /// <param name="itemHappened">当前发生的入库量</param> /// <returns></returns> public static void PutInOut(Guid? tenantID, Guid? userID, Z10Cabbage.Entity.Z10OrderItem item, decimal itemHappened) { var db = Zippy.Data.StaticDB.DB; if (itemHappened > 0) //入库 ,数量为正数 则入库,否则出库 { #region 入库 //更新商品库 if (!db.Exists<Z10DepotProduct>("ProductID=@ProductID and DepotID=@DepotID and TenantID=@TenantID", db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID), db.CreateParameter("TenantID", tenantID))) { Z10DepotProduct xProduct = new Z10DepotProduct(); xProduct.TenantID = tenantID; xProduct.ProductID = item.ProductID; xProduct.DepotID = item.DepotID; xProduct.StockSum = itemHappened; xProduct.InSum = itemHappened; xProduct.Creator = userID; db.Insert(xProduct); } else { string sqlUpdateDepot = "update Z10DepotProduct set StockSum=StockSum + @itemHappened, InSum=InSum + @itemHappened" + " where ProductID=@ProductID and DepotID=@DepotID"; db.ExecuteNonQuery(sqlUpdateDepot, db.CreateParameter("itemHappened", itemHappened), db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID)); } //更新库存详情 Z10DepotProductDetail dpd = new Z10DepotProductDetail(); dpd.TenantID = tenantID; dpd.ProductID = item.ProductID; dpd.DepotID = item.DepotID; dpd.OrderID = item.OrderID; dpd.StockSum = itemHappened; dpd.InSum = itemHappened; dpd.ExtColor = item.ExtColor; dpd.ExtSize = item.ExtSize; dpd.ExtSpecification = item.ExtSpecification; dpd.ExtModel1 = item.ExtModel1; dpd.ExtModel2 = item.ExtModel2; dpd.ExtModel3 = item.ExtModel3; dpd.ExtModel4 = item.ExtModel4; dpd.ExtModel5 = item.ExtModel5; dpd.PriceStock = item.Price; dpd.Creator = userID; db.Insert(dpd); //更新订单项 db.ColAdd<Z10OrderItem>("CountHappend", itemHappened, item.ItemID); #endregion } else { #region 出库 var productDetail = db.FindUnique<Z10Cabbage.Entity.Z10DepotProductDetail>(item.DepotProductDetailID); if (productDetail == null || productDetail.StockSum <= 0) { throw new Exception("错误的库存商品,或者商品数量为0。"); } if (productDetail.StockSum < Math.Abs(itemHappened)) { throw new Exception("库存数量太少,无法完成此次出货。"); } //更新总库存 string sqlUpdateDepot = "update Z10DepotProduct set StockSum=StockSum + @itemHappened, OutSum=OutSum + @itemHappened" + " where ProductID=@ProductID and DepotID=@DepotID"; db.ExecuteNonQuery(sqlUpdateDepot, db.CreateParameter("itemHappened", itemHappened), db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID)); //更新单项(型号)库存 string sqlUpdateDepotDetail = "update Z10DepotProductDetail set StockSum=StockSum + @itemHappened, OutSum=OutSum + @itemHappened" + " where DepotProductID=@DepotProductID"; db.ExecuteNonQuery(sqlUpdateDepotDetail, db.CreateParameter("itemHappened", itemHappened), db.CreateParameter("DepotProductID", item.DepotProductDetailID)); //更新订单项 db.ColAdd<Z10OrderItem>("CountHappend2", itemHappened, item.ItemID); #endregion } //增加库存流水 Z10DepotFlow xflow = new Z10DepotFlow(); xflow.Creator = userID; xflow.Count = itemHappened; xflow.DepotID = item.DepotID; xflow.OrderID = item.OrderID; xflow.ProductID = item.ProductID; xflow.TenantID = tenantID; db.Insert(xflow); }
/// <summary> /// 表示 [仓库] 对应的实体 /// </summary> public static Z10Depot GetDepotIDEntity(Zippy.Data.IDalProvider db, Z10DepotProduct entity) { return(db.FindUnique <Z10Depot>("DepotID=@DepotID", db.CreateParameter("DepotID", entity.DepotID))); }
public static Z10DepotProduct Create(Zippy.Data.IDalProvider db, Int64 _DepotProductID) { Z10DepotProduct rtn = db.FindUnique <Z10DepotProduct>(_DepotProductID); return(rtn); }
/// <summary> /// 单项入库和出库(按照明细一个一个的入库) /// </summary> /// <param name="tenantID"></param> /// <param name="userID"></param> /// <param name="item"></param> /// <param name="itemHappened">当前发生的入库量</param> /// <returns></returns> public static void PutInOut(Guid?tenantID, Guid?userID, Z10Cabbage.Entity.Z10OrderItem item, decimal itemHappened) { var db = Zippy.Data.StaticDB.DB; if (itemHappened > 0) //入库 ,数量为正数 则入库,否则出库 { #region 入库 //更新商品库 if (!db.Exists <Z10DepotProduct>("ProductID=@ProductID and DepotID=@DepotID and TenantID=@TenantID", db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID), db.CreateParameter("TenantID", tenantID))) { Z10DepotProduct xProduct = new Z10DepotProduct(); xProduct.TenantID = tenantID; xProduct.ProductID = item.ProductID; xProduct.DepotID = item.DepotID; xProduct.StockSum = itemHappened; xProduct.InSum = itemHappened; xProduct.Creator = userID; db.Insert(xProduct); } else { string sqlUpdateDepot = "update Z10DepotProduct set StockSum=StockSum + @itemHappened, InSum=InSum + @itemHappened" + " where ProductID=@ProductID and DepotID=@DepotID"; db.ExecuteNonQuery(sqlUpdateDepot, db.CreateParameter("itemHappened", itemHappened), db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID)); } //更新库存详情 Z10DepotProductDetail dpd = new Z10DepotProductDetail(); dpd.TenantID = tenantID; dpd.ProductID = item.ProductID; dpd.DepotID = item.DepotID; dpd.OrderID = item.OrderID; dpd.StockSum = itemHappened; dpd.InSum = itemHappened; dpd.ExtColor = item.ExtColor; dpd.ExtSize = item.ExtSize; dpd.ExtSpecification = item.ExtSpecification; dpd.ExtModel1 = item.ExtModel1; dpd.ExtModel2 = item.ExtModel2; dpd.ExtModel3 = item.ExtModel3; dpd.ExtModel4 = item.ExtModel4; dpd.ExtModel5 = item.ExtModel5; dpd.PriceStock = item.Price; dpd.Creator = userID; db.Insert(dpd); //更新订单项 db.ColAdd <Z10OrderItem>("CountHappend", itemHappened, item.ItemID); #endregion } else { #region 出库 var productDetail = db.FindUnique <Z10Cabbage.Entity.Z10DepotProductDetail>(item.DepotProductDetailID); if (productDetail == null || productDetail.StockSum <= 0) { throw new Exception("错误的库存商品,或者商品数量为0。"); } if (productDetail.StockSum < Math.Abs(itemHappened)) { throw new Exception("库存数量太少,无法完成此次出货。"); } //更新总库存 string sqlUpdateDepot = "update Z10DepotProduct set StockSum=StockSum + @itemHappened, OutSum=OutSum + @itemHappened" + " where ProductID=@ProductID and DepotID=@DepotID"; db.ExecuteNonQuery(sqlUpdateDepot, db.CreateParameter("itemHappened", itemHappened), db.CreateParameter("ProductID", item.ProductID), db.CreateParameter("DepotID", item.DepotID)); //更新单项(型号)库存 string sqlUpdateDepotDetail = "update Z10DepotProductDetail set StockSum=StockSum + @itemHappened, OutSum=OutSum + @itemHappened" + " where DepotProductID=@DepotProductID"; db.ExecuteNonQuery(sqlUpdateDepotDetail, db.CreateParameter("itemHappened", itemHappened), db.CreateParameter("DepotProductID", item.DepotProductDetailID)); //更新订单项 db.ColAdd <Z10OrderItem>("CountHappend2", itemHappened, item.ItemID); #endregion } //增加库存流水 Z10DepotFlow xflow = new Z10DepotFlow(); xflow.Creator = userID; xflow.Count = itemHappened; xflow.DepotID = item.DepotID; xflow.OrderID = item.OrderID; xflow.ProductID = item.ProductID; xflow.TenantID = tenantID; db.Insert(xflow); }
public static int Update(Zippy.Data.IDalProvider db, Z10DepotProduct entity) { return(db.Update(entity)); }