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