// 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)); }
// 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); }