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_BOM_K3 :BLL.Gy_DataInTmp
    {
        public Gy_DataIn_BOM_K3()
        {
            InitializeComponent();
        }

        public int HMaterIDCol =1;             //²úÆ·´úÂë
        public int HJJGCol = 4;             //»ú¼Ó¹¤´úÂë
        public int HMPCol = 7;             //ëÅ÷ID
        public int HCLCol = 11;             //²ÄÁÏ´úÂë
        //
        public const int HBeginRow = 0;         //ÓÐЧÊý¾Ý£¬¿ªÊ¼ÐÐÊý
        //
        public DAL.ClsGy_ICBomBill_K3 BillNew = new DAL.ClsGy_ICBomBill_K3();
        public DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View();

        /// <summary>
        ///  ³õʼ»¯½çÃæ
        /// </summary>
        public override void initData()
        {
            base.initData();
            base.sSheetName = "Sheet1";
            base.ModRightName = "Gy_DataIn_BOM_K3";
            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 = "K3BOMµ¼Èë";
            this.Text = base.ModCaption;
            lblCaption.Text = base.ModCaption;
            //
            //DBUtility.Gy_BaseFun.SetComboxYear(cmbHYear);
            //DBUtility.Gy_BaseFun.SetComboxPeriod(cmbHPeriod);
            //
        }

        public override void Sub_DataIn()
        {
            //base.Sub_DataIn();
            //
            int m = 0;
            string smsg = "";
            bool b = false;
            //ɾ³ý Ïàͬ»á¼ÆÆڼ䣬Ïàͬ·ÑÓÃÏîÄ¿£¬µÄËùÓмǼ
            for (int i = HBeginRow; i <= grdMain.Rows.Count - 1; i++)
            {
                if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterIDCol].Value) != "")
                {
                    //дÈëÀà
                    if (WriteClass(i))
                    {
                        //±£´æ¼Ç¼
                        if (!BillNew.AddBill(ref DBUtility.ClsPub.sExeReturnInfo))
                        {
                            smsg = smsg + ",," + i.ToString();
                        }
                        else
                        {
                            m++;
                        } 
                    }
                    else
                    {
                        smsg = smsg + ",," + i.ToString();
                    }
                }
                //
                if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HJJGCol].Value) != "")
                {
                    //дÈëÀà
                    if (WriteClass2(i))
                    {
                        //±£´æ¼Ç¼
                        if (!BillNew.AddBill(ref DBUtility.ClsPub.sExeReturnInfo))
                        {
                            smsg = smsg + "," + i.ToString();
                        }
                        else
                        {
                            m++;
                        }
                    }
                    else
                    {
                        smsg = smsg + "," + i.ToString();
                    }
                }
                if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMPCol].Value) != "")
                {
                    if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HCLCol].Value) != "")
                    {
                        //дÈëÀà
                        if (WriteClass3(HMPCol,i))
                        {
                            m++;
                        }
                        else
                        {
                            smsg = smsg + "," + i.ToString();
                        }
                    }
                }
            }
            MessageBox.Show("µ¼ÈëÍê±Ï" + smsg + " || " + m.ToString());
            grdMain.DataSource = null;
        }

        //дÈëÀà ´Ó¿Ø¼þ
        private bool WriteClass(int row)
        {
            //ÅжÏÊÇ·ñÔÊÐí ±£´æ
            //µÃµ½Òµ»§ÄÚÂ룬·ÑÓÃÏîÄ¿ÄÚÂë
            SQLHelper.ClsCNK3 oK3Cn = new SQLHelper.ClsCNK3();
            DataSet Ds;
            string sBillNo = "";
            Ds = oK3Cn.RunProcReturn("exec HX_GetICBillNo 1,50", "t_billcodeby");
            if (Ds.Tables[0].Rows.Count == 0 || Ds == null)
            {
                return false;
            }
            sBillNo = Ds.Tables[0].Rows[0][0].ToString().Trim();
            //дÈëÐÅÏ¢
            BillNew.omodel.HYear = 2011;
            BillNew.omodel.HPeriod = 1;
            BillNew.omodel.HBillNo = sBillNo;
            BillNew.omodel.HDate = DateTime.Today;
            BillNew.omodel.HRemark = "BOMµ¼Èë";
            //
            BillNew.omodel.HParentID = DBUtility.ClsPub.isLong(this.txtHICBOMGroupID.Tag);
            BillNew.omodel.HVersion = "1";
            BillNew.omodel.HStatus = "";
            BillNew.omodel.HPicNo = "";

            if (oMater.GetInfoByNumber(DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMaterIDCol].Value)))
            {
                BillNew.omodel.HMaterID = oMater.omodel.HItemID;
                BillNew.omodel.HUnitID = oMater.omodel.HUnitID;
            }
            else
            {
                BillNew.omodel.HMaterID = 0;
                BillNew.omodel.HUnitID = 0;
                return false;
            }
            BillNew.omodel.HMaterTypeID = 0;
            BillNew.omodel.HPropertyID = 0;
            BillNew.omodel.HQty = 1;
            BillNew.omodel.HProdRate = 100;
            BillNew.omodel.HJump = "1059";
            //
            //BillNew.HExRate = ClsPub.isDoule(this.txtHMaterName.Text.ToString());
            //Ã÷ϸÀำֵ
            BillNew.DetailColl = new List<Model.ClsGy_ICBomBillSub_K3>();
            if (DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMaterIDCol].Value) != "")
            {
                if (DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HJJGCol].Value) != "")
                {
                    Model.ClsGy_ICBomBillSub_K3 oSub = new Model.ClsGy_ICBomBillSub_K3();
                    oSub.HEntryID = 1;
                    //
                    if (oMater.GetInfoByNumber(DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HJJGCol].Value)))
                    {
                        oSub.HMaterID = oMater.omodel.HItemID;
                        oSub.HUnitID = oMater.omodel.HUnitID;
                    }
                    else
                    {
                        oSub.HMaterID = 0;
                        oSub.HUnitID = 0;
                        return false;
                    }
                    oSub.HChildType = "";
                    oSub.HQty = 1;
                    oSub.HRelQty = 1;
                    oSub.HWasteRate = 0;
                    oSub.HWhID = 0;
                    oSub.HProcID = 0;
                    oSub.HRemark2 = "";
                    oSub.HRemark3 = "";
                    oSub.HRemark4 = "";
                    //
                    oSub.HRemark = "";
                    oSub.HSourceInterID = 0;
                    oSub.HSourceEntryID = 0;
                    oSub.HSourceBillType = "";
                    oSub.HSourceBillNo = "";
                    oSub.HRelationQty = 0;
                    oSub.HRelationMoney = 0;
                    BillNew.DetailColl.Add(oSub);
                    return true;
                }
                else if (DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMPCol].Value) != "")
                {
                    Model.ClsGy_ICBomBillSub_K3 oSub = new Model.ClsGy_ICBomBillSub_K3();
                    oSub.HEntryID =1;
                    //
                    if (oMater.GetInfoByNumber(DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMPCol].Value)))
                    {
                        oSub.HMaterID = oMater.omodel.HItemID;
                        oSub.HUnitID = oMater.omodel.HUnitID;
                    }
                    else
                    {
                        oSub.HMaterID = 0;
                        oSub.HUnitID = 0;
                        return false;
                    }
                    oSub.HChildType = "";
                    oSub.HQty = 1;
                    oSub.HRelQty = 1;
                    oSub.HWasteRate = 0;
                    oSub.HWhID = 0;
                    oSub.HProcID = 0;
                    oSub.HRemark2 = "";
                    oSub.HRemark3 = "";
                    oSub.HRemark4 = "";
                    //
                    oSub.HRemark = "";
                    oSub.HSourceInterID = 0;
                    oSub.HSourceEntryID = 0;
                    oSub.HSourceBillType = "";
                    oSub.HSourceBillNo = "";
                    oSub.HRelationQty = 0;
                    oSub.HRelationMoney = 0;
                    BillNew.DetailColl.Add(oSub);
                    return true;
                }
            }
            return true;
        }

        //дÈëÀà ´Ó¿Ø¼þ2
        private bool WriteClass2(int row)
        {
            //ÅжÏÊÇ·ñÔÊÐí ±£´æ
            //µÃµ½Òµ»§ÄÚÂ룬·ÑÓÃÏîÄ¿ÄÚÂë
            SQLHelper.ClsCNK3 oK3Cn = new SQLHelper.ClsCNK3();
            DataSet Ds;
            string sBillNo = "";
            Ds = oK3Cn.RunProcReturn("exec HX_GetICBillNo 1,50", "t_billcodeby");
            if (Ds.Tables[0].Rows.Count == 0 || Ds == null)
            {
                return false;
            }
            sBillNo = Ds.Tables[0].Rows[0][0].ToString().Trim();
            //дÈëÐÅÏ¢
            BillNew.omodel.HYear = 2011;
            BillNew.omodel.HPeriod = 1;
            BillNew.omodel.HBillNo = sBillNo;
            BillNew.omodel.HDate = DateTime.Today;
            BillNew.omodel.HRemark = "BOMµ¼Èë";
            //
            BillNew.omodel.HParentID = DBUtility.ClsPub.isLong(this.txtHICBOMGroupID.Tag);
            BillNew.omodel.HVersion = "1";
            BillNew.omodel.HStatus = "";
            BillNew.omodel.HPicNo = "";
            BillNew.omodel.HMaterTypeID = 0;
            BillNew.omodel.HPropertyID = 0;
            if (oMater.GetInfoByNumber(DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HJJGCol].Value)))
            {
                BillNew.omodel.HMaterID = oMater.omodel.HItemID;
                BillNew.omodel.HUnitID = oMater.omodel.HUnitID;
            }
            else
            {
                BillNew.omodel.HMaterID = 0;
                BillNew.omodel.HUnitID = 0;
                return false;
            }
            BillNew.omodel.HQty = 1;
            BillNew.omodel.HProdRate = 100;
            BillNew.omodel.HJump = "1059";
            //
            //BillNew.HExRate = ClsPub.isDoule(this.txtHMaterName.Text.ToString());
            //Ã÷ϸÀำֵ
            BillNew.DetailColl = new List<Model.ClsGy_ICBomBillSub_K3>();
            if (DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HJJGCol].Value) != "")
            {
                if (DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMPCol].Value) != "")
                {
                    Model.ClsGy_ICBomBillSub_K3 oSub = new Model.ClsGy_ICBomBillSub_K3();
                    oSub.HEntryID = 1;
                    //
                    if (oMater.GetInfoByNumber(DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMPCol].Value)))
                    {
                        oSub.HMaterID = oMater.omodel.HItemID;
                        oSub.HUnitID = oMater.omodel.HUnitID;
                    }
                    else
                    {
                        oSub.HMaterID = 0;
                        oSub.HUnitID = 0;
                        return false;
                    }
                    oSub.HChildType = "";
                    oSub.HQty = 1;
                    oSub.HRelQty = 1;
                    oSub.HWasteRate = 0;
                    oSub.HWhID = 0;
                    oSub.HProcID = 0;
                    oSub.HRemark2 = "";
                    oSub.HRemark3 = "";
                    oSub.HRemark4 = "";
                    //
                    oSub.HRemark = "";
                    oSub.HSourceInterID = 0;
                    oSub.HSourceEntryID = 0;
                    oSub.HSourceBillType = "";
                    oSub.HSourceBillNo = "";
                    oSub.HRelationQty = 0;
                    oSub.HRelationMoney = 0;
                    BillNew.DetailColl.Add(oSub);
                    return true;
                }
                else if (DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HCLCol].Value) != "")
                {
                    WriteClass3(HJJGCol, row);
                    return true;
                }
            }
            return true;
        }

        //дÈëÀà ´Ó¿Ø¼þ3 ²ÄÁÏ
        private bool WriteClass3(int HCol, int row)
        {
            //ÅжÏÊÇ·ñÔÊÐí ±£´æ
            //µÃµ½Òµ»§ÄÚÂ룬·ÑÓÃÏîÄ¿ÄÚÂë
            SQLHelper.ClsCNK3 oK3Cn = new SQLHelper.ClsCNK3();
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DataSet Ds;
            string sBillNo = "";
            long HInterID = 0;
            long HMaterID = 0;
            long HClID = 0;
            long HCLUnitID = 0;
            Ds = oK3Cn.RunProcReturn("exec HX_GetICBillNo 1,50", "t_billcodeby");
            if (Ds.Tables[0].Rows.Count == 0 || Ds == null)
            {
                return false;
            }
            sBillNo = Ds.Tables[0].Rows[0][0].ToString().Trim();
            ///
            Ds = oK3Cn.RunProcReturn("declare @InterID int set @InterID=0 exec GetICMaxNum 'ICBom', @InterID output, 1, 16394 select ltrim(@InterID)", "GetICMaxNum");
            HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) + 10000000;
            //дÈëÐÅÏ¢
            if (oMater.GetInfoByNumber(DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HCol].Value)))
            {
                HMaterID = oMater.omodel.HItemID;
            }
            else
            {
                return false;
            }
            if (oMater.GetInfoByNumber(DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HCLCol].Value)))
            {
                HClID = oMater.omodel.HItemID;
                HCLUnitID=oMater.omodel.HUnitID;
            }
            else
            {
                return false;
            }
            oCn.RunProc("exec h_p_ICBomAdd_K3 " + HInterID.ToString() + ",'" + sBillNo + "'," + DBUtility.ClsPub.isLong(this.txtHICBOMGroupID.Tag).ToString() + "," + HMaterID.ToString() + "," + HClID.ToString() + "," + HCLUnitID.ToString());
            return true;
        }

        private void cmdHBOMGroupID_Click(object sender, EventArgs e)
        {
            DAL.ClsK3_ICBOMGroup_View oBOMGroupID = new DAL.ClsK3_ICBOMGroup_View();
            if (oBOMGroupID.RefreshView())
            {
                this.txtHICBOMGroupID.Text = oBOMGroupID.oModel.HName;
                this.txtHICBOMGroupID.Tag = oBOMGroupID.oModel.HItemID.ToString();
            }
            else
            {
                this.txtHICBOMGroupID.Text = "";
            }
        }

        private void txtHICBOMGroupID_TextChanged(object sender, EventArgs e)
        {
            if (txtHICBOMGroupID.Text.Trim() == "")
            {
                txtHICBOMGroupID.Tag = "0";
            }
        }


    }
}