/// <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 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语句测试错误"); } }