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