/// <summary> /// 测试连接的sql条件 /// </summary> /// <returns></returns> public string TestLineSqlWhere() { string connid = Request["connid"]; string table = Request["table"]; string tablepk = Request["tablepk"]; string where = Request["where"]; DBConnectionBLL dbconn = new DBConnectionBLL(); if (string.IsNullOrEmpty(connid)) { return("流程未设置数据连接!"); } var conn = dbconn.FindByID(connid); if (conn == null) { return("未找到连接!"); } string sql = "SELECT * FROM " + table + " WHERE 1=1 AND " + where; if (dbconn.TestSql(conn, sql)) { return("SQL条件正确!"); } else { return("SQL条件错误!"); } }
public string SubTableDelete() { string secondtableconnid = Request.QueryString["secondtableconnid"]; string secondtable = Request.QueryString["secondtable"]; string secondtableprimarykey = Request.QueryString["secondtableprimarykey"]; string secondtablepkvalue = Request.QueryString["secondtablepkvalue"]; DBConnectionBLL bdbconn = new DBConnectionBLL(); 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 (string.IsNullOrEmpty(connID)) { return("[]"); } List <string> tables = new DBConnectionBLL().GetTables(connID); 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(',') + "]"); }
public string GetFields() { string table = Request.QueryString["table"]; string connid = Request.QueryString["connid"]; if (string.IsNullOrEmpty(table) || string.IsNullOrEmpty(connid)) { return("[]"); } Dictionary <string, string> fields = new DBConnectionBLL().GetFields(connid, table); System.Text.StringBuilder sb = new System.Text.StringBuilder("[", 1000); foreach (var field in fields) { sb.Append("{"); sb.AppendFormat("\"name\":\"{0}\",\"note\":\"{1}\"", field.Key, field.Value); sb.Append("},"); } return(sb.ToString().TrimEnd(',') + "]"); }
public string TestSql() { string sql = Request["sql"]; string dbconn = Request["dbconn"]; if (sql.IsNullOrEmpty() || !dbconn.IsGuid()) { return("SQL语句为空或未设置数据连接"); } DBConnectionBLL bdbconn = new DBConnectionBLL(); var dbconn1 = bdbconn.FindByID(dbconn.ToGuid()); if (bdbconn.TestSql(dbconn1, sql)) { return("SQL语句测试正确"); } else { return("SQL语句测试错误"); } }