/// <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;
}
}