private void ReloadData() { //先判断_curBizData中是否含有Dictionary和DataRow类型的数据,如果有,则直接提取到_curBizData中 foreach (KeyValuePair <string, object> kvSource in _curBizData) { Dictionary <string, object> dicData = kvSource.Value as Dictionary <string, object>; if (dicData != null) { foreach (KeyValuePair <string, object> kv in dicData) { if (_curBizData.ContainsKey(kv.Key)) { continue; } _curBizData.Add(kv.Key, kv.Value); } } DataRow dr = kvSource.Value as DataRow; if (dr != null) { foreach (DataColumn dc in dr.Table.Columns) { if (_curBizData.ContainsKey(dc.ColumnName)) { continue; } _curBizData.Add(dc.ColumnName, dr[dc]); } } } //如果配置了查询,则先重查询中获取数据 if (string.IsNullOrEmpty(_summaryDesign.DBSource.查询语句) == false) { DataTable dtInfo = SqlHelper.GetDataSource(_summaryDesign.DBSource.查询语句, _summaryDesign.DBSource.数据源别名, _dbQuery, QueryParValueEvent); if (dtInfo != null && dtInfo.Rows.Count > 0) { foreach (DataColumn dc in dtInfo.Columns) { if (_curBizData.ContainsKey(dc.ColumnName)) { _curBizData[dc.ColumnName] = dtInfo.Rows[0][dc]; } else { _curBizData.Add(dc.ColumnName, dtInfo.Rows[0][dc]); } } } } ReloadDictionary(_curBizData as Dictionary <string, object>); }
private void ReloadData() { //先判断_curBizData中是否含有Dictionary和DataRow类型的数据,如果有,则直接提取到_curBizData中 foreach (KeyValuePair <string, object> kvSource in _curBizData) { Dictionary <string, object> dicData = kvSource.Value as Dictionary <string, object>; if (dicData != null) { foreach (KeyValuePair <string, object> kv in dicData) { if (_curBizData.ContainsKey(kv.Key)) { continue; } _curBizData.Add(kv.Key, kv.Value); } } DataRow dr = kvSource.Value as DataRow; if (dr != null) { foreach (DataColumn dc in dr.Table.Columns) { if (_curBizData.ContainsKey(dc.ColumnName)) { continue; } _curBizData.Add(dc.ColumnName, dr[dc]); } } } //如果配置了查询,则先重查询中获取数据 if (string.IsNullOrEmpty(_infoDesign.查询语句) == false) { DataTable dtInfo = SqlHelper.GetDataSource(_infoDesign.查询语句, _infoDesign.数据源别名, _dbQuery, QueryParValueEvent); if (dtInfo != null && dtInfo.Rows.Count > 0) { foreach (DataColumn dc in dtInfo.Columns) { if (_curBizData.ContainsKey(dc.ColumnName)) { _curBizData[dc.ColumnName] = dtInfo.Rows[0][dc]; } else { _curBizData.Add(dc.ColumnName, dtInfo.Rows[0][dc]); } } } } int strSize = 18; string strFormatContext = @"{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fcharset134 \'cb\'ce\'cc\'e5;}}" + @"{\colortbl ;\red255\green104\blue104;\red19\green164\blue160;}" + @"{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\sl276\slmult1\lang2052\b\f0\fs" + strSize + " "; if (string.IsNullOrEmpty(_infoDesign.显示项目) == false) { foreach (string dItem in _infoDesign.显示项目.Split(',')) { if (string.IsNullOrEmpty(dItem)) { continue; } if (_curBizData.ContainsKey(dItem)) { string dataContext = SqlHelper.Nvl(_curBizData[dItem], "").Replace("\n", @" \par\cf0\fs" + strSize + " "); strFormatContext = strFormatContext + @"\b\cf0\fs" + strSize + " " + dItem + ":" + @" \b0\cf0\fs" + strSize + " " + dataContext + @"\par"; } else { strFormatContext = strFormatContext + @"\b\cf0\fs" + strSize + " " + dItem + ":" + @" \b0\cf0\fs" + strSize + " " + @"\par"; } } } else { foreach (KeyValuePair <string, object> item in _curBizData) { string dataContext = SqlHelper.Nvl(item.Value, "").Replace("\n", @" \par\cf0\fs" + strSize + " "); strFormatContext = strFormatContext + @"\b\cf0\fs" + strSize + " " + item.Key + ":" + @" \b0\cf0\fs" + strSize + " " + dataContext + @"\par"; } } richTextBox1.Rtf = strFormatContext; richTextBox1.ZoomFactor = _ic.ZoomFactor; }