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 FrmAccessMgr : Office2007Form
    {
        public FrmAccessMgr()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 窗体初始化事件处理
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmAccessMgr_Load(object sender, EventArgs e)
        {
            string sql = "select casic_access.\"id\",casic_access.\"type\",casic_access.\"value\",casic_access.\"priority\",casic_access.\"desc\",casic_perm.\"name\",'编辑' as \"编辑\",'删除' as \"删除\" from casic_access ,casic_perm where casic_access.\"pid\" = casic_perm.\"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 == "编辑")
                {
                    FrmAccess frm = new FrmAccess(id);
                    if (frm.ShowDialog() == DialogResult.OK)
                    {
                        string sql = "select casic_access.\"id\",casic_access.\"type\",casic_access.\"value\",casic_access.\"priority\",casic_access.\"desc\",casic_perm.\"name\",'编辑' as \"编辑\",'删除' as \"删除\" from casic_access ,casic_perm where casic_access.\"pid\" = casic_perm.\"id\"";
                        DataTable dt = OledbHelper.QueryTable(sql);
                        dataGridViewX1.DataSource = dt;
                    }
                }
                else if (dataGridViewX1.Columns[e.ColumnIndex].HeaderText == "删除")
                {
                    if (MessageBox.Show("是否要删除该条记录？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        string sql = "delete from casic_access where \"id\" = " + id;
                        if (OledbHelper.sqlExecuteNonQuery(sql) > 0)
                        {
                            dataGridViewX1.Rows.RemoveAt(e.RowIndex);

                        }
                    }
                }
            }
        }
        /// <summary>
        /// 关闭按钮事件处理
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void buttonX2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}