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

namespace PlanM
{
    public partial class Gy_DataIn_RoutingBill_New :BLL.Gy_DataInTmp
    {
        public Gy_DataIn_RoutingBill_New()
        {
            InitializeComponent();
        }

        public int HMaterNumberCol = 0;             //²úÆ·´úÂë
        public int HWorkTypeNameCol = 0;           //¹¤ÖÖ
        public int HProcNameCol = 0;           //¹¤Ðò
        public int HWorkCenterNameCol = 0;        //¹¤×÷ÖÐÐÄ
        public int HProcMulNameCol = 0;           //¹¤¶Î
        public int HWorkCenterName_SCol = 0;           //²úÏß
        public int HWorkQtyCol = 0;          //²úÄÜ
        public int HSubStdEmpQtyCol = 0;          //ÈËÊý
        public int HWorkQty_SCol = 0;          //²úÏß²úÄÜ
        public int HSubStdEmpQty_SCol = 0;          //²úÏßÈËÊý

        public int HMouldNoCol = 0;          //Ä£¾ß±àºÅ
        public int HChangeMouldCol = 0;          //»»Ä£Ê±¼ä
        public int HPackStdCol = 0;          //ÖÜתÏä±ê×¼
        public int HPackCol = 0;          //ÖÜתÏä
        public int HPutAreaCol = 0;          //ÔÝ·ÅÇø
        //
        public int HMyWorkDaysCol = 0;          //Éú²úÖÜÆÚ
        public int HMyFixWorkDaysCol = 0;          //¹Ì¶¨Éú²úÌìÊý

        public int HBeginDayQtyCol = 6;     //¿ª¹¤¹ÌÌì
        public int HBeginFixQtyCol = 7;     //¿ª¹¤ÓàÁ¿ 
        public int HFixPriceCol = 8;        //¶¨¶î Сʱ¹¤×Ê
        public int HProcPriceCol = 9;       //¹¤¼Û
        public int HProcTypeCol = 0;          //¹¤ÐòÀàÐÍ
        //
        public const int HBeginRow = 2;         //ÓÐЧÊý¾Ý£¬¿ªÊ¼ÐÐÊý
        // 
        public DAL.ClsGy_Process_View oProcHlp = new DAL.ClsGy_Process_View();
        DAL.ClsGy_WorkCenter_View oCenHlp = new DAL.ClsGy_WorkCenter_View();
        DAL.ClsIF_Unit_View oUnit = new DAL.ClsIF_Unit_View();
        public DAL.ClsGy_RoutingBill BillNew = new DAL.ClsGy_RoutingBill();
        DAL.ClsIF_Material_View oMaterHlp = new DAL.ClsIF_Material_View();
        //DAL.ClsGy_WorkType_View oWorkType = new DAL.ClsGy_WorkType_View();
        DAL.ClsGy_ProcMul_View oProcMul = new DAL.ClsGy_ProcMul_View();
        DAL.ClsGy_LineCenter_View oLineCen = new DAL.ClsGy_LineCenter_View();
        long j = -1;
        int c = 0;

        public override bool OpenExcelData()
        {
            base.sSheetName = txtHSheetName.Text;
            return base.OpenExcelData();
        } 

