private void GetStockLocationList(HttpContext context, int pageIndex, int pageSize, string keyword) { var bll = new StockLocation(); IList <StockLocationInfo> list; int totalRecord = 0; StringBuilder sqlWhere = null; ParamsHelper parms = null; var zoneId = Guid.Empty; if (!string.IsNullOrWhiteSpace(context.Request.Form["ZoneId"])) { Guid.TryParse(context.Request.Form["ZoneId"], out zoneId); } if (!zoneId.Equals(Guid.Empty)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(300); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and (ZoneId = @ZoneId) "); var parm = new SqlParameter("@ZoneId", SqlDbType.UniqueIdentifier); parm.Value = parm.Value = zoneId; parms.Add(parm); } if (!string.IsNullOrWhiteSpace(keyword)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(200); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and (sl.Code like @Keyword or sl.Named like @Keyword) "); var parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 50); parm.Value = parm.Value = "%" + keyword + "%"; parms.Add(parm); } if (!zoneId.Equals(Guid.Empty)) { list = bll.GetList(sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray()); } else { list = bll.GetListByJoin(pageIndex, pageSize, out totalRecord, sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray()); } context.Response.Write(ResResult.ResJsonString(true, "", "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}")); }
public ResResultModel GetSkuModel(object orderId, string productCode) { Guid gId = Guid.Empty; if (orderId != null) { Guid.TryParse(orderId.ToString(), out gId); } if (gId.Equals(Guid.Empty)) { return(ResResult.Response(false, "参数值不正确", "")); } if (string.IsNullOrWhiteSpace(productCode)) { return(ResResult.Response(false, "参数值不正确", "")); } var orpBll = new OrderReceiptProduct(); var model = orpBll.GetModelByProductcode(gId, productCode); if (model == null) { return(ResResult.Response(false, "数据不存在或已被删除", "")); } var stlBll = new StockLocation(); var stlModel = stlBll.GetList(1, 1, "", null).FirstOrDefault(); if (stlModel == null) { return(ResResult.Response(false, "未找到任何库位", "")); } var skuModel = new PdaSkuModel(); skuModel.ExpectedAmount = model.ExpectedQty; skuModel.ReceiptAmount = model.ReceiptQty; skuModel.ProductId = model.ProductId; skuModel.PackageId = model.PackageId; skuModel.Unit = model.Unit; skuModel.StockLocationId = stlModel.Id; skuModel.StockLocationCode = stlModel.Code; skuModel.StockLocationName = stlModel.Named; return(ResResult.Response(true, "调用成功", JsonConvert.SerializeObject(skuModel))); }