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

namespace HuanXin.ERP
{
    public partial class CH_PoStockInCheckCount : Form
    {
        public CH_PoStockInCheckCount()
        {
            InitializeComponent();
        }
        public Pub_Control.frmBillQueryCondition_Base frmCondition;
        const string ViewName = "h_v_CH_PoStockInCheckCount";
        const string ModCaption = "外购入库核算";
        public const string ModRightName = "CH_PoStockInCheckCount";
        public const string ModRightNameEdit = ModRightName + "_Edit";
        public const string ModRightNameCheck = ModRightName + "_Check";
        public const string ModRightNameClose = ModRightName + "_Close";
        public const string ModRightNameDelete = ModRightName + "_Delete";
        //ClsCg_InvoiceBillMain oBill = new ClsCg_InvoiceBillMain();
        //public Cg_InvoiceBill oFrm;
        //
        private void initGrid()
        {
            //

            grdMain.RowTemplate.Height = 18;
            grdMain.RowTemplate.MinimumHeight = 18;
            grdMain.ColumnHeadersHeight = 35;
            grdMain.RowHeadersVisible = false;
            grdMain.ColumnHeadersVisible = true;
            grdMain.ColumnCount = 0;
            grdMain.RowCount = 0;
            //格式化
            //表格设置
            grdMain.RowsDefaultCellStyle.SelectionForeColor = Color.White;
            grdMain.RowsDefaultCellStyle.SelectionBackColor = Color.DarkCyan;
            grdMain.DefaultCellStyle.SelectionBackColor = Color.DarkCyan;
            grdMain.DefaultCellStyle.SelectionForeColor = Color.White;
            grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
            grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            grdMain.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            grdMain.ReadOnly = true;
            grdMain.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //允许用户调整列宽
            grdMain.EnableHeadersVisualStyles = false;     //网格标题 样式
            grdMain.AllowUserToAddRows = false;             //是否允许自增--否
            grdMain.AllowUserToDeleteRows = false;          //是否允许删除--否 
            grdMain.AllowUserToResizeColumns = true;         //允许调整列宽--是
            grdMain.AllowUserToResizeRows = false;           //允许调整行高--否
            grdMain.AllowUserToOrderColumns = false;         //允许 拖拽列
            grdMain.BackgroundColor = Color.White;
            grdMain.GridColor = Color.SeaShell;             //网格线颜色
            grdMain.ShowCellToolTips = true;
            grdMain.CellBorderStyle = DataGridViewCellBorderStyle.RaisedVertical;
            //
            ClsPub.GetGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);//设置列宽
        }
        //

        private void Display()
        {
            ClsCN SubCn = new ClsCN();
            DataSet DSet ;
            string sSql = "";
            string sWhere = "";
            //过滤条件
            if (frmCondition.SqlStr.Trim().Length == 0)
                return;
            sSql = frmCondition.SqlStr + sWhere + " order by 发票号码 desc,hsubid ";
            //
            DSet = SubCn.RunProcReturn(sSql, "h_v_CH_PoStockInCheckCount",ref ClsPub.sExeReturnInfo);
            //生成首行标题
            if (DSet == null)
            {
                MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询！"+ClsPub.sExeReturnInfo);
                return;
            }
            //
            for (int i = 0; i < grdMain.ColumnCount; i++)
            {
                grdMain.Columns[i].Frozen = false;
            }
            //
            grdMain.DataSource = DSet.Tables[0].DefaultView;
            
            //合计
            //grdMain.Rows.Add();
             
            //加载列宽,隐藏列
            for (int i = 0; i < grdMain.ColumnCount; i++)
            {
                grdMain.Columns[i].Width = 100;
                //if (frmCondition.cmbHComplete.Text == "否")
                //{
                //    grdMain.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
                //}
                //else
                //{
                //    grdMain.Columns[i].SortMode = DataGridViewColumnSortMode.Automatic;
                //}

                if (grdMain.Columns[i].HeaderText.Substring(0, 1).ToLower() == "h")
                {
                    grdMain.Columns[i].Visible = false;
                }
                else
                {
                    grdMain.Columns[i].Visible = true ;
                }
            }
            ClsPub.GetGridView(this.grdMain, this.Name, DBUtility.ClsPub.AppPath);
            //画线
            GraphLine();
            //冻结
            int FrCol = ClsPub.isInt(frmCondition.txtFrozenCol.Text);
            if ( FrCol < grdMain.ColumnCount)
            {
                grdMain.Columns[FrCol].Frozen = true;
            }
            // 
        }

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

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

        private void sx_Click(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }

        private void dj_Click(object sender, EventArgs e)
        {
            Sub_ShowBill();
        }

        private void Sub_ShowBill()
        {
            
        }

        private Int32 Fun_GetCol(string sCol)
        {
            for (int c = 0; c < grdMain.ColumnCount; c++)
            {
                if (ClsPub.isStrNull(grdMain.Columns[c].HeaderText).ToUpper().Trim() == sCol.Trim().ToUpper())
                {
                    return c;
                }
            }
            return 0;
        }

