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