public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().SetXml(@" <settings> <table> trade_trailer </table> <where> <c column='JOBNO' symbol='equal'></c> </where> </settings>"); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().SetXml(@" <settings> <table>trade_scheduler</table> <where> <c column='JOBNO' symbol='equal'></c> <c column='SNO' symbol='equal'></c> </where> </settings>")); var service = new trade_trailerService(); var result = service.Edit(data, formWrapper, tabsWrapper); }
public void Audit(string id, JObject data) { var pUpdate = ParamUpdate.Instance() .Update("trade_trailer") .Column("ApproveState", data["status"]) .Column("ApproveRemark", data["comment"]) .Column("ApprovePerson", FormsAuth.GetLoginer().UserName) .Column("ApproveDate", DateTime.Now) .Where("JOBNO", id); var service = new trade_trailerService(); var rowsAffected = service.Update(pUpdate); MvcHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}],请重试或联系管理员!", id); }
public dynamic GetPageData(string id) { var masterService = new trade_trailerService(); var pQuery = ParamQuery.Instance().Where("JOBNO", id); var result = new { //主表数据 form = masterService.GetModel(pQuery), scrollKeys = masterService.ScrollKeys("JOBNO", id), //明细数据 tab0 = new trade_schedulerService().GetDynamicList(pQuery) }; return result; }
public dynamic GetPageData(string id) { var masterService = new trade_trailerService(); var pQuery = ParamQuery.Instance().Where("JOBNO", id); var result = new { //主表数据 form = masterService.GetModel(pQuery), scrollKeys = masterService.ScrollKeys("JOBNO", id), //明细数据 tab0 = new trade_schedulerService().GetDynamicList(pQuery) }; return(result); }
public dynamic Get(RequestWrapper query) { query.SetXml(@" <settings > <select>*</select> <from>trade_trailer</from> <where> <c column='TR_JOBNOIN' symbol='like' ignore='empty'></c> <c column='TR_BLNO' symbol='like' ignore='empty'></c> <c column='TR_CONNO' symbol='like' ignore='empty'></c> <c column='TR_CARRI' symbol='equal' ignore='empty'></c> <c column='TR_CARNO' symbol='like' ignore='empty'></c> <c column='TR_ETSH' symbol='daterange' ignore='empty'></c> </where> <orderby>JOBNO</orderby> </settings>"); var service = new trade_trailerService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); }
public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().SetXml(@" <settings> <table> trade_trailer </table> <where> <c column='JOBNO' symbol='equal'></c> </where> </settings>"); var tabsWrapper = new List<RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().SetXml(@" <settings> <table>trade_scheduler</table> <where> <c column='JOBNO' symbol='equal'></c> <c column='SNO' symbol='equal'></c> </where> </settings>")); var service = new trade_trailerService(); var result = service.Edit(data, formWrapper, tabsWrapper); }
public dynamic Get(RequestWrapper query) { query.SetXml(@" <settings > <select>*</select> <from>trade_trailer</from> <where> <c column='TR_JOBNOIN' symbol='like' ignore='empty'></c> <c column='TR_BLNO' symbol='like' ignore='empty'></c> <c column='TR_CONNO' symbol='like' ignore='empty'></c> <c column='TR_CARRI' symbol='equal' ignore='empty'></c> <c column='TR_CARNO' symbol='like' ignore='empty'></c> <c column='TR_ETSH' symbol='daterange' ignore='empty'></c> </where> <orderby>JOBNO</orderby> </settings>"); var service = new trade_trailerService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return result; }