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;
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_userstatus 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\"";
            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_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_userstatus 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\"";
                        DataTable dt = OledbHelper.QueryTable(sql);
                        //for (int i = 0; i < dt.Rows.Count; i++)
                        //{
                        //    dt.Rows[i]["password"] = Utility.MD5Encrypt(dt.Rows[i]["password"].ToString().Trim());
                        //}
                        dataGridViewX1.DataSource = dt;
                    }
                }
                else if (dataGridViewX1.Columns[e.ColumnIndex].HeaderText == "删除")
                {
                    if (MessageBox.Show("是否要删除该条记录？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        string sql = "delete from casic_userstatus where \"id\" = " + id;
                        if (OledbHelper.sqlExecuteNonQuery(sql) > 0)
                        {
                            dataGridViewX1.Rows.RemoveAt(e.RowIndex);
                        }
                    }
                }
            }
        }
    }
}