public string Query()
{
string text = base.Request.Form["Title"];
string text2 = base.Request.Form["Address"];
string text3 = base.Request.Form["typeid"];
string text4 = base.Request.Form["sidx"];
string text5 = base.Request.Form["sord"];
RoadFlow.Platform.Dictionary dictionary = new RoadFlow.Platform.Dictionary();
RoadFlow.Platform.AppLibrary appLibrary = new RoadFlow.Platform.AppLibrary();
string type = MyExtensions.IsGuid(text3) ? appLibrary.GetAllChildsIDString(MyExtensions.ToGuid(text3)) : "";
int pageSize = Tools.GetPageSize();
int pageNumber = Tools.GetPageNumber();
string order = (MyExtensions.IsNullOrEmpty(text4) ? "Title" : text4) + " " + (MyExtensions.IsNullOrEmpty(text5) ? "asc" : text5);
long count;
List <RoadFlow.Data.Model.AppLibrary> pagerData = appLibrary.GetPagerData(out count, pageSize, pageNumber, MyExtensions.Trim1(text), type, MyExtensions.Trim1(text2), order);
JsonData jsonData = new JsonData();
foreach (RoadFlow.Data.Model.AppLibrary item in pagerData)
{
string empty = string.Empty;
empty = ((!MyExtensions.IsFontIco(item.Ico)) ? ("<img src=\"" + MyExtensions.Trim1(item.Ico) + "\" style=\"vertical-align:middle;\" />") : ("<i class=\"fa " + MyExtensions.Trim1(item.Ico) + "\" style=\"font-size:14px;vertical-align:middle;" + (MyExtensions.IsNullOrEmpty(item.Color) ? "" : ("color:" + item.Color + ";")) + "\"></i>"));
JsonData jsonData2 = new JsonData();
jsonData2["id"] = item.ID.ToString();
jsonData2["Title"] = empty + "<span style=\"vertical-align:middle;margin-left:4px;\">" + item.Title + "</span>";
jsonData2["Address"] = item.Address;
jsonData2["TypeTitle"] = dictionary.GetTitle(item.Type);
jsonData2["Opation"] = "<a class=\"editlink\" href=\"javascript:void(0);\" onclick=\"edit('" + item.ID.ToString() + "');return false;\" style=\"margin-right:6px;\">编辑</a><a class=\"editlink\" href=\"javascript:void(0);\" onclick=\"editsubpage('" + item.ID.ToString() + "');return false;\">子页面</a>";
jsonData.Add(jsonData2);
}
return("{\"userdata\":{\"total\":" + count + ",\"pagesize\":" + pageSize + ",\"pagenumber\":" + pageNumber + "},\"rows\":" + jsonData.ToJson() + "}");
}
public string Query()
{
string str1 = this.Request.Form["Title"];
string str2 = this.Request.Form["Address"];
string str3 = this.Request.Form["typeid"];
string str4 = this.Request.Form["sidx"];
string str5 = this.Request.Form["sord"];
RoadFlow.Platform.Dictionary dictionary = new RoadFlow.Platform.Dictionary();
RoadFlow.Platform.AppLibrary appLibrary1 = new RoadFlow.Platform.AppLibrary();
string type = str3.IsGuid() ? appLibrary1.GetAllChildsIDString(str3.ToGuid(), true) : "";
int pageSize = Tools.GetPageSize();
int pageNumber = Tools.GetPageNumber();
string order = (str4.IsNullOrEmpty() ? "Title" : str4) + " " + (str5.IsNullOrEmpty() ? "asc" : str5);
long count;
List <RoadFlow.Data.Model.AppLibrary> pagerData = appLibrary1.GetPagerData(out count, pageSize, pageNumber, str1.Trim1(), type, str2.Trim1(), order);
JsonData jsonData = new JsonData();
foreach (RoadFlow.Data.Model.AppLibrary appLibrary2 in pagerData)
{
string empty = string.Empty;
string str6;
if (appLibrary2.Ico.IsFontIco())
{
str6 = "<i class=\"fa " + appLibrary2.Ico.Trim1() + "\" style=\"font-size:14px;vertical-align:middle;" + (appLibrary2.Color.IsNullOrEmpty() ? "" : "color:" + appLibrary2.Color + ";") + "\"></i>";
}
else
{
str6 = "<img src=\"" + appLibrary2.Ico.Trim1() + "\" style=\"vertical-align:middle;\" />";
}
jsonData.Add((object)new JsonData()
{
["id"] = (JsonData)appLibrary2.ID.ToString(),
["Title"] = (JsonData)(str6 + "<span style=\"vertical-align:middle;margin-left:4px;\">" + appLibrary2.Title + "</span>"),
["Address"] = (JsonData)appLibrary2.Address,
["TypeTitle"] = (JsonData)dictionary.GetTitle(appLibrary2.Type),
["Opation"] = (JsonData)("<a class=\"editlink\" href=\"javascript:void(0);\" onclick=\"edit('" + appLibrary2.ID.ToString() + "');return false;\" style=\"margin-right:6px;\">编辑</a><a class=\"editlink\" href=\"javascript:void(0);\" onclick=\"editsubpage('" + appLibrary2.ID.ToString() + "');return false;\">子页面</a>")
});
}
return("{\"userdata\":{\"total\":" + (object)count + ",\"pagesize\":" + (object)pageSize + ",\"pagenumber\":" + (object)pageNumber + "},\"rows\":" + jsonData.ToJson(true) + "}");
}
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());
}
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();
}
