public void Audit(string id, JObject data) { var pUpdate = ParamUpdate.Instance() .Update("PRS_ProcessRouteModelMain") .Column("ApproveState", data["status"]) .Column("ApproveRemark", data["comment"]) .Column("ApprovePerson", FormsAuth.GetUserData().UserName) .Column("ApproveDate", DateTime.Now) .AndWhere("ID", id); var service = new PRS_ProcessRouteModelMainService(); var rowsAffected = service.Update(pUpdate); MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}],请重试或联系管理员!", id); }
public dynamic GetPageData(string id) { var masterService = new PRS_ProcessRouteModelMainService(); var pQuery = ParamQuery.Instance().AndWhere("ID", id); //var pQuery = ParamQuery.Instance(); if (id == "") { var result = new { tab0 = "", tab1 = "" }; return(result); } else { var mainData = masterService.GetModel(pQuery); if (mainData != null) { var pQuery2 = ParamQuery.Instance().AndWhere("MainID", mainData.ID); var result = new { //主表数据 form = mainData, scrollKeys = masterService.ScrollKeys("ID", id), //明细数据 tab0 = new PRS_ProcessRouteModelDetailService().GetDynamicList(pQuery2), }; return(result); } else { var result = new { //主表数据 form = mainData, scrollKeys = masterService.ScrollKeys("ID", id), //明细数据 tab0 = "", tab1 = "" }; return(result); } } }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='temp.ID'> <select>*</select> <from>(select t1.*,t2.ProjectName from PRS_ProcessRouteModelMain t1 left join PMS_BN_Project t2 on t1.ContractCode=t2.ContractCode) as temp</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='temp.ProcessRouteCode' cp='equal'></field> </where> </settings>"); var service = new PRS_ProcessRouteModelMainService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery.AndWhere("IsEnable", 1)); return(result); }
public void Edit(dynamic data) { var id = data.form["ID"].ToString(); var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", id); var re = new PRS_ProcessRouteModelMainService().GetModelList(pQuery); if (re.Count > 0 && re[0].BillState == 1) { MmsHelper.ThrowHttpExceptionWhen(true, "已审核数据不能修改!"); return; } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> PRS_ProcessRouteModelMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>PRS_ProcessRouteModelDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); var service = new PRS_ProcessRouteModelMainService(); if (data.form["ProcessRouteCode"] == "系统生成") { string documentNo = MmsHelper.GetLSNumber("PRS_ProcessRouteModelMain", "ProcessRouteCode", "GYMX", "", ""); data.form["ProcessRouteCode"] = documentNo; } var result = service.EditPage(data, formWrapper, tabsWrapper); }