// GET: ExecuteResult public ActionResult Index(int ViewId) { string parameterSQL = string.Empty; VExecuteResultModel vModel = new VExecuteResultModel(); Tsql_View daView = new Tsql_View(); daView.SelectView(ViewId); _plsql = Isparameter(daView.CommandText); _yplsql = daView.CommandText; Tsql_ViewCollection daViewColl = new Tsql_ViewCollection(); daViewColl.ListByALLPlSql(_plsql); ExecuteSQL SQLFacade = new ExecuteSQL(); ViewBag.TableHtml = SQLFacade.CreateTable(daViewColl.DataTable); ViewBag.ViewName = daView.ViewName; ViewBag.Remarks = daView.Remarks; _viewid = ViewBag.ViewId = ViewId; _cachetype = ViewBag.Cache = daView.CacheStatus; _plsqlname = daView.ViewName; ViewBag.PageSize = daView.PageRow == 0 ? 50 : daView.PageRow; ViewBag.HeadSearch = CreateCondition(daView.CommandText); return(View(vModel)); }
public bool AddOrUpdateCache(int viewId, int cacheStatus, string sql) { Tsql_View daCache = new Tsql_View(); if (cacheStatus == 1) { if (daCache.IsExistTable(viewId)) { daCache.DropCacheTable(viewId); } if (!daCache.CreateCacheTable(viewId, sql)) { return(false); } return(true); } else { if (daCache.IsExistTable(viewId)) { return(daCache.DropCacheTable(viewId)); } return(true); } }
public JsonResult GetSQLInfo(int SQLId) { if (SQLId < 1) { return(FailResult("SQLId不合法")); } VViewModel vModel = new VViewModel(); //获取分类列表 Tsql_ClassifyCollection daclassifyColl = new Tsql_ClassifyCollection(); daclassifyColl.SelectClassify(); Tsql_View daview = new Tsql_View(); daview.SelectSQLBySqlId(SQLId); vModel = MapProvider.Map <VViewModel>(daview.DataRow); List <Classify> list = new List <Classify>(); list = MapProvider.Map <Classify>(daclassifyColl.DataTable); vModel.classifylist = new List <Classify>(); foreach (var item in list) { vModel.classifylist.Add(item); } return(SuccessResult(vModel)); }
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 JsonResult AddSql(ViewModel model) { if (SysUser != null) { model.INPUTER = SysUser.UserCode; } else { return(FailResult("未登录状态")); } var verifymodel = ModelVerify.First(model); if (verifymodel != null) { return(FailResult(verifymodel.ErrorMessage)); } if (model.COMMAND_TEXT.Length > 2000) { return(FailResult("该SQL超出长度")); } if (!string.IsNullOrEmpty(model.VIEW_NAME)) { if (sqlManager.IsExists(model.VIEW_NAME)) { return(FailResult("标题已存在,不可用")); } } if (!sqlManager.IsCorrect(model.COMMAND_TEXT)) { return(FailResult(sqlManager.PromptInfo.Message)); } Tsql_View daView = new Tsql_View() { ViewName = model.VIEW_NAME, ClassifyId = model.CLASSIFY_ID, CommandText = model.COMMAND_TEXT, ViewTemplate = model.VIEW_TEMPLATE, CacheStatus = model.CACHE_STATUS, PageRow = model.PAGE_ROW, Status = 1, Inputer = model.INPUTER, Remarks = model.REMARKS, }; if (!daView.Insert()) { return(FailResult(daView.PromptInfo.Message)); } else { //添加删除缓存数据 ViewFacade viewfacade = new ViewFacade(); viewfacade.AddOrUpdateCache(daView.ViewId, Convert.ToInt32(daView.CacheStatus), Isparameter(daView.CommandText)); } return(SuccessResult()); }
// GET: Binding public ActionResult Index(int ViewId) { Tsql_View daview = new Tsql_View(); daview.SelectView(ViewId); ViewBag.ViewId = ViewId; ViewBag.ViewName = daview.ViewName; return(View()); }
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); }
public bool IsExists(string title) { Tsql_View daSql = new Tsql_View(); if (string.IsNullOrEmpty(title)) { return(false); } if (daSql.IsExistTitle(title)) { return(true); } return(false); }
public JsonResult TableHTML(FormCollection form) { Dictionary <string, string> searchStr = new Dictionary <string, string>(); SQLManager sqlFacade = new SQLManager(); string strsch = " 1=1"; searchStr = sqlFacade.GetparameterWhere(_yplsql); foreach (var item in searchStr) { var val = form["" + item.Value + ""]; if (val.ToString() != "") { strsch += " AND " + item.Value + " = '" + form["" + item.Value + ""].ToString() + "'"; Session["strsch"] = string.Empty; } } Session["strsch"] = strsch; order = form["order"].Safe().ToString(); orderby = form["orderby"].Safe().ToString(); int iscache = form["iscache"].Safe().ToInt32(); Tsql_ViewCollection daViewColl = new Tsql_ViewCollection(); daViewColl.ChangePage = this.ChangePage(); Tsql_View daView = new Tsql_View(); if (_cachetype == 0) { daViewColl.ListByALLPlSqlByOrder(_plsql, order, orderby, strsch); } else { if (daView.IsExistTable(_viewid) && iscache == 0) { string cachesql = "SELECT * FROM PLSQLCACHE_" + _viewid; daViewColl.ListByALLPlSqlByOrder(cachesql, order, orderby, strsch); } else { daViewColl.ListByALLPlSqlByOrder(_plsql, order, orderby, strsch); } } List <Object> vList = new List <object>(); ExecuteSQL SQLFacade = new ExecuteSQL(); vList = SQLFacade.TableTd(daViewColl.DataTable); return(SuccessResultList(vList, daViewColl.ChangePage)); }