public ResResultModel SavePandianProduct(PandianProductFmModel model) { try { var bll = new PandianProduct(); int effect = -1; var oldInfo = bll.GetModel(model.PandianId, model.ProductId, model.CustomerId); if (oldInfo == null) { throw new ArgumentException(MC.Data_NotExist); } oldInfo.UserId = WebCommon.GetUserId(); oldInfo.Qty = model.Qty; oldInfo.FailQty = oldInfo.StayQty - model.Qty; oldInfo.UpdatedZones = model.Zones; oldInfo.UpdatedStockLocations = HttpUtility.UrlDecode(model.StockLocations); if (oldInfo.Qty > 0) { if (oldInfo.FailQty == 0) { oldInfo.Status = EnumData.EnumOrderStatus.已完成.ToString(); } else { oldInfo.Status = EnumData.EnumOrderStatus.待完成.ToString(); } } oldInfo.LastUpdatedDate = DateTime.Now; effect = bll.Update(oldInfo); effect += new Pandian().UpdateStatus(oldInfo.PandianId, EnumData.EnumOrderStatus.待完成.ToString()); if (effect < 1) { return(ResResult.Response(false, MC.M_Save_Error, "")); } return(ResResult.Response(true, "", "")); } catch (Exception ex) { return(ResResult.Response(false, ex.Message, "")); } }
public ResResultModel GetPandianProductList(ListModel model) { try { if (model.PageIndex < 1) { model.PageIndex = 1; } if (model.PageSize < 1) { model.PageSize = 10; } var bll = new PandianProduct(); int[] totals = null; StringBuilder sqlWhere = null; ParamsHelper parms = null; if (model.ParentId != null) { var pandianId = Guid.Parse(model.ParentId.ToString()); parms = new ParamsHelper(); sqlWhere = new StringBuilder(100); sqlWhere.AppendFormat("and pdp.PandianId = @PandianId "); var parm = new SqlParameter("@PandianId", SqlDbType.UniqueIdentifier); parm.Value = pandianId; parms.Add(parm); totals = bll.GetTotal(pandianId); } var list = bll.GetListByJoin(model.PageIndex, model.PageSize, sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray()); return(ResResult.Response(true, "", "{\"rows\":" + JsonConvert.SerializeObject(list) + ",\"footer\":{\"TotalPan\":" + totals[0] + ",\"TotalYpan\":" + totals[1] + ",\"TotalNotPan\":" + totals[2] + "}}")); } catch (Exception ex) { return(ResResult.Response(false, ex.Message, "")); } }