/// <summary> /// 根据sql得到Combox列表项 /// </summary> /// <param name="dbconn"></param> /// <param name="sql"></param> /// <returns></returns> public string GetComboxTableHtmlFromSql(string connID, string sql, string value) { string cid; if (!connID.IsGuid(out cid)) { return(""); } DBConnectionBLL dbConn = new DBConnectionBLL(); var dbconn = dbConn.FindByID(cid); if (dbconn == null) { return(""); } DataTable dt = dbConn.GetDataTable(dbconn, sql.ReplaceSelectSql()); if (dt.Rows.Count == 0) { return(""); } StringBuilder html = new StringBuilder(2000); html.Append("<table><thead><tr>"); for (int i = 0; i < dt.Columns.Count; i++) { if (dt.Columns.Count > 1 && i == 0) { continue; } html.Append("<th>"); html.Append(dt.Columns[i].ColumnName); html.Append("</th>"); } html.Append("</thead>"); html.Append("<tbody>"); for (int i = 0; i < dt.Rows.Count; i++) { html.Append("<tr>"); for (int j = 0; j < dt.Columns.Count; j++) { if (dt.Columns.Count > 1 && j == 0) { continue; } html.AppendFormat("<td value=\"{0}\"{1}>", dt.Rows[i][0], dt.Rows[i][0].ToString().Equals(value, StringComparison.CurrentCultureIgnoreCase) ? " selected=\"selected\"" : ""); html.Append(dt.Rows[i][j]); html.Append("</td>"); } html.Append("</tr>"); } html.Append("</tr></tbody></table>"); return(html.ToString()); }
/// <summary> /// 根据sql得到单选按钮组 /// </summary> /// <param name="dbconn"></param> /// <param name="sql"></param> /// <returns></returns> public string GetRadioFromSql(string connID, string sql, string name, string value, string attr = "") { string cid; if (!connID.IsGuid(out cid)) { return(""); } DBConnectionBLL dbConn = new DBConnectionBLL(); var dbconn = dbConn.FindByID(cid); if (dbconn == null) { return(""); } DataTable dt = dbConn.GetDataTable(dbconn, sql.ReplaceSelectSql()); if (dt.Rows.Count == 0) { return(""); } List <ListItem> items = new List <ListItem>(); foreach (DataRow dr in dt.Rows) { if (dt.Columns.Count == 0) { continue; } string value1 = dr[0].ToString(); string title = value1; if (dt.Columns.Count > 1) { title = dr[1].ToString(); } items.Add(new ListItem(title, value1) { Selected = value == value1 }); } return(Next.WorkFlow.Utility.Tools.GetRadioString(items.ToArray(), name, attr)); }
/// <summary> /// 得到Grid的html /// </summary> /// <param name="dataFormat"></param> /// <param name="dataSource"></param> /// <param name="dataSource1"></param> /// <returns></returns> public string GetFormGridHtml(string connID, string dataFormat, string dataSource, string dataSource1) { if (!dataFormat.IsInt() || !dataSource.IsInt() || dataSource1.IsNullOrEmpty()) { return(""); } switch (dataSource) { case "0": DBConnectionBLL dbConn = new DBConnectionBLL(); var dbconn = dbConn.FindByID(connID.ToGuid()); if (dbconn == null) { return(""); } DataTable dt = dbConn.GetDataTable(dbconn, dataSource1.ReplaceSelectSql()); switch (dataFormat) { case "0": return(dataTableToHtml(dt)); case "1": return(dt.Rows.Count > 0 ? dt.Rows[0][0].ToString() : ""); case "2": return(dt.Rows.Count > 0 ? jsonToHtml(dt.Rows[0][0].ToString()) : ""); default: return(""); } case "1": string str = string.Empty; try { str = Next.WorkFlow.Utility.HttpHelper.SendGet(dataSource1); switch (dataFormat) { case "0": case "1": return(str); case "2": return(jsonToHtml(str)); default: return(""); } } catch { return(""); } case "2": WorkFlowCustomEventParams eventParams = new WorkFlowCustomEventParams(); eventParams.FlowID = (System.Web.HttpContext.Current.Request.QueryString["FlowID"] ?? "").ToGuid(); eventParams.GroupID = (System.Web.HttpContext.Current.Request.QueryString["GroupID"] ?? "").ToGuid(); eventParams.StepID = (System.Web.HttpContext.Current.Request.QueryString["StepID"] ?? "").ToGuid(); eventParams.TaskID = (System.Web.HttpContext.Current.Request.QueryString["TaskID"] ?? "").ToGuid(); eventParams.InstanceID = System.Web.HttpContext.Current.Request.QueryString["InstanceID"] ?? ""; object obj = null; try { obj = new WorkFlowTaskBLL().ExecuteFlowCustomEvent(dataSource1, eventParams); switch (dataFormat) { case "0": return(dataTableToHtml((DataTable)obj)); case "1": return(obj.ToString()); case "2": return(jsonToHtml(obj.ToString())); default: return(""); } } catch { return(""); } } return(""); }
/// <summary> /// 根据显示方式得到显示的字符串 /// </summary> /// <param name="value"></param> /// <param name="displayModel"></param> /// <returns></returns> public string GetDisplayString(string value, string displayModel, string format = "", string dbconnID = "", string sql = "") { string value1 = string.Empty; switch ((displayModel ?? "").ToLower()) { case "normal": default: value1 = value; break; case "dict_id_title": var dict = new DictBLL().FindByID(value.ToGuid()); value1 = dict == null ? "" : dict.Title; break; case "dict_id_code": var dict1 = new DictBLL().FindByID(value.ToGuid()); value1 = dict1 == null ? "" : dict1.Code; break; case "dict_id_value": var dict2 = new DictBLL().FindByID(value.ToGuid()); value1 = dict2 == null ? "" : dict2.Value; break; case "dict_id_note": var dict3 = new DictBLL().FindByID(value.ToGuid()); value1 = dict3 == null ? "" : dict3.Note; break; case "dict_id_other": var dict4 = new DictBLL().FindByID(value.ToGuid()); value1 = dict4 == null ? "" : dict4.Other; break; case "dict_code_title": var dict5 = new DictBLL().GetByCode(value); value1 = dict5 == null ? "" : dict5.Title; break; case "dict_code_id": var dict6 = new DictBLL().GetByCode(value); value1 = dict6 == null ? "" : dict6.ID.ToString(); break; case "dict_code_value": var dict7 = new DictBLL().GetByCode(value); value1 = dict7 == null ? "" : dict7.Value; break; case "dict_code_note": var dict8 = new DictBLL().GetByCode(value); value1 = dict8 == null ? "" : dict8.Note; break; case "dict_code_other": var dict9 = new DictBLL().GetByCode(value); value1 = dict9 == null ? "" : dict9.Other; break; case "organize_id_name": value1 = new DeptBLL().GetNames(value); break; case "files_link": string[] files = value.Split('|'); StringBuilder links = new StringBuilder(); //links.Append("<div>"); foreach (string file in files) { links.AppendFormat("<a target=\"_blank\" class=\"blue\" href=\"{0}\">{1}</a><br/>", file, System.IO.Path.GetFileName(file)); } //links.Append("</div>"); value1 = links.ToString(); break; case "files_img": string[] files1 = value.Split('|'); StringBuilder links1 = new StringBuilder(); //links.Append("<div>"); foreach (string file in files1) { links1.AppendFormat("<img src=\"{0}\" />", file); } //links.Append("</div>"); value1 = links1.ToString(); break; case "datetime_format": value1 = value.ToDateTime().ToString(format ?? Utility.Config.DateFormat); break; case "number_format": value1 = value.ToDecimal().ToString(format); break; case "table_fieldvalue": DBConnectionBLL dbconn = new DBConnectionBLL(); DataTable dt = dbconn.GetDataTable(dbconn.FindByID(dbconnID.ToGuid()), sql + "'" + value + "'"); value1 = dt.Rows.Count > 0 && dt.Columns.Count > 0 ? dt.Rows[0][0].ToString() : ""; break; } return(value1); }