//领料单
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);
}
