public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>t1.*,t2.TypeName</select>
<from>SYS_Part as t1 left join SYS_PartType as t2 on t1.PartTypeID = t2.PartTypeCode</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
<field name='PartCode' cp='equal'></field>
</where>
</settings>");
var service = new SYS_PartService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='PartType'>
<select>ID,text,case when InventoryCode=ReferenceCode then '' else InventoryCode end InventoryCode,InventoryName,Model,Spec,ReferenceCode,ReferenceName,ReferenceModel,PartType,WarehouseCode,WarehouseName,QuantityUnit</select>
<from>(SELECT *, CASE WHEN PartType='PRS_BoardCreateMate' THEN '板材报料'
WHEN PartType='MES_WorkshopPurchaseDetail' THEN '车间请购'
WHEN PartType='PRS_Process_BOM' THEN '工艺定料' END AS text
FROM [V_CreateSysPart]) as tmp</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
<field name='InventoryName' cp='like'></field>
<field name='Model' cp='like'></field>
<field name='Spec' cp='like'></field>
</where>
</settings>");
var service = new SYS_PartService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
