public string GetJson_TableRefresh()
{
string str1 = this.Request.QueryString["dbconn"];
string str2 = this.Request.QueryString["dbtable"];
string str3 = this.Request.QueryString["valuefield"];
string str4 = this.Request.QueryString["titlefield"];
string str5 = this.Request.QueryString["parentfield"];
string str6 = this.Request.QueryString["where"];
string str7 = this.Request.QueryString["refreshid"];
RoadFlow.Platform.DBConnection dbConnection = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn = dbConnection.Get(str1.ToGuid(), true);
string str8 = "select " + str3 + "," + str4 + " from " + str2 + " where " + str5 + "='" + str7 + "'";
DataTable dataTable = dbConnection.GetDataTable(dbconn, str8.ReplaceSelectSql(), (IDataParameter[])null);
StringBuilder stringBuilder = new StringBuilder(1000);
foreach (DataRow row in (InternalDataCollectionBase)dataTable.Rows)
{
string str9 = row[0].ToString();
string str10 = dataTable.Columns.Count > 1 ? row[1].ToString() : str9;
string str11 = "select * from " + str2 + " where " + str5 + "='" + str9 + "'";
bool flag = dbConnection.GetDataTable(dbconn, str11.ReplaceSelectSql(), (IDataParameter[])null).Rows.Count > 0;
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"id\":\"{0}\",", (object)str9);
stringBuilder.AppendFormat("\"parentID\":\"{0}\",", (object)Guid.Empty.ToString());
stringBuilder.AppendFormat("\"title\":\"{0}\",", (object)str10);
stringBuilder.AppendFormat("\"type\":\"{0}\",", flag ? (object)"1" : (object)"2");
stringBuilder.AppendFormat("\"ico\":\"{0}\",", (object)"");
stringBuilder.AppendFormat("\"hasChilds\":\"{0}\",", flag ? (object)"1" : (object)"0");
stringBuilder.Append("\"childs\":[]},");
}
return("[" + stringBuilder.ToString().TrimEnd(',') + "]");
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string dbconn = context.Request.QueryString["dbconn"];
string dbtable = context.Request.QueryString["dbtable"];
string valuefield = context.Request.QueryString["valuefield"];
string titlefield = context.Request.QueryString["titlefield"];
string parentfield = context.Request.QueryString["parentfield"];
string where = (context.Request.QueryString["where"] ?? "").UrlDecode();
RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection();
var conn = bdbconn.Get(dbconn.ToGuid());
string sql = "select " + valuefield + "," + titlefield + " from " + dbtable + (where.IsNullOrEmpty() ? "" : " where " + where);
DataTable dt = bdbconn.GetDataTable(conn, sql.ReplaceSelectSql());
System.Text.StringBuilder json = new System.Text.StringBuilder(1000);
foreach (System.Data.DataRow dr in dt.Rows)
{
string value = dr[0].ToString();
string title = dt.Columns.Count > 1 ? dr[1].ToString() : value;
string sql1 = "select * from " + dbtable + " where " + parentfield + "='" + value + "'";
bool hasChilds = bdbconn.GetDataTable(conn, sql1.ReplaceSelectSql()).Rows.Count > 0;
json.Append("{");
json.AppendFormat("\"id\":\"{0}\",", value);
json.AppendFormat("\"parentID\":\"{0}\",", Guid.Empty.ToString());
json.AppendFormat("\"title\":\"{0}\",", title);
json.AppendFormat("\"type\":\"{0}\",", hasChilds ? "1" : "2"); //类型：0根 1父 2子
json.AppendFormat("\"ico\":\"{0}\",", "");
json.AppendFormat("\"hasChilds\":\"{0}\",", hasChilds ? "1" : "0");
json.Append("\"childs\":[]},");
}
context.Response.Write("[" + json.ToString().TrimEnd(',') + "]");
}
public string GetJson_TableRefresh()
{
string text = base.Request.QueryString["dbconn"];
string text2 = base.Request.QueryString["dbtable"];
string text3 = base.Request.QueryString["valuefield"];
string text4 = base.Request.QueryString["titlefield"];
string text5 = base.Request.QueryString["parentfield"];
string text10 = base.Request.QueryString["where"];
string text6 = base.Request.QueryString["refreshid"];
RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn = dBConnection.Get(MyExtensions.ToGuid(text));
string text7 = "select " + text3 + "," + text4 + " from " + text2 + " where " + text5 + "='" + text6 + "'";
DataTable dataTable = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(text7));
StringBuilder stringBuilder = new StringBuilder(1000);
foreach (DataRow row in dataTable.Rows)
{
string text8 = row[0].ToString();
string arg = (dataTable.Columns.Count > 1) ? row[1].ToString() : text8;
string text9 = "select * from " + text2 + " where " + text5 + "='" + text8 + "'";
bool flag = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(text9)).Rows.Count > 0;
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"id\":\"{0}\",", text8);
stringBuilder.AppendFormat("\"parentID\":\"{0}\",", Guid.Empty.ToString());
stringBuilder.AppendFormat("\"title\":\"{0}\",", arg);
stringBuilder.AppendFormat("\"type\":\"{0}\",", flag ? "1" : "2");
stringBuilder.AppendFormat("\"ico\":\"{0}\",", "");
stringBuilder.AppendFormat("\"hasChilds\":\"{0}\",", flag ? "1" : "0");
stringBuilder.Append("\"childs\":[]},");
}
return("[" + stringBuilder.ToString().TrimEnd(',') + "]");
}
public string GetJson_TableRefresh()
{
string dbconn = Request.QueryString["dbconn"];
string dbtable = Request.QueryString["dbtable"];
string valuefield = Request.QueryString["valuefield"];
string titlefield = Request.QueryString["titlefield"];
string parentfield = Request.QueryString["parentfield"];
string where = Request.QueryString["where"];
string id = Request.QueryString["refreshid"];
RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection();
var conn = bdbconn.Get(dbconn.ToGuid());
string sql = "select " + valuefield + "," + titlefield + " from " + dbtable + " where " + parentfield + "='" + id + "'";
DataTable dt = bdbconn.GetDataTable(conn, sql.ReplaceSelectSql());
System.Text.StringBuilder json = new System.Text.StringBuilder(1000);
foreach (System.Data.DataRow dr in dt.Rows)
{
string value = dr[0].ToString();
string title = dt.Columns.Count > 1 ? dr[1].ToString() : value;
string sql1 = "select * from " + dbtable + " where " + parentfield + "='" + value + "'";
bool hasChilds = bdbconn.GetDataTable(conn, sql1.ReplaceSelectSql()).Rows.Count > 0;
json.Append("{");
json.AppendFormat("\"id\":\"{0}\",", value);
json.AppendFormat("\"parentID\":\"{0}\",", Guid.Empty.ToString());
json.AppendFormat("\"title\":\"{0}\",", title);
json.AppendFormat("\"type\":\"{0}\",", hasChilds ? "1" : "2"); //类型：0根 1父 2子
json.AppendFormat("\"ico\":\"{0}\",", "");
json.AppendFormat("\"hasChilds\":\"{0}\",", hasChilds ? "1" : "0");
json.Append("\"childs\":[]},");
}
return("[" + json.ToString().TrimEnd(',') + "]");
}
public string GetNames_SQL()
{
string str1 = this.Request.QueryString["dbconn"];
string str2 = this.Request.QueryString["sql"];
RoadFlow.Platform.DBConnection dbConnection = new RoadFlow.Platform.DBConnection();
DataTable dataTable = dbConnection.GetDataTable(dbConnection.Get(str1.ToGuid(), true), str2.UrlDecode().FilterWildcard("").ReplaceSelectSql(), (IDataParameter[])null);
string str3 = this.Request.QueryString["values"] ?? "";
StringBuilder stringBuilder = new StringBuilder();
char[] chArray = new char[1] {
','
};
foreach (string str4 in str3.Split(chArray))
{
string empty = string.Empty;
string str5 = string.Empty;
foreach (DataRow row in (InternalDataCollectionBase)dataTable.Rows)
{
string str6 = row[0].ToString();
if (str4 == str6)
{
str5 = dataTable.Columns.Count > 1 ? row[1].ToString() : str6;
break;
}
}
stringBuilder.Append(str5);
stringBuilder.Append(',');
}
return(stringBuilder.ToString().TrimEnd(','));
}
public string GetJson_SQL()
{
if (!Tools.CheckLogin(redirect: false))
{
return("{}");
}
string text = base.Request.QueryString["dbconn"];
string text2 = base.Request.QueryString["sql"];
RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn = dBConnection.Get(MyExtensions.ToGuid(text));
DataTable dataTable = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(MyExtensions.UrlDecode(text2).FilterWildcard()));
StringBuilder stringBuilder = new StringBuilder(1000);
foreach (DataRow row in dataTable.Rows)
{
string text3 = row[0].ToString();
string arg = (dataTable.Columns.Count > 1) ? row[1].ToString() : text3;
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"id\":\"{0}\",", text3);
stringBuilder.AppendFormat("\"parentID\":\"{0}\",", Guid.Empty.ToString());
stringBuilder.AppendFormat("\"title\":\"{0}\",", arg);
stringBuilder.AppendFormat("\"type\":\"{0}\",", "2");
stringBuilder.AppendFormat("\"ico\":\"{0}\",", "");
stringBuilder.AppendFormat("\"hasChilds\":\"{0}\",", "0");
stringBuilder.Append("\"childs\":[]},");
}
return("[" + stringBuilder.ToString().TrimEnd(',') + "]");
}
public string GetJson_SQL()
{
if (!Common.Tools.CheckLogin(false))
{
return("{}");
}
string dbconn = Request.QueryString["dbconn"];
string sql = Request.QueryString["sql"];
RoadFlow.Platform.DBConnection conn = new RoadFlow.Platform.DBConnection();
var conn1 = conn.Get(dbconn.ToGuid());
System.Data.DataTable dt = conn.GetDataTable(conn1, sql.UrlDecode().ReplaceSelectSql());
System.Text.StringBuilder json = new System.Text.StringBuilder(1000);
foreach (System.Data.DataRow dr in dt.Rows)
{
string value = dr[0].ToString();
string title = dt.Columns.Count > 1 ? dr[1].ToString() : value;
json.Append("{");
json.AppendFormat("\"id\":\"{0}\",", value);
json.AppendFormat("\"parentID\":\"{0}\",", Guid.Empty.ToString());
json.AppendFormat("\"title\":\"{0}\",", title);
json.AppendFormat("\"type\":\"{0}\",", "2"); //类型：0根 1父 2子
json.AppendFormat("\"ico\":\"{0}\",", "");
json.AppendFormat("\"hasChilds\":\"{0}\",", "0");
json.Append("\"childs\":[]},");
}
return("[" + json.ToString().TrimEnd(',') + "]");
}
public string GetNames_SQL()
{
string dbconn = Request.QueryString["dbconn"];
string sql = Request.QueryString["sql"];
RoadFlow.Platform.DBConnection conn = new RoadFlow.Platform.DBConnection();
var conn1 = conn.Get(dbconn.ToGuid());
DataTable dt = conn.GetDataTable(conn1, sql.UrlDecode().ReplaceSelectSql());
string values = Request.QueryString["values"] ?? "";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (string value in values.Split(','))
{
string value1 = string.Empty;
string title1 = string.Empty;
foreach (DataRow dr in dt.Rows)
{
value1 = dr[0].ToString();
if (value == value1)
{
title1 = dt.Columns.Count > 1 ? dr[1].ToString() : value1;
break;
}
}
sb.Append(title1);
sb.Append(',');
}
return(sb.ToString().TrimEnd(','));
}
public string GetNames_Table()
{
string text = base.Request.QueryString["dbconn"];
string text2 = base.Request.QueryString["dbtable"];
string text3 = base.Request.QueryString["valuefield"];
string text4 = base.Request.QueryString["titlefield"];
string text7 = base.Request.QueryString["parentfield"];
string text8 = base.Request.QueryString["where"];
string obj = base.Request.QueryString["values"] ?? "";
RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn = dBConnection.Get(MyExtensions.ToGuid(text));
StringBuilder stringBuilder = new StringBuilder();
string[] array = obj.Split(',');
foreach (string text5 in array)
{
if (!MyExtensions.IsNullOrEmpty(text5))
{
string text6 = "select " + text4 + " from " + text2 + " where " + text3 + "='" + text5 + "'";
DataTable dataTable = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(text6));
if (dataTable.Rows.Count > 0)
{
stringBuilder.Append(dataTable.Rows[0][0].ToString());
stringBuilder.Append(",");
}
}
}
return(stringBuilder.ToString().TrimEnd(','));
}
public string GetJson_SQL()
{
if (!Tools.CheckLogin(false))
{
return("{}");
}
string str1 = this.Request.QueryString["dbconn"];
string str2 = this.Request.QueryString["sql"];
RoadFlow.Platform.DBConnection dbConnection = new RoadFlow.Platform.DBConnection();
DataTable dataTable = dbConnection.GetDataTable(dbConnection.Get(str1.ToGuid(), true), str2.UrlDecode().FilterWildcard("").ReplaceSelectSql(), (IDataParameter[])null);
StringBuilder stringBuilder = new StringBuilder(1000);
foreach (DataRow row in (InternalDataCollectionBase)dataTable.Rows)
{
string str3 = row[0].ToString();
string str4 = dataTable.Columns.Count > 1 ? row[1].ToString() : str3;
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"id\":\"{0}\",", (object)str3);
stringBuilder.AppendFormat("\"parentID\":\"{0}\",", (object)Guid.Empty.ToString());
stringBuilder.AppendFormat("\"title\":\"{0}\",", (object)str4);
stringBuilder.AppendFormat("\"type\":\"{0}\",", (object)"2");
stringBuilder.AppendFormat("\"ico\":\"{0}\",", (object)"");
stringBuilder.AppendFormat("\"hasChilds\":\"{0}\",", (object)"0");
stringBuilder.Append("\"childs\":[]},");
}
return("[" + stringBuilder.ToString().TrimEnd(',') + "]");
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string dbconn = context.Request.QueryString["dbconn"];
string sql = context.Request.QueryString["sql"];
RoadFlow.Platform.DBConnection conn = new RoadFlow.Platform.DBConnection();
var conn1 = conn.Get(dbconn.ToGuid());
DataTable dt = conn.GetDataTable(conn1, sql.UrlDecode().ReplaceSelectSql());
string values = context.Request.QueryString["values"] ?? "";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (string value in values.Split(','))
{
string value1 = string.Empty;
string title1 = string.Empty;
foreach (DataRow dr in dt.Rows)
{
value1 = dr[0].ToString();
if (value == value1)
{
title1 = dt.Columns.Count > 1 ? dr[1].ToString() : value1;
break;
}
}
sb.Append(title1);
sb.Append(',');
}
context.Response.Write(sb.ToString().TrimEnd(','));
}
public string GetNames_SQL()
{
string text = base.Request.QueryString["dbconn"];
string text2 = base.Request.QueryString["sql"];
RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn = dBConnection.Get(MyExtensions.ToGuid(text));
DataTable dataTable = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(MyExtensions.UrlDecode(text2).FilterWildcard()));
string obj = base.Request.QueryString["values"] ?? "";
StringBuilder stringBuilder = new StringBuilder();
string[] array = obj.Split(',');
foreach (string a in array)
{
string empty = string.Empty;
string value = string.Empty;
foreach (DataRow row in dataTable.Rows)
{
empty = row[0].ToString();
if (a == empty)
{
value = ((dataTable.Columns.Count > 1) ? row[1].ToString() : empty);
break;
}
}
stringBuilder.Append(value);
stringBuilder.Append(',');
}
return(stringBuilder.ToString().TrimEnd(','));
}
public string GetNames_Table()
{
string str1 = this.Request.QueryString["dbconn"];
string str2 = this.Request.QueryString["dbtable"];
string str3 = this.Request.QueryString["valuefield"];
string str4 = this.Request.QueryString["titlefield"];
string str5 = this.Request.QueryString["parentfield"];
string str6 = this.Request.QueryString["where"];
string str7 = this.Request.QueryString["values"] ?? "";
RoadFlow.Platform.DBConnection dbConnection = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn = dbConnection.Get(str1.ToGuid(), true);
StringBuilder stringBuilder = new StringBuilder();
char[] chArray = new char[1] {
','
};
foreach (string str8 in str7.Split(chArray))
{
if (!str8.IsNullOrEmpty())
{
string str9 = "select " + str4 + " from " + str2 + " where " + str3 + "='" + str8 + "'";
DataTable dataTable = dbConnection.GetDataTable(dbconn, str9.ReplaceSelectSql(), (IDataParameter[])null);
if (dataTable.Rows.Count > 0)
{
stringBuilder.Append(dataTable.Rows[0][0].ToString());
stringBuilder.Append(",");
}
}
}
return(stringBuilder.ToString().TrimEnd(','));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string dbconn = context.Request.QueryString["dbconn"];
string dbtable = context.Request.QueryString["dbtable"];
string valuefield = context.Request.QueryString["valuefield"];
string titlefield = context.Request.QueryString["titlefield"];
string parentfield = context.Request.QueryString["parentfield"];
string where = context.Request.QueryString["where"];
string values = context.Request.QueryString["values"] ?? "";
RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection();
var conn = bdbconn.Get(dbconn.ToGuid());
System.Text.StringBuilder names = new System.Text.StringBuilder();
foreach (string value in values.Split(','))
{
if (value.IsNullOrEmpty())
{
continue;
}
string sql = "select " + titlefield + " from " + dbtable + " where " + valuefield + "='" + value + "'";
DataTable dt = bdbconn.GetDataTable(conn, sql.ReplaceSelectSql());
if (dt.Rows.Count > 0)
{
names.Append(dt.Rows[0][0].ToString());
names.Append(",");
}
}
context.Response.Write(names.ToString().TrimEnd(','));
}
public ActionResult TableQuery(FormCollection collection)
{
RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection();
string empty = string.Empty;
string empty2 = string.Empty;
RoadFlow.Data.Model.DBConnection dBConnection2 = null;
string empty3 = string.Empty;
empty = base.Request.QueryString["tablename"];
empty2 = base.Request.QueryString["dbconnid"];
dBConnection2 = dBConnection.Get(MyExtensions.ToGuid(empty2));
if (dBConnection2 == null)
{
base.ViewBag.LiteralResult = "未找到数据连接";
base.ViewBag.LiteralResultCount.Text = "";
return(View());
}
if (collection != null)
{
empty3 = base.Request.Form["sqltext"];
}
else
{
if (MyExtensions.IsNullOrEmpty(empty))
{
base.ViewBag.LiteralResult = "";
base.ViewBag.LiteralResultCount = "";
return(View());
}
empty3 = dBConnection.GetDefaultQuerySql(dBConnection2, empty);
}
if (MyExtensions.IsNullOrEmpty(empty3))
{
base.ViewBag.LiteralResult = "SQL为空！";
base.ViewBag.LiteralResultCount = "";
return(View());
}
if (!dBConnection.CheckSql(empty3))
{
base.ViewBag.LiteralResult = "SQL含有破坏系统表的语句，禁止执行！";
base.ViewBag.LiteralResultCount = "";
RoadFlow.Platform.Log.Add("尝试执行有破坏系统表的SQL语句", empty3, RoadFlow.Platform.Log.Types.数据连接);
return(View());
}
DataTable dataTable = dBConnection.GetDataTable(dBConnection2, empty3);
RoadFlow.Platform.Log.Add("执行了SQL", empty3, RoadFlow.Platform.Log.Types.数据连接, MyExtensions.ToJsonString((object)dataTable));
base.ViewBag.LiteralResult = Tools.DataTableToHtml(dataTable);
base.ViewBag.LiteralResultCount = "(共" + dataTable.Rows.Count + "行)";
base.ViewBag.sqltext = empty3;
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
RoadFlow.Platform.Dictionary Dict = new RoadFlow.Platform.Dictionary();
string values = Request.QueryString["values"];
string rootid = Request.QueryString["rootid"];
string datasource = Request.QueryString["datasource"];
string sql = Request.QueryString["sql"];
DataTable SqlDataTable = new DataTable();
if ("1" == datasource)
{
string dbconn = Request.QueryString["dbconn"];
RoadFlow.Platform.DBConnection conn = new RoadFlow.Platform.DBConnection();
var conn1 = conn.Get(dbconn.ToGuid());
SqlDataTable = conn.GetDataTable(conn1, sql.UrlDecode().ReplaceSelectSql());
}
System.Text.StringBuilder defautlSB = new System.Text.StringBuilder();
foreach (string value in values.Split(','))
{
switch (datasource)
{
case "0":
default:
Guid id;
if (!value.IsGuid(out id))
{
continue;
}
defautlSB.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", value);
defautlSB.Append(Dict.GetTitle(id));
defautlSB.Append("</div>");
break;
case "1": //SQL
string title1 = string.Empty;
foreach (DataRow dr in SqlDataTable.Rows)
{
if (value == dr[0].ToString())
{
title1 = SqlDataTable.Columns.Count > 1 ? dr[1].ToString() : value;
break;
}
}
defautlSB.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", value);
defautlSB.Append(title1);
defautlSB.Append("</div>");
break;
case "2": //url
string url2 = Request.QueryString["url2"];
if (!url2.IsNullOrEmpty())
{
url2 = url2.IndexOf('?') >= 0 ? url2 + "&values=" + value : url2 + "?values=" + value;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
try
{
System.IO.TextWriter tw = new System.IO.StringWriter(sb);
Server.Execute(url2, tw);
}
catch (Exception err) { }
defautlSB.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", value);
defautlSB.Append(sb.ToString());
defautlSB.Append("</div>");
}
break;
case "3": //table
string dbconn = Request.QueryString["dbconn"];
string dbtable = Request.QueryString["dbtable"];
string valuefield = Request.QueryString["valuefield"];
string titlefield = Request.QueryString["titlefield"];
string parentfield = Request.QueryString["parentfield"];
string where = Request.QueryString["where"];
RoadFlow.Platform.DBConnection bdbconn = new RoadFlow.Platform.DBConnection();
var conn = bdbconn.Get(dbconn.ToGuid());
string sql2 = "select " + titlefield + " from " + dbtable + " where " + valuefield + "='" + value + "'";
DataTable dt = bdbconn.GetDataTable(conn, sql2.ReplaceSelectSql());
string title3 = string.Empty;
if (dt.Rows.Count > 0)
{
title3 = dt.Rows[0][0].ToString();
}
defautlSB.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", value);
defautlSB.Append(title3);
defautlSB.Append("</div>");
break;
}
}
defaultValuesString = defautlSB.ToString();
}
public ActionResult Index()
{
RoadFlow.Platform.Dictionary dictionary = new RoadFlow.Platform.Dictionary();
string obj = base.Request.QueryString["values"] ?? "";
string text12 = base.Request.QueryString["rootid"];
string text = base.Request.QueryString["datasource"];
string text2 = base.Request.QueryString["sql"];
DataTable dataTable = new DataTable();
if ("1" == text)
{
string text3 = base.Request.QueryString["dbconn"];
RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn = dBConnection.Get(MyExtensions.ToGuid(text3));
dataTable = dBConnection.GetDataTable(dbconn, MyExtensions.ReplaceSelectSql(MyExtensions.UrlDecode(text2).FilterWildcard()));
}
StringBuilder stringBuilder = new StringBuilder();
string[] array = obj.Split(',');
foreach (string text4 in array)
{
if (!MyExtensions.IsNullOrEmpty(text4))
{
if (!(text == "0"))
{
if (text == "1")
{
string value = string.Empty;
foreach (DataRow row in dataTable.Rows)
{
if (text4 == row[0].ToString())
{
value = ((dataTable.Columns.Count > 1) ? row[1].ToString() : text4);
break;
}
}
stringBuilder.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", text4);
stringBuilder.Append(value);
stringBuilder.Append("</div>");
continue;
}
if (text == "2")
{
string text5 = base.Request.QueryString["url2"];
if (!MyExtensions.IsNullOrEmpty(text5))
{
text5 = ((text5.IndexOf('?') >= 0) ? (text5 + "&values=" + text4) : (text5 + "?values=" + text4));
StringBuilder stringBuilder2 = new StringBuilder();
try
{
TextWriter writer = new StringWriter(stringBuilder2);
base.Server.Execute(text5, writer);
}
catch
{
}
stringBuilder.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", text4);
stringBuilder.Append(stringBuilder2.ToString());
stringBuilder.Append("</div>");
}
continue;
}
if (text == "3")
{
string text6 = base.Request.QueryString["dbconn"];
string text7 = base.Request.QueryString["dbtable"];
string text8 = base.Request.QueryString["valuefield"];
string text9 = base.Request.QueryString["titlefield"];
string text13 = base.Request.QueryString["parentfield"];
string text10 = base.Request.QueryString["where1"];
RoadFlow.Platform.DBConnection dBConnection2 = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn2 = dBConnection2.Get(MyExtensions.ToGuid(text6));
string text11 = "select " + text9 + " from " + text7 + " where " + text8 + "='" + text4 + "'";
DataTable dataTable2 = dBConnection2.GetDataTable(dbconn2, MyExtensions.ReplaceSelectSql(text11));
string value2 = string.Empty;
if (dataTable2.Rows.Count > 0)
{
value2 = dataTable2.Rows[0][0].ToString();
}
stringBuilder.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", text4);
stringBuilder.Append(value2);
stringBuilder.Append("</div>");
base.ViewBag.where = MyExtensions.UrlEncode(text10);
continue;
}
}
Guid id = default(Guid);
if (MyExtensions.IsGuid(text4, out id))
{
stringBuilder.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", text4);
stringBuilder.Append(dictionary.GetTitle(id));
stringBuilder.Append("</div>");
}
}
}
base.ViewBag.defaultValuesString = MyExtensions.Trim1(stringBuilder.ToString());
return(View());
}
