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

namespace WorkM
{
    public partial class Sc_WorkProcReport : Form   //简单报表－直接有一个存储过程＋简单过滤，返回生成报表
    {
        public Sc_WorkProcReport()
        {
            InitializeComponent();
        }
        public string ModName = "";
        public string ModCaption = "生产进度跟踪表";


        #region 固定代码

        private void initGrid()
        {
            DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
        }
        //得到对应列
        private int Fun_GetCol(string sColName)
        {
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sColName, grdMain);
        }

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

        Sc_WorkProcReportDlg oDlg = new Sc_WorkProcReportDlg();
        private void cx_Click(object sender, EventArgs e)
        {
            oDlg.ShowDialog();
            if (oDlg.IsOk == 1)
            {
                timer1.Enabled = true;
            }
        }

        //设置报表名称
        private void SetFormCaption()
        {
            this.Text = ModCaption;
            lblCaption.Text = this.Text;
            initGrid();//网格标题初始化
            initHeadCaption();//表头初始化
        }


        private void Frm_EasyReport_Load(object sender, EventArgs e)
        {
            SetFormCaption();
        }


        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled = false;
            if (Fun_AllowQuery())
            {
                initGrid();
                //显示等待框
                DBUtility.Xt_Wait oFrm = new DBUtility.Xt_Wait();
                oFrm.Show();
                System.Windows.Forms.Application.DoEvents();
                Display();
                System.Windows.Forms.Application.DoEvents();
                oFrm.Close();
                oFrm.Dispose();
            }
        }

        private void Xs_SellOutDayReport_KeyUp(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)//按回车刷新
                timer1.Enabled = true;
        }

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

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

        //打印
        private void dy_Click(object sender, EventArgs e)
        {
            Sub_SetReport();
            Report.Print(true);
        }
        //预览
        private void view_Click(object sender, EventArgs e)
        {
            Sub_SetReport();
            Report.PrintPreview(true);
        }
       
        #endregion

        #region 界面处理
        //初始化表头显示
        private void initHeadCaption()
        {
           
        }

        private bool Fun_AllowQuery()//审核查询条件
        {
            //查询必录项目
            //if (txtHBDeptID.Text.Trim().Length == 0)
            //{
            //    MessageBox.Show(this, "请选择开始部门！", "提示");
            //    return false;
            //}
            return true;
        }

        private void Display()
        {
            SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
            DataSet DSet ;
            
            //显示报表头 标题
            
            //停止GRID刷新 加快速度
            DBUtility.Xt_BaseBillFun.IsRedraw(grdMain, false); 
            grdMain.Rows = grdMain.FixedRows;
            //过滤条件Dlg
            string sDlgWhere = "";
            //sDlgWhere = sDlgWhere + ",2011";
            //sDlgWhere = sDlgWhere + ",10";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHSeOrderBillNo.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHICMOBillNo.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHBMaterID.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHEMaterID.Text.Trim() + "'";
            //处理SQL过滤语句
            DBUtility.Gy_BaseFun.SetSQLWhere_Rtp(ref sDlgWhere);
            //
            DSet = SubCn.RunProcReturn("exec h_p_Sc_WorkProcReport_K3 " + sDlgWhere, "Gy_Czygl");
            //生成首行标题
            if (DSet==null  )
            {
                DBUtility.Xt_BaseBillFun.IsRedraw(grdMain, true); 
                MessageBox.Show("没有返回任何数据！" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            //填充网格
            DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, DSet);
            //得到MAINIDCOL,SUBIDCOL
            int HMainIDCol = 0;
            int HSubIDCol = 0;
            HMainIDCol = DBUtility.Xt_BaseBillFun.Fun_GetCol("HMainID", grdMain);
            HSubIDCol = DBUtility.Xt_BaseBillFun.Fun_GetCol("HSubID", grdMain);
            //普通网格合计
            DBUtility.Xt_BaseBillFun.GridTotal(grdMain, DSet);
            //特殊合计 
            //设置网格列宽
            DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name);
            //划线
            DBUtility.Xt_BaseBillFun.GraphLine(grdMain, HMainIDCol, HSubIDCol);
            //恢复grid刷新
            DBUtility.Xt_BaseBillFun.IsRedraw(grdMain, true); 
        }

        #endregion

        #region 打印设置

        //打印设置
        GridppReport Report;
        //设置打印模版路径
        private void Sub_SetReport()
        {
            Report = new GridppReport();
            Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\Report\生产进度跟踪表.grf");  //here .
            Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
        }
        //填入单据表头信息
        private void ReportBeforePostRecord()//your report?kao
        {
            //Report.FieldByName("HDateItemID").AsString = lblHDateItemID.Text;
            //Report.FieldByName("CusNumber").AsString = lblHCusNumber.Text;
            //Report.FieldByName("CusName").AsString = lblHCusName.Text;
            //Report.FieldByName("BeginBalance").AsString = lblHBeginBalance.Text;
        }
        //填入单据明细信息
        private void ReportFetchRecordByDataTable()
        {
            //BLL.Utility.FillRecordToReport(Report, grdMain, grdMain,0,);
        }
        #endregion

        #region 数据导出
         
        private void yc_Click(object sender, EventArgs e)
        {
              
        }
        #endregion

       
        //初次进入 查询
        private void timer2_Tick(object sender, EventArgs e)
        {
            timer2.Enabled = false;
            oDlg.ShowDialog();
            if (oDlg.IsOk == 1)
            {
                timer1.Enabled = true;
            }
        }
    }
}