public JsonResult UpdateSql(VViewModel vModel) { if (SysUser == null) { FailResult("未登录状态"); } if (!sqlManager.IsCorrect(vModel.COMMAND_TEXT)) { return(FailResult(sqlManager.PromptInfo.Message)); } Tsql_View daview = new Tsql_View(); daview.SelectByPK(vModel.VIEW_ID); daview.ViewName = vModel.VIEW_NAME; daview.ClassifyId = vModel.CLASSIFY_ID; daview.CommandText = vModel.COMMAND_TEXT; daview.ViewTemplate = vModel.VIEW_TEMPLATE; daview.CacheStatus = vModel.CACHE_STATUS; daview.PageRow = vModel.PAGE_ROW; daview.Status = 1; daview.Remarks = vModel.REMARKS; if (!daview.Update()) { return(FailResult(daview.PromptInfo.Message)); } else { ViewFacade viewfacade = new ViewFacade(); viewfacade.AddOrUpdateCache(daview.ViewId, Convert.ToInt32(daview.CacheStatus), Isparameter(daview.CommandText)); } return(SuccessResult()); }
public bool UpadateCache(int id, int cache) { Tsql_View daView = new Tsql_View(); daView.SelectView(id); daView.CacheStatus = cache; if (daView.Update()) { return(true); } return(false); }
public bool DeleteView(int id) { Tsql_View daView = new Tsql_View(); daView.SelectView(id); daView.Status = 0; if (daView.Update()) { return(true); } return(false); }