public dynamic Get(RequestWrapper query)
{
if (query["PartTypeCode"] != "")
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>(select * from SYS_PartType where PartTypeCode like 'CCC%') as temp</from>
</settings>");
var pQuery = query.ToParamQuery();
pQuery.GetData().From = pQuery.GetData().From.Replace("CCC", query["PartTypeCode"].ToString());
var service = new SYS_PartTypeService();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
else
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>SYS_PartType </from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
<field name='PartTypeCode' cp='like'></field>
</where>
</settings>");
var pQuery = query.ToParamQuery();
var service = new SYS_PartTypeService();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
}
public void Edit(dynamic data)
{
var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
SYS_PartType
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>");
var service = new SYS_PartTypeService();
var result = service.Edit(null, listWrapper, data);
}
