/// <summary>
 /// 获取EmailConfig信息
 /// </summary>
 /// <param name="sender">邮件发送者</param>
 /// <returns>邮件配置实体</returns>
 public EmailConfig GetEmailConfig()
 {
     EmailConfig emailConfig = null;
     SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text,
           "SELECT emailAddress,emailPassword,emailServerAddress,emailServerPort FROM usta_EmailConfig");
     while (dr.Read())
     {
         emailConfig = new EmailConfig
         {
             emailAddress = dr["emailAddress"].ToString().Trim(),
             emailPassword = dr["emailPassword"].ToString().Trim(),
             emailServerAddress = dr["emailServerAddress"].ToString().Trim(),
             emailServerPort = int.Parse(dr["emailServerPort"].ToString().Trim())
         };
     }
     dr.Close();
     conn.Close();
     return emailConfig;
 }
        /// <summary>
        /// 更新EmailConfig
        /// </summary>
        /// <param name="emailConfig">邮件配置实体</param>
        /// <returns>操作成功标号</returns>
        public int UpdateEmailConfig(EmailConfig emailConfig)
        {
            SqlParameter[] parameters = {
                    new SqlParameter("@emailAddress", SqlDbType.NChar,50),
                    new SqlParameter("@emailPassword", SqlDbType.NChar,50),
                    new SqlParameter("@emailServerAddress", SqlDbType.NChar,50),
                    new SqlParameter("@emailServerPort", SqlDbType.Int,4),
                     new SqlParameter("@sender", SqlDbType.NChar,10)};
            parameters[0].Value = emailConfig.emailAddress;
            parameters[1].Value = emailConfig.emailPassword;
            parameters[2].Value = emailConfig.emailServerAddress;
            parameters[3].Value = emailConfig.emailServerPort;
            parameters[4].Value = emailConfig.sender;

            SqlHelper.ExecuteNonQuery(conn, CommandType.Text,
                "UPDATE usta_EmailConfig SET emailAddress=@emailAddress,emailPassword=@emailPassword,emailServerAddress=@emailServerAddress, emailServerPort=@emailServerPort WHERE sender=@sender",
                parameters);
            return 1;
        }
Beispiel #3
0
    //修改邮件配置信息
    protected void btnMailCommit_Click(object sender, EventArgs e)
    {
        if (txtEmailAddress.Text.Trim().Length == 0 || txtpasswd.Text.Trim().Length == 0 || txtMailServer.Text.Trim().Length == 0 || txtMailServerPort.Text.Trim().Length == 0)
        {

            Javascript.GoHistory(-1, "邮件配置信息不能为空,请输入!", Page);
        }
        else
        {

            UserCookiesInfo user = BllOperationAboutUser.GetUserCookiesInfo();

            DalOperationAboutEmail doae = new DalOperationAboutEmail();
            EmailConfig emailconfig = new EmailConfig();
            emailconfig.emailAddress = txtEmailAddress.Text.Trim();
            emailconfig.emailPassword = txtpasswd.Text.Trim();
            emailconfig.emailServerAddress = txtMailServer.Text.Trim();
            emailconfig.emailServerPort = int.Parse(txtMailServerPort.Text.Trim());
            emailconfig.sender = user.userName;
            try
            {
                doae.UpdateEmailConfig(emailconfig);
                Javascript.AlertAndRedirect("更新邮件配置信息成功!", "/Administrator/EmailManage.aspx?fragment=4", Page);
            }
            catch (Exception ex)
            {
                MongoDBLog.LogRecord(ex);
                Javascript.AlertAndRedirect("更新邮件配置信息失败!", "/Administrator/EmailManage.aspx?fragment=4", Page);
            }

        }
    }