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.Collections;
namespace Cyberpipe
{
    public partial class FrmUserAdd : Office2007Form
    {
        int id;
        string username="";
        string pwd="";
        
        Dictionary<string, string> repoCodes = new Dictionary<string, string>();
        Dictionary<string, string> region = new Dictionary<string, string>();
        Dictionary<string, string> role = new Dictionary<string, string>();

        public FrmUserAdd(int _id)
        {
            InitializeComponent();
            id = _id;
        }
        /// <summary>
        /// 添加、保存按钮事件处理
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void buttonX1_Click(object sender, EventArgs e)
        {
            string sql = "";
            if (txtName.Text.Trim() == "")
            {
                MessageBox.Show("请输入用户名称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }            
            if (txtPassWord.Text.Trim() == "")
            {
                MessageBox.Show("请输入用户密码！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            
            if (comboBoxExRegionRole.SelectedIndex == -1)
            {
                MessageBox.Show("请选择角色！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (appCombo.SelectedIndex == -1) {
                MessageBox.Show("请选择其App权限！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }

            if (id == -1)
            {
                sql = "select * from casic_userinfotest where USERNAME='" + txtName.Text.Trim() + "'";
                try
                {
                    DataTable dt = OledbHelper.QueryTable(sql);
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        MessageBox.Show("该用户名已经存在！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        txtName.Clear();
                        return;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                    return;
                }
                string role=comboBoxExRegionRole.SelectedItem.ToString().Trim();
                int roleid = 0;
                if (role == "系统管理员")
                {
                    roleid = 1;
                }
                else if (role == "数据管理员")
                {
                    roleid = 2;
                }
                else if (role == "设计审核员")
                {
                    roleid = 3;
                }
                else if (role == "普通工作人员")
                {
                    roleid = 4;
                }
                
                string approle = appCombo.SelectedItem.ToString().Trim();
                int approleid = 0;
                if (approle == "有审批权限") {
                    approleid = 1;
                }
                
                sql = "insert into casic_userinfotest(USERNAME,PASSWORD,RID,APPR) values('" 
                    + txtName.Text.Trim() + "','" + Utility.MD5Encrypt2(txtPassWord.Text.Trim()) + "',"
                    + roleid + "," + approleid + ")";
            }
            else
            {
                sql = "select * from casic_userinfotest where USERNAME ='" + txtName.Text.Trim() 
                    + "' and ID <> " + id.ToString();
                
                try
                {
                    DataTable dt = OledbHelper.QueryTable(sql);
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        MessageBox.Show("该用户名已经存在！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        txtName.Clear();
                        return;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                    return;
                }
                string role = comboBoxExRegionRole.SelectedItem.ToString().Trim();
                int roleid = 0;
                if (role == "系统管理员")
                {
                    roleid = 1;
                }
                else if (role == "数据管理员")
                {
                    roleid = 2;
                }
                else if (role == "设计审核员")
                {
                    roleid = 3;
                }
                else if (role == "普通工作人员")
                {
                    roleid = 4;
                }

                string approle = appCombo.SelectedItem.ToString().Trim();
                int approleid = 0;
                if (approle == "有审批权限")
                {
                    approleid = 1;
                }

                if(pwd!=txtPassWord.Text.Trim()){
                    sql = "update casic_userinfotest set USERNAME='" + txtName.Text.Trim() + "',PASSWORD='" 
                    + Utility.MD5Encrypt2(txtPassWord.Text.Trim()) + "' ,rid = "
                    + roleid + ",APPR="+approleid+" where ID =" + id.ToString(); 
                }else{
                 sql = "update casic_userinfotest set USERNAME='" + txtName.Text.Trim() + "',PASSWORD='" 
                    + (txtPassWord.Text.Trim()) + "' ,rid = "  + roleid + ",APPR="+approleid
                    +" where ID =" + id.ToString(); 
                }
            }
            try
            {
                OledbHelper.sqlExecuteNonQuery(sql);
                {
                    MessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    DialogResult = DialogResult.OK;
                    
                    this.Close();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
        /// <summary>
        /// 关闭按钮事件处理
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void buttonX2_Click(object sender, EventArgs e)
        {
            Close();
        }
        /// <summary>
        /// 窗体初始化事件处理
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmUserRepo_Load(object sender, EventArgs e)
        {
            string sql = "";
            DataTable dt = null;
            if (id == -1)//新建用户 
            {
                //初始化两个combobox 
                appCombo.SelectedIndex = 0;
                comboBoxExRegionRole.SelectedIndex = 3;
            }

             if (id != -1)
            {
                this.Text = "编辑用户信息";
                buttonX1.Text = "保存";
                try
                {
                    //用户名、密码、描述
                    sql = "select * from casic_userinfotest where \"ID\" =" + id.ToString();
                    dt = OledbHelper.QueryTable(sql);
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        txtName.Text = dt.Rows[0]["USERNAME"].ToString().Trim();
                        //txtDesc.Text = dt.Rows[0]["desc"].ToString().Trim();
                        txtPassWord.Text = dt.Rows[0]["PASSWORD"].ToString().Trim();//MD5解密是不可逆的
                        username = txtName.Text;
                        pwd = txtPassWord.Text;

                        int roleid = int.Parse(dt.Rows[0]["RID"].ToString().Trim());
                        comboBoxExRegionRole.SelectedIndex = (roleid - 1);
                        appCombo.SelectedIndex = int.Parse(dt.Rows[0]["APPR"].ToString().Trim());

                    } 
                    
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }
            else
            {
                //部门 注册index改变事件
                //cbxRegion.SelectedIndexChanged += new EventHandler(cbxRegion_SelectedIndexChanged);
            }
        }
        /// <summary>
        /// 下拉框选中项改变事件处理
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cbxRegion_SelectedIndexChanged(object sender, EventArgs e)
        {
            string sql = "";
            //string sql = "select casic_role.\"name\" from casic_role join casic_regionrole on casic_role.\"id\"=casic_regionrole.\"rid\" where casic_regionrole.\"reid\"=" + region[cbxRegion.SelectedItem.ToString().Trim()];
            DataTable dt = OledbHelper.QueryTable(sql);
            if (dt != null && dt.Rows.Count > 0)
            {
                comboBoxExRegionRole.Items.Clear();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    comboBoxExRegionRole.Items.Add(dt.Rows[i][0].ToString().Trim());//部门角色                    
                }
            }
        }
    }
}