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