public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> mms_receive </table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <columns ignore='MaterialName,Model,Material'></columns> <table> mms_receiveDetail </table> <where> <field name='BillNo' cp='equal'></field> <field name='RowId' cp='equal'></field> </where> </settings>"); var service = new mms_receiveService(); var result = service.Edit(formWrapper, listWrapper, data); }
// 地址:GET api/mms/send/getdetail 功能:取得收料单明细信息 public dynamic GetDetail(string id) { var query = RequestWrapper .InstanceFromRequest() .SetRequestData("BillNo", id) .LoadSettingXmlString(@" <settings defaultOrderBy='MaterialCode'> <select> A.*, B.MaterialName,B.Model,B.Material </select> <from> mms_receiveDetail A left join mms_materialInfo B on B.MaterialCode = A.MaterialCode </from> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var pQuery = query.ToParamQuery(); var ReceiveService = new mms_receiveService(); var result = ReceiveService.GetDynamicListWithPaging(pQuery); return(result); }
// GET api/mms/send/geteditmaster 取得编辑页面中的主表数据及上一页下一页主键 public dynamic GetEditMaster(string id) { var projectCode = MmsHelper.GetCookies("CurrentProject"); var masterService = new mms_receiveService(); return new{ form = masterService.GetModel(ParamQuery.Instance().AndWhere("BillNo", id)), scrollKeys = masterService.ScrollKeys("BillNo", id, ParamQuery.Instance().AndWhere("ProjectCode", projectCode)) }; }
// GET api/mms/send/geteditmaster 取得编辑页面中的主表数据及上一页下一页主键 public dynamic GetEditMaster(string id) { var projectCode = MmsHelper.GetCookies("CurrentProject"); var masterService = new mms_receiveService(); return(new{ form = masterService.GetModel(ParamQuery.Instance().AndWhere("BillNo", id)), scrollKeys = masterService.ScrollKeys("BillNo", id, ParamQuery.Instance().AndWhere("ProjectCode", projectCode)) }); }
public dynamic Get(RequestWrapper query) { query.SetXml(@" <settings> <select>*</select> <from>mms_receive</from> <where> <c column='BillNo' symbol='equal' ignore='empty'></c> <c column='BillDate' symbol='equal' ignore='empty'></c> <c column='ProjectCode' symbol='equal' ignore='empty'></c> <c column='DoPerson' symbol='equal' ignore='empty'></c> <c column='SupplierCode' symbol='equal' ignore='empty'></c> <c column='ReceiveDate' symbol='equal' ignore='empty'></c> </where> <orderby>BillNo</orderby> </settings>"); var service = new mms_receiveService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return result; }
public dynamic Get(RequestWrapper query) { query.SetXml(@" <settings> <select>*</select> <from>mms_receive</from> <where> <c column='BillNo' symbol='equal' ignore='empty'></c> <c column='BillDate' symbol='equal' ignore='empty'></c> <c column='ProjectCode' symbol='equal' ignore='empty'></c> <c column='DoPerson' symbol='equal' ignore='empty'></c> <c column='SupplierCode' symbol='equal' ignore='empty'></c> <c column='ReceiveDate' symbol='equal' ignore='empty'></c> </where> <orderby>BillNo</orderby> </settings>"); var service = new mms_receiveService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); }
// 地址:GET api/mms/send/getdetail 功能:取得收料单明细信息 public dynamic GetDetail(string id) { var query = RequestWrapper .InstanceFromRequest() .SetRequestData("BillNo",id) .LoadSettingXmlString(@" <settings defaultOrderBy='MaterialCode'> <select> A.*, B.MaterialName,B.Model,B.Material </select> <from> mms_receiveDetail A left join mms_materialInfo B on B.MaterialCode = A.MaterialCode </from> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var pQuery = query.ToParamQuery(); var ReceiveService = new mms_receiveService(); var result = ReceiveService.GetDynamicListWithPaging(pQuery); return result; }
public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> mms_receive </table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <columns ignore='MaterialName,Model,Material'></columns> <table> mms_receiveDetail </table> <where> <field name='BillNo' cp='equal'></field> <field name='RowId' cp='equal'></field> </where> </settings>"); var service = new mms_receiveService(); var result = service.Edit(formWrapper, listWrapper, data); }