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 BaseSet
{
    public partial class Gy_DataIn_MaterSP :BLL.Gy_DataInTmp
    {
        public Gy_DataIn_MaterSP()
        {
            InitializeComponent();
        }

        public int HMaterNumberCol = 0;             //²úÆ·´úÂë
        public int HSPNumberCol = 0;           //²Öλ
        //
        public const int HBeginRow = 2;         //ÓÐЧÊý¾Ý£¬¿ªÊ¼ÐÐÊý
        // 
        DAL.ClsGy_MaterStockPlace_Ctl oMaterSP = new DAL.ClsGy_MaterStockPlace_Ctl();
        DAL.ClsIF_StockPlace_View oSPHlp = new DAL.ClsIF_StockPlace_View();
        DAL.ClsIF_Material_View oMaterHlp = new DAL.ClsIF_Material_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_MaterSP";
            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;
            //
            //
        }
        //µ¼Èë
        public override void Sub_DataIn()
        {
            string hnumber = "";
            string HBillNo = "";
            //
            HMaterNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("ÎïÁϳ¤´úÂë", grdMain);
            HSPNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("²Öλ", grdMain);
            //ûÓÐÕÒµ½ÁÐ
            if (HMaterNumberCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾ÎïÁϳ¤´úÂë¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            if (HSPNumberCol == -1)
            {
                MessageBox.Show("ûÓÐÕÒµ½¡¾²Öλ¡¿µÄ±êÌâ", "Ìáʾ");
                return;
            }
            //
            if (!Checkdata())
            {
                return;
            }
            for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
            {
                string sHNumber = "";
                if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value) != "")
                {
                    //
                    //дÈëÀà
                    if (WriteClass(i))
                    {
                        //±£´æ¼Ç¼
                        if (!oMaterSP.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 sHNameSP = ""; 
            //
            sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMaterNumberCol].Value);
            sHNameSP = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HSPNumberCol].Value);
            //ÅжÏÊÇ·ñÔÊÐí ±£´æ

            Model.ClsGy_MaterStockPlace_Model oSub = new Model.ClsGy_MaterStockPlace_Model();
            oMaterSP.DetailColl.Clear();
            //µÃµ½²ÖλÄÚÂë
            if (oSPHlp.GetInfoByNumber(sHNameSP))
            {
                oSub.HSPID = oSPHlp.omodel.HItemID;
            }

            //µÃµ½ÎïÁÏÄÚÂë
            if (oMaterHlp.GetInfoByNumber(sHNumber))
            {
                oSub.HMaterID = oMaterHlp.omodel.HItemID;
            }
            //дÈëÐÅÏ¢
            oSub.HSPGroupID = 0;
            oSub.HDeptID = 0;
            oSub.HQty = 1000000;
            oSub.HStopflag = true;
            oSub.HRemark = "";
            oSub.HMaker = DBUtility.ClsPub.CurUserName;
            oSub.HMakeDate = DBUtility.ClsPub.GetServerDate(-1);
            
            oMaterSP.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 sHNameSP = ""; 
                
                //
                sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNumberCol].Value);
                sHNameSP = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HSPNumberCol].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 (!oSPHlp.GetInfoByName(sHNameSP))
                    {
                        sMsg = "[" + sHNameSP + "]²Öλ²»´æÔÚ";
                        if (sErrMsg.Contains(sMsg) == false)
                        {
                            sErrMsg = sErrMsg + "[" + sHNameSP + "]²Öλ²»´æÔÚ\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;
            }

        }

    }
}