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

namespace DBUtility
{
    public partial class frmHlpBillList : Form
    {
        public frmHlpBillList()
        {
            InitializeComponent();
        }
        public  string ViewName;
        public string tSQL;
        public frmBillQueryCondition_New frmCondition;
        public string sPrimaryCol;
        public Pub_Class.ClsPub.Enum_OKTag OKTag;
        public string sBillName="";
        //³õʼ»¯GRID
        private void initGrid()
        {
            grdMain.Cols = 1;
            grdMain.Rows = 1;
            grdMain.FixedCols = 1;
            grdMain.FixedRows = 1;
            
            //grdMain.ExplorerBar = VSFlex7.ExplorerBarSettings.flexExSortAndMove;
            grdMain.AllowBigSelection = false;
            grdMain.AllowSelection = true;
            grdMain.SelectionMode = VSFlex7.SelModeSettings.flexSelectionByRow;
            grdMain.ScrollTrack = true;
            grdMain.WordWrap = true;
            grdMain.set_ColWidth(-1, 1500);
            grdMain.set_RowHeight(-1, 400);
            grdMain.set_RowHeight(0, 500);
            grdMain.RowHeightMin = 250;
            grdMain.Editable = VSFlex7.EditableSettings.flexEDNone;
            grdMain.AllowUserResizing = VSFlex7.AllowUserResizeSettings.flexResizeBoth;
            grdMain.AllowUserFreezing = VSFlex7.AllowUserFreezeSettings.flexFreezeBoth;
            grdMain.set_FixedAlignment(-1, VSFlex7.AlignmentSettings.flexAlignCenterCenter);
            grdMain.AutoSizeMode = VSFlex7.AutoSizeSettings.flexAutoSizeColWidth;
            grdMain.GridLines = VSFlex7.GridStyleSettings.flexGridFlatVert;
        }
        //ÏÔʾÄÚÈÝ
        private void Display()
        {
            ClsCN SubCn = new ClsCN();
            DataSet DSet ;
            int AddCol = 1;
            grdMain.Rows = grdMain.FixedRows;
            string sSql = "";
            string sWhere =tSQL;
            //¹ýÂËÌõ¼þ
            if (frmCondition.SqlStr.Trim().Length == 0)
                return;
            sSql = frmCondition.SqlStr + sWhere ;
            //
            DSet = SubCn.RunProcReturn(sSql, ViewName);
            //Éú³ÉÊ×ÐбêÌâ
            if (DSet.Tables[0].Rows.Count == 0)
            {
                grdMain.Redraw = VSFlex7.RedrawSettings.flexRDBuffered;
                return;
            }
            //
            grdMain.Redraw = VSFlex7.RedrawSettings.flexRDNone;
            //
            grdMain.Cols = DSet.Tables[0].Columns.Count + grdMain.FixedCols + AddCol;
            grdMain.set_TextMatrix(0, grdMain.FixedCols - 1, "ÐòºÅ");
            grdMain.set_TextMatrix(0, grdMain.FixedCols - 1+AddCol, "Ñ¡Ôñ"); //ÉèÖà ×Ô¶¨ÒåÁÐ
            grdMain.set_ColWidth(0, 500);
            for (int i = 0; i <= DSet.Tables[0].Columns.Count - 1; i++)
            {
                grdMain.set_TextMatrix(0, i + grdMain.FixedCols + AddCol, DSet.Tables[0].Columns[i].Caption);
                if (DSet.Tables[0].Columns[i].Caption.ToLower().Substring(0, 1) == "h") //Ê××ÖĸΪhÔòÒþ²Ø
                {
                    grdMain.set_ColHidden(i + grdMain.FixedCols + AddCol, true);
                }
                else
                {
                    grdMain.set_ColHidden(i + grdMain.FixedCols + AddCol, false);
                    grdMain.set_ColWidth(i + grdMain.FixedCols + AddCol, 1000);
                }
            }

            //Ìî³äÍø¸ñ
            string s = "";
            grdMain.Rows = DSet.Tables[0].Rows.Count + grdMain.FixedRows;
            for (int i = 0; i <= DSet.Tables[0].Rows.Count - 1; i++)
            {
                grdMain.set_TextMatrix(i + grdMain.FixedRows, 0, (i + grdMain.FixedRows).ToString()); //ÐкÅ
                for (int j = 0; j <= DSet.Tables[0].Columns.Count - 1; j++)
                {
                    s = DSet.Tables[0].Rows[i][j].ToString();
                    grdMain.set_TextMatrix(i + grdMain.FixedRows, j + grdMain.FixedCols + AddCol, s);
                }
            }
            //ºÏ¼Æ
            grdMain.SubtotalPosition = VSFlex7.SubtotalPositionSettings.flexSTBelow;
            for (int i = 0; i <= DSet.Tables[0].Columns.Count - 1; i++)
            {
                if (DSet.Tables[0].Columns[i].DataType.ToString() == "System.Double" ||
                    DSet.Tables[0].Columns[i].DataType.ToString() == "System.Single" ||
                    DSet.Tables[0].Columns[i].DataType.ToString() == "System.Decimal"
                    )
                {
                    //ÈôΪÊýÖµÔò ÓÒ¶ÔÆë²¢ÇҺϼÆ
                    grdMain.set_ColFormat(i + grdMain.FixedCols + AddCol, "###,###,##0.##");
                    grdMain.Subtotal(VSFlex7.SubtotalSettings.flexSTSum, -1, i + grdMain.FixedCols + AddCol, "###,###,##0.00", 15197644, 0, true, "ºÏ¼Æ", 2, false);
                    grdMain.set_ColAlignment(i + grdMain.FixedCols + AddCol, VSFlex7.AlignmentSettings.flexAlignRightCenter);
                }
                else if (DSet.Tables[0].Columns[i].DataType.ToString() == "System.Int16" ||
                        DSet.Tables[0].Columns[i].DataType.ToString() == "System.Int32" ||
                        DSet.Tables[0].Columns[i].DataType.ToString() == "System.Int64")
                {
                    //ÈôΪÊýÖµÔò ÓÒ¶ÔÆë²¢ÇҺϼÆ
                    grdMain.Subtotal(VSFlex7.SubtotalSettings.flexSTSum, -1, i + grdMain.FixedCols + AddCol, 0, 15197644, 0, true, "ºÏ¼Æ", 2, false);
                    grdMain.set_ColAlignment(i + grdMain.FixedCols + AddCol, VSFlex7.AlignmentSettings.flexAlignRightCenter);
                }
                else
                {
                    //·ÇÊýÖµ Ôò×ó¶ÔÆë
                    grdMain.set_ColAlignment(i + grdMain.FixedCols + AddCol, VSFlex7.AlignmentSettings.flexAlignLeftCenter);
                }
            }
            //¹Ì¶¨ÐÐ Öмä¶ÔÆë
            grdMain.set_FixedAlignment(-1, VSFlex7.AlignmentSettings.flexAlignCenterCenter);
            //¼ÓÔØÁпí
            ClsPub.GetGrid(this.grdMain, this.Name,ClsPub.AppPath);
            //»­Ïß
            GraphLine();
            //
            grdMain.FrozenCols = 2;
            grdMain.Redraw = VSFlex7.RedrawSettings.flexRDBuffered;
        }

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

