public dynamic GetDetail(string id) { var ReceiveService = new mms_sewagetreatmentService(); 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_sewagetreatment A </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='Name' cp='like' ></field> <field name='IdentificationCode' cp='like' ></field> <field name='OwnershipUnit' cp='like' ></field> <field name='DischargeWater' cp='like' ></field> </where> </settings>"); var service = new mms_sewagetreatmentService(); var pQuery = query.ToParamQuery().AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject()); return(service.GetDynamicListWithPaging(pQuery)); }