/// <summary>
///
/// Description: 从数据库中匹配出内容
/// Author:Liudpc
/// Create Date: 2010-6-11 16:38:03
/// </summary>
/// <param name="rfe"></param>
/// <returns></returns>
public DataReplaceEntityCRF GetDataReplace(ReplaceFileEntityCRF rfe)
{
DataReplaceEntityCRF dre = new DataReplaceEntityCRF();
dre.ResultFlag = true;
dre.MainParms = new Dictionary<string, string>();
string sMainReplace = ReplaceFileConfigCCC.Config.MainParmReplace;
List<SqlParameter> sqlParmList = new List<SqlParameter>();
DataHelper.DataTableAutoHelperCDH dtah = new DataTableAutoHelperCDH();
#region 开始进行输入参数的处理
if (!string.IsNullOrEmpty(rfe.ReplaceParms))
{
string[] strParms = Regex.Split(rfe.ReplaceParms, ReplaceFileConfigCCC.Config.SplitString);
List<ItemPramEntityCRF> parmList = rfe.TempleteXml.Code.Parm;
for (int i = 0, j = strParms.Length; i < j; i++)
{
int iIndex=strParms[i].IndexOf("=");
if(iIndex>0)
{
ItemPramEntityCRF ipe= parmList.Single(t => t.ParmName == strParms[i].Substring(0, iIndex));
sqlParmList.Add(new SqlParameter("@"+ipe.ParmName,strParms[i].Substring(iIndex+1)));
if (ipe != null)
{
dre.MainParms.Add(string.Format(sMainReplace, ipe.ParmText), strParms[i].Substring(iIndex + 1));
}
}
}
}
#endregion
#region 开始进行主sql取出
if (rfe.TempleteXml.Code.MainSql.Count > 0)
{
SqlParameter[] sp=sqlParmList.ToArray();
foreach(ItemMainSqlEntityCRF imse in rfe.TempleteXml.Code.MainSql)
{
if (dre.ResultFlag)
{
DataTable dt = dtah.GetDataTable(rfe.DataServer, ReplaceParmsByDict(imse.SqlString, dre.MainParms), sp);
if (dt.Rows.Count > 0)
{
for (int i = 0, j = dt.Columns.Count; i < j; i++)
{
dre.MainParms.Add(string.Format(sMainReplace, dt.Columns[i].ColumnName), dt.Rows[0][i].ToString().Trim());
}
}
else
{
dre.ResultFlag = false;
}
}
}
}
#endregion
#region 开始进行循环表格取出
if (rfe.TempleteXml.Code.ListSql.Count > 0)
{
dre.ListParms = new List<DataTable>();
SqlParameter[] sp=sqlParmList.ToArray();
foreach (ItemListSqlEntityCRF ilse in rfe.TempleteXml.Code.ListSql)
{
dre.ListParms.Add(dtah.GetDataTable(rfe.DataServer, ReplaceParmsByDict(ilse.SqlString,dre.MainParms), sp));
}
}
#endregion
return dre;
}
public string GetReplaceContentFromDatabase(string sContent,DataReplaceEntityCRF dataEntity)
{
sContent = ReplaceParmsByDict(sContent, dataEntity.MainParms);
if(sContent.IndexOf("[#循环开始]")>-1)
{
MatchCollection mc = Regex.Matches(sContent, "\\[#循环开始\\].*?\\[#循环结束\\]", RegexOptions.Singleline);
for (int i = 0, j = mc.Count; i < j; i++)
{
StringBuilder sb = new StringBuilder();
for (int n = 0, m = dataEntity.ListParms[i].Rows.Count; n < m; n++)
{
string sList = mc[i].Value.Replace("[#循环开始]", "").Replace("[#循环结束]","");
for (int q = 0, w = dataEntity.ListParms[i].Columns.Count; q < w; q++)
{
sList=sList.Replace("[#"+dataEntity.ListParms[i].Columns[q].ColumnName.Trim()+"]",dataEntity.ListParms[i].Rows[n][q].ToString());
}
sb.Append(sList);
}
sContent = sContent.Replace(mc[i].Value, sb.ToString());
}
}
return sContent;
}
