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