public void Edit(dynamic data)
{
var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
PMS_BN_ProjectPart
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>");
var service = new PMS_BN_ProjectPartService();
var result = service.Edit(null, listWrapper, data);
}
public dynamic GetProjectPart(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>V_PMS_BN_ProjectPart</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='ContractCode' cp='equal'></field>
<field name='ProjectDetailID' cp='equal'></field>
</where>
</settings>");
var service = new PMS_BN_ProjectPartService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic GetProjectDetail(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='temp.ProjectID'>
<select>*</select>
<from>(
select t1.ProjectID,t1.ContractCode,t1.ProjectName,t2.ProductName,t2.FigureNumber,t2.Model,t2.Specifications,t2.ProductType from PMS_BN_Project t1
left join PMS_BN_ProjectDetail t2 on t1.ProjectID=t2.MainID) as temp</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='temp.ContractCode' cp='equal'></field>
<field name='temp,FigureNumber' cp='equal'></field>
</where>
</settings>");
var service = new PMS_BN_ProjectPartService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
