/// <summary> /// 根据id获取盘点报告单 /// </summary> /// <returns></returns> public override WhInventoryRepor GetWhInventoryRepor(int sysNo) { var model = new WhInventoryRepor(); model = Context.Select <WhInventoryRepor>("*").From("WhInventoryRepor").Where("SysNo=@SysNo").Parameter("SysNo", sysNo).QuerySingle(); return(model); }
/// <summary> /// 根据id获取盘点报告单明细 /// </summary> /// <returns></returns> public override WhInventoryRepor GetWhInventoryReporModel(int sysNo, int PageType) { var model = new WhInventoryRepor(); model = Context.Select <WhInventoryRepor>("*").From("WhInventoryRepor").Where("SysNo=@SysNo").Parameter("SysNo", sysNo).QuerySingle(); if (model == null) { return(null); } else { if (PageType == 1)//盘盈 { model.DataList = Context.Select <WhIReporPrDetails>("*").From("WhIReporPrDetails") .Where("WhInventoryReporSysNo=@WhInventoryReporSysNo and RealityQuantity>ADQuantity ") .Parameter("WhInventoryReporSysNo", sysNo) .QueryMany(); } else if (PageType == 2) //盘亏 { model.DataList = Context.Select <WhIReporPrDetails>("*").From("WhIReporPrDetails") .Where("WhInventoryReporSysNo=@WhInventoryReporSysNo and RealityQuantity<ADQuantity") .Parameter("WhInventoryReporSysNo", sysNo) .QueryMany(); } else { model.DataList = Context.Select <WhIReporPrDetails>("*").From("WhIReporPrDetails") .Where("WhInventoryReporSysNo=@WhInventoryReporSysNo") .Parameter("WhInventoryReporSysNo", sysNo) .QueryMany(); } return(model); } }
public ActionResult UpdateWhInventoryReporStatus(WhInventoryRepor model, int?id, int?status) { Result <object> result = new Result <object>(); if (id == null || status == null) { result.Status = false; result.Message = "参数错误,修改失败!"; return(Json(result)); } #region 修改盘点报告单 var getModel = Hyt.BLL.InventorySheet.WhInventoryBo.Instance.GetWhInventoryRepor((int)id); getModel.Status = (int)status; getModel.Tally = model.Tally; getModel.CustodySysNo = model.CustodySysNo; getModel.HeadSysNo = model.HeadSysNo; getModel.AgentSysNo = model.AgentSysNo; getModel.AuditTime = model.AuditTime; getModel.Remarks = model.Remarks; if (Hyt.BLL.InventorySheet.WhInventoryBo.Instance.UploadWhInventoryRepor(getModel)) { result.Status = true; result.Message = "成功!"; return(Json(result)); } else { result.Status = false; result.Message = "错误,提交失败!"; return(Json(result)); } #endregion }
/// <summary> /// 生成盘点报告单 /// </summary> /// <returns></returns> public override bool AddWhInventoryRepor(WhInventoryRepor reporModl, List <WhIReporPrDetails> productModel) { int sysNo = 0; using (var context = Context.UseTransaction(true)) { try { sysNo = Context.Insert("WhInventoryRepor", reporModl).AutoMap(x => x.SysNo, x => x.DataList, x => x.PanKuiStatus, x => x.PanYingStatus).ExecuteReturnLastId <int>("SysNo"); if (sysNo > 0) { foreach (var item in productModel) { item.WhInventoryReporSysNo = sysNo; Context.Insert("WhIReporPrDetails", item).AutoMap(x => x.SysNo).ExecuteReturnLastId <int>("SysNo"); } } context.Commit(); } catch (Exception e) { var a = e.Message; //回滚 sysNo = 0; context.Rollback(); } } return(sysNo > 0); }
public ActionResult EditWhInventoryRepor(int?id, int?PageType = 1) { WhInventoryRepor model = new WhInventoryRepor(); if (id != null) { model = Hyt.BLL.InventorySheet.WhInventoryBo.Instance.GetWhInventoryReporModel((int)id, (int)PageType); } ViewBag.PageType = PageType; ViewBag.AdminName = CurrentUser.Base.UserName; return(View(model)); }
/// <summary> /// 更新盘点报告单 /// </summary> /// <param name="sysNo"></param> /// <returns></returns> public override bool UploadWhInventoryRepor(WhInventoryRepor model) { return(Context.Update("WhInventoryRepor") .Column("Status", model.Status) .Column("Tally", model.Tally) .Column("CustodySysNo", model.CustodySysNo) .Column("HeadSysNo", model.HeadSysNo) .Column("AgentSysNo", model.AgentSysNo) .Column("AuditTime", model.AuditTime) .Column("Remarks", model.Remarks) .Where("SysNo", model.SysNo) .Execute() > 0); }
public ActionResult AddWhInventoryReporList(WhInventoryRepor model, string productCode, string ProductName, string CSysId, string CSysName, string CErpCode, string CZCount, string ShiSum, string DanJia, string PanYingCount, string PanYingJinE, string BeiZhu, int pdStatus) { Result <object> result = new Result <object>(); model.Status = pdStatus == 5 ? (int)Hyt.Model.InventorySheet.WhlnventoryEnum.WhInventoryReporStatus.盘盈入库 : (int)Hyt.Model.InventorySheet.WhlnventoryEnum.WhInventoryReporStatus.盘亏入库; model.WarehouseCode = CSysId.Trim(','); model.AddUser = CurrentUser.Base.SysNo; model.YingKuiStatus = pdStatus == 5 ? 1 : 2; model.AddTime = DateTime.Now; List <WhIReporPrDetails> productModelList = new List <WhIReporPrDetails>(); for (int i = 0; i < productCode.Trim(',').Split(',').Length; i++) { var productModel = new WhIReporPrDetails() { ProduceCode = productCode.Trim(',').Split(',')[i], ProductName = ProductName.Trim(',').Split(',')[i], Specification = "", AuxiliaryAttribute = "", BatchNumber = "", Unit = "", ADQuantity = Convert.ToDecimal(CZCount.Trim(',').Split(',')[i]), RealityQuantity = Convert.ToDecimal(ShiSum.Trim(',').Split(',')[i]), PlanPrice = Convert.ToDecimal(DanJia.Trim(',').Split(',')[i]), UnitPrice = Convert.ToDecimal(DanJia.Trim(',').Split(',')[i]), ProfitAndLoss = Convert.ToDecimal(PanYingCount.Trim(',').Split(',')[i]), ProfitAndLossPrice = Convert.ToDecimal(PanYingJinE.Trim(',').Split(',')[i]), Remark = BeiZhu.Trim('^').Split('^')[i], WarehouseName = CSysName.Split(',')[i], WarehouseSysNo = Convert.ToInt32(CSysId.Trim(',').Split(',')[i]) }; productModelList.Add(productModel); } if (!Hyt.BLL.InventorySheet.WhInventoryBo.Instance.AddWhInventoryRepor(model, productModelList)) { result.Status = false; result.Message = "错误,生成失败!"; return(Json(result)); } else { result.Status = true; result.Message = "成功!"; return(Json(result)); } }
public ActionResult AddWhInventoryRepor(int id, int pdStatus) { Result <object> result = new Result <object>(); #region 生成盘点报告单 //获取盘点单信息 var whlist = Hyt.BLL.InventorySheet.WhInventoryBo.Instance.GetWhInventoryDetail((int)id); if (whlist == null || whlist.dataList == null || whlist.dataList.Count == 0) { result.Status = false; result.Message = "没有适合盘点的商品信息,报告单生成失败!"; return(Json(result)); } if (pdStatus == 1) { //生成盘盈 if (!Hyt.BLL.InventorySheet.WhInventoryBo.Instance.GetIsWhInventoryRepor(whlist.Code, pdStatus)) { whlist.dataList = whlist.dataList.Where(p => p.InventoryQuantity > p.ZhangCunQuantity).ToList(); } else { result.Status = false; result.Message = "已生成过盘盈报告单,生成失败!"; return(Json(result)); } } else { //生成盘亏 if (!Hyt.BLL.InventorySheet.WhInventoryBo.Instance.GetIsWhInventoryRepor(whlist.Code, pdStatus)) { whlist.dataList = whlist.dataList.Where(p => p.InventoryQuantity < p.ZhangCunQuantity).ToList(); } else { result.Status = false; result.Message = "已生成过盘亏报告单,生成失败!"; return(Json(result)); } } if (whlist.dataList == null || whlist.dataList.Count == 0) { result.Status = false; result.Message = "没有适合盘点的商品信息,报告单生成失败!"; return(Json(result)); } #region 盘点报告单信息 WhInventoryRepor model = new WhInventoryRepor() { WhInventoryCode = whlist.Code, Remarks = "", ReportType = 0, PrintCount = 0, WarehouseCode = whlist.WhInventorySysNo, WarehouseName = "", Time = DateTime.Now, Make = CurrentUser.Base.UserName, Audit = "", Tally = "", CustodySysNo = "", HeadSysNo = "", AgentSysNo = "", AddUser = CurrentUser.Base.SysNo, AuditTime = null, YingKuiStatus = pdStatus, Status = pdStatus == 1 ? (int)Hyt.Model.InventorySheet.WhlnventoryEnum.WhInventoryReporStatus.盘盈入库 : (int)Hyt.Model.InventorySheet.WhlnventoryEnum.WhInventoryReporStatus.盘亏入库, AddTime = DateTime.Now }; #endregion #region 盘点报告单商品信息 List <WhIReporPrDetails> WhIReporPrDetailsList = new List <WhIReporPrDetails>(); foreach (var item in whlist.dataList) { WhIReporPrDetails productList = new WhIReporPrDetails() { WarehouseSysNo = item.WarehouseSysNo, ProduceCode = item.ErpCode, ProductName = item.ProductName, Specification = "", AuxiliaryAttribute = "", BatchNumber = "", Unit = "", ADQuantity = item.ZhangCunQuantity, RealityQuantity = item.InventoryQuantity, PlanPrice = item.CostPrice, //UnitPrice = 0, ProfitAndLoss = item.adjustmenQuantity, ProfitAndLossPrice = (item.CostPrice * item.adjustmenQuantity) - (item.CostPrice * item.ZhangCunQuantity), Remark = "", ProcurementTime = null, //ShelfLife= ValidityTime = null, WarehouseName = item.WarehouseNameDate }; WhIReporPrDetailsList.Add(productList); } #endregion if (!Hyt.BLL.InventorySheet.WhInventoryBo.Instance.AddWhInventoryRepor(model, WhIReporPrDetailsList)) { result.Status = false; result.Message = "错误,生成失败!"; return(Json(result)); } else { result.Status = true; result.Message = "成功!"; return(Json(result)); } #endregion }
/// <summary> /// 更新盘点报告单 /// </summary> /// <param name="sysNo"></param> /// <returns></returns> public abstract bool UploadWhInventoryRepor(WhInventoryRepor model);
/// <summary> /// 生成盘点报告单 /// </summary> /// <returns></returns> public abstract bool AddWhInventoryRepor(WhInventoryRepor reporModl, List <WhIReporPrDetails> productModel);
/// <summary> /// 更新盘点报告单 /// </summary> /// <param name="sysNo"></param> /// <returns></returns> public bool UploadWhInventoryRepor(WhInventoryRepor model) { return(IWhInventoryDao.Instance.UploadWhInventoryRepor(model)); }
/// <summary> /// 生成盘点报告单 /// </summary> /// <returns></returns> public bool AddWhInventoryRepor(WhInventoryRepor reporModl, List <WhIReporPrDetails> productModel) { return(IWhInventoryDao.Instance.AddWhInventoryRepor(reporModl, productModel)); }