// 查询主表:GET api/mms/send public dynamic Get(RequestWrapper query) { query.SetXml(@" <settings > <select> * </select> <from> test_user </from> <where> <c column='UserCode' ignore='empty' symbol='like' ></c> <c column='UserName' ignore='empty' symbol='like' ></c> <c column='Description' ignore='empty' symbol='like' ></c> <c column='IsEnable' ignore='empty' symbol='equal' ></c> <c column='LoginCount' ignore='empty' symbol='equal' ></c> <c column='LastLoginDate' ignore='empty' symbol='daterange' ></c> </where> <orderby>UserCode</orderby> </settings>"); var pQuery = query.ToParamQuery(); var list = new mms_sendService().GetDynamicListWithPaging(pQuery); return(list); }
public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> mms_send </table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>mms_sendBatches</table> <where> <field name='BillNo' cp='equal'></field> <field name='RowId' cp='equal'></field> </where> </settings>")); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>mms_transfer</table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>")); var service = new mms_sendService(); var result = service.EditPage(data, formWrapper, tabsWrapper); }
// 查询主表:GET api/mms/send public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='UserCode'> <select> * </select> <from> test_user </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='UserCode' cp='like' ></field> <field name='UserName' cp='like' ></field> <field name='Description' cp='like' ></field> <field name='IsEnable' cp='equal' ></field> <field name='LoginCount' cp='equal' ></field> <field name='LastLoginDate' cp='daterange' ></field> </where> </settings>"); var pQuery = query.ToParamQuery(); var list = new mms_sendService().GetDynamicListWithPaging(pQuery); return(list); }
// 查询主表:GET api/mms/send public dynamic Get(RequestWrapper query) { query.SetXml(@" <settings > <select> * </select> <from> test_user </from> <where> <c column='UserCode' ignore='empty' symbol='like' ></c> <c column='UserName' ignore='empty' symbol='like' ></c> <c column='Description' ignore='empty' symbol='like' ></c> <c column='IsEnable' ignore='empty' symbol='equal' ></c> <c column='LoginCount' ignore='empty' symbol='equal' ></c> <c column='LastLoginDate' ignore='empty' symbol='daterange' ></c> </where> <orderby>UserCode</orderby> </settings>"); var pQuery = query.ToParamQuery(); var list = new mms_sendService().GetDynamicListWithPaging(pQuery); return list; }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().SetXml(@" <settings> <table> mms_send </table> <where> <c column='BillNo' symbol='equal'></c> </where> </settings>"); var service = new mms_sendService(); var result = service.Edit(null, listWrapper, data); }
public void Audit(string id, JObject data) { var pUpdate = ParamUpdate.Instance() .Update("mms_send") .Column("ApproveState", data["status"]) .Column("ApproveRemark", data["comment"]) .Column("ApprovePerson", FormsAuth.GetUserData().UserName) .Column("ApproveDate", DateTime.Now) .AndWhere("BillNo", id); var service = new mms_sendService(); var rowsAffected = service.Update(pUpdate); MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}],请重试或联系管理员!", id); }
public dynamic GetPageData(string id) { var masterService = new mms_sendService(); var pQuery = ParamQuery.Instance().AndWhere("BillNo", id); var result = new { //主表数据 form = masterService.GetModel(pQuery), scrollKeys = masterService.ScrollKeys("BillNo", id), //明细数据 tab0 = new mms_sendBatchesService().GetDynamicList(pQuery), tab1 = new mms_transferService().GetModel(pQuery), }; return result; }
public dynamic GetPageData(string id) { var masterService = new mms_sendService(); var pQuery = ParamQuery.Instance().AndWhere("BillNo", id); var result = new { //主表数据 form = masterService.GetModel(pQuery), scrollKeys = masterService.ScrollKeys("BillNo", id), //明细数据 tab0 = new mms_sendBatchesService().GetDynamicList(pQuery), tab1 = new mms_transferService().GetModel(pQuery), }; return(result); }
public dynamic Get(RequestWrapper query) { query.SetXml(@" <settings > <select>*</select> <from>mms_send</from> <where> <c column='BillNo' symbol='equal' ignore='empty'></c> <c column='BillDate' symbol='equal' ignore='empty'></c> <c column='DoPerson' symbol='equal' ignore='empty'></c> <c column='ProjectCode' symbol='equal' ignore='empty'></c> <c column='WarehouseCode' symbol='equal' ignore='empty'></c> </where> <orderby>BillNo</orderby> </settings>"); var service = new mms_sendService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return result; }
public dynamic Get(RequestWrapper query) { query.SetXml(@" <settings > <select>*</select> <from>mms_send</from> <where> <c column='BillNo' symbol='equal' ignore='empty'></c> <c column='BillDate' symbol='equal' ignore='empty'></c> <c column='DoPerson' symbol='equal' ignore='empty'></c> <c column='ProjectCode' symbol='equal' ignore='empty'></c> <c column='WarehouseCode' symbol='equal' ignore='empty'></c> </where> <orderby>BillNo</orderby> </settings>"); var service = new mms_sendService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); }
// 查询主表:GET api/mms/send public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='UserCode'> <select> * </select> <from> test_user </from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='UserCode' cp='like' ></field> <field name='UserName' cp='like' ></field> <field name='Description' cp='like' ></field> <field name='IsEnable' cp='equal' ></field> <field name='LoginCount' cp='equal' ></field> <field name='LastLoginDate' cp='daterange' ></field> </where> </settings>"); var pQuery = query.ToParamQuery(); var list = new mms_sendService().GetDynamicListWithPaging(pQuery); return list; }
public void Audit(string id, JObject data) { var pUpdate = ParamUpdate.Instance() .Update("mms_send") .Column("ApproveState", data["status"]) .Column("ApproveRemark", data["comment"]) .Column("ApprovePerson", FormsAuth.GetUserData().UserName) .Column("ApproveDate", DateTime.Now) .AndWhere("BillNo", id); var service = new mms_sendService(); var rowsAffected = service.Update(pUpdate); MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}],请重试或联系管理员!", id); }
public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> mms_send </table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>"); var tabsWrapper = new List<RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>mms_sendBatches</table> <where> <field name='BillNo' cp='equal'></field> <field name='RowId' cp='equal'></field> </where> </settings>")); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>mms_transfer</table> <where> <field name='BillNo' cp='equal'></field> </where> </settings>")); var service = new mms_sendService(); var result = service.EditPage(data, formWrapper, tabsWrapper); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().SetXml(@" <settings> <table> mms_send </table> <where> <c column='BillNo' symbol='equal'></c> </where> </settings>"); var service = new mms_sendService(); var result = service.Edit(null, listWrapper, data); }