using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace BLL
{
    public partial class Xt_User : Form
    {
        public Xt_User()
        {
            InitializeComponent();
        }

        public string sDisplay;     //ÅжÏÑ¡ÖеÄÊÇÄĸöÍø¸ñ 
        //´°Ìå¼ÓÔØ
        private void Xt_User_Load(object sender, EventArgs e)
        {
            sDisplay = "Óû§";
            initGrid();
            Display1();
            Display2();
        }

        //Íø¸ñ³õʼ»¯
        private void initGrid()
        {
            //Íø¸ñ--Óû§
            grdMain.SelectionMode = DataGridViewSelectionMode.FullRowSelect;        //Ñ¡ÖÐģʽ--ÐÐÑ¡ÖÐ
            grdMain.ColumnHeadersVisible = true;                                    //±êÌâÁÐÏÔʾ--ÊÇ
            grdMain.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;  //±êÌâÁгߴçģʽ--£¨×Ô¶¯µ÷Õû£¬¿Éµ÷Õû£©
            grdMain.RowTemplate.Height = 18;
            grdMain.RowTemplate.MinimumHeight = 18;
            grdMain.ColumnHeadersHeight = 35;          //±êÌâÐиß
            grdMain.RowHeadersVisible = false;              //±êÌâÐпɼû--·ñ
            grdMain.AllowUserToAddRows = false;             //ÊÇ·ñÔÊÐí×ÔÔö--·ñ
            grdMain.AllowUserToDeleteRows = false;          //ÊÇ·ñÔÊÐíɾ³ý--·ñ
            grdMain.ColumnCount = 0;                        //×ÜÁÐÊý--5
            grdMain.RowCount = 0;
            grdMain.AllowUserToResizeColumns = true;         //ÔÊÐíµ÷ÕûÁпí--ÊÇ
            grdMain.AllowUserToResizeRows = false;           //ÔÊÐíµ÷ÕûÐиß--·ñ
            grdMain.ReadOnly = true;                         //Ö»¶Á--ÊÇ
            grdMain.MultiSelect = false;                    //Ö»ÄÜÑ¡ÖÐÒ»ÐÐ
            grdMain.BackgroundColor = Color.White;
            grdMain.GridColor = Color.LightGray;
            grdMain.DefaultCellStyle.SelectionBackColor = Color.Black;
            grdMain.EnableHeadersVisualStyles = false;     //Íø¸ñ±êÌâ Ñùʽ
            //
            //Íø¸ñ--Óû§×é
            grdSub.SelectionMode = DataGridViewSelectionMode.FullRowSelect;        //Ñ¡ÖÐģʽ--ÐÐÑ¡ÖÐ
            grdSub.ColumnHeadersVisible = true;                                    //±êÌâÁÐÏÔʾ--ÊÇ
            grdSub.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;  //±êÌâÁгߴçģʽ--£¨×Ô¶¯µ÷Õû£¬¿Éµ÷Õû£©
            grdSub.RowTemplate.Height = 18;
            grdSub.RowTemplate.MinimumHeight = 18;
            grdSub.ColumnHeadersHeight = 35;          //±êÌâÐиß
            grdSub.RowHeadersVisible = false;              //±êÌâÐпɼû--·ñ
            grdSub.AllowUserToAddRows = false;             //ÊÇ·ñÔÊÐí×ÔÔö--·ñ
            grdSub.AllowUserToDeleteRows = false;          //ÊÇ·ñÔÊÐíɾ³ý--·ñ
            grdSub.ColumnCount = 0;                        //×ÜÁÐÊý--5
            grdSub.RowCount = 0;
            grdSub.AllowUserToResizeColumns = true;         //ÔÊÐíµ÷ÕûÁпí--ÊÇ
            grdSub.AllowUserToResizeRows = false;           //ÔÊÐíµ÷ÕûÐиß--·ñ
            grdSub.ReadOnly = true;                         //Ö»¶Á--ÊÇ
            grdSub.MultiSelect = false;                    //Ö»ÄÜÑ¡ÖÐÒ»ÐÐ
            grdSub.BackgroundColor = Color.White;
            grdSub.GridColor = Color.LightGray;
            grdSub.DefaultCellStyle.SelectionBackColor = Color.Black;
            grdSub.EnableHeadersVisualStyles = false;     //Íø¸ñ±êÌâ Ñùʽ
        }

        //²éÕÒÊý¾Ý----Óû§
        private void Display1()
        {
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                DataSet oDs = new DataSet();
                oDs = oCn.RunProcReturn("select * from  h_v_Gy_Czygl order by Óû§", "h_v_Gy_Czygl", ref DBUtility.ClsPub.sExeReturnInfo);
                if (oDs == null)
                {
                    MessageBox.Show("ÏÔʾʧ°Ü£¡Ô­Òò£º" + DBUtility.ClsPub.sExeReturnInfo);
                    return;
                }
                //
                grdMain.DataSource = oDs.Tables[0].DefaultView;
                //¼ÓÔØÁпí
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    grdMain.Columns[i].Width = 100;
                    if (grdMain.Columns[i].HeaderText.Substring(0, 1).ToLower() == "h")
                    {
                        grdMain.Columns[i].Visible = false;
                    }
                    else
                    {
                        grdMain.Columns[i].Visible = true;
                    }
                }
                DBUtility.ClsPub.GetGridView(this.grdMain, this.Name + "1", DBUtility.ClsPub.AppPath);
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message, "Ìáʾ");
                return;
            }
        }

        //²éÕÒÊý¾Ý--Óû§×é
        private void Display2()
        {
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                DataSet oDs = new DataSet();
                oDs = oCn.RunProcReturn("select * from h_v_System_UserGroup order by ½ÇÉ«", "h_v_System_UserGroup", ref DBUtility.ClsPub.sExeReturnInfo);
                if (oDs == null)
                {
                    MessageBox.Show("ÏÔʾʧ°Ü£¡Ô­Òò£º" + DBUtility.ClsPub.sExeReturnInfo);
                    return;
                }
                //
                grdSub.DataSource = oDs.Tables[0].DefaultView;
                //¼ÓÔØÁпí
                for (int i = 0; i < grdSub.ColumnCount; i++)
                {
                    grdSub.Columns[i].Width = 100;
                    if (grdSub.Columns[i].HeaderText.Substring(0, 1).ToLower() == "h")
                    {
                        grdSub.Columns[i].Visible = false;
                    }
                    else
                    {
                        grdSub.Columns[i].Visible = true;
                    }
                }
                DBUtility.ClsPub.GetGridView(this.grdSub, this.Name + "2", DBUtility.ClsPub.AppPath);
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message, "Ìáʾ");
                return;
            }
        }
        //Ë¢ÐÂ
        private void shuax_Click(object sender, EventArgs e)
        {
            Display1();
            Display2();
        }
        //Í˳ö
        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        //ÐÂÔöÓû§
        private void xz_Click(object sender, EventArgs e)
        {
            Xt_UserNew oNew = new Xt_UserNew();
            oNew.InputMode = Pub_Class.ClsPub.Enum_InputMode.InputMode_AddNew; 
            oNew.ShowDialog();
        }
        //ÐÂÔöÓû§×é
        private void xzz_Click(object sender, EventArgs e)
        {
            Xt_UserGroup oGroup = new Xt_UserGroup();
            oGroup.InputMode = Pub_Class.ClsPub.Enum_InputMode.InputMode_AddNew; 
            oGroup.ShowDialog();
        }
        //ÐÞ¸ÄÓû§
        private void grdMain_DoubleClick(object sender, EventArgs e)
        {
            if (grdMain.CurrentRow != null)
            {
                Xt_UserNew oNew = new Xt_UserNew();
                oNew.InputMode = Pub_Class.ClsPub.Enum_InputMode.InputMode_Modify;
                oNew.Czybm = grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HCzybm")].Value.ToString(); 
                oNew.ShowDialog();
            }
        }
        //ÐÞ¸ÄÓû§×é
        private void grdSub_DoubleClick(object sender, EventArgs e)
        {
            if (grdSub.CurrentRow != null)
            {
                Xt_UserGroup oGroup = new Xt_UserGroup();
                oGroup.InputMode = Pub_Class.ClsPub.Enum_InputMode.InputMode_Modify;
                oGroup.HGroupID = DBUtility.ClsPub.isLong(grdSub.Rows[grdSub.CurrentRow.Index].Cells[Fun_GetCol("HGroupID")].Value.ToString());
 
                oGroup.ShowDialog();
            }
        }
        //µÃµ½¶ÔÓ¦ÁÐ
        private Int32 Fun_GetCol(string sCol)//Lock
        {
            for (int c = 0; c < grdMain.ColumnCount; c++)
            {
                if (DBUtility.ClsPub.isStrNull(grdMain.Columns[c].HeaderText).ToUpper().Trim() == sCol.Trim().ToUpper())
                {
                    return c;
                }
            }
            return 0;
        }

        //µÃµ½¶ÔÓ¦ÁÐ
        private Int32 Fun_GetCol_Sub(string sCol)//Lock
        {
            for (int c = 0; c < grdSub.ColumnCount; c++)
            {
                if (DBUtility.ClsPub.isStrNull(grdSub.Columns[c].HeaderText).ToUpper().Trim() == sCol.Trim().ToUpper())
                {
                    return c;
                }
            }
            return 0;
        }

        private void bclk_Click(object sender, EventArgs e)
        {
            //±£´æÁпí
            DBUtility.ClsPub.SaveGridView(grdMain, this.Name + "1", DBUtility.ClsPub.AppPath);
            //±£´æÁпí
            DBUtility.ClsPub.SaveGridView(grdSub, this.Name + "2", DBUtility.ClsPub.AppPath);
        }

        private void mrlk_Click(object sender, EventArgs e)
        {
            DBUtility.ClsPub.DefaultGridView(grdMain);
            //²ÎÊý½âÊÍ  ¿ªÊ¼ÁÐ £¬½áÊøÁУ¬ÊÇ·ñÒÔ×î´óÁпíΪ׼£¬×îСÁпí
            DBUtility.ClsPub.SaveGridView(grdMain, this.Name + "1", DBUtility.ClsPub.AppPath);
            //
            DBUtility.ClsPub.DefaultGridView(grdSub);
            //²ÎÊý½âÊÍ  ¿ªÊ¼ÁÐ £¬½áÊøÁУ¬ÊÇ·ñÒÔ×î´óÁпíΪ׼£¬×îСÁпí
            DBUtility.ClsPub.SaveGridView(grdSub, this.Name + "2", DBUtility.ClsPub.AppPath);
        }

        private void qx_Click(object sender, EventArgs e)
        {
            Xt_Authorization oAuth = new Xt_Authorization(); 
            oAuth.sDisplay = this.sDisplay;
            if (sDisplay == "Óû§")
            {
                oAuth.czybm = grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("HCzybm")].Value.ToString();
                oAuth.lblUser.Text = grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("Óû§")].Value.ToString() + "--ȨÏÞÉèÖÃ";
            }
            else
            {
                oAuth.HGroupID = DBUtility.ClsPub.isLong(grdSub.Rows[grdSub.CurrentCell.RowIndex].Cells[Fun_GetCol_Sub("HGroupID")].Value);
                oAuth.lblUser.Text = grdSub.Rows[grdSub.CurrentCell.RowIndex].Cells[Fun_GetCol_Sub("½ÇÉ«")].Value.ToString() + "--ȨÏÞÉèÖÃ";
            }
            //дÈëÈÕÖ¾
            DBUtility.ClsPub.Add_Log(DBUtility.ClsPub.CurUserName, "ɾ³ýÓû§:" + oAuth.lblUser.Text, DBUtility.ClsPub.CurUserName);
            oAuth.ShowDialog();
        }

        private void grdMain_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            sDisplay = "Óû§";
        }

        private void grdSub_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            sDisplay = "½ÇÉ«";
        }

        private void sc_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("È·¶¨ÒªÉ¾³ýµ±Ç°Óû§£¿" + grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("Óû§")].Value.ToString(), "Ìáʾ", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
            {
                return;
            }
            if (MessageBox.Show("ÔÙ´ÎÈ·¶¨ÒªÉ¾³ýµ±Ç°Óû§£¿" + grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("Óû§")].Value.ToString(), "Ìáʾ", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
            {
                return;
            }
            DeleteBill();
            Display1();
            Display2();
        }

        private void DeleteBill()
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            if (sDisplay == "Óû§")
            {
                try
                {
                    oCn.BeginTran();
                    oCn.RunProc("delete from  Gy_Czygl where Czybm='" + grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("HCzybm")].Value.ToString() + "'");
                    oCn.RunProc("delete from  System_UserGroupInfo where UserId='" + grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("HCzybm")].Value.ToString() + "'");
                    DBUtility.ClsPub.Add_Log(DBUtility.ClsPub.CurUserName, "ɾ³ýÓû§:" + grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("HCzybm")].Value.ToString(), DBUtility.ClsPub.CurUserName);
                    oCn.Commit();
                }
                catch (Exception e)
                {
                    MessageBox.Show(e.Message, "Ìáʾ");
                    oCn.RollBack();
                    return;
                }
            }
            else
            {
                try
                {
                    oCn.BeginTran();
                    oCn.RunProc("delete from   System_UserGroup where GroupId=" + grdSub.Rows[grdSub.CurrentCell.RowIndex].Cells[Fun_GetCol("HGroupID")].Value.ToString());
                    oCn.RunProc("delete from  System_UserGroupInfo where GroupId=" + grdSub.Rows[grdSub.CurrentCell.RowIndex].Cells[Fun_GetCol("HGroupID")].Value.ToString());
                    oCn.Commit();
                }
                catch (Exception e)
                {
                    MessageBox.Show(e.Message, "Ìáʾ");
                    oCn.RollBack();
                    return;
                }
            }
            MessageBox.Show(sDisplay + "ɾ³ý³É¹¦£¡", "Ìáʾ");
        }
        private void sx_Click(object sender, EventArgs e)
        {
             
        }

        private void grdMain_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        public int i = 0;   //ÐеÄϱê¿ØÖÆÆ÷ (*****¿ØÖÆ´ÓµÚ¼¸ÐпªÊ¼±éÀú*****)
        public bool notNull = false;    //µÝ¹é¿ØÖÆÆ÷ (*****¿ØÖÆÊÇ·ñ¿Éµ÷Óõݹé******)
        private void cmdHUser_Click(object sender, EventArgs e)
        {
            string sFind = txtHUser.Text.Trim();
            string sUser = "";
            foreach (DataGridViewRow dr in grdMain.SelectedRows) //È¡ÏûÐеÄÑ¡ÖÐ
            {
                dr.Selected = false;
            }
            for (int a = i; a <= grdMain.RowCount - 1; a++)
            {
                sUser = DBUtility.ClsPub.isStrNull(this.grdMain.Rows[a].Cells[Fun_GetCol("Óû§")].Value);
                if (sUser.IndexOf(sFind) != -1)
                {
                    grdMain.Rows[a].Selected = true;  //Èç¹ûÆ¥ÅäÔòÑ¡ÖиÃÐÐ
                    grdMain.FirstDisplayedScrollingRowIndex = a;  //¹ö¶¯Ìõ»¬×Ô¸ÃÐÐ
                    i = a + 1;  //ʹÏ´αéÀú´Ó¸ÃÐеÄÏÂÒ»ÐпªÊ¼²éÕÒ
                    notNull = true;
                    return;   //ÉèÖÃnotNullΪÕæ,Ìø³ö
                }
            }
            if (notNull) //ʼÖÕδÕÒµ½Æ¥ÅäÏîÔò½øÈë
            {
                i = 0;  //ÖØÖôӵÚÒ»ÐбéÀú
                notNull = false;  //ÉèÖÃnotNullΪ¼Ù,Èç¹ûÔÙÒ»´Î´ÓµÚÒ»ÐбéÀúδÕÒµ½Æ¥ÅäÏîÔò²»»áÔÙ½øÈëIFµ÷Óõݹé
                cmdHUser_Click(sender, e); //µÝ¹é
            }
            else
            {
                MessageBox.Show("δÕÒµ½£¡£¡");
            }
        }

       

    }
}