        /// <summary>
        ///  ³õʼ»¯½çÃæ
        /// </summary>
        public override void initData()
        {
            base.initData();
            base.sSheetName = txtHSheetName.Text ; 
            base.ModRightName = "Gy_DataIn_RoutingBill";
            base.ModRightNameCheck = base.ModRightName + base.ModRightNameCheck;
            base.ModRightNameClose = base.ModRightName + base.ModRightNameClose;
            base.ModRightNameDelete = base.ModRightName + base.ModRightNameDelete;
            base.ModRightNameEdit = base.ModRightName + base.ModRightNameEdit;
            base.ModRightNameMoney = base.ModRightName + base.ModRightNameMoney;
            base.ModRightNameQty = base.ModRightName + base.ModRightNameQty;
            base.ModCaption = "¹¤ÒÕ·Ïßµ¼Èë";
            this.Text = base.ModCaption;
            lblCaption.Text = base.ModCaption;
            //
            DBUtility.Gy_BaseFun.SetComboxYear(cmbHYear);
            DBUtility.Gy_BaseFun.SetComboxPeriod(cmbHPeriod);
            //
        }
        //µ¼Èë
        public override void Sub_DataIn()
        {
            string hnumber = "";
            string HBillNo = "";
            //
            HMaterNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÆ·´úÂë", grdMain);
            //HWorkTypeNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤ÖÖ", grdMain);
            HProcNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤Ðò", grdMain);
            HWorkCenterNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤×÷ÖÐÐÄ", grdMain);
            HProcMulNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤¶Î", grdMain);
            HWorkCenterName_SCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÏß", grdMain);
            HWorkQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÄÜ", grdMain);
            HSubStdEmpQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÈËÊý", grdMain);
            HWorkQty_SCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÏß²úÄÜ", grdMain);
            HSubStdEmpQty_SCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÏßÈËÊý", grdMain);
            HMouldNoCol = DBUtility.Gy_BaseFun.Fun_GetCol("Ä£¾ß±àºÅ", grdMain);
            HChangeMouldCol = DBUtility.Gy_BaseFun.Fun_GetCol("»»Ä£Ê±¼ä", grdMain);
            HPackStdCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÖÜתÏä±ê×¼", grdMain);
            HPackCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÖÜתÏä", grdMain);
            HPutAreaCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÔÝ·ÅÇø", grdMain);
            HMyWorkDaysCol = DBUtility.Gy_BaseFun.Fun_GetCol("Éú²úÖÜÆÚ", grdMain);
            HMyFixWorkDaysCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹Ì¶¨Éú²úÌìÊý", grdMain);

            //
            HBeginFixQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("¿ª¹¤ÓàÁ¿", grdMain);
            HBeginDayQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("¿ª¹¤¹ÌÌì", grdMain);
            HFixPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("Сʱ¹¤×Ê", grdMain);
            HProcPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("µ¥¸ö¹¤¼Û", grdMain);
            HProcTypeCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤ÐòÀàÐÍ", grdMain);

            //ûÓÐÕÒµ½ÁÐ
            if (HMaterNumberCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾²úÆ·´úÂë¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HProcNameCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾¹¤Ðò¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            //if (HWorkTypeNameCol == -1)
            //{
            //    MessageBox.Show("ûÓÐÕÒµ½¡¾¹¤ÖÖ¡¿µÄ±êÌâ", "Ìáʾ");
            //    return;
            //}
            if (HWorkCenterNameCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾¹¤×÷ÖÐÐÄ¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HProcMulNameCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾¹¤¶Î¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HWorkCenterName_SCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾²úÏß¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HWorkQtyCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾²úÄÜ¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HBeginFixQtyCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾¿ª¹¤ÓàÁ¿¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HBeginDayQtyCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾¿ª¹¤¹ÌÌì¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HFixPriceCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾Ð¡Ê±¹¤×Ê¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HProcPriceCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾µ¥¸ö¹¤¼Û¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HWorkQty_SCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾²úÏß²úÄÜ¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HSubStdEmpQty_SCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾²úÏßÈËÊý¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HMouldNoCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾Ä£¾ß±àºÅ¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HChangeMouldCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾»»Ä£Ê±¼ä¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HPackStdCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾ÖÜתÏä±ê×¼¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HPackCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾ÖÜתÏä¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HPutAreaCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾ÔÝ·ÅÇø¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HProcTypeCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾¹¤ÐòÀàÐÍ¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            //
            if (!Checkdata())
            {
                return;
            }
            if (grdMain.Rows.Count > 0)
            { 
                hnumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells[HMaterNumberCol].Value);
                HBillNo = ClsPub.CreateBillCode(BillNew.BillType, ref ClsPub.sExeReturnInfo, true);
                BillNew.omodel.HStandard = false;
                BillNew.omodel.HMainTimeUnit = "Сʱ";
                BillNew.omodel.HYear = 2011;
                BillNew.omodel.HPeriod = 1;
                BillNew.omodel.HBillNo = HBillNo;
                BillNew.omodel.HDate = DateTime.Today.Date;
                BillNew.DetailColl.Clear();
            } 
            for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
            {
                string sHNumber = ""; 
                if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value) != "" )
                {
                    //
                    sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value);
                    //ÉóºË´úÂëÊÇ·ñºÏÀí
                    if (!DBUtility.ClsPub.AllowNumber(sHNumber))
                    {
                        MessageBox.Show("ÎïÁÏ´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡", "Ìáʾ");
                        return;
                    }

                    if (hnumber == DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value))
                    {
                        //µÃµ½ÎïÁÏÄÚÂë
                        if (oMaterHlp.GetInfoByNumber(sHNumber))
                        {
                            if (BillNew.omodel.HMaterID != oMaterHlp.omodel.HItemID)
                            {
                                BillNew.omodel.HMaterID = oMaterHlp.omodel.HItemID;
                                BillNew.omodel.HMaterNumber = oMaterHlp.omodel.HNumber;
                                BillNew.omodel.HUnitID = oMaterHlp.omodel.HUnitID;
                                BillNew.omodel.HUnitNumber = oMaterHlp.omodel.HUnitNumber;
                            }

                        }
                        else
                        {
                            BillNew.omodel.HMaterID = 0;
                            MessageBox.Show("µÚ" + i.ToString() + "ÐÐ," + sHNumber + "ûÓÐÕÒµ½¶ÔÓ¦µÄÎïÁÏ£¡");
                            return;
                        }
                        j++;
                        //дÈëÀà
                        WriteClass(i);

                    }
                    else
                    {
                        DataSet Ds;
                        ClsCN oCn=new ClsCN();
                        bool b = false;
                        // ÅжÏÊÇ·ñ´æÔÚ¹¤ÒÕ·Ïß
                        Ds = oCn.RunProcReturn("Select HMaterID from Gy_RoutingBillMain Where HMaterID=" + BillNew.omodel.HMaterID.ToString(), "Gy_RoutingBillMain");
                        if (checkadd.Checked == true)
                        {
                            //if (Ds.Tables[0].Rows.Count == 0)//×·¼Ó
                            //{
                                //ÐÂÔöÇ° ÏÈɾ³ýÔ­À´¹¤ÒÕ
                                BillNew.DeleteByMaterID(BillNew.omodel.HMaterID);
                                b = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
                                if (b == false) return;
                                c++;
                                BillNew.CheckBill(BillNew.omodel.HInterID, ref ClsPub.sExeReturnInfo);
                            //}
                            //else
                            //{

                            //}
                        }
                        else
                        {
                            BillNew.DeleteByMaterID(BillNew.omodel.HMaterID);
                            b = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
                            if (b == false) return;
                            c++;
                            BillNew.CheckBill(BillNew.omodel.HInterID, ref ClsPub.sExeReturnInfo);
                        }


                        BillNew.DetailColl.Clear();
                        hnumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value);
                        sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value);
                        
