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