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

namespace SCM
{
    public partial class Gy_UserByOrgRelation : Form
    {
        public frmBillQueryCondition_Base frmCondition;
        public const string ViewName = "h_v_Gy_UserByOrgRelationList";
        public DBUtility.ClsPub.Enum_InputMode InputMode;  //录入状态标志(0-非录入状态 1-增加 2-修改)
        public string sCzybm; //用户编码
        public string sCzymc; //用户名称

        public WMSWeb.WebService1 oWeb = new WMSWeb.WebService1();

        public Gy_UserByOrgRelation()
        {
            InitializeComponent();
        }

        //以下代码基本不需要修改
        #region 固定代码

        //保存GRID列宽
        private void Gy_UserByOrgRelation_FormClosing(object sender, FormClosingEventArgs e)
        {
            DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);  
        }

        //窗体加载
        private void Gy_UserByOrgRelation_Load(object sender, EventArgs e)
        {
            //设置动态URL
            oWeb.Url = ClsPub1.WEBSURL;
            //
            txtCzybm.ReadOnly = true;
            txtCzymc.ReadOnly = true;
            frmCondition = new frmBillQueryCondition_Base();
            initGrid();
            RefreshTool();
        }

        //初始化GRID
        private void initGrid()
        {
            DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
        }

        //刷新TOOLBAR
        private void RefreshTool()//Lock
        {
            if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_View)
            {
                stTab.SelectedIndex = 0;
                stTab.TabPages.Remove(this.tabPage2);
                stTab.TabPages.Remove(this.tabPage1);
                stTab.TabPages.Add(this.tabPage1);
                grdMain.Enabled = true;
                bj.Enabled = true;
                sc.Enabled = true;
                sx.Enabled = true;
                tc.Enabled = true;
            }
            else
            {
                stTab.SelectedIndex = 1;
                stTab.TabPages.Remove(this.tabPage1);
                stTab.TabPages.Remove(this.tabPage2);
                stTab.TabPages.Add(this.tabPage2);
                stTab.TabPages[0].Hide();
                grdMain.Enabled = false;
                bj.Enabled = false;
                sc.Enabled = false;
                sx.Enabled = false;
                tc.Enabled = true;
            }
        }

        private Int32 Fun_GetCol(string sCol)//Lock
        {
            return DBUtility.Gy_BaseFun.Fun_GetCol(sCol, grdMain);
        }

        //时间控件
        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            Display();
        }

        private void grdMain_DoubleClick(object sender, EventArgs e)
        {
            InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew;
            RefreshTool();
            ShowData();
        }

        #endregion


        #region 功能控件处理

        //编辑
        private void bj_Click(object sender, EventArgs e)
        {
            if (DBUtility.Gy_BaseFun.AllowRow(grdMain))
            {
                InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew;
                RefreshTool();
                ShowData();
            }
        }

        //读取类 到 控件
        private void ShowData()
        {
            LbYes.Items.Clear();
            LbNo.Items.Clear();
            sCzybm = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("用户编码")].Value);
            sCzymc = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("用户名称")].Value);
            try
            {
                txtCzybm.Text = sCzybm;
                txtCzymc.Text = sCzymc;

                //加载不属于组织
                DataSet oDs1 = oWeb.getDataSetBySQL("select a.HItemID,a.Hname from Xt_ORGANIZATIONS a with(nolock) left join Gy_UserByOrgRelation b with(nolock) on a.HItemID=b.HOrgID and (isnull(b.HUserID,'')='" + sCzybm + "' or isnull(b.HUserID,'')='')"
                + " where isnull(b.HItemID,'')=''", "Gy_UserByOrgRelation", ref ClsPub.sExeReturnInfo);

                if (oDs1.Tables[0].Rows.Count != 0)
                {
                    for (int i = 0; i <= oDs1.Tables[0].Rows.Count - 1; i++)
                    {
                        LbNo.Items.Add(oDs1.Tables[0].Rows[i][0].ToString().Trim() + "-" + oDs1.Tables[0].Rows[i][1].ToString().Trim());
                    }
                }
                //加载属于组织
                DataSet oDs2 = oWeb.getDataSetBySQL("select a.HItemID,a.Hname from Xt_ORGANIZATIONS a with(nolock) left join Gy_UserByOrgRelation b with(nolock) on a.HItemID=b.HOrgID and (isnull(b.HUserID,'')='" + sCzybm + "' or isnull(b.HUserID,'')='')"
                + " where isnull(b.HItemID,'')<>''", "Gy_UserByOrgRelation", ref ClsPub.sExeReturnInfo);

                if (oDs2.Tables[0].Rows.Count != 0)
                {
                    for (int i = 0; i <= oDs2.Tables[0].Rows.Count - 1; i++)
                    {
                        LbYes.Items.Add(oDs2.Tables[0].Rows[i][0].ToString().Trim() + "-" + oDs2.Tables[0].Rows[i][1].ToString().Trim());
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message, "提示");
                return;
            }
        }

        //删除
        private void sc_Click(object sender, EventArgs e)
        {
            if (DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HItemID")].Value) == 0)
            {
                MessageBox.Show("当前用户没有对应组织权限信息，无需删除", "提示");
                return;
            }
            else if (MessageBox.Show("确定要删除当前用户对应组织权限？" + grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("用户名称")].Value.ToString() + "，对应组织：" + grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("对应组织名称")].Value.ToString(), "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
            {
                return;
            }
            DeleteBill();
            Display();
        }

        private void DeleteBill()
        {
            try
            {
                oWeb.getRunProc("delete from Gy_UserByOrgRelation where HItemID=" + DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HItemID")].Value.ToString()), ref DBUtility.ClsPub.sExeReturnInfo);
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message, "提示");
                return;
            }
            MessageBox.Show("删除成功！", "提示");
        }

        //刷新
        private void xs_Click(object sender, EventArgs e)
        {
            Display();
        }

        //显示列表
        private void Display()
        {
            try
            {
                DataSet oDs = new DataSet();
                oDs = oWeb.getDataSetBySQL("select * from " + ViewName + " order by 用户名称", ViewName, 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.Gy_BaseFun.DisplayGrid(grdMain, this.Name);
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message, "提示");
                return;
            }
        }

        //退出模块
        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        //保存列宽
        private void bclk_Click(object sender, EventArgs e)
        {
            DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
        }

        //默认列宽
        private void mrlk_Click(object sender, EventArgs e)//Lock
        {
            DBUtility.ClsPub.DefaultGridView(grdMain);
            //参数解释  开始列 ，结束列，是否以最大列宽为准，最小列宽
            DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
        }

        #endregion


        #region 编辑界面控件处理

        //保存按钮
        private void cmdOK_Click(object sender, EventArgs e)
        {
            if (Save())
            {
                MessageBox.Show("保存完毕！", "提示");
            }
            else
            {
                MessageBox.Show("保存失败！原因：" + DBUtility.ClsPub.sExeReturnInfo, "提示");
            }
            if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_Modify)
            {
                InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View;
                RefreshTool();
            }
        }

        //保存
        private bool Save()
        {
            oWeb.getRunProc("delete from Gy_UserByOrgRelation where HUserID='" + sCzybm.ToString() + "'", ref DBUtility.ClsPub.sExeReturnInfo);
            for (int i = 0; i <= LbYes.Items.Count - 1; i++)
            {
                oWeb.getRunProc("insert into Gy_UserByOrgRelation (HBillType,HUserID,HOrgID) values ('','" + sCzybm.ToString() + "'," + ClsPub.isLong(Get_Code(this.LbYes.Items[i].ToString())) + ")", ref DBUtility.ClsPub.sExeReturnInfo);
            }
            Display();
            return true;
        }

        //拆分
        private string Get_Code(string sCode)
        {
            sCode = sCode.Trim();
            char c = Convert.ToChar("-");
            string[] s = sCode.Split(c);
            if (s.Length > 1)
            {
                return s[0].Trim();
            }
            else
            {
                return "0";
            }
        }

        //取消按钮
        private void cmdCancel_Click(object sender, EventArgs e)
        {
            InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View;
            RefreshTool();
        }

        //左移
        private void cmdLeft_Click(object sender, EventArgs e)
        {
            if (this.LbNo.SelectedItems.Count > 0)
            {
                int i = this.LbNo.SelectedIndex;
                this.LbYes.Items.Add(this.LbNo.SelectedItem.ToString());
                this.LbNo.Items.RemoveAt(i);
            }
        }

        //全部左移
        private void cmdAllLeft_Click(object sender, EventArgs e)
        {
            if (this.LbNo.Items.Count > 0)
            {
                for (int i = 0; i <= this.LbNo.Items.Count - 1; i++)
                {
                    this.LbYes.Items.Add(this.LbNo.Items[i].ToString());
                    this.LbNo.Items.RemoveAt(i);
                    i--;
                }
            }
        }

        //右移
        private void cmdRight_Click(object sender, EventArgs e)
        {
            if (this.LbYes.SelectedItems.Count > 0)
            {
                int i = this.LbYes.SelectedIndex;
                this.LbNo.Items.Add(this.LbYes.SelectedItem.ToString());
                this.LbYes.Items.RemoveAt(i);
            }
        }

        //全部右移
        private void cmdAllRight_Click(object sender, EventArgs e)
        {
            if (this.LbYes.Items.Count > 0)
            {
                for (int i = 0; i <= this.LbYes.Items.Count - 1; i++)
                {
                    this.LbNo.Items.Add(this.LbYes.Items[i].ToString());
                    this.LbYes.Items.RemoveAt(i);
                    i--;
                }
            }
        }

        #endregion


        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("未找到！！");
            }
        }






    }
}