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

namespace BaseSet
{
    public partial class Gy_NetWeight_DataIn : Form
    {
        //ClsGy_NetWeight_DataIn oTmp = new ClsGy_NetWeight_DataIn();

        DAL.ClsGy_NetWeight_Ctl BillNew = new DAL.ClsGy_NetWeight_Ctl();
        DAL.ClsK3_Material_View oMat = new DAL.ClsK3_Material_View();
        DAL.ClsGy_ICBomBill oBom = new DAL.ClsGy_ICBomBill();
        
        //

        public Gy_NetWeight_DataIn()
        {
            InitializeComponent();
        }


        private void initHeadCaption()
        {

        }

        //
        private void yl_Click(object sender, EventArgs e)
        {
            WriteClass(cmbHDataInTmp.Text);
        }

        //Êý¾Ýµ¼Èë
        public void WriteClass(string sName)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            string sColName;
            string sFieldName;
            if (sName == "¾»ÖØ×ÊÁϵ¼Èë")
            {
                for (int i = 0; i <= grdmain.Rows.Count - 1; i++)
                {
                    if (Mater_WriteClass(i))
                    {
                        if (!BillNew.DeleteByHMaterID(BillNew.oModel.HInterID))
                        {
                            MessageBox.Show("ɾ³ýʧ°Ü£¡");
                            return;
                        }
                        if (!BillNew.AddNew())
                        {
                            MessageBox.Show("±£´æʧ°Ü£¡");
                            return;
                        }
                    }
                    else
                    {
                        MessageBox.Show("µÚ"+DBUtility.ClsPub.isStrNull(i)+"ÐУ¬ÎïÁÏδÕÒµ½£¡");
                        return;
                    }
                }
            }
            MessageBox.Show("µ¼ÈëÍê±Ï");
            grdmain.DataSource = null;
        }

        //дÈëÀà ´Ó¿Ø¼þ
        private bool Mater_WriteClass(int row)
        {
            //
            //BillNew.DetailColl = new List<Model.ClsGy_NetWeight_DataIn_M>();
            //Model.ClsGy_NetWeight_DataIn_M omodel = new Model.ClsGy_NetWeight_DataIn_M();
            //string sBillNo = "";
           // sBillNo = DBUtility.ClsPub.CreateBillCode("1812", ref DBUtility.ClsPub.sExeReturnInfo, true);//µÃµ½Ðµ¥ºÅ£¨È±ÉÙº¯Êý£©  δÍê³É
            int sMaterCol = DBUtility.Gy_BaseFun.Fun_GetCol("²úÆ·´úÂë", grdmain);
            int sQtyCol = DBUtility.Gy_BaseFun.Fun_GetCol("¾»ÖØ", grdmain);

            string sMaterNum = DBUtility.ClsPub.isStrNull(grdmain.Rows[row].Cells[sMaterCol].Value);

            long HMaterID = 0;
            long HBomID = 0;
            string HBomNumber = "";
            //дÈëÐÅÏ¢
            //
            if (oMat.GetInfoByNumber(sMaterNum))
            {
                HMaterID = oMat.omodel.HItemID;
                if (oBom.Get_BOMIDByMaterID(HMaterID, ref HBomID, ref HBomNumber))
                {
                    BillNew.oModel.HInterID = HBomID;
                    if (oBom.ShowBill(HBomID, ref  DBUtility.ClsPub.sExeReturnInfo))
                    {
                        foreach (Model.ClsGy_ICBomBillSub_K3 oSub in oBom.DetailColl)
                        {
                            if (oMat.GetInfoByID(oSub.HMaterID))
                            {
                                BillNew.oModel.HMaterID = oMat.omodel.HItemID;
                            }
                            else
                            {
                                BillNew.oModel.HMaterID = 0;
                                return false;
                            }
                        }
                    }
                }
                else
                {
                    BillNew.oModel.HInterID=0;
                    return false;
                }
            }
            else
            {
                BillNew.oModel.HInterID = 0;
                BillNew.oModel.HMaterID = 0;
                return false;
            }
            BillNew.oModel.HQty = DBUtility.ClsPub.isDoule(grdmain.Rows[row].Cells[sQtyCol].Value);
            
            return true;
        }

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

        private void K3_OutMachFeeDataIn_Load(object sender, EventArgs e)
        {
            cmbHDataInTmp.SelectedIndex = 0;
            initHeadCaption();
        }
        public string ExcelPath;
        
        private void OpenExcelData(string sPath)
        {
            string sName;
            sName = "Sheet1";
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sPath + ";" +
                         "Extended Properties='Excel 8.0;IMEX=1'";
            DataSet ds = new DataSet();
            OleDbConnection conn = new OleDbConnection(strConn);
            conn.Open();
            try
            {
                OleDbDataAdapter Da = new OleDbDataAdapter("select * from [" + sName + "$]", conn);
                Da.Fill(ds);
                grdmain.DataSource = ds.Tables[0];
            }
            catch(Exception e)
            {
                MessageBox.Show("ÒýÈëEXCELÊý¾Ýʧ°Ü£¡ÇëÓë¹ÜÀíÔ±ÁªÏµ£¡" + e.Message);
            }
        }

        private void button1_Click_1(object sender, EventArgs e)
        {
            OpenExcelFile.Title = "Open Excel File  ";
            OpenExcelFile.FileName = "";
            OpenExcelFile.Filter = "Microsoft Office Excel Files(*.xls)|*.xls|(*.csv)|*.csv";
            OpenExcelFile.ShowDialog();
            if (OpenExcelFile.FileName != "")
            {
                ExcelPath = OpenExcelFile.FileName;
                OpenExcelData(ExcelPath);
            }
            else
            {
                ExcelPath = "";
            }

        }

    }
}