        private void tc_Click(object sender, EventArgs e)
        {
            OKTag = Pub_Class.ClsPub.Enum_OKTag.OKTag_Cancel;
            this.Visible = false;
        }

        private void sx_Click(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }
        //ÕÒµ½¶ÔÓ¦ÁÐ
        public Int32 Fun_GetCol(string sCol)
        {
            for (int c = 0; c < grdMain.Cols; c++)
            {
                if (ClsPub.isStrNull(grdMain.get_TextMatrix(0, c)).ToUpper().Trim() == sCol.Trim().ToUpper())
                {
                    return c;
                }
            }
            return 0;
        }

        private void frmHlpBillList_Load(object sender, EventArgs e)
        {
            frmCondition = new frmBillQueryCondition_New();
            initGrid();
        }

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

        private void bclk_Click(object sender, EventArgs e)
        {
            //±£´æÁпí
            ClsPub.SaveGrid(grdMain, this.Name, ClsPub.AppPath);
        }

        private void mrlk_Click(object sender, EventArgs e)
        {
            grdMain.AutoSize(0, grdMain.Cols - 1, false, 1);
            //²ÎÊý½âÊÍ  ¿ªÊ¼ÁÐ £¬½áÊøÁУ¬ÊÇ·ñÒÔ×î´óÁпíΪ׼£¬×îСÁпí
            ClsPub.SaveGrid(grdMain, this.Name, ClsPub.AppPath);
        }
        //»®Ïß
        private void GraphLine()  //Lock
        {
            //ÕÒµ½Ö÷±íIDºÍ×Ó±íIDµÄ ·¶Î§
            int MainIDCol = Fun_GetCol("hmainid");
            int SubIDCol = Fun_GetCol("hsubid");
            long HMainID = 0;
            //Ñ­»·ËùÓÐÐÐ
            for (int i = grdMain.FixedRows; i < grdMain.Rows - 1; i++)
            {
                if (HMainID == 0)
                {
                    HMainID = ClsPub.isLong(grdMain.get_ValueMatrix(i, MainIDCol).ToString());
                }
                else
                {
                    if (HMainID == ClsPub.isLong(grdMain.get_ValueMatrix(i, MainIDCol).ToString()))
                    {
                        //grdMain.set_Cell(VSFlex7.CellPropertySettings.flexcpText, i, MainIDCol + 1, i, SubIDCol - 1, "");

                    }
                    else
                    {
                        HMainID = ClsPub.isLong(grdMain.get_ValueMatrix(i, MainIDCol).ToString());
                        grdMain.Select(i, grdMain.FixedCols, i, grdMain.Cols - 1);
                        grdMain.CellBorder(16755034, 0, 1, 0, 0, 0, 0);
                    }
                }
            }
        }
        //ÊÇ·ñÔÊÐí·µ»Ø
        private bool AllowBack()  //Lock
        {
            string stmp="";
            int PrimaryCol;
            int SelectCol = Fun_GetCol("Ñ¡Ôñ");
            if (sPrimaryCol.Trim() != "")
            {
                PrimaryCol = Fun_GetCol(sPrimaryCol);
                if (PrimaryCol == 0)
                {
                    return true;
                }
                else
                {
                    for (int i = grdMain.FixedRows; i < grdMain.Rows; i++)
                    {
                        if (ClsPub.isStrNull(grdMain.get_TextMatrix(i, SelectCol)) == "*")
                        {
                            if (stmp == "")
                            {
                                stmp = ClsPub.isStrNull(grdMain.get_TextMatrix(i, PrimaryCol));
                            }
                            if(stmp!=ClsPub.isStrNull(grdMain.get_TextMatrix(i, PrimaryCol)))
                                return false;
                        }
                    }
                }
            }
            else
            {
                return true;
            }
            return true;
        }
        //·µ»ØÐÅÏ¢
        private void Sub_DataBack()
        {
            if (!AllowBack())
            {
                MessageBox.Show("²»ÔÊÐíÑ¡Ôñ²»Í¬µÄ" + sPrimaryCol + "£¡", "Ìáʾ");
                return;
            }
            OKTag = Pub_Class.ClsPub.Enum_OKTag.OKTag_OK;
            this.Visible = false;
        }
        //
        private void fh_Click(object sender, EventArgs e)
        {
            Sub_DataBack();
        }
        //Ñ¡ÖÐÐÐ
        private void Sub_SelectRow()
        {
            int SelectCol = Fun_GetCol("Ñ¡Ôñ");
            int BRow, ERow;
            if (grdMain.Row >= grdMain.RowSel)
            {
                BRow = grdMain.RowSel;
                ERow = grdMain.Row;
            }
            else
            {
                ERow = grdMain.RowSel;
                BRow = grdMain.Row;
            }
            for (int i = BRow; i <= ERow; i++)
            {
                grdMain.set_TextMatrix(i, SelectCol, "*");
            }
        }
        //
        private void xz_Click(object sender, EventArgs e)
        {
            Sub_SelectRow();
        }
        //
        private void Sub_ClearRow()
        {
            int SelectCol = Fun_GetCol("Ñ¡Ôñ");
            int BRow, ERow;
            if (grdMain.Row >= grdMain.RowSel)
            {
                BRow = grdMain.RowSel;
                ERow = grdMain.Row;
            }
            else
            {
                ERow = grdMain.RowSel;
                BRow = grdMain.Row;
            }
            for (int i = BRow; i <= ERow; i++)
            {
                grdMain.set_TextMatrix(i, SelectCol, "");
            }
        }
        //
        private void qc_Click(object sender, EventArgs e)
        {
            Sub_ClearRow();
        }

        private void timer2_Tick(object sender, EventArgs e)
        {
            timer2.Enabled = false;
            frmCondition = new frmBillQueryCondition_New();
            frmCondition.Tag = "";
            frmCondition.ViewName = ViewName;
            frmCondition.ModName = this.Name;
            frmCondition.ShowDialog();
            if (frmCondition.Tag.ToString() == "OK")
            {
                timer1.Enabled = true;
            }
        }
        //
        private void grdMain_DblClick(object sender, EventArgs e)
        {
            int SelectCol = Fun_GetCol("Ñ¡Ôñ");
            if (grdMain.Row >= grdMain.FixedRows && grdMain.Row <= grdMain.Rows - 2)
            {
                if (ClsPub.isStrNull( grdMain.get_TextMatrix(grdMain.Row, SelectCol)) == "*")
                {
                    grdMain.set_TextMatrix(grdMain.Row, SelectCol, "");
                }
                else
                {
                    grdMain.set_TextMatrix(grdMain.Row, SelectCol,"*") ;
                }
            }
        }
    }
}