public dynamic Get(RequestWrapper query)
{
#region 原SQL
/*
* SELECT a.ID,
* a.InventoryCode,
* a.InventoryName PartName,
* a.New_InventoryCode SetMateName,
* a.PartFigureCode FigureCode,
* b.InventoryName,
* b.Model,
* b.QuantityUnit,
* a.SetMateNum,
* a.InPlanceSize,
* a.BlankingSize,
* a.MateParamValue,
* MateType
* FROM PRS_Process_BOM a
* LEFT JOIN SYS_Part b
* ON b.InventoryCode = a.New_InventoryCode
* WHERE 1=1
*/
#endregion
query.LoadSettingXmlString(@"
<settings defaultOrderBy=' New_InventoryCode,PartFigureCode'>
<select>*</select>
<from>(SELECT a.ID,
a.ContractCode, --合同编号
c.ProjectName, --工程项目
d.ID AS ProductID,
d.ProductName, --产品名称
a.PartFigureCode, --零件图号
a.PartName, --零件名称
a.MaterialCode, --材质
b.InventoryCode,
b.InventoryName, --材料名称
b.Model, --型号规格
a.SetMateNum, --定料数量
a.InPlanceSize, --到位尺寸
a.BlankingSize, --下料尺寸
a.MateParamValue, --直径
MateType, --材料类型
a.New_InventoryCode
FROM dbo.PRS_Process_BOM_Blanking a
INNER JOIN dbo.PMS_BN_Project c
ON a.ContractCode = c.ContractCode
INNER JOIN dbo.PMS_BN_ProjectDetail d
ON c.ProjectID = d.MainID
AND a.ProductID = d.ID
LEFT JOIN SYS_Part b
ON b.InventoryCode = a.New_InventoryCode
WHERE a.MateType IN (2,3)
) as temp</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
<field name='ContractCode' cp='equal'></field>
<field name='ProductID' cp='equal'></field>
</where>
</settings>");
var service = new PRS_Process_BOMService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicList(pQuery);
return(result);
}
