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

namespace BaseSet
{
    public partial class Gy_DataIn_Source :BLL.Gy_DataInTmp
    {
        public Gy_DataIn_Source()
        {
            InitializeComponent();
        }

        public int HCollectIDCol = 1;         //²É¼¯Æ÷ÄÚÂë
        public int HRoomIDCol = 5;            //Òµ»§ÄÚÂë
        public int HBeginDateCol = 13;         //¿ªÊ¼ÈÕÆÚ
        public int HEndDateCol = 10;           //½áÊøÈÕÆÚ
        public int HItMoneyIDCol = 5;         //·ÑÓÃÏîÄ¿
        public int HQtyCol = 6;               //ÊýÁ¿
        public int HPriceCol = 7;             //µ¥¼Û
        public int HMoneyCol = 8;             //½ð¶î
        public int HBeginBalanceCol = 12;      //¿ªÊ¼ÊýÖµ
        public int HEndBalanceCol = 9;        //½áÊøÊýÖµ
        //
        public const int HBeginRow = 2;         //ÓÐЧÊý¾Ý£¬¿ªÊ¼ÐÐÊý
        //
        public DAL.ClsGy_Source_Ctl oSource = new DAL.ClsGy_Source_Ctl();
        public DAL.ClsGy_Source_View oSourceHlp = new DAL.ClsGy_Source_View();
        public DAL.ClsGy_WorkCenter_View oWorkCenter = new DAL.ClsGy_WorkCenter_View();
        public DAL.ClsGy_Process_View oProce = new DAL.ClsGy_Process_View();

        /// <summary>
        ///  ³õʼ»¯½çÃæ
        /// </summary>
        public override void initData()
        {
            base.initData();
            base.sSheetName = "Éú²ú×ÊÔ´";
            base.ModRightName = "Gy_DataIn_Source";
            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()
        {

            for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
            {
                if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[0].Value) != "" && DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[1].Value) != "")
                {
                    //дÈëÀà
                    if (WriteClass(i))
                    {
                        //±£´æ¼Ç¼
                        if (!oSource.AddNew())
                        {
                            MessageBox.Show("µ¼Èëʧ°Ü!Ô­Òò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
                            return;
                        }
                    }
                }
                else
                {
                    MessageBox.Show("Éú²ú×ÊÔ´´úÂë»òÃû³ÆΪ¿Õ!Ô­Òò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
                    return;
                }
            }
            MessageBox.Show("µ¼ÈëÍê±Ï");
            grdMain.DataSource = null;
        }

        //дÈëÀà ´Ó¿Ø¼þ
        private bool WriteClass(int row)
        {
            string sHNumber = "";
            string sHName = "";
            string sWorkCenterNumber = "";
            string sProcNumber = "";
            string sTye = "";
            string sR = "";
            long HItemID = 0;
            int sCol = DBUtility.Gy_BaseFun.Fun_GetCol("×ÊÔ´´úÂë", grdMain);
            int sHNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("×ÊÔ´Ãû³Æ", grdMain);
            int sTyeCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÀàÐÍ", grdMain);
            int sWorkCenterNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤×÷ÖÐÐÄ´úÂë", grdMain);
            int sProcNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("¹¤Ðò´úÂë", grdMain);
            int sRCol = DBUtility.Gy_BaseFun.Fun_GetCol("±¸×¢", grdMain);
            //
            sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sCol].Value);            
            sHName=DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sHNameCol].Value);
            sTye = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sTyeCol].Value);
            sWorkCenterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sWorkCenterNumberCol].Value);
            sProcNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sProcNumberCol].Value);
            sR = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[sRCol].Value);
            //ÅжÏÊÇ·ñÔÊÐí ±£´æ
            //ÉóºË´úÂëÊÇ·ñºÏÀí
            if (!DBUtility.ClsPub.AllowNumber(sHNumber))
            {
                MessageBox.Show("´úÂëÖв»ÄܳöÏÖÁ¬Ðø¡®.¡¯²¢ÇÒÊ×λĩλ²»ÄÜΪ¡®.¡¯£¡", "Ìáʾ");
                return false;
            }

            //ÊÇ·ñÖظ´´úÂë
            if (oSource.HavSameNumber(HItemID, sHNumber))
            {
                MessageBox.Show("´úÂëÖظ´£¡", "Ìáʾ");
                return false;
            }
            //¼ì²é¸¸¼¶ÊÇ·ñ´æÔÚ
            string sParent;
            sParent = DBUtility.ClsPub.GetParentCode(sHNumber);
            if (sParent.Trim() == "")
            {
                oSource.oModel.HParentID = 0;
            }
            else
            {
                if (oSource.HavParentCode(sParent.Trim(), HItemID))
                {
                    oSource.oModel.HParentID = oSource.oModel.HItemID;
                }
                else
                {
                    MessageBox.Show("Éϼ¶´úÂë²»´æÔÚ»ò±»½ûÓã¡", "Ìáʾ");
                    return false;
                }
            }
            //µÃµ½¶Ì´úÂë
            string sShortNumber;
            sShortNumber = DBUtility.ClsPub.GetShortNumber(sHNumber);
            if (sShortNumber.Trim() == "")
            {
                return false;
            }
            //±£´æÔ­´úÂë
            if (oSourceHlp.GetInfoByID(HItemID))
            {
                oSource.HOldNumber = oSourceHlp.oModel.HNumber;
                //ÊÇ·ñдúÂëÊÇ×Ô¼º×ÓÏîÄ¿µÄ¡¡×ÓÏîÄ¿
                if (sParent.Length >= oSource.HOldNumber.Length)
                {
                    if (sParent.Substring(0, oSource.HOldNumber.ToString().Length) == oSource.HOldNumber.Trim())
                    {
                        MessageBox.Show("дúÂë²»ÄÜÊÇ×Ô¼ºµÄϼ¶µÄ×ÓÏîÄ¿£¡", "Ìáʾ");
                        return false;
                    }
                }
            }
            else
            {
                oSource.HOldNumber = "";
            }

            //µÃµ½ 
            if (oWorkCenter.GetInfoByNumber(sWorkCenterNumber))
            {
                oSource.oModel.HCenterID = oWorkCenter.omodel.HItemID;
            }
            else
            {
                oSource.oModel.HCenterID = 0;
                MessageBox.Show("µÚ" + row.ToString() + "ÐÐ," + sWorkCenterNumber + "ûÓÐÕÒµ½¶ÔÓ¦µÄ¹¤×÷ÖÐÐÄ£¡");
                return false;
            }
            //дÈëÐÅÏ¢
            oSource.oModel.HShortNumber = sShortNumber;
            oSource.oModel.HEndFlag = true;
            oSource.oModel.HLevel = DBUtility.ClsPub.GetLevel(sHNumber);
            oSource.oModel.HNumber = sHNumber;
            oSource.oModel.HHelpCode = "";
            oSource.oModel.HName = sHName;
            oSource.oModel.HStopflag = false;
            oSource.oModel.HRemark = sR;
            oSource.oModel.HType = sTye;
            //if (oFactory.GetInfoByName(sWorkNumber))
            //{
            //    oSource.oModel.HCenterID = oFactory.omodel.HItemID;
            //}
            //else
            //{
            //    oSource.oModel.HCenterID = 0;
            //    return false;
            //}
            //
            if (oProce.GetInfoByNumber(sProcNumber))
            {
                oSource.oModel.HProcID = oProce.omodel.HItemID;
            }
            else
            {
                oSource.oModel.HProcID = 0;
                return false;
            }
           
            return true;
        }

        private void button1_Click(object sender, EventArgs e)
        {

        }

        

    }
}