//gdc CR32 20120804
public string GetEmailTemplateContentWithEmailSkin(int emailSkinId, string emailTemplateContent)
{
LPWeb.BLL.Template_EmailSkins bll = new Template_EmailSkins();
string content = "";
#region Skin Read To content
if (emailSkinId <= 0)
{
DataSet dsDefaultSkin = null;
string sqlCmdDefaultSkin = string.Format(" [Default] =1 AND [Enabled] = 1 ");
dsDefaultSkin = bll.GetList(sqlCmdDefaultSkin);
if ((dsDefaultSkin == null) || (dsDefaultSkin.Tables[0].Rows.Count <= 0) || dsDefaultSkin.Tables[0].Rows[0]["HTMLBody"] == DBNull.Value)
{
content = "";
}
else
{
content = dsDefaultSkin.Tables[0].Rows[0]["HTMLBody"].ToString();
}
}
else
{
DataSet dsSkin = null;
string sqlCmdSkin = string.Format(" EmailSkinId ={0} AND [Enabled] = 1 ", emailSkinId);
dsSkin = bll.GetList(sqlCmdSkin);
if ((dsSkin == null) || (dsSkin.Tables[0].Rows.Count <= 0) || dsSkin.Tables[0].Rows[0]["HTMLBody"] == DBNull.Value)
{
content = "";
}
else
{
content = dsSkin.Tables[0].Rows[0]["HTMLBody"].ToString();
}
}
#endregion
if (!string.IsNullOrEmpty(content) && System.Text.RegularExpressions.Regex.IsMatch(content, "<@EmailBody@>")) //<@EmailBody@> == <@EmailBody@> (Encoded)
{
content = System.Text.RegularExpressions.Regex.Replace(content, "<@EmailBody@>", emailTemplateContent);
}
else
{
content = emailTemplateContent;
}
return(content);
}
private DataTable GetEmailSkinList(string sWhere, string sOrderby)
{
Template_EmailSkins x = new Template_EmailSkins();
return(x.GetEmailSkinList(sWhere, sOrderby));
}
