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