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

namespace Cyberpipe
{
    public partial class FrmUserManager : Office2007Form
    {
        public FrmUserManager()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 关闭按钮事件处理
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void buttonX1_Click(object sender, EventArgs e)
        {
            Close();
        }
        /// <summary>
        /// 窗体初始化事件处理
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmUserRepoMgr_Load(object sender, EventArgs e)
        {
            //string sql = "select casic_userstatus.\"id\",casic_userstatus.\"username\",casic_userstatus.\"password\",casic_userrepo.\"name\" as \"reponame\",casic_userstatus.\"desc\",casic_region.\"name\" as \"region\",casic_role.\"name\" as \"role\",'编辑' as \"编辑\",'删除' as \"删除\" from casic_userinfotest join casic_userrepo on casic_userstatus.\"repocode\"=casic_userrepo.\"id\" join casic_region on casic_userstatus.\"reid\" = casic_region.\"id\" join casic_role on casic_userstatus.\"rid\"=casic_role.\"id\"";
            string sql = "select ID,USERNAME,PASSWORD,'编辑' as \"编辑\",'删除' as \"删除\" from casic_userinfotest";
            DataTable dt = OledbHelper.QueryTable(sql);          
            dataGridViewX1.DataSource = dt;
        }
        /// <summary>
        /// 表格单元格单击事件处理
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dataGridViewX1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex != -1 && e.ColumnIndex != -1)
            {
                int id = Convert.ToInt32(dataGridViewX1.Rows[e.RowIndex].Cells["编号"].Value.ToString());
                if (dataGridViewX1.Columns[e.ColumnIndex].HeaderText == "编辑")
                {
                    FrmUserAdd frm = new FrmUserAdd(id);
                    if (frm.ShowDialog() == DialogResult.OK)
                    {
                        string sql = "select casic_userinfotest.ID,casic_userinfotest.USERNAME,"
                            + "casic_userinfotest.PASSWORD,casic_userinfotest.NT,"
                            +"'编辑' as \"编辑\",'删除' as \"删除\" from casic_userinfotest "
                            + "join casic_userroletest on casic_userroletest.ROLE=casic_userinfotest.RID ";
                        DataTable dt = OledbHelper.QueryTable(sql);
                        dataGridViewX1.DataSource = dt;
                    }
                }
                else if (dataGridViewX1.Columns[e.ColumnIndex].HeaderText == "删除")
                {
                    string username = dataGridViewX1.Rows[e.RowIndex].Cells["用户名"].Value.ToString();
                    if (username != Utility.userName)
                    {

                        if (MessageBox.Show("是否要删除该条记录？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        {
                            string sql = "delete from casic_userinfotest where ID= " + id;
                            if (OledbHelper.sqlExecuteNonQuery(sql) > 0)
                            {
                                dataGridViewX1.Rows.RemoveAt(e.RowIndex);
                            }
                        }
                    }
                    else {
                        MessageBox.Show("不能删除自己！");
                    }
                }
            }
        }
        //创建新用户
        private void buttonX2_Click(object sender, EventArgs e)
        {
            FrmUserAdd frm = new FrmUserAdd(-1);
            frm.ShowDialog(); 
        }
    }
}