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)));
}
