using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DevComponents.DotNetBar;
using System.Data.OracleClient;

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 sysname='EMS' and username='" + txt_code.Text.Trim() + "'";
                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("111111") + "','EMS')";
                OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql);
                txt_code.Text = "";
                reloadGrid(-1);
                MessageBox.Show("添加成功！","结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show("添加失败:" + ex.ToString(),"错误" , MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
    }
}