public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*,B.Name as WarehouseName,C.Name as CustomerName </select> <from> psi_picking A left join psi_warehouse B on B.Id = A.Warehouse left join psi_customer C on C.Id = A.CustomNo left join psi_customerContract D on D.ContractNo = A.Contract </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='Warehouse' cp='equal' ></field> <field name='PickingPerson' cp='like' ></field> <field name='PickingDate' cp='daterange' ></field> <field name='C.Name' cp='like' variable='CustomerName'></field> <field name='Contract' cp='like' ></field> </where> </settings>"); var PickingService = new psi_pickingService(); var pQuery = query.ToParamQuery(); var result = PickingService.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_pickingGoods 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 PickingService = new psi_pickingService(); var result = PickingService.GetDynamicListWithPaging(pQuery); return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='BillNo'> <select> A.*,B.Name as WarehouseName,C.Name as CustomerName </select> <from> psi_picking A left join psi_warehouse B on B.Id = A.Warehouse left join psi_customer C on C.Id = A.CustomNo left join psi_customerContract D on D.ContractNo = A.Contract </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='BillNo' cp='equal' ></field> <field name='Warehouse' cp='equal' ></field> <field name='PickingPerson' cp='like' ></field> <field name='PickingDate' cp='daterange' ></field> <field name='C.Name' cp='like' variable='CustomerName'></field> <field name='Contract' cp='like' ></field> </where> </settings>"); var PickingService = new psi_pickingService(); var pQuery = query.ToParamQuery(); var result = PickingService.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_pickingGoods 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 PickingService = new psi_pickingService(); var result = PickingService.GetDynamicListWithPaging(pQuery); return result; }