public bool IsSqlCorrect(string sql)
{
try
{
if (sql.Substring(0, sql.Length - 1) == ";")
{
sql = sql.Substring(0, sql.Length - 1);
}
Tsql_ViewCollection daSqlColl = new Tsql_ViewCollection();
if (daSqlColl.ExecuteQuery(sql))
{
Alert("没有问题");
return(true);
}
else
{
Alert("SQL语句有错误:" + daSqlColl.PromptInfo.Message);
return(false);
}
}
catch (Exception ex)
{
Alert("SQL语句有错误," + ex.Message);
return(false);
}
}
// 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 ActionResult ExcelExport()
{
Tsql_ViewCollection daViewColl = new Tsql_ViewCollection();
//daViewColl.ListByALLPlSql(_plsql);
daViewColl.ListByALLPlSqlByOrder(_plsql, order, orderby, Session["strsch"].ToString());
var excel = new Javirs.Common.IO.Excel(daViewColl.DataTable);
return(excel.Export(string.Concat(_plsqlname, DateTime.Now.ToString("yyyyMMdd"), ".xls")));
}
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));
}
public JsonResult Index(FormCollection form)
{
if (SysUser == null)
{
return(FailResult("未登录状态"));
}
string ViewName = form["ViewName"];
int pageSize = form["PageSize"].Safe().ToInt32();
int pageIndex = form["PageIndex"].Safe().ToInt32();
Tsql_ViewCollection daViewColl = new Tsql_ViewCollection();
daViewColl.ChangePage = this.ChangePage(pageIndex, pageSize);
daViewColl.GetAllViewByUserInfo(SysUser.UserId, SysUser.UserCode, ViewName);
List <VSqlList> List = new List <VSqlList>();
List = MapProvider.Map <VSqlList>(daViewColl.DataTable);
return(SuccessResultList(List, daViewColl.ChangePage));
}
public JsonResult Index(FormCollection form)
{
if (SysUser == null)
{
return(FailResult("未登录状态"));
}
string ViewName = form["ViewName"].Safe().ToString();
int ClassifyId = form["ClassifyId"].Safe().ToInt32();
string UserName = form["UserName"].Safe().ToString();
int pageSize = form["PageSize"].Safe().ToInt32();
int pageIndex = form["PageIndex"].Safe().ToInt32();
Tsql_ViewCollection daViewColl = new Tsql_ViewCollection();
daViewColl.ChangePage = this.ChangePage(pageIndex, pageSize);
daViewColl.GetAllViewByClassifyAndUserName(ViewName, ClassifyId, UserName);
List <VManagerModel> vModel = MapProvider.Map <VManagerModel>(daViewColl.DataTable);
return(SuccessResultList(vModel, daViewColl.ChangePage));
}
