using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;

namespace BLL
{
    /// <summary>
    /// ·µ»Ø»ù´¡×ÊÁÏÐÅÏ¢ÀàCLD
    /// </summary>
    public class ClsBaseSelect_CLD
    {

        #region ÉèÖÃÎı¾¿ò

        //Ñ¡ÔñCLDÖ°Ô±
        public static void SetTextByEmp_CLD(TextBox txt)
        {
            //DAL.ClsCLD_Employee_View oEmp = new DAL.ClsCLD_Employee_View();
            //if (oEmp.RefreshView())
            //{
            //    txt.Text = oEmp.oModel.HName;
            //    txt.Tag = oEmp.oModel.HItemID.ToString();
            //}
            //else
            //{
            //    txt.Text = "";
            //}
        }

         

        //Ñ¡ÔñCLD²¿ÃÅ
        /// <summary>
        /// Ñ¡ÔñCLD²¿ÃÅ
        /// </summary>
        /// <param name="txt">µÝÈëÎı¾¿ò</param>
        /// <param name="BackNumber">ÊÇ·ñ·µ»Ø´úÂë</param>
        public static void SetTextByDept_CLD(TextBox txt,bool BackNumber)
        {
            DAL.ClsCLD_Department_View oDept = new DAL.ClsCLD_Department_View();
            if (oDept.RefreshView())
            {
                if (BackNumber==false)
                {
                    txt.Text = oDept.oModel.HName;
                    txt.Tag = oDept.oModel.HItemID.ToString();
                }
                else
                {
                    txt.Text = oDept.oModel.HNumber;
                    txt.Tag = oDept.oModel.HItemID.ToString();
                }
            }
            else
            {
                txt.Text = "";
            }
        }




