public static SimpleJson GetWHInfo(ISession session, string area, string section) { if (string.IsNullOrEmpty(area) || area.Trim().Length <= 0) { return(new SimpleJson().HandleError("您没有选择库位")); } string a = area.Trim().ToUpper(); string sec = string.IsNullOrEmpty(section) ? "" : section.Trim().ToUpper(); SimpleJson json = new SimpleJson().Add("area", area).Add("section", sec); if (sec.Length <= 0) { //加载库位信息 WHArea whArea = WHArea.Retrieve(session, a); if (whArea == null) { return(json.HandleError("库位" + a + "不存在")); } json.Add("capacity", Cast.Int(whArea.AreaCapacity)); int stoQty = Cast.Int(session.CreateObjectQuery(@"select sum(StockQty) from StockDetail where AreaCode=?area group by AreaCode") .Attach(typeof(StockDetail)) .SetValue("?area", a, "AreaCode") .Scalar()); json.Add("stored", stoQty); } else { //加载货架信息 WHSection whSection = WHSection.Retrieve(session, a, sec); if (whSection == null) { return(json.HandleError("库位" + a + "中不存在货架号" + sec)); } json.Add("capacity", Cast.Int(whSection.SectionCapacity)); int stoQty = Cast.Int(session.CreateObjectQuery(@" select sum(StockQty) from StockDetail where AreaCode=?area and SectionCode=?section group by AreaCode") .Attach(typeof(StockDetail)) .SetValue("?area", a, "AreaCode") .SetValue("?section", sec, "SectionCode") .Scalar()); json.Add("stored", stoQty); } return(json); }
public static SimpleJson GetJSON(ISession session, string areaCode, string sectionCode) { WHSection section = WHSection.Retrieve(session, areaCode, sectionCode); if (section == null) { return(new SimpleJson().HandleError(string.Format("存储区域{0}中的货架{1}不存在", areaCode, sectionCode))); } SimpleJson json = new SimpleJson() .Add("parent", section.AreaCode) .Add("type", "s") .Add("code", section.SectionCode) .Add("status", (int)section.Status) .Add("desc", section.Text) .Add("cap", section.SectionCapacity) .Add("allowdelete", "1") .Add("allowchild", "0") .Add("parentType", "a") .Add("text", section.ToString()); return(json); }