/// <summary> /// 创建盘点作业 /// </summary> /// <param name="model">盘点实体</param> /// <param name="productModel">盘点商品实体</param> /// <returns></returns> public override int AddWhInventory(Hyt.Model.InventorySheet.WhInventory model, List <WhInventoryProduct> productModel) { int sysNo = 0; using (var context = Context.UseTransaction(true)) { try { sysNo = Context.Insert("WhInventory", model).AutoMap(x => x.SysNo).ExecuteReturnLastId <int>("SysNo"); if (sysNo > 0) { foreach (var item in productModel) { item.InventorySysNo = sysNo; Context.Insert("WhInventoryProduct", item).AutoMap(x => x.SysNo).ExecuteReturnLastId <int>("SysNo"); } } context.Commit(); } catch (Exception) { //回滚 sysNo = 0; context.Rollback(); } } return(sysNo); }
public ActionResult EditInventory(string id) { Hyt.Model.InventorySheet.WhInventory model = new Hyt.Model.InventorySheet.WhInventory(); ViewBag.Name = MvcHtmlString.Create(MvcCreateHtml.EnumToString <Hyt.Model.InventorySheet.WhlnventoryEnum.WhlnventoryName>(null, null).ToString()); ViewBag.Where = MvcHtmlString.Create(MvcCreateHtml.EnumToString <Hyt.Model.InventorySheet.WhlnventoryEnum.WhlnventoryWhere>(null, null).ToString()); //ViewBag.Type = GetSyUserList((int)Hyt.Model.WorkflowStatus.SystemStatus.用户组状态.启用); //if (!string.IsNullOrEmpty(id)) //{ // model = WhInventoryBo.Instance.GetModelId(Guid.Parse(id)); //} return(View(model)); }
/// <summary> /// 创建盘点作业 /// </summary> /// <param name="model">盘点实体</param> /// <param name="productModel">盘点商品实体</param> /// <returns></returns> public abstract int AddWhInventory(Hyt.Model.InventorySheet.WhInventory model, List <WhInventoryProduct> productModel);
public ActionResult AddWhInventory(string WhInventoryStr, int Type, string whereStr, string TypeIdStr, string brandIdStr) { if (string.IsNullOrEmpty(WhInventoryStr)) { return(Json(new Result { Status = false, Message = "请选择需要盘点的仓库!" }, JsonRequestBehavior.AllowGet)); } List <CBPdProductStockList> pager = null; #region 获取库存商品 if (Type == (int)Hyt.Model.InventorySheet.WhlnventoryEnum.WhlnventoryType.仓位商品) { if (!string.IsNullOrEmpty(whereStr)) { whereStr = whereStr.Replace("物料代码", "p.ErpCode"); whereStr = whereStr.Replace("物料名称", "p.EasName"); whereStr = whereStr.Replace("仓位代码", "w.erpCode"); whereStr = whereStr.Replace("仓位名称", "w.WarehouseName"); whereStr = whereStr.Replace("条形码", "p.Barcode"); } pager = PdProductStockBo.Instance.GetPdProductStockListData(WhInventoryStr.Trim(','), whereStr, "", ""); } if (Type == (int)Hyt.Model.InventorySheet.WhlnventoryEnum.WhlnventoryType.品牌) { if (string.IsNullOrEmpty(brandIdStr)) { return(Json(new Result { Status = false, Message = "请选择需要盘点的商品品牌!" }, JsonRequestBehavior.AllowGet)); } pager = PdProductStockBo.Instance.GetPdProductStockListData(WhInventoryStr.Trim(','), "", brandIdStr.Trim(','), ""); } if (Type == (int)Hyt.Model.InventorySheet.WhlnventoryEnum.WhlnventoryType.商品类别) { if (string.IsNullOrEmpty(TypeIdStr)) { return(Json(new Result { Status = false, Message = "请选择需要盘点的商品类别!" }, JsonRequestBehavior.AllowGet)); } pager = PdProductStockBo.Instance.GetPdProductStockListData(WhInventoryStr.Trim(','), "", "", TypeIdStr.Trim(',')); } if (pager == null || pager.Count == 0) { return(Json(new Result { Status = false, Message = "没有可用的数据,不能备份!" }, JsonRequestBehavior.AllowGet)); } #endregion #region 获取盘点代码 var sl = (Hyt.BLL.InventorySheet.WhInventoryBo.Instance.GetWhInventoryCount() + 1); var Code = ""; if (sl.ToString().Length == 1) { Code = DateTime.Now.ToString("yyyyMMdd") + "000" + sl; } if (sl.ToString().Length == 2) { Code = DateTime.Now.ToString("yyyyMMdd") + "00" + sl; } if (sl.ToString().Length == 3) { Code = DateTime.Now.ToString("yyyyMMdd") + "0" + sl; } if (sl.ToString().Length == 4) { Code = DateTime.Now.ToString("yyyyMMdd") + sl; } #endregion #region 创建盘点作业 Hyt.Model.InventorySheet.WhInventory model = new Hyt.Model.InventorySheet.WhInventory() { Code = Code, CreatedBy = CurrentUser.Base.SysNo, CreatedName = CurrentUser.Base.UserName, Status = (int)Hyt.Model.InventorySheet.WhlnventoryEnum.WhlnventoryStatus.未处理, InventoryWhere = whereStr, WhInventorySysNo = WhInventoryStr.Trim(','), ProductTypeSysNo = TypeIdStr.Trim(','), ProductBrandSysNo = brandIdStr.Trim(','), AddTime = DateTime.Now }; List <WhInventoryProduct> produceModelList = new List <WhInventoryProduct>(); foreach (var item in pager) { var produceModel = new WhInventoryProduct() { WarehouseSysNo = item.WarehouseSysNo, ProductSysNo = item.ProductSysNo, ZhangCunQuantity = Convert.ToDecimal(item.StockQuantity), InventoryQuantity = Convert.ToDecimal(item.StockQuantity), adjustmenQuantity = 0, Quantity = 0, Status = -1, Remarks = "" }; produceModelList.Add(produceModel); } int sysno = Hyt.BLL.InventorySheet.WhInventoryBo.Instance.AddWhInventory(model, produceModelList); if (sysno > 0) { return(Json(new Result { Status = true, Message = "成功" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new Result { Status = true, Message = "失败" }, JsonRequestBehavior.AllowGet)); } #endregion }
/// <summary> /// 创建盘点作业 /// </summary> /// <param name="model">盘点实体</param> /// <param name="productModel">盘点商品实体</param> /// <returns></returns> public int AddWhInventory(Hyt.Model.InventorySheet.WhInventory model, List <WhInventoryProduct> productModel) { return(IWhInventoryDao.Instance.AddWhInventory(model, productModel)); }