/// <summary> /// 测试连接的sql条件 /// </summary> /// <returns></returns> public string TestLineSqlWhere() { string connid = Request["connid"]; string table = Request["table"]; string tablepk = Request["tablepk"]; string where = Request["where"]; MyCreek.Platform.DBConnection dbconn = new MyCreek.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条件错误!"); } }
public string TestSql() { string sql = Request["sql"]; string dbconn = Request["dbconn"]; if (sql.IsNullOrEmpty() || !dbconn.IsGuid()) { return("SQL语句为空或未设置数据连接"); } MyCreek.Platform.DBConnection bdbconn = new MyCreek.Platform.DBConnection(); var dbconn1 = bdbconn.Get(dbconn.ToGuid()); if (bdbconn.TestSql(dbconn1, sql)) { return("SQL语句测试正确"); } else { return("SQL语句测试错误"); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string sql = context.Request["sql"]; string dbconn = context.Request["dbconn"]; if (sql.IsNullOrEmpty() || !dbconn.IsGuid()) { context.Response.Write("SQL语句为空或未设置数据连接"); return; } MyCreek.Platform.DBConnection bdbconn = new MyCreek.Platform.DBConnection(); var dbconn1 = bdbconn.Get(dbconn.ToGuid()); if (bdbconn.TestSql(dbconn1, sql)) { context.Response.Write("SQL语句测试正确"); } else { context.Response.Write("SQL语句测试错误"); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string connid = context.Request["connid"]; string table = context.Request["table"]; string tablepk = context.Request["tablepk"]; string where = context.Request["where"]; MyCreek.Platform.DBConnection dbconn = new MyCreek.Platform.DBConnection(); if (!connid.IsGuid()) { context.Response.Write("流程未设置数据连接!"); return; } var conn = dbconn.Get(connid.ToGuid()); if (conn == null) { context.Response.Write("未找到连接!"); return; } string sql = "SELECT * FROM " + table + " WHERE 1=1 AND " + where; if (dbconn.TestSql(conn, sql)) { context.Response.Write("SQL条件正确!"); return; } else { context.Response.Write("SQL条件错误!"); return; } }