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