public dynamic GetDetail(string id) { var query = RequestWrapper .InstanceFromRequest() .SetRequestData("BillNo", id) .LoadSettingXmlString(@" <settings defaultOrderBy='RowId'> <select> A.*, B.Name,B.Catagory,B.Brand,B.Model,B.Unit </select> <from> psi_receiveGoods A left join psi_goods B on B.Id = A.GoodNo </from> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var pQuery = query.ToParamQuery(); var ReceiveService = new psi_receiveService(); var result = ReceiveService.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*,B.Name as WarehouseName,C.Name as SupplierName </select> <from> psi_receive A left join psi_warehouse B on B.Id = A.Warehouse left join psi_supplier C on C.Id = A.Supplier </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='Warehouse' cp='equal' ></field> <field name='ReceivePerson' cp='like' ></field> <field name='Contract' cp='like' ></field> <field name='ReceiveDate' cp='daterange' ></field> <field name='C.Name' cp='like' variable='SupplierName'></field> </where> </settings>"); var ReceiveService = new psi_receiveService(); var pQuery = query.ToParamQuery(); var result = ReceiveService.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic GetDetail(string id) { var query = RequestWrapper .InstanceFromRequest() .SetRequestData("BillNo", id) .LoadSettingXmlString(@" <settings defaultOrderBy='RowId'> <select> A.*, B.Name,B.Catagory,B.Brand,B.Model,B.Unit </select> <from> psi_receiveGoods A left join psi_goods B on B.Id = A.GoodNo </from> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var pQuery = query.ToParamQuery(); var ReceiveService = new psi_receiveService(); var result = ReceiveService.GetDynamicListWithPaging(pQuery); return result; }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*,B.Name as WarehouseName,C.Name as SupplierName </select> <from> psi_receive A left join psi_warehouse B on B.Id = A.Warehouse left join psi_supplier C on C.Id = A.Supplier </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='Warehouse' cp='equal' ></field> <field name='ReceivePerson' cp='like' ></field> <field name='Contract' cp='like' ></field> <field name='ReceiveDate' cp='daterange' ></field> <field name='C.Name' cp='like' variable='SupplierName'></field> </where> </settings>"); var ReceiveService = new psi_receiveService(); var pQuery = query.ToParamQuery(); var result = ReceiveService.GetDynamicListWithPaging(pQuery); return result; }