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 FrmAppUSER : Office2007Form
    {
        public FrmAppUSER()
        {
            InitializeComponent();
        }

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

        private void FrmAppUSER_Load(object sender, EventArgs e)
        {
            string sql = "select DBID,USERNAME,PASSWORD,AGE,SEX,PHONENUMBER,STATUS,'编辑' as \"编辑\",'删除' as \"删除\" from casic_app_patroler order by DBID";
            DataTable dt = OledbHelper.QueryTable(sql);
            dataGridViewX1.DataSource = dt;
        }

        private void dataGridViewX1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex != -1 && e.ColumnIndex != -1)
            {
                int dbid = Convert.ToInt32(dataGridViewX1.Rows[e.RowIndex].Cells["编号"].Value.ToString());
                string username = dataGridViewX1.Rows[e.RowIndex].Cells["用户名"].Value.ToString();
                string age = dataGridViewX1.Rows[e.RowIndex].Cells["年龄"].Value.ToString();
                string password = dataGridViewX1.Rows[e.RowIndex].Cells["密码"].Value.ToString();
                string sex = dataGridViewX1.Rows[e.RowIndex].Cells["性别"].Value.ToString();
                string phonenum = dataGridViewX1.Rows[e.RowIndex].Cells["电话"].Value.ToString();
                string isroot = dataGridViewX1.Rows[e.RowIndex].Cells["是否管理员"].Value.ToString();

                if (dataGridViewX1.Columns[e.ColumnIndex].HeaderText == "编辑")
                {
                    FrmAppUSERRESET frm = new FrmAppUSERRESET(dbid, username, age, password, sex, phonenum, isroot);
                    if (frm.ShowDialog() == DialogResult.OK)
                    {
                        string sql = "select casic_app_patroler.DBID,casic_app_patroler.USERNAME,"
                            + "casic_app_patroler.PASSWORD,casic_app_patroler.AGE,casic_app_patroler.SEX,casic_app_patroler.PHONENUMBER,casic_app_patroler.STATUS,"
                            + "'编辑' as \"编辑\",'删除' as \"删除\" from casic_app_patroler";
                        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_app_patroler where DBID= " + dbid;
                        if (OledbHelper.sqlExecuteNonQuery(sql) > 0)
                        {
                            dataGridViewX1.Rows.RemoveAt(e.RowIndex);
                        }
                    }
                }
            }
        }


    }
}