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

using System.Data.SqlClient;
namespace PipeLine.Forms
{
    public partial class FrmCreateUser : Office2007Form
    {
        private string createUser;//添加一个创建用户
        public FrmCreateUser(string createuser)
        {
            InitializeComponent();
            createUser = createuser;
        }

        private void FrmCreateUser_Load(object sender, EventArgs e)
        {
            cmbGender.SelectedIndex = 0;
            //cmbDepart.SelectedIndex = 0;
        }
        private void btnCreate_Click(object sender, EventArgs e)
        {          
            SqlConnection conn = null;
            SqlCommand sqlCmd = null;
            try
            {
                //创建connection对象
                conn = new SqlConnection("Data Source=" + Utility.DBServer + ";Initial Catalog=" + Utility.dbdatabase + ";Persist Security Info=True;User ID=" + Utility.userID + ";pwd=" + Utility.DBPassword + "");
                //打开数据库连接
                conn.Open();
                //创建Transac Sql命令对象
                sqlCmd = conn.CreateCommand();
                //创佳SQL查询语句1
                sqlCmd.CommandText = "select count(*) from users where username='" + txtUser.Text + "'";
                //查询记录数

                object obj = sqlCmd.ExecuteScalar();
                int num = (int)obj;
                if (num > 0)
                {
                    MessageBox.Show("用户名已存在，请重新输入！", "提示");
                    return;
                }
                if (txtPsdConfirm.Text != txtPsd.Text)
                {
                    MessageBox.Show("密码输入不一致，请重新输入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (txtUser.Text == "" || txtPsd.Text == "")
                {

                    if (txtUser.Text == "" && txtPsd.Text == "")
                    {
                        MessageBox.Show("用户名和密码不能为空，请输入用户名和密码！", "提示");
                    }
                    else if (txtPsd.Text == "")
                    {
                        MessageBox.Show("密码不能为空，请输入密码！", "提示");
                    }
                    else
                    {
                        MessageBox.Show("用户名不能为空，请输入密码！", "提示");
                    }
                    return;
                }
                //if (clbDepart.CheckedItems.Count <= 0)
                //{
                //    MessageBox.Show("请至少选中一个部门！","提示");
                //    return;
                //}
                //else
                //{
                //    string departAll = "";
                //    int count = clbDepart.CheckedItems.Count;
                //    for (int i = 0; i < count; i++)
                //    {
                //        string checkedDepart = clbDepart.CheckedItems[i].ToString();
                //        departAll += "" + checkedDepart + "" + ",";
                //    }
                //    //sqlCmd.CommandText = string.Format("insert into users (username,password,person,gender,department,phone) values ('{0}','{1}','{2}','{3}','{4}','{5}')", txtUser.Text, txtPsd.Text, txtName.Text, cmbGender.SelectedItem.ToString(), cmbDepart.SelectedItem.ToString(), txtPhone.Text);
                //    //sqlCmd.CommandText = string.Format("insert into users (username,password,person,gender,department,phone) values ('{0}','{1}','{2}','{3}','{4}','{5}')", txtUser.Text, txtPsd.Text, txtName.Text, cmbGender.SelectedItem.ToString(), departAll, txtPhone.Text);
                //    sqlCmd.CommandText = string.Format("insert into users (username,password,person,gender,department,phone,createuser) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", txtUser.Text, txtPsd.Text, txtName.Text, cmbGender.SelectedItem.ToString(), departAll, txtPhone.Text,createUser);//天加一个创建用户字段
                //}
                sqlCmd.CommandText = string.Format("insert into users (username,password,person,gender,phone,createuser) values ('{0}','{1}','{2}','{3}','{4}','{5}')", txtUser.Text, txtPsd.Text, txtName.Text, cmbGender.SelectedItem.ToString(), txtPhone.Text, createUser);//天加一个创建用户字段
                sqlCmd.ExecuteNonQuery();
                conn.Close();
                this.Close();
                MessageBox.Show("创建成功！", "提示！", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                LogError.PublishError(ex);
                conn.Close();
            }
        }

        private void buttonX1_Click(object sender, EventArgs e)
        {
            this.Close();
        }

    }
}