public dynamic GetDetail(string id)
{
var ReceiveService = new mms_riverestuaryService();
var query = RequestWrapper
.InstanceFromRequest()
.SetRequestData("CustomerId", id)
.LoadSettingXmlString(@"
<settings defaultOrderBy='UpdateDate desc'>
<select>
A.*
</select>
<from>
psi_customerContract A
</from>
<where>
<field name='CustomerId' cp='equal'></field>
</where>
</settings>");
var pQuery1 = query.ToParamQuery();
query.LoadSettingXmlString(@"
<settings defaultOrderBy='VisitId desc'>
<select>
A.*
</select>
<from>
psi_customerVisit A
</from>
<where>
<field name='CustomerId' cp='equal'></field>
</where>
</settings>");
var pQuery2 = query.ToParamQuery();
var result = ReceiveService.GetDynamicListWithPaging(pQuery2);
return(result);
}
// 查询主表：GET api/mms/send
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='BillNo'>
<select>
A.*
</select>
<from>
mms_riverestuary A
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillNo' cp='equal' ></field>
<field name='Address' cp='like' ></field>
<field name='Category' cp='like' ></field>
<field name='DrainageCode' cp='like' ></field>
<field name='AdministrativeArea' cp='like' ></field>
</where>
</settings>");
var service = new mms_riverestuaryService();
var pQuery = query.ToParamQuery().AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject());
return(service.GetDynamicListWithPaging(pQuery));
}