using System;
using System.Data;
using System.Windows.Forms;
using DevComponents.DotNetBar;

namespace Cyberpipe
{
    public partial class FrmSysUserInfoPassword : Office2007Form
    {
        private string dbid;
        public FrmSysUserInfoPassword(string dbid)
        {
            InitializeComponent();
            this.dbid = dbid;
        }

        private void btn_ok_Click(object sender, EventArgs e)
        {
            try
            {
                string sql = "select count(*) from ems_user_info where password='" + txt_password_old.Text.Trim() + "'";
                int count = int.Parse(OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, CommandType.Text, sql).ToString());
                if (count <= 0)
                {
                    MessageBox.Show("原始密码不正确!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (!txt_password_new.Text.Trim().Equals(txt_password_cfm.Text.Trim()))
                {
                    MessageBox.Show("请确认便更后的密码!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                sql = "update ems_user_info set password='" + txt_password_new.Text.Trim() + "' where dbid =" + dbid;
                OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql);
                MessageBox.Show("密码修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("密码修改失败:" + ex, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
    }
}