//获取显示转换数据 public string GetFieldKeyValue(DataRow dr, string str) { var fieldata = str; foreach (DataColumn item in dr.Table.Columns) { fieldata = fieldata.Replace("row." + item.ColumnName, dr[item.ColumnName].ToString()); } return(BaseClass.GetDataViewSQL(BaseClass.GetSgForStr(fieldata))); }
//获取显示转换数据 public string GetFieldKeyValue(Dictionary <string, string> data) { DataRow[] dr = TableFieldInfo.Select("FieldKey='" + data["FieldKey"] + "'"); var fieldata = dr[0]["FieldData"].ToString(); foreach (var item in data) { fieldata = fieldata.Replace("row." + item.Key, item.Value); } return(BaseClass.GetDataViewSQL(BaseClass.GetSgForStr(fieldata))); }
//设置Sum显示 public string SetSumHtml(string Strwhere) { string[] color = { "success", "primary", "info", "warning", "danger", "default" }; string result = ",\"sumHtml\":\""; string[] list = TableModel.CountData.Split('|'); string sql = " select {0} from " + TableModel.TableName + (Strwhere == "" ? "" : " where " + Strwhere); for (int i = 0; i < list.Length; i++) { string resul = list[i]; Regex reg = new Regex("(?<={).*?(?=})", RegexOptions.IgnoreCase); MatchCollection mc = reg.Matches(resul); foreach (Match m in mc) { resul = resul.Replace("{" + m.Value + "}", BaseClass.GetDataViewSQL(string.Format(sql, m.Value))); } result += "<span class='label label-" + color[i] + "' style='font-size: small'>" + resul + "</span> "; } return(result); }