/// <summary>
///
/// Description: 得到发送内容
/// Author:Liudpc
/// Create Date: 2010-6-12 17:50:39
/// </summary>
/// <param name="sXmlId"></param>
/// <param name="sParmsContent"></param>
/// <returns></returns>
public List<DoSendEmailEntityCRF> GetSendList(string sXmlId, string sParmsContent)
{
List<DoSendEmailEntityCRF> doSend = new List<DoSendEmailEntityCRF>();
ReplaceFileEntityCRF replaceEntity = new ReplaceFileEntityCRF();
replaceEntity.TempleteXml = replace.GetTempleteXml(ReplaceFileConfigCCC.Config.XmlFileDirectory + sXmlId + ".xml");
replaceEntity.ReplaceParms = sParmsContent;
replaceEntity.ReplaceFileId = sXmlId;
replaceEntity.DataServer = ReplaceFileConfigCCC.Config.DataServerList.SingleOrDefault(t => t.Id == replaceEntity.TempleteXml.Code.Config.DataServerId);
DataReplaceEntityCRF dataReplace = replace.GetDataReplace(replaceEntity);
if (dataReplace.ResultFlag)
{
if (replaceEntity.TempleteXml.Design.ItemRule.Count > 0)
{
foreach (ItemRuleEntityAtCRF itemRule in replaceEntity.TempleteXml.Design.ItemRule)
{
if (itemRule.RuleType == ItemRuleType.RuleExpression)
{
ItemRuleExpressionEntityCRF ruleExpress = itemRule as ItemRuleExpressionEntityCRF;
string sResult =string.IsNullOrEmpty(ruleExpress.Expression)?"true": EvalFunctionCCF.Eval(replace.ReplaceParmsByDict(ruleExpress.Expression, dataReplace.MainParms)).ToLower();
if (sResult == "true")
{
doSend.Add(new DoSendEmailEntityCRF() { TempleteId = ruleExpress.TempleteGuid, ToEmail = replace.ReplaceParmsByDict(ruleExpress.ExpressionParm, dataReplace.MainParms) });
}
}
}
}
if (doSend.Count > 0)
{
foreach (DoSendEmailEntityCRF send in doSend)
{
ItemTempleteEmailInfoEntityCRF emailEntity = replaceEntity.TempleteXml.Design.ItemTemplete.SingleOrDefault(t => t.Guid == send.TempleteId) as ItemTempleteEmailInfoEntityCRF;
send.Title = replace.ReplaceParmsByDict(emailEntity.Title, dataReplace.MainParms);
send.Content = replace.GetReplaceContentFromDatabase(emailEntity.Content, dataReplace);
send.EmailServerId = replaceEntity.TempleteXml.Code.Config.EmailServerId;
}
}
}
return doSend;
}
/// <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;
}