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