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

namespace NETERP
{
    public partial class Gy_DataInTmp : Form
    {
        

        public Gy_DataInTmp()
        {
            InitializeComponent();
        }

        //
        public  string ModCaption = "Êý¾Ýµ¼ÈëÄ£¿é";
        public  string ModName = "9999";
        public  string ModRightName = "Gy_DataInTmp";
        public  string ModRightNameEdit = "_Edit";
        public  string ModRightNameCheck = "_Check";
        public  string ModRightNameClose = "_Close";
        public  string ModRightNameDelete =  "_Delete";
        public  string ModRightNameMoney =  "_Money";
        public  string ModRightNameQty = "_Qty";
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();

        public string ExcelPath;
        public string sSheetName;

        #region  ¹Ì¶¨´úÂë

        //³õʼ»¯Íø¸ñ
        private void initGrid()
        { 
            DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
        }

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

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

        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        private void Gy_DataInTmp_Load(object sender, EventArgs e)
        {
            // 
            this.Text = ModCaption;
            lblCaption.Text = ModCaption;
            oSumGrid.ogrdMain = grdMain;  //³õʼ»¯ new
            oSumGrid.oGridsum = grdSum;
            initData();
            initGrid();
        }

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

        private void mrlk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
        }

        // 
        private void GraphLine()
        {
            long n = 0;
            //ÏÔʾ
            //lbldj.Text = "²éѯ³ö " + n.ToString() + " Õŵ¥¾Ý";
            lbljl.Text = "¹²ÓÐ " + grdMain.RowCount.ToString() + " Ìõ¼Ç¼";

        }

        //ºÏ¼Æ new
        private void Total()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.Total();
            }
        }

        //ºÏ¼Æ new
        private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
        {
            Total();
        }
        //ºÏ¼Æ new
        private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
        {
            Total();
        }


        private void cmdHPath_Click(object sender, EventArgs e)
        {
            OpenExcelFile.Title = "Open Excel File  ";
            OpenExcelFile.FileName = "";
            OpenExcelFile.Filter = "Microsoft Office Excel Files(*.xls)|*.xls";
            OpenExcelFile.ShowDialog();
            if (OpenExcelFile.FileName != "")
            {
                ExcelPath = OpenExcelFile.FileName;
                OpenExcelData();
            }
            else
            {
                ExcelPath = "";
            }
        }
         

        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
        }

        //
        public virtual bool OpenExcelData()
        {
            if (ExcelPath.Trim() == "")
            {
                MessageBox.Show("´íÎóµÄ·¾¶£¡");
                return false;
            }
            if (sSheetName.Trim() == "")
            {
                MessageBox.Show("´íÎóµÄ¹¤×÷²¾£¡");
                return false;
            }
            return DBUtility.Gy_BaseFun.OpenExcelData(ExcelPath, sSheetName, grdMain);
        }

        private void Out_Click(object sender, EventArgs e)
        {
            if (grdMain.Rows.Count == 0)
            {
                MessageBox.Show("ûÓпÉÒÔµ¼ÈëµÄÊý¾Ý£¡");
                return;
            }
            Sub_DataIn();
        }
        #endregion
        //

        


        #region  //´òÓ¡ÉèÖÃ

        GridppReport Report;

        private void set_Click(object sender, EventArgs e)
        {
            //Ñ¡Ôñ´òÓ¡Ä£°å
            BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
            oFrm.sBillName = ModName;
            oFrm.sBillModel = ModCaption;
            oFrm.ShowDialog();
        }

        private void dy_Click(object sender, EventArgs e)
        {
            //Ñ¡Ôñ´òÓ¡Ä£°å
            BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
            oFrm.sBillName = ModName;
            oFrm.sBillModel = ModCaption;
            oFrm.ShowDialog();
            if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
            {
                //
                Sub_SetReport(oFrm.sOpenTmp);
                Report.Print(true);
            }
        }

        //Ô¤ÀÀ
        private void yl_Click(object sender, EventArgs e)
        {
            //Ñ¡Ôñ´òÓ¡Ä£°å
            BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
            oFrm.sBillName = ModName;
            oFrm.sBillModel = ModCaption;
            oFrm.ShowDialog();
            if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
            {
                //
                Sub_SetReport(oFrm.sOpenTmp);
                Report.PrintPreview(true);
            }
        }

        private void Sub_SetReport(string sOpenTmp)
        {
            //ÅжÏÐÐÊý
            //
            Report = new GridppReport();
            Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf");  //here .
            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
        }

        private void ReportFetchRecordByDataTable()
        {
            BLL.Utility.FillRecordToReport(Report, grdMain, grdPrint, 0);
        }

        #endregion

        

        public virtual void Sub_DataIn()
        {
            return;
        }


        public virtual void initData()
        {
            ExcelPath = "";
        }
    }
}