//todo 改成支持多个Tab
// 地址：GET api/mms/@(controller)/getnewrowid 预取得新的明细表的行号
public string GetNewRowId(string type, string key, int qty = 1)
{
switch (type)
{
case "grid0":
var service0 = new WMS_BN_BillDetailService();
return(service0.GetNewKey("ID", "maxplus", qty, ParamQuery.Instance().AndWhere("ID", key, Cp.Equal)));
default:
return("");
}
}
//领料单
public dynamic GetLLD(RequestWrapper query)
{
if (query["PBillCode"].ToString() == "")
{
return(null);
}
query.LoadSettingXmlString(@"
<settings defaultOrderBy='temp.ID'>
<select>*</select>
<from>(
select * from WMS_BN_BillDetail where billCode like 'LLCK%') as temp</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='temp.PBillCode' cp='equal'></field>
</where>
</settings>");
var service = new WMS_BN_BillDetailService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic Get(RequestWrapper query)
{
if (query["InventoryCode"] == null)
{
return(null);
}
query.LoadSettingXmlString(@"
<settings defaultOrderBy='temp.ID'>
<select>*</select>
<from>(select t1.* from WMS_BN_BillDetail as t1
inner join WMS_BN_BillMain as t2 on t1.BillCode=t2.BillCode
where t2.BillType=2) as temp</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='temp.InventoryCode' cp='equal'></field>
</where>
</settings>");
var service = new WMS_BN_BillDetailService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
//入库单
public dynamic GetRKD(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='temp.ID'>
<select>*</select>
<from>(
select * from WMS_BN_BillDetail where billCode like 'CPRK%' and InventoryCode=(select InventoryCode from SYS_Part where PartCode='xxx')) as temp</from>
</settings>");
var service = new WMS_BN_BillDetailService();
var pQuery = query.ToParamQuery();
var c = query["PartCode"].ToString().Length;
if (c != 0)
{
pQuery.GetData().From = pQuery.GetData().From.Replace("xxx", query["PartCode"].ToString());
}
else
{
return(null);
}
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
