public int UpdateEmailFormat(EmailFormatInfo emailFormat)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[4];
objParams[0] = new SqlParameter("@EmailTitle", emailFormat.EmailTitle);
objParams[1] = new SqlParameter("@EmailTemplate", emailFormat.EmailTemplete);
objParams[2] = new SqlParameter("@IsSend", emailFormat.IsSend);
objParams[3] = new SqlParameter("@ID", emailFormat.EmailID);
return objSqlHelper.ExecuteNonQuery("je_Email_UpdateEmailFormat", objParams);
}
public EmailFormatInfo GetEmailFormatByID(int emailFormatID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@ID", SqlDbType.Int, 4);
objParams[0].Value = emailFormatID;
SqlDataReader reader = objSqlHelper.ExecuteReader("je_Email_GetEmailFormatByID", objParams);
EmailFormatInfo item = new EmailFormatInfo();
while (reader.Read())
{
item.EmailID = reader.GetInt32(reader.GetOrdinal("ID"));
item.EmailType = reader.GetString(reader.GetOrdinal("EmailType"));
item.EmailTitle = reader.GetString(reader.GetOrdinal("EmailTitle"));
item.EmailTemplete = reader.GetString(reader.GetOrdinal("EmailTemplate"));
item.ExplainInfo = reader.GetString(reader.GetOrdinal("ExplainInfo"));
item.IsSend = reader.GetBoolean(reader.GetOrdinal("IsSend"));
}
reader.Close();
return item;
}
/// <summary>
/// 更新标题样式信息
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int UpdateEmailFormat(EmailFormatInfo emailFormat)
{
return emails.UpdateEmailFormat(emailFormat);
}