                        //ÉóºË´úÂëÊÇ·ñºÏÀí
                        if (!DBUtility.ClsPub.AllowNumber(sHNumber))
                        {
                            MessageBox.Show("ÎïÁÏ´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡", "Ìáʾ");
                            return;
                        }
                        //µÃµ½ÎïÁÏÄÚÂë
                        if (oMaterHlp.GetInfoByNumber(sHNumber))
                        {
                            if (BillNew.omodel.HMaterID != oMaterHlp.omodel.HItemID)
                            {
                                BillNew.omodel.HMaterID = oMaterHlp.omodel.HItemID;
                                BillNew.omodel.HMaterNumber = oMaterHlp.omodel.HNumber;
                                BillNew.omodel.HUnitID = oMaterHlp.omodel.HUnitID;
                                BillNew.omodel.HUnitNumber = oMaterHlp.omodel.HUnitNumber;
                            }

                        }
                        else
                        {
                            BillNew.omodel.HMaterID = 0;
                            MessageBox.Show("µÚ" + i.ToString() + "ÐÐ," + sHNumber + "ûÓÐÕÒµ½¶ÔÓ¦µÄÎïÁÏ£¡");
                            return;
                        }
                        j = 0;
                        HBillNo = ClsPub.CreateBillCode(BillNew.BillType, ref ClsPub.sExeReturnInfo, true);
                        BillNew.omodel.HBillNo = HBillNo;
                        BillNew.omodel.HUseMan = DBUtility.ClsPub.CurUserName;
                        //дÈëÀà
                        WriteClass(i);
                    }
                }
                else
                {
                    MessageBox.Show("µÚ" + i.ToString() + "ÐÐ,ûÓÐÕÒµ½¶ÔÓ¦µÄÎïÁÏ£¡");
                    return;
                }
            }
            //×îºóÒ»¸öÎïÁÏ´¦Àí
            if (BillNew.DetailColl.Count > 0)
            {
                DataSet Ds;
                ClsCN oCn = new ClsCN();
                bool b = false;
                //Ds = oCn.RunProcReturn("Select HMaterID from Gy_RoutingBillMain Where HMaterID=" + BillNew.omodel.HMaterID.ToString(), "Gy_RoutingBillMain");
                //if (Ds.Tables[0].Rows.Count == 0)
                //{
                    BillNew.DeleteByMaterID(BillNew.omodel.HMaterID);
                    b = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
                    if (b == false) return;
                    c++;
                    BillNew.CheckBill(BillNew.omodel.HInterID, ref ClsPub.sExeReturnInfo);
                //}
                MessageBox.Show("µ¼ÈëÍê±Ï:¹²"+c.ToString()+"¸ö¹¤ÒÕ·Ïß");
                grdMain.DataSource = null;
            }
            c = 0;
        }

        //дÈëÀà ´Ó¿Ø¼þ
        private bool WriteClass(int row)
        {
            string sHNumber = "";
            string sHNamePoc = "";
            string sHNumberCen = "";
            string sHNumberProcMul = "";
            //string sHNumberWorkType = "";
            string sHNumberLineCen = "";


            Single sWorkQty = 0;
            Single sBeginDayQty = 0;
            Single sBeginFixQty = 0;
            //long HItemID = 0; 
            //
            sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMaterNumberCol].Value); 
            sHNumberCen = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HWorkCenterNameCol].Value);
            sHNamePoc = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HProcNameCol].Value);
            sHNumberProcMul = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HProcMulNameCol].Value);
            //sHNumberWorkType = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HWorkTypeNameCol].Value);
            sHNumberLineCen = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HWorkCenterName_SCol].Value);
            //
            //
            sWorkQty = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HWorkQtyCol].Value);
            sBeginDayQty = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HBeginDayQtyCol].Value);
            sBeginFixQty = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HBeginFixQtyCol].Value);
            //ÅжÏÊÇ·ñÔÊÐí ±£´æ
 
            Model.ClsGy_RoutingBillSub oSub=new Model.ClsGy_RoutingBillSub();

            //µÃµ½¹¤ÐòÄÚÂë
            if (oProcHlp.GetInfoByName(sHNamePoc))
            {
                oSub.HProcID = oProcHlp.omodel.HItemID;
            }

            //µÃµ½¹¤×÷ÖÐÐÄÄÚÂë
            if (oCenHlp.GetInfoByName(sHNumberCen))
            {
                oSub.HCenterID = oCenHlp.omodel.HItemID;
            }
            //µÃµ½²úÏßÄÚÂë
            if (oLineCen.GetInfoByName(sHNumberLineCen))
            {
                oSub.HCenterID_S = oLineCen.omodel.HItemID;
            }
            else
            {
                oSub.HCenterID_S = 0;
            }
            //µÃµ½¹¤¶ÎÄÚÂë
            if (oProcMul.GetInfoByName(sHNumberProcMul))
            {
                oSub.HProcID_S = oProcMul.omodel.HItemID;
            }
            else
            {
                oSub.HProcID_S = 0;
            }
            //дÈëÐÅÏ¢
            oSub.HEntryID = j;

            oSub.HProcNo = 0;
            oSub.HUnitTime = 1;
            oSub.HWorkQty = sWorkQty;
            oSub.HRemark = "";
            oSub.HTimeUnit = "Сʱ";
            oSub.HReadyTime = 0;
            oSub.HQueueTime = 0;
            oSub.HMoveTime = 0;
            //
            oSub.HCloseMan = "";
            oSub.HCloseType = false;
            oSub.HSourceInterID = 0;
            oSub.HSourceEntryID = 0;
            oSub.HSourceBillType = "";
            oSub.HSourceBillNo ="";
            oSub.HRelationQty = 0;
            oSub.HRelationMoney = 0;

            oSub.HMouldNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMouldNoCol].Value);
            oSub.HPackStd = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HPackStdCol].Value);
            oSub.HPack = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HPackCol].Value);
            oSub.HPutArea = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HPutAreaCol].Value);
            oSub.HWorkQty_S = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HWorkQty_SCol].Value);
            oSub.HSubStdEmpQty_S = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HSubStdEmpQty_SCol].Value);
            oSub.HChangeMould = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HChangeMouldCol].Value);
            oSub.HMyWorkDays = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HMyWorkDaysCol].Value);
            oSub.HMyFixWorkDays = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HMyFixWorkDaysCol].Value);
            oSub.HSubStdEmpQty = DBUtility.ClsPub.isDoule(grdMain.Rows[row].Cells[HSubStdEmpQtyCol].Value);

            oSub.HFixPrice = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HFixPriceCol].Value);
            oSub.HProcPrice = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HProcPriceCol].Value);
            oSub.HBadPrice = 0;
            oSub.HWasterPrice = 0;
            oSub.HStdFlag = false;
            oSub.HBeginDayQty = sBeginDayQty;
            oSub.HBeginFixQty = sBeginFixQty;
            oSub.HProcType = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HProcTypeCol].Value);
            
            BillNew.DetailColl.Add(oSub);
            return true;
        }

        //¼ì²éÎïÁÏ
        private bool Checkdata()
        {
            bool b=false;
            string sErrMsg = "";
            string sMsg = "";
            for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
            {
                string sHNumber = "";
                string sHNamePoc = "";
                string sHNumberCen = "";
                //string sHNumberWorkType = "";
                string sHNumberProcMul = "";
                string sHNumberLineCen = "";
                
                //
                sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value);
                sHNumberCen = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HWorkCenterNameCol].Value);
                sHNamePoc = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HProcNameCol].Value);
                //sHNumberWorkType = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HWorkTypeNameCol].Value);
                sHNumberProcMul = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HProcMulNameCol].Value);
                sHNumberLineCen = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HWorkCenterName_SCol].Value);
                if (sHNumber != "" )
                {
                    // 
                    //ÉóºË´úÂëÊÇ·ñºÏÀí
                    if (!DBUtility.ClsPub.AllowNumber(sHNumber))
                    {
                        MessageBox.Show("ÎïÁÏ´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡", "Ìáʾ");
                        return false;
                    }
                    //µÃµ½ÎïÁÏÄÚÂë
                    int j = i + HBeginRow;
                    if (!oMaterHlp.GetInfoByNumber(sHNumber))
                    {
                        sMsg = "[" + sHNumber + "]ÎïÁϲ»´æÔÚ";
                        if (sErrMsg.Contains(sMsg)==false)
                        {
                            sErrMsg = sErrMsg + "[" + sHNumber + "]ÎïÁϲ»´æÔÚ\r\n" ;
                        }
                        b = true;
                    }
                    //µÃµ½¹¤ÐòÄÚÂë
                    if (!oProcHlp.GetInfoByName(sHNamePoc))
                    {
                        sMsg = "[" + sHNamePoc + "]¹¤Ðò²»´æÔÚ";
                        if (sErrMsg.Contains(sMsg) == false)
                        {
                            sErrMsg = sErrMsg + "[" + sHNamePoc + "]¹¤Ðò²»´æÔÚ\r\n";
                        }
                        b = true;
                    }

                    //µÃµ½¹¤×÷ÖÐÐÄÄÚÂë
                    if (!oCenHlp.GetInfoByName(sHNumberCen))
                    {
                        sMsg = "[" + sHNumberCen + "]¹¤×÷ÖÐÐIJ»´æÔÚ";
                        if (sErrMsg.Contains(sMsg) == false)
                        {
                            sErrMsg = sErrMsg + "[" + sHNumberCen + "]¹¤×÷ÖÐÐIJ»´æÔÚ\r\n";
                        }
                        b = true;
                    }
                    //µÃµ½¹¤ÖÖÄÚÂë
                    //if (!oWorkType.GetInfoByName(sHNumberWorkType))
                    //{
                    //    sMsg = "[" + sHNumberWorkType + "]¹¤ÖÖ²»´æÔÚ";
                    //    if (sErrMsg.Contains(sMsg) == false)
                    //    {
                    //        sErrMsg = sErrMsg + "[" + sHNumberWorkType + "]¹¤ÖÖ²»´æÔÚ\r\n";
                    //    }
                    //    b = true;
                    //}
                    //µÃµ½¹¤¶ÎÄÚÂë
                    if (sHNumberProcMul.Trim() != "")
                    {
                        if (!oProcMul.GetInfoByName(sHNumberProcMul))
                        {
                            sMsg = "[" + sHNumberProcMul + "]¹¤¶Î²»´æÔÚ";
                            if (sErrMsg.Contains(sMsg) == false)
                            {
                                sErrMsg = sErrMsg + "[" + sHNumberProcMul + "]¹¤¶Î²»´æÔÚ\r\n";
                            }
                            b = true;
                        }
                    }
                    //µÃµ½²úÏßÄÚÂë
                    if (sHNumberLineCen.Trim() != "")
                    {
                        if (!oLineCen.GetInfoByName(sHNumberLineCen))
                        {
                            sMsg = "[" + sHNumberLineCen + "]²úÏß²»´æÔÚ";
                            if (sErrMsg.Contains(sMsg) == false)
                            {
                                sErrMsg = sErrMsg + "[" + sHNumberLineCen + "]²úÏß²»´æÔÚ\r\n";
                            }
                            b = true;
                        }
                    }

                }               
            }
            if (b == true)
            {
                Pub_Control.ErrMsgBox oMsgbox = new Pub_Control.ErrMsgBox();
                oMsgbox.txtHErrMsg.Text = sErrMsg;
                oMsgbox.ShowDialog();
                return false;
            }
            else
            {
                return true;
            }
        }










    }
}