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

namespace Cyberpipe
{
    public delegate void ReloadSysUserInfoGrid(int pageIndex);
    public partial class FrmSysUserInfoEdit : Office2007Form
    {
        public event ReloadSysUserInfoGrid reloadGrid;

        public FrmSysUserInfoEdit()
        {
            InitializeComponent();
        }

        private void buttonX1_Click(object sender, EventArgs e)
        {
            try
            {
                if (String.IsNullOrEmpty(txt_code.Text.Trim()))
                {
                    MessageBox.Show("账号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    txt_code.Focus();
                    return;
                }
                string sql = "select count(*) from casic_userinfotest where username='" + txt_code.Text.Trim() + "' and sysname='GHFX'";
                int count = int.Parse(OracleUtils.ExecuteScalar(OracleUtils.ConnectionString,CommandType.Text,sql).ToString());
                if (count > 0)
                {
                    MessageBox.Show("账号不能重复！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    txt_code.Focus();
                    return;
                }

                sql = "insert into casic_userinfotest (username,password,sysname) values ('" + txt_code.Text.Trim() + "','" + Utility.MD5Encrypt2(textBoxPassWord.Text) + "','GHFX')";
                OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql);
                txt_code.Text = "";
                reloadGrid(-1);
                MessageBox.Show("添加成功！","结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
                Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("添加失败:" + ex,"错误" , MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
    }
}