/// <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; }