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 gregn6Lib;
using DBUtility;

namespace APSM
{
    public partial class Sc_PlanMaterReadyAnalyse : Form   //简单报表－直接有一个存储过程＋简单过滤，返回生成报表
    {
        public Sc_PlanMaterReadyAnalyse()
        {
            InitializeComponent();
        }
        public string ModName = "";
        public string ModCaption = "物料齐套分析"; 
        public bool grdStatus;

        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();

        #region 固定代码 

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

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

        K3_ICMOSetWorkCenterListDlg oDlg = new K3_ICMOSetWorkCenterListDlg();
        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();

            oSumGrid.ogrdMain = grdMain;  //初始化 new
            oSumGrid.oGridsum = grdSum;
        }


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

        private void Xs_SellOutPriceReport_KeyUp(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
                timer1.Enabled = true;
        }

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

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

        //打印
        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()//审核查询条件
        {
            return true;
        }

        private void Display()
        {
            SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
            DataSet DSet = new DataSet();
            //显示报表头 标题
             
            //显示过滤条件
            //过滤条件Dlg
            string sDlgWhere = "";
            sDlgWhere = sDlgWhere + ",'" + oDlg.dtpHBDate.Value + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.dtpHEDate.Value + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHBDeptID.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHEDeptID.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHBMaterID.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHEMaterID.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHBSellNo.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHESellNo.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHBICMONo.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + oDlg.txtHEICMONo.Text.Trim() + "'";
            if (sDlgWhere.Trim().Length > 0)
            {
                sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1);
            }
            DSet = SubCn.RunProcReturn("exec h_p_Sc_PlanMaterReadyAnalyse " + sDlgWhere, "Gy_Czygl",ref DBUtility.ClsPub.sExeReturnInfo);
            //生成首行标题
            if (DSet == null)
            {
                MessageBox.Show("没有返回任何结果,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            //
            grdMain.DataSource = DSet.Tables[0].DefaultView;
            //设置合计列
            string sTotalCol = "";
            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
            string[] sT;
            sT = sTotalCol.Split(Convert.ToChar(","));
            oSumGrid.BuildTotalCols(sT);
            //  
            DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, "是", 0);
            //
            grdMain.Columns[DBUtility.Xt_BaseBillFun.Fun_GetCol("工作中心",grdMain)].ReadOnly = true;
            //保留小数
            grdMain.Columns[DBUtility.Xt_BaseBillFun.Fun_GetCol("任务单数量", grdMain)].DefaultCellStyle.Format = "###,###,###.00";
            
            DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name);
            Total();
            SubCn.CnClose();
            SubCn.CnDispose();
        }

        #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
        {
            //try
            //{
            //    Report.FieldByName("HDateItemID").AsString = lblHDateItemID.Text;
            //    Report.FieldByName("CusNumber").AsString = lblHCusNumber.Text;
            //    Report.FieldByName("CusName").AsString = lblHCusName.Text;
            //    Report.FieldByName("BeginBalance").AsString = lblHBeginBalance.Text;
            //}
            //catch (Exception e)
            //{
            //    MessageBox.Show("打印失败!表头：" + e.Message);
            //}
        }
        //填入单据明细信息
        private void ReportFetchRecordByDataTable()
        {
            //
        }
        #endregion
         
         

        private void timer2_Tick(object sender, EventArgs e)
        {
            timer2.Enabled = false;
            oDlg.ShowDialog();
            if (oDlg.IsOk == 1)
            {
                timer1.Enabled = true;
            }
        } 
        //帮助函数
        private void Sub_GridKey(int sKeyCode, int sRow, int sCol, DataGridViewTextBoxEditingControl oEdit)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DAL.ClsGy_WorkCenter_View oWork = new DAL.ClsGy_WorkCenter_View();
            int HCenterNumberCol = Fun_GetCol("工作中心");
            int HCenterIDCol = Fun_GetCol("工作中心代码");
            int HInterIDCol = Fun_GetCol("h任务单ID");
            int HBillNoCol = Fun_GetCol("生产任务单号");
            int HBeginDateCol = Fun_GetCol("最迟开工日期");
            int HEndDateCol = Fun_GetCol("最迟完工日期");
            //if (!grdStatus)
            //{
            //    return;
            //} 
            switch (sKeyCode)
            {
                case 118:          //F7
                    {
                        if (sCol == HCenterNumberCol)
                        {
                            oWork.WherePart = "";
                            if (oWork.RefreshView())
                            {
                                grdMain.Rows[sRow].Cells[HCenterIDCol].Value = oWork.oModel.HItemID.ToString();
                                grdMain.Rows[sRow].Cells[HCenterNumberCol].Value = oWork.oModel.HName;
                                //oEdit.Text = oWork.HNumber;
                                //改为DAL类处理
                                oCn.RunProc("delete Sc_ICMOBillMain_Extend where hinterid=" + grdMain.Rows[sRow].Cells[HInterIDCol].Value);
                                oCn.RunProc("insert into Sc_ICMOBillMain_Extend (HInterID,HBillNo,HCenterID,HCenterNumber,HBeginDate,HEndDate,HLevNum,HReadyQty) "+
                                            "values(" + grdMain.Rows[sRow].Cells[HInterIDCol].Value + ",'" + grdMain.Rows[sRow].Cells[HBillNoCol].Value +
                                            "'," + grdMain.Rows[sRow].Cells[HCenterIDCol].Value + ",'" + grdMain.Rows[sRow].Cells[HCenterNumberCol].Value +
                                            "','" + grdMain.Rows[sRow].Cells[HBeginDateCol].Value + "','" + grdMain.Rows[sRow].Cells[HEndDateCol].Value + "',0,0)");
                            }
                            else
                            {
                                grdMain.Rows[sRow].Cells[HCenterIDCol].Value = 0;
                                grdMain.Rows[sRow].Cells[HCenterNumberCol].Value = "";
                                //oEdit.Text = "";
                            }
                        }
                        break;
                    }
                case 117:  //F6
                    MessageBox.Show("此功能尚未开放！", "提示");
                    break;
                default:
                    break;
            }
        }
        DataGridViewTextBoxEditingControl EditingControl;
        //网格按键事件
        private void grdMain_KeyDownEdit(object sender, KeyEventArgs e)
        {
            Sub_GridKey(e.KeyValue, grdMain.CurrentRow.Index, grdMain.CurrentCell.ColumnIndex, EditingControl);

        }
        //网格按键事件
        private void grdMain_KeyDownEvent(object sender, KeyEventArgs e)
        {
            Sub_GridKey(e.KeyValue, grdMain.CurrentRow.Index, grdMain.CurrentCell.ColumnIndex, EditingControl);
        }

        private void grdMain_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            if (grdMain.CurrentCell != null)
            {
                if (e.Control is DataGridViewTextBoxEditingControl)
                {
                    this.EditingControl = (DataGridViewTextBoxEditingControl)e.Control;
                    //增加委托处理 
                    this.EditingControl.KeyDown += new KeyEventHandler(this.EditingControl_KeyDown);
                }
            } 
        }
        private void EditingControl_KeyDown(object sender, KeyEventArgs e)
        {
            //业务处理 
            Sub_GridKey(e.KeyValue, grdMain.CurrentRow.Index, grdMain.CurrentCell.ColumnIndex, EditingControl);
        }

        private void grdMain_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
             
            if (this.EditingControl != null)
            {
                EditingControl.KeyDown -= new KeyEventHandler(this.EditingControl_KeyDown);
                this.EditingControl = null;
            }
        }

        private void grdMain_CellLeave(object sender, DataGridViewCellEventArgs e)
        {
             //
        }

        private void grdMain_DoubleClick(object sender, EventArgs e)
        {
            int SelectCol = Fun_GetCol("选择");
            if (DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[SelectCol].Value) == "√")
            {
                grdMain.Rows[grdMain.CurrentRow.Index].Cells[SelectCol].Value="";
            }
            else
            {
                grdMain.Rows[grdMain.CurrentRow.Index].Cells[SelectCol].Value= "√";
            }
        }
        //计算开工日期和完工日期
        private void js_Click(object sender, EventArgs e)
        {
            SQLHelper.ClsCN oCn = new  SQLHelper.ClsCN();
            DataSet Ds;
            DateTime HBeginDate;
            DateTime HEndDate;
            long HCenterID = 0;
            string HCenterNumber = "";
            int SelectCol = Fun_GetCol("选择");
            int HBeginDateCol = Fun_GetCol("最迟开工日期");
            int HEndDateCol = Fun_GetCol("最迟完工日期");
            int HCenterNumberCol = Fun_GetCol("工作中心");
            int HCenterIDCol = Fun_GetCol("工作中心代码");
            int HInterIDCol = Fun_GetCol("h任务单ID");
            int HBillNoCol = Fun_GetCol("生产任务单号");
            for (int i = 0; i < grdMain.Rows.Count; i++)
            {
                if (grdMain.Rows[i].Cells[SelectCol].Value.ToString() == "√")
                {
                    Ds = oCn.RunProcReturn("exec h_p_Sc_ICMOSetWorkCenterDate " + grdMain.Rows[i].Cells[HInterIDCol].Value, "h_p_K3_ICMOSetWorkCenterDate");
                    if (Ds.Tables[0].Rows.Count != 0)
                    {
                        HBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0][1]);
                        HEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0][0]);
                        HCenterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HCenterIDCol].Value);
                        HCenterNumber = grdMain.Rows[i].Cells[HCenterNumberCol].Value.ToString();
                        grdMain.Rows[i].Cells[HBeginDateCol].Value = HBeginDate;
                        grdMain.Rows[i].Cells[HEndDateCol].Value = HEndDate;
                        //改为 DAL类执行
                        oCn.RunProc("delete Sc_ICMOBillMain_Extend where hinterid=" + grdMain.Rows[i].Cells[HInterIDCol].Value);
                        oCn.RunProc("insert into Sc_ICMOBillMain_Extend (HInterID,HBillNo,HCenterID,HCenterNumber,HBeginDate,HEndDate,HLevNum,HReadyQty) " +
                                    "values(" + grdMain.Rows[i].Cells[HInterIDCol].Value + ",'" + grdMain.Rows[i].Cells[HBillNoCol].Value +
                                    "'," + HCenterID + ",'" + HCenterNumber +
                                    "','" + grdMain.Rows[i].Cells[HBeginDateCol].Value + "','" + grdMain.Rows[i].Cells[HEndDateCol].Value + "',0,0)");
                    }
                }
            }
            oCn.CnClose();
            oCn.CnDispose();
        }
        //选择
        private void xz_Click(object sender, EventArgs e)
        {
            int SelectCol = Fun_GetCol("选择");
            for (int i = 0; i < grdMain.SelectedRows.Count; i++)
            {
                grdMain.SelectedRows[i].Cells[SelectCol].Value = "√";
            }
        }
        //清除
        private void qc_Click(object sender, EventArgs e)
        {
            int SelectCol = Fun_GetCol("选择");
            for (int i = 0; i < grdMain.SelectedRows.Count; i++)
            {
                grdMain.SelectedRows[i].Cells[SelectCol].Value = "";
            }
        }

        private void grdMain_Paint(object sender, PaintEventArgs e)
        {
            DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
        }

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

        //合计 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 pc_Click(object sender, EventArgs e)
        {
            SetICMOWorkCenter();
        }

        //设置工作中心
        private void SetICMOWorkCenter()
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            int SelectCol = Fun_GetCol("选择");
            int HInterIDCol = Fun_GetCol("h任务单ID");
            try
            {
                for (int i = 0; i < grdMain.Rows.Count; i++)
                {
                    if (grdMain.Rows[i].Cells[SelectCol].Value.ToString() == "√")
                    {
                        oCn.RunProcReturn("exec h_p_K3_ICMOSetWorkCenterID " + grdMain.Rows[i].Cells[HInterIDCol].Value, "h_p_K3_ICMOSetWorkCenterID");

                    }
                }
                oCn.CnClose();
                oCn.CnDispose();
                MessageBox.Show("设置工作中心完毕！");
                Display();
            }
            catch (Exception e)
            {
                oCn.CnClose();
                oCn.CnDispose();
                MessageBox.Show("设置工作中心失败!"+e.Message);
            }
        }

        //Sc_PPBom_K3 oFrm;
        ////显示投料单
        //private void tl_Click(object sender, EventArgs e)
        //{
        //    int HInterIDCol = Fun_GetCol("h任务单ID");
        //    Int64 HInterID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HInterIDCol].Value);
        //    if (HInterID == 0)
        //    {
        //        return;
        //    }
        //    DataSet Ds;
        //    SQLHelper.ClsCNK3 oCnK3 = new SQLHelper.ClsCNK3();
        //    Ds = oCnK3.RunProcReturn("select finterid from ppbom where ficmointerid=" + HInterID, "ppbom");
        //    Int64 PPBomID = 0;   //BOMID
        //    if (Ds.Tables[0].Rows.Count != 0)
        //    {
        //        PPBomID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
        //    }
        //    DAL.ClsSc_PPBom_K3 oBill = new DAL.ClsSc_PPBom_K3();
        //    if (oBill.ShowBill(PPBomID, ref DBUtility.ClsPub.sExeReturnInfo))
        //    {
        //        oFrm = new Sc_PPBom_K3();
        //        oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
        //        oFrm.BillOld = oBill;
        //        oFrm.BillOld.omodel.HInterID = PPBomID;
        //        oFrm.ShowDialog();
        //    }
        //    else
        //    {
        //        MessageBox.Show("单据未找到", "提示");
        //    }
        //    oBill = null;
        //}

        //设置等级
        public K3_ICMOSetWorkCenterList_OrderLevDlg oOrderLevDlg;
        private void dj_Click(object sender, EventArgs e)
        {
            oOrderLevDlg = new K3_ICMOSetWorkCenterList_OrderLevDlg();
            oOrderLevDlg.ShowDialog();
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            if (oOrderLevDlg.IsOk == 1)
            {
                int SelectCol = Fun_GetCol("选择");
                int HInterIDCol = Fun_GetCol("h任务单ID");
                Int64 HInterID = 0;
                for (int i = 0; i < grdMain.Rows.Count; i++)
                {
                    if (grdMain.Rows[i].Cells[SelectCol].Value.ToString() == "√")
                    {
                        HInterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HInterIDCol].Value);
                        oCn.RunProc("update Sc_ICMOBillMain_Extend set HOrderLevID=" + oOrderLevDlg.HOrderLevID + "  where hinterid= " + HInterID);
                    }
                }
                Display();
            }
        }

        //批选工作中心
        private void zx_Click(object sender, EventArgs e)
        {
            SetWorkCenter();
        }

        //
        private void SetWorkCenter()
        {
            DAL.ClsGy_WorkCenter_View oCenter = new DAL.ClsGy_WorkCenter_View();
            if (oCenter.RefreshView())
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                int SelectCol = Fun_GetCol("选择");
                int HInterIDCol = Fun_GetCol("h任务单ID");
                Int64 HInterID = 0;
                for (int i = 0; i < grdMain.Rows.Count; i++)
                {
                    if (grdMain.Rows[i].Cells[SelectCol].Value.ToString() == "√")
                    {
                        HInterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HInterIDCol].Value);
                        oCn.RunProc("update Sc_ICMOBillMain_Extend set HCenterID=" + oCenter.oModel.HItemID.ToString() + "  where hinterid= " + HInterID);
                    }
                }
                Display();
            }
        }

        private void qt_Click(object sender, EventArgs e)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            int SelectCol = Fun_GetCol("选择");
            int HInterIDCol = Fun_GetCol("h任务单ID");
            Int64 HInterID = 0;
            for (int i = 0; i < grdMain.Rows.Count; i++)
            {
                if (grdMain.Rows[i].Cells[SelectCol].Value.ToString() == "√")
                {
                    HInterID = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HInterIDCol].Value);
                    oCn.RunProc("exec h_p_Sc_PlanMaterReadyAnalyseJS " + HInterID);
                }
            }
            Display();
        }

        private void mx_Click(object sender, EventArgs e)
        {
            Sc_PlanMaterReadyAnalyseMX oMX = new Sc_PlanMaterReadyAnalyseMX();
            int HInterIDCol = Fun_GetCol("h任务单ID");
            oMX.HInterID = DBUtility.ClsPub.isLong(grdMain.SelectedRows[0].Cells[HInterIDCol].Value);
            oMX.ShowDialog();
        }

        

        
    }
}