        private void CH_PoStockInCheckCount_Load(object sender, EventArgs e)
        {
            //
            frmCondition = new Pub_Control.frmBillQueryCondition_Base();
            this.Text = ModCaption;
            lblCaption.Text = ModCaption;
            initGrid();
        }

        
        private void cx_Click(object sender, EventArgs e)
        {
            frmCondition = new Pub_Control.frmBillQueryCondition_Base();
            frmCondition.Tag = "";
            frmCondition.ViewName = ViewName;
            frmCondition.ModName = this.Name;
            frmCondition.ShowDialog();
            if (frmCondition.Tag.ToString() == "OK")
            {
                Display();
            }
        }

        private void xz_Click(object sender, EventArgs e)
        {
            // 
        }

        private void sc_Click(object sender, EventArgs e)
        {
            Sub_DeleteBill();
        }
        //删除
        private void Sub_DeleteBill()
        {
           
        }

        private void timer2_Tick(object sender, EventArgs e)
        {
            timer2.Enabled = false;
            frmCondition = new Pub_Control.frmBillQueryCondition_Base();
            frmCondition.Tag = "";
            frmCondition.ViewName = ViewName;
            frmCondition.ModName = this.Name;
            frmCondition.ShowDialog();
            if (frmCondition.Tag.ToString() == "OK")
            {
                timer1.Enabled = true;
            }
        }

        private void yl_Click(object sender, EventArgs e)
        {

        }

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

        private void mrlk_Click(object sender, EventArgs e)
        {
            ClsPub.DefaultGridView(grdMain);
            //参数解释  开始列 ，结束列，是否以最大列宽为准，最小列宽
            ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
        }
        //划线
        private void GraphLine()
        {
            //找到主表ID和子表ID的 范围
            int MainIDCol = Fun_GetCol("hmainid");
            int SubIDCol = Fun_GetCol("hsubid");
            long HMainID = 0;
            bool b = false;
            long n = 0;
            //循环所有行
            for (int i = 0; i<grdMain.RowCount; i++)
            {
                if (HMainID == 0)
                {
                    HMainID = ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value); 
                    n++;
                }
                else
                {
                    //if (frmCondition.cmbHComplete.Text == "否")
                    //{
                        if (HMainID == ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value))
                        {
                            //区域性清空
                            SetDataGrid(i, MainIDCol + 1, i, SubIDCol - 1, "");
                        }
                        else
                        {
                            HMainID = ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value);
                            b = !b;
                            n++;
                        }
                    //}
                    //else
                    //{
                    //    HMainID = ClsPub.isLong(grdMain.Rows[i].Cells[MainIDCol].Value);
                    //    b = !b;
                    //    n++;
                    //}
                }
                if (b)
                {
                    grdMain.Rows[i].DefaultCellStyle.BackColor = Color.White;
                }
                else
                {
                    grdMain.Rows[i].DefaultCellStyle.BackColor = Color.Lavender;
                }
            }
            //显示
            lbldj.Text = "查询出 " + n.ToString() + " 张单据";
            lbljl.Text="共有 "+grdMain.RowCount.ToString()+" 条记录";
        }
        //设置网格
        private void SetDataGrid(int BRow, int BCol, int ERow, int ECol, string sText)
        {
            for (int i = BRow; i <= ERow; i++)
            {
                for (int j = BCol; j <= ECol; j++)
                {
                    grdMain.Rows[i].Cells[j].Value = DBNull.Value;
                }
            }

        }

        //审核
        private void sh_Click(object sender, EventArgs e)
        {
            this.Sub_CheckBill();
        }
        //审核单据
        private void Sub_CheckBill()
        {
            
        }
        //反审单据
        private void Sub_AbandonCheck()
        {
             
        }
        //反审核
        private void qsh_Click(object sender, EventArgs e)
        {
            Sub_AbandonCheck();
        }

        private void grdMain_DoubleClick(object sender, EventArgs e)
        {
            Sub_ShowBill();
        }

        private void grdMain_Paint(object sender, PaintEventArgs e)
        {
            GraphicsGrid();
        }

        private void GraphicsGrid()
        {

            Graphics g = grdMain.CreateGraphics();
            Pen p = new Pen(Color.Black);
            p.Width = 1;
            int lWidth;
            if (grdMain.RowHeadersVisible)
                lWidth = grdMain.RowHeadersWidth;
            else
                lWidth = 0;
            foreach (DataGridViewColumn col in grdMain.Columns)
            {
                lWidth += col.Width;
            }
            int sWidth;
            if (grdMain.ColumnHeadersVisible)
                sWidth = grdMain.ColumnHeadersHeight;
            else
                sWidth = 0;
            foreach (DataGridViewRow col in grdMain.Rows)
            {
                sWidth += col.Height;
                if (col.Index == grdMain.RowCount - 1)
                {
                    g.DrawLine(p, new Point(0, sWidth), new Point(lWidth, sWidth));
                }
            }
        }

    }
}