        //Ñ¡ÔñCLD²Ö¿â
        public static void SetTextByWareHouse_CLD(TextBox txt)
        {
            DAL.ClsCLD_Warehouse_View oWh = new DAL.ClsCLD_Warehouse_View();
            if (oWh.RefreshView())
            {
                txt.Text = oWh.oModel.HName;
                txt.Tag = oWh.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ñ¡ÔñCLD²Ö¿â
        public static void SetTextByWareHouse_CLD(TextBox txt,bool BackNumber)
        {
            DAL.ClsCLD_Warehouse_View oWh = new DAL.ClsCLD_Warehouse_View();
            if (oWh.RefreshView())
            {
                txt.Text = oWh.oModel.HNumber; 
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ñ¡ÔñCLD¿Í»§
        public static void SetTextByCus_CLD(TextBox txt)
        {
            DAL.ClsCLD_Customer_View oCus = new DAL.ClsCLD_Customer_View();
            if (oCus.RefreshView())
            {
                txt.Text = oCus.oModel.HName;
                txt.Tag = oCus.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

       

        

        //Ñ¡ÔñCLD¹©Ó¦ÉÌ
        public static void SetTextBySupplier_CLD(TextBox txt)
        {
            DAL.ClsCLD_Supplier_View oSup = new DAL.ClsCLD_Supplier_View();
            if (oSup.RefreshView())
            {
                txt.Text = oSup.oModel.HName;
                txt.Tag = oSup.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ñ¡ÔñCLD¼ÆÁ¿µ¥Î»
        public static void SetTextByUnit_CLD(TextBox txt)
        {
            DAL.ClsCLD_Unit_View oUnit = new DAL.ClsCLD_Unit_View();
            if (oUnit.RefreshView())
            {
                txt.Text = oUnit.oModel.HName;
                txt.Tag = oUnit.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        

        //Ñ¡ÔñCLDÎïÁÏÉϼ¶×é
        public static void SetTextByMaterGroup_CLD(TextBox txt)
        {
            //DAL.ClsCLD_MaterGroup_View oMaterGroup = new DAL.ClsCLD_MaterGroup_View();
            //if (oMaterGroup.RefreshViewForBig())
            //{
            //    txt.Text = oMaterGroup.oModel.HNumber;
            //    txt.Tag = oMaterGroup.oModel.HItemID.ToString();
            //}
            //else
            //{
            //    txt.Text = "";
            //}
        }

        //Ñ¡ÔñCLDÎïÁÏ
        /// <summary>
        /// Ñ¡ÔñCLDÎïÁÏ
        /// </summary>
        /// <param name="txtNumber">´úÂëÎı¾¿ò</param>
        /// <param name="txtName">Ãû³ÆÎı¾¿ò</param>
        /// <param name="txtModel">¹æ¸ñÎı¾¿ò</param>
        /// <param name="txtUnit">µ¥Î»Îı¾¿ò</param>
        public static void SetTextByMater_CLD(TextBox txtNumber,TextBox txtName,TextBox txtModel,TextBox txtUnit)
        {
            DAL.ClsCLD_Material_View oMater = new DAL.ClsCLD_Material_View();
            DAL.ClsCLD_Unit_View oUnit = new DAL.ClsCLD_Unit_View();
            if (oMater.RefreshView())
            {
                if (oMater.GetInfoByID(oMater.omodel.HItemID))
                {
                    txtNumber.Tag = oMater.omodel.HItemID.ToString();
                    txtNumber.Text = oMater.omodel.HNumber;
                    txtName.Text = oMater.omodel.HName;
                    txtModel.Text = oMater.omodel.HModel;
                    if (oUnit.GetInfoByID(oMater.omodel.HItemID))
                    {
                        txtUnit.Text = oUnit.omodel.HName;
                        txtUnit.Tag = oUnit.omodel.HItemID.ToString();
                    }
                    else
                    {
                        txtUnit.Text ="";
                        txtUnit.Tag = "0";
                    }
                }
            }
            else
            {
                txtNumber.Tag = "0";
                txtNumber.Text = "";
                txtName.Text = "";
                txtModel.Text = "";
                txtUnit.Text = "";
                txtUnit.Tag = "0";
            }
        }

        //Ñ¡ÔñCLDÎïÁÏ
        /// <summary>
        /// Ñ¡ÔñCLDÎïÁÏ
        /// </summary>
        /// <param name="txtNumber">´úÂëÎı¾¿ò</param>
        public static void SetTextByMater_CLD(TextBox txtNumber)
        {
            DAL.ClsCLD_Material_View oMater = new DAL.ClsCLD_Material_View(); 
            if (oMater.RefreshView())
            {
                if (oMater.GetInfoByID(oMater.omodel.HItemID))
                {
                    txtNumber.Tag = oMater.omodel.HItemID.ToString();
                    txtNumber.Text = oMater.omodel.HNumber;
                     
                }
                else
                {
                    txtNumber.Tag = "0";
                    txtNumber.Text = "";
                }
            }
            else
            {
                txtNumber.Tag = "0";
                txtNumber.Text = ""; 
            }
        }

        //Ñ¡ÔñCLD±Ò±ð
        public static void SetTextByCur_CLD(TextBox txt,TextBox txtHRate)
        {
            //DAL.ClsCLD_Currency_View oCur = new DAL.ClsCLD_Currency_View();
            //if (oCur.RefreshView())
            //{
            //    if (oCur.GetInfoByID(oCur.oModel.HItemID))
            //    {
            //        txt.Text = oCur.omodel.HName;
            //        txt.Tag = oCur.omodel.HItemID.ToString();
            //        txtHRate.Text = oCur.omodel.HExRate.ToString();
            //    }
            //    else
            //    {
            //        txt.Text = "";
            //        txt.Tag = "0";
            //        txtHRate.Text = "1";
            //    }
            //}
            //else
            //{
            //    txt.Text = "";
            //    txt.Tag = "0";
            //    txtHRate.Text = "1";
            //}
        }
        //Ñ¡ÔñCLDÁìÁϵ¥
        public static void SetTextByMateOutBill_CLD(TextBox txt)
        {
            //DAL.ClsCLD_MateOutBill_View oMateOutBill = new DAL.ClsCLD_MateOutBill_View();
            //if (oMateOutBill.RefreshView())
            //{
            //    txt.Text = oMateOutBill.oModel.HNumber.ToString();
            //    txt.Tag = oMateOutBill.oModel.HItemID.ToString();
            //}
            //else
            //{
            //    txt.Text = "";
            //}
        }
        //Ñ¡ÔñÁìÁÏÉêÇëµ¥
        public static void SetTextByMateOutRequestBill_CLD(TextBox txt)
        {
            //DAL.ClsKf_MateOutRequestBill_View oMateOutRequestBill = new DAL.ClsKf_MateOutRequestBill_View();
            //if (oMateOutRequestBill.RefreshView())
            //{
            //    txt.Text = oMateOutRequestBill.oModel.HNumber.ToString();
            //    txt.Tag = oMateOutRequestBill.oModel.HItemID.ToString();
            //}
            //else
            //{
            //    txt.Text = "";
            //}
        }


        //Ñ¡ÔñÉú²úÈÎÎñµ¥CLD
        public static void SetTextByICMOBill_CLD(TextBox txt)
        {
            //DAL.ClsCLD_ICMOBill_View oICMO = new DAL.ClsCLD_ICMOBill_View();
            //if (oICMO.RefreshView())
            //{
            //    txt.Text = oICMO.oModel.HNumber.ToString();
            //    txt.Tag = oICMO.oModel.HItemID.ToString();
            //}
            //else
            //{
            //    txt.Text = "";
            //}
        } 

        #endregion


        #region  ÉèÖÃÍø¸ñ

        //ÎïÁÏ-Íø¸ñ
        /// <summary>
        /// ÎïÁÏ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HMaterIDCol"></param>
        /// <param name="HMaterNumberCol"></param>
        /// <param name="HMaterNameCol"></param>
        /// <param name="HMaterModelCol"></param>
        /// <param name="HUnitIDCol"></param>
        /// <param name="HUnitNumberCol"></param>
        /// <param name="HUnitNameCol"></param>
        public static void SetGridByMater_CLD(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol)
        {
            DAL.ClsCLD_Material_View oMater = new DAL.ClsCLD_Material_View();
            DAL.ClsCLD_Unit_View oUnit = new DAL.ClsCLD_Unit_View();
            if (oMater.RefreshView())
            {
                if (oMater.GetInfoByID(oMater.omodel.HItemID))
                {
                    grdMain.Rows[i].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
                    grdMain.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName;
                    grdMain.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
                    if (oUnit.GetInfoByID(oMater.omodel.HUnitID))
                    {
                        grdMain.Rows[i].Cells[HUnitNumberCol].Value = oUnit.omodel.HNumber;
                        grdMain.Rows[i].Cells[HUnitNameCol].Value = oUnit.omodel.HName;
                        grdMain.Rows[i].Cells[HUnitIDCol].Value = oUnit.omodel.HItemID.ToString();
                    }
                    else
                    {
                        grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
                        grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
                        grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
                    }
                }
                else
                {
                    grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
                    grdMain.Rows[i].Cells[HMaterModelCol].Value = "";
                    grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
                    grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
                grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
                grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
                grdMain.Rows[i].Cells[HMaterModelCol].Value = "";
                grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
                grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
                grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
            }
        }

        //²Ö¿â-Íø¸ñ
        /// <summary>
        /// ²Ö¿â-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HWhIDCol"></param>
        /// <param name="HWhNumberCol"></param>
        /// <param name="HWhNameCol"></param>
        public static void SetGridByWareHouse_CLD(DataGridView grdMain, int i, int HWhIDCol, int HWhNumberCol, int HWhNameCol)
        {
            DAL.ClsCLD_Warehouse_View oWh = new DAL.ClsCLD_Warehouse_View();
            if (oWh.RefreshView())
            {
                if (oWh.GetInfoByID(oWh.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HWhIDCol].Value = oWh.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HWhNumberCol].Value = oWh.omodel.HNumber;
                    grdMain.Rows[i].Cells[HWhNameCol].Value = oWh.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HWhIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HWhNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HWhNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HWhIDCol].Value = "0";
                grdMain.Rows[i].Cells[HWhNumberCol].Value = "";
                grdMain.Rows[i].Cells[HWhNameCol].Value = "";
            }
        }


        //ÎïÁÏ-Íø¸ñ
        /// <summary>
        /// ÎïÁÏ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HMaterIDCol"></param>
        /// <param name="HMaterNumberCol"></param>
        /// <param name="HMaterNameCol"></param>
        /// <param name="HMaterModelCol"></param>
        /// <param name="HUnitIDCol"></param>
        /// <param name="HUnitNumberCol"></param>
        /// <param name="HUnitNameCol"></param>
        public static void SetGridByMater_CLD(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol, int HQtyDecimalCol, int HPriceDecimalCol)
        {
            DAL.ClsCLD_Material_View oMater = new DAL.ClsCLD_Material_View();
            DAL.ClsCLD_Unit_View oUnit = new DAL.ClsCLD_Unit_View();
            if (oMater.RefreshView())
            {
                if (oMater.GetInfoByID(oMater.omodel.HItemID))
                {
                    grdMain.Rows[i].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
                    grdMain.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName;
                    grdMain.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
                    //grdMain.Rows[i].Cells[HQtyDecimalCol].Value = oMater.omodel.HQtyDecimal;
                    //grdMain.Rows[i].Cells[HPriceDecimalCol].Value = oMater.omodel.HPriceDecimal;
                    if (oUnit.GetInfoByID(oMater.omodel.HUnitID))
                    {
                        grdMain.Rows[i].Cells[HUnitNumberCol].Value = oUnit.omodel.HNumber;
                        grdMain.Rows[i].Cells[HUnitNameCol].Value = oUnit.omodel.HName;
                        grdMain.Rows[i].Cells[HUnitIDCol].Value = oUnit.omodel.HItemID.ToString();
                    }
                    else
                    {
                        grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
                        grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
                        grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
                    }
                }
                else
                {
                    grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
                    grdMain.Rows[i].Cells[HMaterModelCol].Value = "";
                    grdMain.Rows[i].Cells[HQtyDecimalCol].Value = "0";
                    grdMain.Rows[i].Cells[HPriceDecimalCol].Value = "0";
                    grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
                    grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
                grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
                grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
                grdMain.Rows[i].Cells[HMaterModelCol].Value = "";
                grdMain.Rows[i].Cells[HQtyDecimalCol].Value = "0";
                grdMain.Rows[i].Cells[HPriceDecimalCol].Value = "0";
                grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
                grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
                grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
            }
        }

        //²Öλ-Íø¸ñ
        /// <summary>
        /// ²Öλ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HSPIDCol"></param>
        /// <param name="HSPNumberCol"></param>
        /// <param name="HSPNameCol"></param>
        public static void SetGridByStockPlace_CLD(DataGridView grdMain, int i, int HSPIDCol, int HSPNumberCol, int HSPNameCol)
        {
            DAL.ClsCLD_StockPlace_View oSP = new DAL.ClsCLD_StockPlace_View();
            if (oSP.RefreshView())
            {
                if (oSP.GetInfoByID(oSP.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HSPIDCol].Value = oSP.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HSPNumberCol].Value = oSP.omodel.HNumber;
                    grdMain.Rows[i].Cells[HSPNameCol].Value = oSP.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HSPIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSPNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HSPNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HSPIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSPNumberCol].Value = "";
                grdMain.Rows[i].Cells[HSPNameCol].Value = "";
            }
        }

        //²Öλ-Íø¸ñ
        /// <summary>
        /// ²Öλ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HSPIDCol"></param>
        /// <param name="HSPNumberCol"></param>
        /// <param name="HSPNameCol"></param>
        public static void SetGridByStockPlace_CLD(DataGridView grdMain, int i,Int64 HMaterID, int HSPIDCol, int HSPNumberCol, int HSPNameCol)
        {
            DAL.ClsCLD_StockPlace_View oSP = new DAL.ClsCLD_StockPlace_View();
            if (oSP.RefreshViewByRelation(HMaterID))
            {
                if (oSP.GetInfoByID(oSP.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HSPIDCol].Value = oSP.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HSPNumberCol].Value = oSP.omodel.HNumber;
                    grdMain.Rows[i].Cells[HSPNameCol].Value = oSP.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HSPIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSPNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HSPNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HSPIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSPNumberCol].Value = "";
                grdMain.Rows[i].Cells[HSPNameCol].Value = "";
            }
        }


        //¼ÆÁ¿µ¥Î»-Íø¸ñ
        /// <summary>
        /// ¼ÆÁ¿µ¥Î»-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HUnitIDCol"></param>
        /// <param name="HUnitNumberCol"></param>
        /// <param name="HUnitNameCol"></param>
        public static void SetGridByUnit_CLD(DataGridView grdMain, int i, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol)
        {

            DAL.ClsCLD_Unit_View oUnit = new DAL.ClsCLD_Unit_View();
            if (oUnit.RefreshView())
            {
                if (oUnit.GetInfoByID(oUnit.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HUnitIDCol].Value = oUnit.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HUnitNumberCol].Value = oUnit.omodel.HNumber;
                    grdMain.Rows[i].Cells[HUnitNameCol].Value = oUnit.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
                grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
                grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
            }
        }


        

        //ÎïÁÏÉϼ¶×é-Íø¸ñ
        /// <summary>
        /// ÎïÁÏÉϼ¶×é-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HParentIDCol"></param>
        /// <param name="HParentNumberCol"></param>
        public static void SetGridByMaterGroup_CLD(DataGridView grdMain, int i, int HParentIDCol, int HParentNumberCol,int HParentNameCol)
        {

            //DAL.ClsCLD_MaterGroup_View oMaterGroup = new DAL.ClsCLD_MaterGroup_View();
            //if (oMaterGroup.RefreshViewForBig())
            //{
            //    if (oMaterGroup.GetInfoByID(oMaterGroup.oModel.HItemID))
            //    {
            //        grdMain.Rows[i].Cells[HParentIDCol].Value = oMaterGroup.omodel.HItemID.ToString();
            //        grdMain.Rows[i].Cells[HParentNumberCol].Value = oMaterGroup.omodel.HNumber;
            //        grdMain.Rows[i].Cells[HParentNameCol].Value = oMaterGroup.omodel.HName; 
            //    }
            //    else
            //    {
            //        grdMain.Rows[i].Cells[HParentIDCol].Value = "0";
            //        grdMain.Rows[i].Cells[HParentNumberCol].Value = "";
            //        grdMain.Rows[i].Cells[HParentNameCol].Value = ""; 
            //    }
            //}
            //else
            //{
            //    grdMain.Rows[i].Cells[HParentIDCol].Value = "0";
            //    grdMain.Rows[i].Cells[HParentNumberCol].Value = "";
            //    grdMain.Rows[i].Cells[HParentNameCol].Value = ""; 
            //}
        }


        //ÎïÁÏÊôÐÔ-Íø¸ñ
        public static void SetGridByErpCls_CLD(DataGridView grdMain, int i, int HErpClsIDCol, int HErpClsNameCol)
        {

            //DAL.ClsCLD_ErpCls_View oErpCls = new DAL.ClsCLD_ErpCls_View();
            //if (oErpCls.RefreshView())
            //{
            //    if (oErpCls.GetInfoByID(oErpCls.oModel.HItemID))
            //    {
            //        grdMain.Rows[i].Cells[HErpClsIDCol].Value = oErpCls.omodel.HItemID.ToString();
            //        grdMain.Rows[i].Cells[HErpClsNameCol].Value = oErpCls.omodel.HName;
            //    }
            //    else
            //    {
            //        grdMain.Rows[i].Cells[HErpClsIDCol].Value = "0";
            //        grdMain.Rows[i].Cells[HErpClsNameCol].Value = "";
            //    }
            //}
            //else
            //{
            //    grdMain.Rows[i].Cells[HErpClsIDCol].Value = "0";
            //    grdMain.Rows[i].Cells[HErpClsNameCol].Value = "";
            //}
        }


        //²¿ÃÅ-Íø¸ñ
        /// <summary>
        /// ²¿ÃÅ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HDeptIDCol"></param>
        /// <param name="HDeptNumberCol"></param>
        /// <param name="HDeptNameCol"></param>
        public static void SetGridByDept_CLD(DataGridView grdMain, int i, int HDeptIDCol, int HDeptNumberCol, int HDeptNameCol)
        {

            DAL.ClsCLD_Department_View oDept = new DAL.ClsCLD_Department_View();
            if (oDept.RefreshView())
            {
                if (oDept.GetInfoByID(oDept.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HDeptIDCol].Value = oDept.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HDeptNumberCol].Value = oDept.omodel.HNumber;
                    grdMain.Rows[i].Cells[HDeptNameCol].Value = oDept.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HDeptIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HDeptNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HDeptNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HDeptIDCol].Value = "0";
                grdMain.Rows[i].Cells[HDeptNumberCol].Value = "";
                grdMain.Rows[i].Cells[HDeptNameCol].Value = "";
            }
        }

         
        //ÎïÁÏ·ÖÀà-Íø¸ñ
        /// <summary>
        /// ÎïÁÏ·ÖÀà-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HMaterTypeIDCol"></param>
        /// <param name="HMaterTypeNumberCol"></param>
        /// <param name="HMaterTypeNameCol"></param>
        public static void SetGridByMaterType_CLD(DataGridView grdMain, int i, int HMaterTypeIDCol, int HMaterTypeNumberCol, int HMaterTypeNameCol)
        {

            //DAL.ClsCLD_MaterType_View oMaterType = new DAL.ClsCLD_MaterType_View();
            //if (oMaterType.RefreshView())
            //{
            //    if (oMaterType.GetInfoByID(oMaterType.oModel.HItemID))
            //    {
            //        grdMain.Rows[i].Cells[HMaterTypeIDCol].Value = oMaterType.omodel.HItemID.ToString();
            //        grdMain.Rows[i].Cells[HMaterTypeNumberCol].Value = oMaterType.omodel.HNumber;
            //        grdMain.Rows[i].Cells[HMaterTypeNameCol].Value = oMaterType.omodel.HName;
            //    }
            //    else
            //    {
            //        grdMain.Rows[i].Cells[HMaterTypeIDCol].Value = "0";
            //        grdMain.Rows[i].Cells[HMaterTypeNumberCol].Value = "";
            //        grdMain.Rows[i].Cells[HMaterTypeNameCol].Value = "";
            //    }
            //}
            //else
            //{
            //    grdMain.Rows[i].Cells[HMaterTypeIDCol].Value = "0";
            //    grdMain.Rows[i].Cells[HMaterTypeNumberCol].Value = "";
            //    grdMain.Rows[i].Cells[HMaterTypeNameCol].Value = "";
            //}
        }

        

        //¹©Ó¦ÉÌ-Íø¸ñ
        /// <summary>
        /// ¹©Ó¦ÉÌ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HSupIDCol"></param>
        /// <param name="HSupNumberCol"></param>
        /// <param name="HSupNameCol"></param>
        public static void SetGridBySup_CLD(DataGridView grdMain, int i, int HSupIDCol, int HSupNumberCol, int HSupNameCol)
        {

            DAL.ClsCLD_Supplier_View oSup = new DAL.ClsCLD_Supplier_View();
            if (oSup.RefreshView())
            {
                if (oSup.GetInfoByID(oSup.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HSupIDCol].Value = oSup.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HSupNumberCol].Value = oSup.omodel.HNumber;
                    grdMain.Rows[i].Cells[HSupNameCol].Value = oSup.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HSupIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSupNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HSupNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HSupIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSupNumberCol].Value = "";
                grdMain.Rows[i].Cells[HSupNameCol].Value = "";
            }
        }


        #endregion
    }
}