public string GetJson_TableRefresh() { string text = base.Request.QueryString["dbconn"]; string text2 = base.Request.QueryString["dbtable"]; string text3 = base.Request.QueryString["valuefield"]; string text4 = base.Request.QueryString["titlefield"]; string text5 = base.Request.QueryString["parentfield"]; string text10 = base.Request.QueryString["where"]; string text6 = base.Request.QueryString["refreshid"]; RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection(); RoadFlow.Data.Model.DBConnection dbconn = dBConnection.Get(MyExtensions.ToGuid(text)); string text7 = "select " + text3 + "," + text4 + " from " + text2 + " where " + text5 + "='" + text6 + "'"; DataTable dataTable = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(text7)); StringBuilder stringBuilder = new StringBuilder(1000); foreach (DataRow row in dataTable.Rows) { string text8 = row[0].ToString(); string arg = (dataTable.Columns.Count > 1) ? row[1].ToString() : text8; string text9 = "select * from " + text2 + " where " + text5 + "='" + text8 + "'"; bool flag = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(text9)).Rows.Count > 0; stringBuilder.Append("{"); stringBuilder.AppendFormat("\"id\":\"{0}\",", text8); stringBuilder.AppendFormat("\"parentID\":\"{0}\",", Guid.Empty.ToString()); stringBuilder.AppendFormat("\"title\":\"{0}\",", arg); stringBuilder.AppendFormat("\"type\":\"{0}\",", flag ? "1" : "2"); stringBuilder.AppendFormat("\"ico\":\"{0}\",", ""); stringBuilder.AppendFormat("\"hasChilds\":\"{0}\",", flag ? "1" : "0"); stringBuilder.Append("\"childs\":[]},"); } return("[" + stringBuilder.ToString().TrimEnd(',') + "]"); }
public string GetNames_Table() { string text = base.Request.QueryString["dbconn"]; string text2 = base.Request.QueryString["dbtable"]; string text3 = base.Request.QueryString["valuefield"]; string text4 = base.Request.QueryString["titlefield"]; string text7 = base.Request.QueryString["parentfield"]; string text8 = base.Request.QueryString["where"]; string obj = base.Request.QueryString["values"] ?? ""; RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection(); RoadFlow.Data.Model.DBConnection dbconn = dBConnection.Get(MyExtensions.ToGuid(text)); StringBuilder stringBuilder = new StringBuilder(); string[] array = obj.Split(','); foreach (string text5 in array) { if (!MyExtensions.IsNullOrEmpty(text5)) { string text6 = "select " + text4 + " from " + text2 + " where " + text3 + "='" + text5 + "'"; DataTable dataTable = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(text6)); if (dataTable.Rows.Count > 0) { stringBuilder.Append(dataTable.Rows[0][0].ToString()); stringBuilder.Append(","); } } } return(stringBuilder.ToString().TrimEnd(',')); }
public string GetJson_SQL() { if (!Tools.CheckLogin(redirect: false)) { return("{}"); } string text = base.Request.QueryString["dbconn"]; string text2 = base.Request.QueryString["sql"]; RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection(); RoadFlow.Data.Model.DBConnection dbconn = dBConnection.Get(MyExtensions.ToGuid(text)); DataTable dataTable = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(MyExtensions.UrlDecode(text2).FilterWildcard())); StringBuilder stringBuilder = new StringBuilder(1000); foreach (DataRow row in dataTable.Rows) { string text3 = row[0].ToString(); string arg = (dataTable.Columns.Count > 1) ? row[1].ToString() : text3; stringBuilder.Append("{"); stringBuilder.AppendFormat("\"id\":\"{0}\",", text3); stringBuilder.AppendFormat("\"parentID\":\"{0}\",", Guid.Empty.ToString()); stringBuilder.AppendFormat("\"title\":\"{0}\",", arg); stringBuilder.AppendFormat("\"type\":\"{0}\",", "2"); stringBuilder.AppendFormat("\"ico\":\"{0}\",", ""); stringBuilder.AppendFormat("\"hasChilds\":\"{0}\",", "0"); stringBuilder.Append("\"childs\":[]},"); } return("[" + stringBuilder.ToString().TrimEnd(',') + "]"); }
public string GetNames_SQL() { string text = base.Request.QueryString["dbconn"]; string text2 = base.Request.QueryString["sql"]; RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection(); RoadFlow.Data.Model.DBConnection dbconn = dBConnection.Get(MyExtensions.ToGuid(text)); DataTable dataTable = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(MyExtensions.UrlDecode(text2).FilterWildcard())); string obj = base.Request.QueryString["values"] ?? ""; StringBuilder stringBuilder = new StringBuilder(); string[] array = obj.Split(','); foreach (string a in array) { string empty = string.Empty; string value = string.Empty; foreach (DataRow row in dataTable.Rows) { empty = row[0].ToString(); if (a == empty) { value = ((dataTable.Columns.Count > 1) ? row[1].ToString() : empty); break; } } stringBuilder.Append(value); stringBuilder.Append(','); } return(stringBuilder.ToString().TrimEnd(',')); }
public Dictionary <string, string> GetOptionsFields(Guid id, string sql) { Dictionary <string, string> list = new Dictionary <string, string>(); RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection(); RoadFlow.Data.Model.DBConnection dbconn = bdbconn.Get(id); using (System.Data.IDbConnection conn = bdbconn.GetConnection(dbconn)) { if (conn == null) { return(list); } try { conn.Open(); } catch (Exception ex) { System.Web.HttpContext.Current.Response.Write("连接数据库出错:" + ex.Message); RoadFlow.Platform.Log.Add(ex); } List <System.Data.IDataParameter> parList = new List <System.Data.IDataParameter>(); System.Data.IDbDataAdapter dataAdapter = bdbconn.GetDataAdapter(conn, dbconn.Type, sql, parList.ToArray()); System.Data.DataSet ds = new System.Data.DataSet(); dataAdapter.Fill(ds); foreach (System.Data.DataRow row in ds.Tables[0].Rows) { list.Add(row[0].ToString(), row[1].ToString()); } return(list); } }
// // GET: /DBConnection/ public ActionResult Index() { string query1 = string.Format("&appid={0}&tabid={1}", Request.QueryString["appid"], Request.QueryString["tabid"]); RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection(); if (!Request.Form["DeleteBut"].IsNullOrEmpty()) { string deleteID = Request.Form["checkbox_app"]; System.Text.StringBuilder delxml = new System.Text.StringBuilder(); foreach (string id in deleteID.Split(',')) { Guid gid; if (id.IsGuid(out gid)) { delxml.Append(bdbconn.Get(gid).Serialize()); bdbconn.Delete(gid); } } bdbconn.ClearCache(); RoadFlow.Platform.Log.Add("删除了数据连接", delxml.ToString(), RoadFlow.Platform.Log.Types.流程相关); } var connList = bdbconn.GetAll(); ViewBag.Query1 = query1; return(View(connList)); }
/// <summary> /// 测试连接的sql条件 /// </summary> /// <returns></returns> public string TestLineSqlWhere() { string connid = Request["connid"]; string table = Request["table"]; string tablepk = Request["tablepk"]; string where = Request["where"]; RoadFlow.Platform.DBConnection dbconn = new RoadFlow.Platform.DBConnection(); if (!connid.IsGuid()) { return("流程未设置数据连接!"); } var conn = dbconn.Get(connid.ToGuid()); if (conn == null) { return("未找到连接!"); } string sql = "SELECT * FROM " + table + " WHERE 1=1 AND " + where; if (dbconn.TestSql(conn, sql)) { return("SQL条件正确!"); } else { return("SQL条件错误!"); } }
protected void Page_Load(object sender, EventArgs e) { string query1 = string.Format("&appid={0}&tabid={1}", Request.QueryString["appid"], Request.QueryString["tabid"]); RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection(); if (IsPostBack) { if (!Request.Form["DeleteBut"].IsNullOrEmpty()) { string deleteID = Request.Form["checkbox_app"]; System.Text.StringBuilder delxml = new System.Text.StringBuilder(); foreach (string id in deleteID.Split(',')) { Guid gid; if (id.IsGuid(out gid)) { delxml.Append(bdbconn.Get(gid).Serialize()); bdbconn.Delete(gid); } } bdbconn.ClearCache(); RoadFlow.Platform.Log.Add("删除了数据连接", delxml.ToString(), RoadFlow.Platform.Log.Types.流程相关); } } ConnList = bdbconn.GetAll(); Query1 = query1; }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string dbconn = context.Request.QueryString["dbconn"]; string dbtable = context.Request.QueryString["dbtable"]; string valuefield = context.Request.QueryString["valuefield"]; string titlefield = context.Request.QueryString["titlefield"]; string parentfield = context.Request.QueryString["parentfield"]; string where = (context.Request.QueryString["where"] ?? "").UrlDecode(); RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection(); var conn = bdbconn.Get(dbconn.ToGuid()); string sql = "select " + valuefield + "," + titlefield + " from " + dbtable + (where.IsNullOrEmpty() ? "" : " where " + where); DataTable dt = bdbconn.GetDataTable(conn, sql.ReplaceSelectSql()); System.Text.StringBuilder json = new System.Text.StringBuilder(1000); foreach (System.Data.DataRow dr in dt.Rows) { string value = dr[0].ToString(); string title = dt.Columns.Count > 1 ? dr[1].ToString() : value; string sql1 = "select * from " + dbtable + " where " + parentfield + "='" + value + "'"; bool hasChilds = bdbconn.GetDataTable(conn, sql1.ReplaceSelectSql()).Rows.Count > 0; json.Append("{"); json.AppendFormat("\"id\":\"{0}\",", value); json.AppendFormat("\"parentID\":\"{0}\",", Guid.Empty.ToString()); json.AppendFormat("\"title\":\"{0}\",", title); json.AppendFormat("\"type\":\"{0}\",", hasChilds ? "1" : "2"); //类型:0根 1父 2子 json.AppendFormat("\"ico\":\"{0}\",", ""); json.AppendFormat("\"hasChilds\":\"{0}\",", hasChilds ? "1" : "0"); json.Append("\"childs\":[]},"); } context.Response.Write("[" + json.ToString().TrimEnd(',') + "]"); }
public string GetTables() { string msg; if (!WebMvc.Common.Tools.CheckLogin(out msg)) { return(""); } this.Response.Charset = "utf-8"; string str1 = this.Request.QueryString["connid"]; if (!str1.IsGuid()) { return("[]"); } List <string> tables = new RoadFlow.Platform.DBConnection().GetTables(str1.ToGuid(), 0); StringBuilder stringBuilder = new StringBuilder("[", 1000); foreach (string str2 in tables) { stringBuilder.Append("{\"name\":"); stringBuilder.AppendFormat("\"{0}\"", (object)str2); stringBuilder.Append("},"); } return(stringBuilder.ToString().TrimEnd(',') + "]"); }
public string GetNames_Table() { string str1 = this.Request.QueryString["dbconn"]; string str2 = this.Request.QueryString["dbtable"]; string str3 = this.Request.QueryString["valuefield"]; string str4 = this.Request.QueryString["titlefield"]; string str5 = this.Request.QueryString["parentfield"]; string str6 = this.Request.QueryString["where"]; string str7 = this.Request.QueryString["values"] ?? ""; RoadFlow.Platform.DBConnection dbConnection = new RoadFlow.Platform.DBConnection(); RoadFlow.Data.Model.DBConnection dbconn = dbConnection.Get(str1.ToGuid(), true); StringBuilder stringBuilder = new StringBuilder(); char[] chArray = new char[1] { ',' }; foreach (string str8 in str7.Split(chArray)) { if (!str8.IsNullOrEmpty()) { string str9 = "select " + str4 + " from " + str2 + " where " + str3 + "='" + str8 + "'"; DataTable dataTable = dbConnection.GetDataTable(dbconn, str9.ReplaceSelectSql(), (IDataParameter[])null); if (dataTable.Rows.Count > 0) { stringBuilder.Append(dataTable.Rows[0][0].ToString()); stringBuilder.Append(","); } } } return(stringBuilder.ToString().TrimEnd(',')); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string dbconn = context.Request.QueryString["dbconn"]; string dbtable = context.Request.QueryString["dbtable"]; string valuefield = context.Request.QueryString["valuefield"]; string titlefield = context.Request.QueryString["titlefield"]; string parentfield = context.Request.QueryString["parentfield"]; string where = context.Request.QueryString["where"]; string values = context.Request.QueryString["values"] ?? ""; RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection(); var conn = bdbconn.Get(dbconn.ToGuid()); System.Text.StringBuilder names = new System.Text.StringBuilder(); foreach (string value in values.Split(',')) { if (value.IsNullOrEmpty()) { continue; } string sql = "select " + titlefield + " from " + dbtable + " where " + valuefield + "='" + value + "'"; DataTable dt = bdbconn.GetDataTable(conn, sql.ReplaceSelectSql()); if (dt.Rows.Count > 0) { names.Append(dt.Rows[0][0].ToString()); names.Append(","); } } context.Response.Write(names.ToString().TrimEnd(',')); }
public string GetNames_SQL() { string dbconn = Request.QueryString["dbconn"]; string sql = Request.QueryString["sql"]; RoadFlow.Platform.DBConnection conn = new RoadFlow.Platform.DBConnection(); var conn1 = conn.Get(dbconn.ToGuid()); DataTable dt = conn.GetDataTable(conn1, sql.UrlDecode().ReplaceSelectSql()); string values = Request.QueryString["values"] ?? ""; System.Text.StringBuilder sb = new System.Text.StringBuilder(); foreach (string value in values.Split(',')) { string value1 = string.Empty; string title1 = string.Empty; foreach (DataRow dr in dt.Rows) { value1 = dr[0].ToString(); if (value == value1) { title1 = dt.Columns.Count > 1 ? dr[1].ToString() : value1; break; } } sb.Append(title1); sb.Append(','); } return(sb.ToString().TrimEnd(',')); }
public string GetJson_TableRefresh() { string str1 = this.Request.QueryString["dbconn"]; string str2 = this.Request.QueryString["dbtable"]; string str3 = this.Request.QueryString["valuefield"]; string str4 = this.Request.QueryString["titlefield"]; string str5 = this.Request.QueryString["parentfield"]; string str6 = this.Request.QueryString["where"]; string str7 = this.Request.QueryString["refreshid"]; RoadFlow.Platform.DBConnection dbConnection = new RoadFlow.Platform.DBConnection(); RoadFlow.Data.Model.DBConnection dbconn = dbConnection.Get(str1.ToGuid(), true); string str8 = "select " + str3 + "," + str4 + " from " + str2 + " where " + str5 + "='" + str7 + "'"; DataTable dataTable = dbConnection.GetDataTable(dbconn, str8.ReplaceSelectSql(), (IDataParameter[])null); StringBuilder stringBuilder = new StringBuilder(1000); foreach (DataRow row in (InternalDataCollectionBase)dataTable.Rows) { string str9 = row[0].ToString(); string str10 = dataTable.Columns.Count > 1 ? row[1].ToString() : str9; string str11 = "select * from " + str2 + " where " + str5 + "='" + str9 + "'"; bool flag = dbConnection.GetDataTable(dbconn, str11.ReplaceSelectSql(), (IDataParameter[])null).Rows.Count > 0; stringBuilder.Append("{"); stringBuilder.AppendFormat("\"id\":\"{0}\",", (object)str9); stringBuilder.AppendFormat("\"parentID\":\"{0}\",", (object)Guid.Empty.ToString()); stringBuilder.AppendFormat("\"title\":\"{0}\",", (object)str10); stringBuilder.AppendFormat("\"type\":\"{0}\",", flag ? (object)"1" : (object)"2"); stringBuilder.AppendFormat("\"ico\":\"{0}\",", (object)""); stringBuilder.AppendFormat("\"hasChilds\":\"{0}\",", flag ? (object)"1" : (object)"0"); stringBuilder.Append("\"childs\":[]},"); } return("[" + stringBuilder.ToString().TrimEnd(',') + "]"); }
public string TestLineSqlWhere() { string msg; if (!WebMvc.Common.Tools.CheckLogin(out msg)) { return(""); } string str1 = this.Request["connid"]; string str2 = this.Request["table"]; string str3 = this.Request["tablepk"]; string str4 = this.Request["where"] ?? ""; RoadFlow.Platform.DBConnection dbConnection = new RoadFlow.Platform.DBConnection(); if (!str1.IsGuid()) { return("流程未设置数据连接!"); } RoadFlow.Data.Model.DBConnection dbconn = dbConnection.Get(str1.ToGuid(), true); if (dbconn == null) { return("未找到连接!"); } string sql = "SELECT * FROM " + str2 + " WHERE 1=1 AND " + str4.FilterWildcard(""); return(dbConnection.TestSql(dbconn, sql, true) ? "SQL条件正确!" : "SQL条件错误!"); }
public string GetNames_SQL() { string str1 = this.Request.QueryString["dbconn"]; string str2 = this.Request.QueryString["sql"]; RoadFlow.Platform.DBConnection dbConnection = new RoadFlow.Platform.DBConnection(); DataTable dataTable = dbConnection.GetDataTable(dbConnection.Get(str1.ToGuid(), true), str2.UrlDecode().FilterWildcard("").ReplaceSelectSql(), (IDataParameter[])null); string str3 = this.Request.QueryString["values"] ?? ""; StringBuilder stringBuilder = new StringBuilder(); char[] chArray = new char[1] { ',' }; foreach (string str4 in str3.Split(chArray)) { string empty = string.Empty; string str5 = string.Empty; foreach (DataRow row in (InternalDataCollectionBase)dataTable.Rows) { string str6 = row[0].ToString(); if (str4 == str6) { str5 = dataTable.Columns.Count > 1 ? row[1].ToString() : str6; break; } } stringBuilder.Append(str5); stringBuilder.Append(','); } return(stringBuilder.ToString().TrimEnd(',')); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string dbconn = context.Request.QueryString["dbconn"]; string sql = context.Request.QueryString["sql"]; RoadFlow.Platform.DBConnection conn = new RoadFlow.Platform.DBConnection(); var conn1 = conn.Get(dbconn.ToGuid()); DataTable dt = conn.GetDataTable(conn1, sql.UrlDecode().ReplaceSelectSql()); string values = context.Request.QueryString["values"] ?? ""; System.Text.StringBuilder sb = new System.Text.StringBuilder(); foreach (string value in values.Split(',')) { string value1 = string.Empty; string title1 = string.Empty; foreach (DataRow dr in dt.Rows) { value1 = dr[0].ToString(); if (value == value1) { title1 = dt.Columns.Count > 1 ? dr[1].ToString() : value1; break; } } sb.Append(title1); sb.Append(','); } context.Response.Write(sb.ToString().TrimEnd(',')); }
public string GetJson_TableRefresh() { string dbconn = Request.QueryString["dbconn"]; string dbtable = Request.QueryString["dbtable"]; string valuefield = Request.QueryString["valuefield"]; string titlefield = Request.QueryString["titlefield"]; string parentfield = Request.QueryString["parentfield"]; string where = Request.QueryString["where"]; string id = Request.QueryString["refreshid"]; RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection(); var conn = bdbconn.Get(dbconn.ToGuid()); string sql = "select " + valuefield + "," + titlefield + " from " + dbtable + " where " + parentfield + "='" + id + "'"; DataTable dt = bdbconn.GetDataTable(conn, sql.ReplaceSelectSql()); System.Text.StringBuilder json = new System.Text.StringBuilder(1000); foreach (System.Data.DataRow dr in dt.Rows) { string value = dr[0].ToString(); string title = dt.Columns.Count > 1 ? dr[1].ToString() : value; string sql1 = "select * from " + dbtable + " where " + parentfield + "='" + value + "'"; bool hasChilds = bdbconn.GetDataTable(conn, sql1.ReplaceSelectSql()).Rows.Count > 0; json.Append("{"); json.AppendFormat("\"id\":\"{0}\",", value); json.AppendFormat("\"parentID\":\"{0}\",", Guid.Empty.ToString()); json.AppendFormat("\"title\":\"{0}\",", title); json.AppendFormat("\"type\":\"{0}\",", hasChilds ? "1" : "2"); //类型:0根 1父 2子 json.AppendFormat("\"ico\":\"{0}\",", ""); json.AppendFormat("\"hasChilds\":\"{0}\",", hasChilds ? "1" : "0"); json.Append("\"childs\":[]},"); } return("[" + json.ToString().TrimEnd(',') + "]"); }
public string GetJson_SQL() { if (!Common.Tools.CheckLogin(false)) { return("{}"); } string dbconn = Request.QueryString["dbconn"]; string sql = Request.QueryString["sql"]; RoadFlow.Platform.DBConnection conn = new RoadFlow.Platform.DBConnection(); var conn1 = conn.Get(dbconn.ToGuid()); System.Data.DataTable dt = conn.GetDataTable(conn1, sql.UrlDecode().ReplaceSelectSql()); System.Text.StringBuilder json = new System.Text.StringBuilder(1000); foreach (System.Data.DataRow dr in dt.Rows) { string value = dr[0].ToString(); string title = dt.Columns.Count > 1 ? dr[1].ToString() : value; json.Append("{"); json.AppendFormat("\"id\":\"{0}\",", value); json.AppendFormat("\"parentID\":\"{0}\",", Guid.Empty.ToString()); json.AppendFormat("\"title\":\"{0}\",", title); json.AppendFormat("\"type\":\"{0}\",", "2"); //类型:0根 1父 2子 json.AppendFormat("\"ico\":\"{0}\",", ""); json.AppendFormat("\"hasChilds\":\"{0}\",", "0"); json.Append("\"childs\":[]},"); } return("[" + json.ToString().TrimEnd(',') + "]"); }
public string GetFields() { string msg; if (!WebMvc.Common.Tools.CheckLogin(out msg)) { return(""); } string str1 = this.Request.QueryString["table"]; string str2 = this.Request.QueryString["connid"]; if (str1.IsNullOrEmpty() || !str2.IsGuid()) { return("[]"); } System.Collections.Generic.Dictionary <string, string> fields = new RoadFlow.Platform.DBConnection().GetFields(str2.ToGuid(), str1); StringBuilder stringBuilder = new StringBuilder("[", 1000); foreach (KeyValuePair <string, string> keyValuePair in fields) { stringBuilder.Append("{"); stringBuilder.AppendFormat("\"name\":\"{0}\",\"note\":\"{1}\"", (object)keyValuePair.Key, (object)keyValuePair.Value); stringBuilder.Append("},"); } return(stringBuilder.ToString().TrimEnd(',') + "]"); }
public string GetJson_SQL() { if (!Tools.CheckLogin(false)) { return("{}"); } string str1 = this.Request.QueryString["dbconn"]; string str2 = this.Request.QueryString["sql"]; RoadFlow.Platform.DBConnection dbConnection = new RoadFlow.Platform.DBConnection(); DataTable dataTable = dbConnection.GetDataTable(dbConnection.Get(str1.ToGuid(), true), str2.UrlDecode().FilterWildcard("").ReplaceSelectSql(), (IDataParameter[])null); StringBuilder stringBuilder = new StringBuilder(1000); foreach (DataRow row in (InternalDataCollectionBase)dataTable.Rows) { string str3 = row[0].ToString(); string str4 = dataTable.Columns.Count > 1 ? row[1].ToString() : str3; stringBuilder.Append("{"); stringBuilder.AppendFormat("\"id\":\"{0}\",", (object)str3); stringBuilder.AppendFormat("\"parentID\":\"{0}\",", (object)Guid.Empty.ToString()); stringBuilder.AppendFormat("\"title\":\"{0}\",", (object)str4); stringBuilder.AppendFormat("\"type\":\"{0}\",", (object)"2"); stringBuilder.AppendFormat("\"ico\":\"{0}\",", (object)""); stringBuilder.AppendFormat("\"hasChilds\":\"{0}\",", (object)"0"); stringBuilder.Append("\"childs\":[]},"); } return("[" + stringBuilder.ToString().TrimEnd(',') + "]"); }
protected void Page_Load(object sender, EventArgs e) { string editid = Request.QueryString["id"]; RoadFlow.Platform.DBConnection bdbConn = new RoadFlow.Platform.DBConnection(); RoadFlow.Data.Model.DBConnection dbconn = null; if (editid.IsGuid()) { dbconn = bdbConn.Get(editid.ToGuid()); } bool isAdd = !editid.IsGuid(); string oldXML = string.Empty; if (dbconn == null) { dbconn = new RoadFlow.Data.Model.DBConnection(); dbconn.ID = Guid.NewGuid(); } else { oldXML = dbconn.Serialize(); } if (IsPostBack) { string Name = Request.Form["Name"]; string LinkType = Request.Form["LinkType"]; string ConnStr = Request.Form["ConnStr"]; string Note = Request.Form["Note"]; dbconn.Name = Name.Trim(); dbconn.Type = LinkType; dbconn.ConnectionString = ConnStr; dbconn.Note = Note; if (isAdd) { bdbConn.Add(dbconn); RoadFlow.Platform.Log.Add("添加了应用程序库", dbconn.Serialize(), RoadFlow.Platform.Log.Types.角色应用); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true); } else { bdbConn.Update(dbconn); RoadFlow.Platform.Log.Add("修改了应用程序库", "", RoadFlow.Platform.Log.Types.角色应用, oldXML, dbconn.Serialize()); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('修改成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();", true); } bdbConn.ClearCache(); } if (dbconn != null) { this.Name.Value = dbconn.Name; this.ConnStr.Value = dbconn.ConnectionString; this.Note.Value = dbconn.Note; } this.TypeOptions.Text = bdbConn.GetAllTypeOptions(dbconn.Type); }
public string TestSql() { string str1 = this.Request["sql"]; string str2 = this.Request["dbconn"]; if (str1.IsNullOrEmpty() || !str2.IsGuid()) { return("SQL语句为空或未设置数据连接"); } RoadFlow.Platform.DBConnection dbConnection = new RoadFlow.Platform.DBConnection(); return(dbConnection.TestSql(dbConnection.Get(str2.ToGuid(), true), str1.ReplaceSelectSql().FilterWildcard(""), true) ? "SQL语句测试正确" : "SQL语句测试错误"); }
public ActionResult TableQuery(FormCollection collection) { RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection(); string empty = string.Empty; string empty2 = string.Empty; RoadFlow.Data.Model.DBConnection dBConnection2 = null; string empty3 = string.Empty; empty = base.Request.QueryString["tablename"]; empty2 = base.Request.QueryString["dbconnid"]; dBConnection2 = dBConnection.Get(MyExtensions.ToGuid(empty2)); if (dBConnection2 == null) { base.ViewBag.LiteralResult = "未找到数据连接"; base.ViewBag.LiteralResultCount.Text = ""; return(View()); } if (collection != null) { empty3 = base.Request.Form["sqltext"]; } else { if (MyExtensions.IsNullOrEmpty(empty)) { base.ViewBag.LiteralResult = ""; base.ViewBag.LiteralResultCount = ""; return(View()); } empty3 = dBConnection.GetDefaultQuerySql(dBConnection2, empty); } if (MyExtensions.IsNullOrEmpty(empty3)) { base.ViewBag.LiteralResult = "SQL为空!"; base.ViewBag.LiteralResultCount = ""; return(View()); } if (!dBConnection.CheckSql(empty3)) { base.ViewBag.LiteralResult = "SQL含有破坏系统表的语句,禁止执行!"; base.ViewBag.LiteralResultCount = ""; RoadFlow.Platform.Log.Add("尝试执行有破坏系统表的SQL语句", empty3, RoadFlow.Platform.Log.Types.数据连接); return(View()); } DataTable dataTable = dBConnection.GetDataTable(dBConnection2, empty3); RoadFlow.Platform.Log.Add("执行了SQL", empty3, RoadFlow.Platform.Log.Types.数据连接, MyExtensions.ToJsonString((object)dataTable)); base.ViewBag.LiteralResult = Tools.DataTableToHtml(dataTable); base.ViewBag.LiteralResultCount = "(共" + dataTable.Rows.Count + "行)"; base.ViewBag.sqltext = empty3; return(View()); }
public ActionResult Edit(FormCollection collection) { string editid = Request.QueryString["id"]; RoadFlow.Platform.DBConnection bdbConn = new RoadFlow.Platform.DBConnection(); RoadFlow.Data.Model.DBConnection dbconn = null; if (editid.IsGuid()) { dbconn = bdbConn.Get(editid.Convert <Guid>()); } bool isAdd = !editid.IsGuid(); string oldXML = string.Empty; if (dbconn == null) { dbconn = new RoadFlow.Data.Model.DBConnection(); dbconn.ID = Guid.NewGuid(); } else { oldXML = dbconn.Serialize(); } if (collection != null) { string Name = Request.Form["Name"]; string LinkType = Request.Form["LinkType"]; string ConnStr = Request.Form["ConnStr"]; string Note = Request.Form["Note"]; dbconn.Name = Name.Trim(); dbconn.Type = LinkType; dbconn.ConnectionString = ConnStr; dbconn.Note = Note; if (isAdd) { bdbConn.Add(dbconn); RoadFlow.Platform.Log.Add("添加了应用程序库", dbconn.Serialize(), RoadFlow.Platform.Log.Types.角色应用); ViewBag.Script = "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } else { bdbConn.Update(dbconn); RoadFlow.Platform.Log.Add("修改了应用程序库", "", RoadFlow.Platform.Log.Types.角色应用, oldXML, dbconn.Serialize()); ViewBag.Script = "alert('修改成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } bdbConn.ClearCache(); } ViewBag.TypeOptions = bdbConn.GetAllTypeOptions(dbconn.Type); return(View(dbconn)); }
public ActionResult Table(FormCollection collection) { string text = base.Request.QueryString["connid"]; List <Tuple <string, int> > list = new List <Tuple <string, int> >(); RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection(); string empty = string.Empty; string empty2 = string.Empty; List <string> systemDataTables = RoadFlow.Utility.Config.get_SystemDataTables(); if (!MyExtensions.IsGuid(text)) { base.Response.Write("数据连接ID错误"); base.Response.End(); return(null); } RoadFlow.Data.Model.DBConnection dBConnection2 = dBConnection.Get(MyExtensions.ToGuid(text)); if (dBConnection2 == null) { base.Response.Write("未找到数据连接"); base.Response.End(); return(null); } empty2 = dBConnection2.Type; foreach (string table2 in dBConnection.GetTables(dBConnection2.ID, 1)) { list.Add(new Tuple <string, int>(table2, 0)); } foreach (string table3 in dBConnection.GetTables(dBConnection2.ID, 2)) { list.Add(new Tuple <string, int>(table3, 1)); } JsonData jsonData = new JsonData(); foreach (Tuple <string, int> item in list) { bool flag = systemDataTables.Find((string p) => p.Equals(item.Item1, StringComparison.CurrentCultureIgnoreCase)) != null; StringBuilder stringBuilder = new StringBuilder("<a class=\"viewlink\" href=\"javascript:void(0);\" onclick=\"queryTable('" + text + "','" + item.Item1 + "');\">查询</a>"); JsonData jsonData2 = new JsonData(); jsonData2["Name"] = item.Item1; jsonData2["Type"] = ((item.Item2 == 0) ? (flag ? "系统表" : "表") : "视图"); jsonData2["Opation"] = stringBuilder.ToString(); jsonData.Add(jsonData2); } empty = "&connid=" + text + "&appid=" + base.Request.QueryString["appid"] + "&tabid=" + base.Request.QueryString["tabid"]; base.ViewBag.Query = empty; base.ViewBag.dbconnID = text; base.ViewBag.DBType = empty2; base.ViewBag.list = jsonData.ToJson(); return(View()); }
public ActionResult Edit(FormCollection collection) { string text = base.Request.QueryString["id"]; RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection(); RoadFlow.Data.Model.DBConnection dBConnection2 = null; if (MyExtensions.IsGuid(text)) { dBConnection2 = dBConnection.Get(MyExtensions.ToGuid(text)); } bool flag = !MyExtensions.IsGuid(text); string oldXML = string.Empty; if (dBConnection2 == null) { dBConnection2 = new RoadFlow.Data.Model.DBConnection(); dBConnection2.ID = Guid.NewGuid(); } else { oldXML = MyExtensions.Serialize((object)dBConnection2); } if (collection != null) { string text2 = base.Request.Form["Name"]; string type = base.Request.Form["LinkType"]; string connectionString = base.Request.Form["ConnStr"]; string note = base.Request.Form["Note"]; dBConnection2.Name = text2.Trim(); dBConnection2.Type = type; dBConnection2.ConnectionString = connectionString; dBConnection2.Note = note; if (flag) { dBConnection.Add(dBConnection2); RoadFlow.Platform.Log.Add("添加了数据库连接", MyExtensions.Serialize((object)dBConnection2), RoadFlow.Platform.Log.Types.数据连接); base.ViewBag.Script = "alert('添加成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } else { dBConnection.Update(dBConnection2); RoadFlow.Platform.Log.Add("修改了数据库连接", "", RoadFlow.Platform.Log.Types.数据连接, oldXML, MyExtensions.Serialize((object)dBConnection2)); base.ViewBag.Script = "alert('修改成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } dBConnection.ClearCache(); } base.ViewBag.TypeOptions = dBConnection.GetAllTypeOptions(dBConnection2.Type); return(View(dBConnection2)); }
public string Delete() { RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection(); string text = base.Request.Form["ids"]; StringBuilder stringBuilder = new StringBuilder(); string[] array = text.Split(','); for (int i = 0; i < array.Length; i++) { Guid id = default(Guid); if (MyExtensions.IsGuid(array[i], out id)) { stringBuilder.Append(MyExtensions.Serialize((object)dBConnection.Get(id))); dBConnection.Delete(id); } } dBConnection.ClearCache(); RoadFlow.Platform.Log.Add("删除了数据连接", stringBuilder.ToString(), RoadFlow.Platform.Log.Types.流程相关); return("删除成功!"); }
public string SubTableDelete() { string secondtableconnid = Request.QueryString["secondtableconnid"]; string secondtable = Request.QueryString["secondtable"]; string secondtableprimarykey = Request.QueryString["secondtableprimarykey"]; string secondtablepkvalue = Request.QueryString["secondtablepkvalue"]; RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection(); int i = bdbconn.DeleteData(secondtableconnid.ToGuid(), secondtable, secondtableprimarykey, secondtablepkvalue); if (i > 0) { return("删除成功!"); } else { return("删除失败!"); } }
public string GetTables() { Response.Charset = "utf-8"; string connID = Request.QueryString["connid"]; if (!connID.IsGuid()) { return("[]"); } List <string> tables = new RoadFlow.Platform.DBConnection().GetTables(connID.ToGuid()); System.Text.StringBuilder sb = new System.Text.StringBuilder("[", 1000); foreach (string table in tables) { sb.Append("{\"name\":"); sb.AppendFormat("\"{0}\"", table); sb.Append("},"); } return(sb.ToString().TrimEnd(',') + "]"); }