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