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(); }