//获取显示转换数据
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);
}
