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

namespace Pub_Control
{
    public partial class frmHlpInfoForBig : Form
    {
        public frmHlpInfoForBig()
        {
            InitializeComponent();
        }
        public string WherePart;
        public string sTitle;//根据该变量保存及显示过滤字段
        public string sBill;//表  视图
        public string sView;
        public string sLike;//过滤条件
        public string sOrderItem;//排序列
        public string sNumberColName;//代码列名称
        public string sNameColName;//名称列名称
        public int CurCol = 0;
        public int Cur2Col = 0;
        public string sOtherItem;//显示列
        TreeNode CurNode = new TreeNode();
        public Pub_Class.ClsPub.Enum_OKTag OKTag;
        Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();

        private void frmHlpInfoForBig_Load(object sender, EventArgs e)
        {
            initUI();
            initGrid();
            LoadTree();
            QueryText();
        }

        //设置过滤字段
        private void initUI()
        {
            //从本视图中读取可过滤字段并加载到组合框里
            SetViewConditionName();
            //从本地文件获取组合框默认字段
            SetCombColumn();
        }

        //从本地文件获取组合框默认字段
        private void SetCombColumn()
        { 
            char x = Convert.ToChar(",");
            char s = Convert.ToChar("|");

            string sStr1 = Pub_Class.ClsIni.ReadIni(sBill, "cmb1", Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            string sStr2 = Pub_Class.ClsIni.ReadIni(sBill, "cmb2", Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            string sStr3 = Pub_Class.ClsIni.ReadIni(sBill, "cmb3", Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            string sStr4 = Pub_Class.ClsIni.ReadIni(sBill, "cmb4", Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");

            string sStr5 = Pub_Class.ClsIni.ReadIni(sBill, "cmbvalue1", Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            string sStr6 = Pub_Class.ClsIni.ReadIni(sBill, "cmbvalue2", Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            string sStr7 = Pub_Class.ClsIni.ReadIni(sBill, "cmbvalue3", Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            string sStr8 = Pub_Class.ClsIni.ReadIni(sBill, "cmbvalue4", Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            if (sStr1 != "没有找到！")
            {
                cmbFindInfo.Text = sStr1;
            }
            else
            {
                cmbFindInfo.Text = "";
            }
            if (sStr2 != "没有找到！")
            {
                cmbFindInfo2.Text = sStr2;
            }
            else
            {
                cmbFindInfo2.Text = "";
            }
            if (sStr3 != "没有找到！")
            {
                cmbFindInfo3.Text = sStr3;
            }
            else
            {
                cmbFindInfo3.Text = "";
            }
            if (sStr4 != "没有找到！")
            {
                cmbFindInfo4.Text = sStr4;
            }
            else
            {
                cmbFindInfo4.Text = "";
            }
            //=====================================
            if (sStr5 != "没有找到！")
            {
                txtFindInfo.Text = sStr5;
            }
            if (sStr6 != "没有找到！")
            {
                txtFindInfo2.Text = sStr6;
            }
            if (sStr7 != "没有找到！")
            {
                txtFindInfo3.Text = sStr7;
            }
            if (sStr8 != "没有找到！")
            {
                txtFindInfo4.Text = sStr8;
            }

        }

        //根据视图加载视图的字段到组合框
        private void SetViewConditionName()
        {
            string[] tArray;
            DataSet Ds = new DataSet();
            int j;
            if (Pub_Class.ClsPub.isStrNull(sBill).Length == 0)
            {
                return;
            } 
            //得到视图 字段信息
            Ds = oCn.RunProcReturn("select column_name,data_type from information_schema.columns where table_name ='" + sBill.Trim() + "' order by  ORDINAL_POSITION", "information");
            //清空 
            cmbFindInfo.Items.Clear();
            cmbFindInfo2.Items.Clear();
            cmbFindInfo3.Items.Clear();
            cmbFindInfo4.Items.Clear();
            //
            for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
            {
                //grid1 
                if (Ds.Tables[0].Rows[i]["column_name"].ToString().Substring(0, 1).ToUpper() != "H")
                {
                    cmbFindInfo.Items.Add(Ds.Tables[0].Rows[i]["column_name"].ToString().Trim());
                    cmbFindInfo2.Items.Add(Ds.Tables[0].Rows[i]["column_name"].ToString().Trim());
                    cmbFindInfo3.Items.Add(Ds.Tables[0].Rows[i]["column_name"].ToString().Trim());
                    cmbFindInfo4.Items.Add(Ds.Tables[0].Rows[i]["column_name"].ToString().Trim());
                }
            }
            
            //
        }

        //初始化GRID
        private void initGrid()
        {


            grdShow.RowTemplate.Height = 18;
            grdShow.RowTemplate.MinimumHeight = 18;
            grdShow.ColumnHeadersHeight = 40;
            grdShow.RowHeadersVisible = false;
            grdShow.ColumnHeadersVisible = true;
            grdShow.ReadOnly = true;                         //只读--是
            //grdShow.RowCount = 1; 
            grdShow.RowsDefaultCellStyle.SelectionForeColor = Color.White;
            grdShow.RowsDefaultCellStyle.SelectionBackColor = Color.DarkCyan;
            grdShow.DefaultCellStyle.SelectionBackColor = Color.DarkCyan;
            grdShow.DefaultCellStyle.SelectionForeColor = Color.White;
            //grdShow.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;//网格内容 对齐方式
            grdShow.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;  //标题列 内容对齐方式
            grdShow.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

            grdShow.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //允许用户调整列宽
            grdShow.EnableHeadersVisualStyles = false;     //网格标题 样式
            grdShow.AllowUserToAddRows = false;             //是否允许自增--否
            grdShow.AllowUserToDeleteRows = false;          //是否允许删除--否 
            grdShow.AllowUserToResizeColumns = true;         //允许调整列宽--是
            grdShow.AllowUserToResizeRows = false;           //允许调整行高--否
            grdShow.AllowUserToOrderColumns = false;         //允许 拖拽列
            grdShow.BackgroundColor = Color.White;          //网格背景色
            grdShow.GridColor = Color.Gainsboro;             //网格线颜色
            grdShow.ShowCellToolTips = true;
            //grdShow.CellBorderStyle = DataGridViewCellBorderStyle.SingleVertical; //网格线样式：只有竖线
            grdShow.ColumnHeadersDefaultCellStyle.BackColor = Color.LightGray; //标题列 背景色
            grdShow.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText;  //剪贴板模式：
            //grdShow.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;grdShow.ShowCellToolTips = false;                                   //鼠标停留 显示提示
            grdShow.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;//网格内容 对齐方式
            //
            Pub_Class.ClsPub.GetGridView(grdShow, sBill, Pub_Class.ClsPub.AppPath);//设置列宽
        }

        //双击 GRID
        private void grdMain_DblClick(object sender, EventArgs e)
        {
            //if (AllowRow())
            if (grdShow.CurrentCell == null)
            {
                return;
            }
            BackData();
        }
        //时间TIMER
        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            this.Text = sTitle;
        }
        //返回
        private void BackData()
        {
            //保存过滤方案
            Pub_Class.ClsIni oIni = new Pub_Class.ClsIni();
            Pub_Class.ClsIni.WriteIni(sBill, "cmbvalue1", txtFindInfo.Text, Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            Pub_Class.ClsIni.WriteIni(sBill, "cmbvalue2", txtFindInfo2.Text, Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            Pub_Class.ClsIni.WriteIni(sBill, "cmbvalue3", txtFindInfo3.Text, Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            Pub_Class.ClsIni.WriteIni(sBill, "cmbvalue4", txtFindInfo4.Text, Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            Pub_Class.ClsIni.WriteIni(sBill, "cmb1", cmbFindInfo.Text, Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            Pub_Class.ClsIni.WriteIni(sBill, "cmb2", cmbFindInfo2.Text, Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            Pub_Class.ClsIni.WriteIni(sBill, "cmb3", cmbFindInfo3.Text, Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini");
            Pub_Class.ClsIni.WriteIni(sBill, "cmb4", cmbFindInfo4.Text, Pub_Class.ClsPub.AppPath + @"\" + "ControlInfo.ini"); 
            OKTag = Pub_Class.ClsPub.Enum_OKTag.OKTag_OK; 
            // 
            Pub_Class.ClsPub.SaveGridView(grdShow, sBill, Pub_Class.ClsPub.AppPath);
            //
            this.Visible = false;
        }
        //退出
        private void tc_Click(object sender, EventArgs e)
        {
            OKTag = Pub_Class.ClsPub.Enum_OKTag.OKTag_Cancel;
            this.Visible = false;
        }
        //返回按钮
        private void fh_Click(object sender, EventArgs e)
        {
            BackData();
        }
        //单击树形
        private void tvProcess_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            CurNode = e.Node;
            if (CurNode != null)
            {
                if (CurNode.Nodes.Count == 0)
                {
                    LoadAllNodes(CurNode);
                }
                QueryTree();
            }
        }
        //加载树型
        private void LoadTree()
        {
            try
            {
                tvTree.Nodes.Clear();
                tvTree.ImageList = imageList1;
                TreeNode sNode = tvTree.Nodes.Add("T0", this.Text, 0, 1);
                LoadAllNodes(sNode);
            }
            catch (Exception e)
            {
                MessageBox.Show(this, "加载树型失败！" + e.Message, "提示");
            }
        }
        //加载子项目
        private void LoadAllNodes(TreeNode sNode)
        {
            if (sNode != null)
            {
                try
                {
                    long sName = Convert.ToInt64(sNode.Name.Substring(1, sNode.Name.Length - 1));
                    sNode.Nodes.Clear();
                    DataSet Ds = oCn.RunProcReturn("select HItemID," + sNumberColName + " 代码," + sNameColName + " 名称 from " + sBill + " where HEndFlag=0 and   HParentID='" + sName + "'  order by " + sNumberColName , sBill);
                    for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
                    {
                        TreeNode oNode = sNode.Nodes.Add("T" + Ds.Tables[0].Rows[i]["HItemID"].ToString(),Ds.Tables[0].Rows[i]["代码"].ToString() + "~" + Ds.Tables[0].Rows[i]["名称"].ToString(), 0, 1);
                    }
                    sNode.Expand();
                }
                catch (Exception e)
                {
                    //MessageBox.Show("加载子项目失败！" + e.Message);
                }
            }
        }

        //保存列宽
        private void frmHlpInfoForBig_FormClosing(object sender, FormClosingEventArgs e)
        {
            //ClsPub.SaveGrid(grdMain, sTitle);
        }
        //过滤项目
        private void QueryText()
        {
            try
            {
                string sWhere = "";
                if (txtFindInfo.Text.Trim() != "" || txtFindInfo2.Text.Trim() != "" || txtFindInfo3.Text.Trim() != "" ||  txtFindInfo4.Text.Trim() != "")
                {
                    if(txtFindInfo.Text.Trim() != "" && cmbFindInfo.Text.Trim()!="")
                    {
                        sWhere =sWhere +  " and " + cmbFindInfo.Text + " like '%" + txtFindInfo.Text.Trim() + "%'";
                    }

                    if (txtFindInfo2.Text.Trim() != "" && cmbFindInfo2.Text.Trim() != "")
                    {
                        sWhere = sWhere + " and " + cmbFindInfo2.Text + " like '%" + txtFindInfo2.Text.Trim() + "%'";
                    }
                    if (txtFindInfo3.Text.Trim() != "" && cmbFindInfo3.Text.Trim() != "")
                    {
                        sWhere = sWhere +  " and " + cmbFindInfo3.Text + " like '%" + txtFindInfo3.Text.Trim() + "%'";
                    }
                    if (txtFindInfo4.Text.Trim() != "" && cmbFindInfo4.Text.Trim() != "")
                    {
                        sWhere = sWhere +  " and " + cmbFindInfo4.Text + " like '%" + txtFindInfo4.Text.Trim() + "%'";
                    }
                }
                else
                {
                    if (sLike.Trim() == "")
                    {
                        sWhere = " ";
                    }
                    else
                    {
                        sWhere = " ";
                    }
                }
                sWhere = sWhere + sLike;
                string sSQL = "Select " + sOtherItem + "  from " + sBill + " where  1=1  " + sWhere  + " " + sOrderItem;
                //编辑ofrm
                //
                ExecSQL(sSQL);
                return;
            }
            catch (Exception e)
            {
                MessageBox.Show("显示失败!"+e.Message );
                return;
            }
        }

        //执行SQL
        private void ExecSQL(string sSQL)
        {
            DataSet Ds = new DataSet();
            Ds = oCn.RunProcReturn(sSQL, sBill);
            grdShow.DataSource = Ds.Tables[0].DefaultView; 
            //隐藏H列
            string s = "";
            for (int i = 0; i < grdShow.ColumnCount; i++)
            {
                s = grdShow.Columns[i].HeaderText.Trim();
                if (s.Substring(0, 1).ToUpper() == "H")
                {
                    grdShow.Columns[i].Visible = false;
                }
                else
                {
                    grdShow.Columns[i].Visible = true;
                }
            }
            //获取列宽
            Pub_Class.ClsPub.GetGridView(grdShow, this.Name + this.sTitle, Pub_Class.ClsPub.AppPath);
        }

        //树形过滤项目
        private void QueryTree()
        {
            try
            {
                string sWhere = "";
                if (CurNode != null)
                {
                    char c = Convert.ToChar("~");
                    string[] s = CurNode.Text.Split(c);
                    Int64 ikey =Pub_Class.ClsPub.isLong(CurNode.Name.Substring(1, CurNode.Name.Length - 1));
                    if (s.Length > 1)
                    {
                        if (chkShowonly.Checked)
                        {
                            sWhere = "and " + sNumberColName + " like '" + s[0].Trim() + "%'";
                        }
                        else
                        {
                            sWhere = "and " + sNumberColName  + " like '" + s[0].Trim() + "%'";
                        }
                    }
                    else
                    {
                        sWhere = "";//选中 最大结点的时候
                    }
                }
                else
                {
                    sWhere = "";
                }
                sWhere = sWhere + sLike;
                string sSQL = "Select " + sOtherItem + "  from " + sBill + " where  HEndFlag=1  " + sWhere + " Order by " + sNumberColName + "   ";
                //编辑ofrm
                //
                ExecSQL(sSQL);
                return;
            }
            catch (Exception e)
            {
                MessageBox.Show("显示失败!" + e.Message);
                return;
            }
        }

        private void chkMH_CheckedChanged(object sender, EventArgs e)
        {
            QueryText();
        }

        private void cx_Click(object sender, EventArgs e)
        {
            QueryText();
        }

        private void grdShow_DoubleClick(object sender, EventArgs e)
        {
            if (grdShow.CurrentCell == null)
            {
                return;
            }
            BackData();
        }

        private void grdShow_Click(object sender, EventArgs e)
        {
            if (grdShow.CurrentCell == null)
            {
                return;
            }
            //if (grdShow.CurrentCell.ColumnIndex >= 0)
            //{
            //    lblFindCol.Text = grdShow.Columns[grdShow.CurrentCell.ColumnIndex].HeaderText;
            //    CurCol = grdShow.CurrentCell.ColumnIndex;
            //}
            //else
            //{
            //    lblFindCol.Text = grdShow.Columns[1].HeaderText;
            //    CurCol = 1;
            //}
        }

        private void txtFindInfo_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                QueryText();
            }
        }

        private void txtFindInfo_TextChanged(object sender, EventArgs e)
        {

        }

        private void grdShow_MouseClick(object sender, MouseEventArgs e)
        {
            if (grdShow.CurrentCell == null)
            {
                return;
            }
            if (e.Button == MouseButtons.Right)
            {
                if (grdShow.CurrentCell.ColumnIndex >= 0)
                {
                    lblFind2Col.Text = grdShow.Columns[grdShow.CurrentCell.ColumnIndex].HeaderText;
                    Cur2Col = grdShow.CurrentCell.ColumnIndex;
                }
                else
                {
                    lblFind2Col.Text = grdShow.Columns[1].HeaderText;
                    Cur2Col = 1;
                }
            }
        }

        private void txtFindInfo2_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                QueryText();
            }
        }

        private void bclk_Click(object sender, EventArgs e)
        {
            Pub_Class.ClsPub.SaveGridView(grdShow, this.Name + this.sTitle, Pub_Class.ClsPub.AppPath);
        }

        private void txtFindInfo3_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                QueryText();
            }
        }

        private void txtFindInfo4_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                QueryText();
            }
        }
 
    }
}