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

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

        #region ÉèÖÃÎı¾¿ò


        //ÎïÁÏ·ÖÀà
        /// <summary>
        /// ÎïÁÏ·ÖÀà
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByMaterType(TextBox txt)
        {
            DAL.ClsGy_UnitGroup_View oUnitGroup = new DAL.ClsGy_UnitGroup_View();
            if (oUnitGroup.RefreshView())
            {
                txt.Text = oUnitGroup.oModel.HName;
                txt.Tag = oUnitGroup.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ñ¡ÔñÖ°Ô±-°´°à×é
        /// <summary>
        /// Ñ¡ÔñÖ°Ô±-°´°à×é
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByEmp_Group(TextBox txt, long HGroupID)
        {
            DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
            if (oEmp.RefreshView("and HGroupID=" + HGroupID))
            {
                txt.Text = oEmp.oModel.HName;
                txt.Tag = oEmp.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ðé²Ö²Ö¿â
        /// <summary>
        /// ²Ö¿â
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByVirtualWarehouse(TextBox txt)
        {
            DAL.ClsGy_VirtualWarehouse_View oWare = new DAL.ClsGy_VirtualWarehouse_View();
            if (oWare.RefreshView())
            {
                txt.Text = oWare.oModel.HName;
                txt.Tag = oWare.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ñ¡ÔñÐé²Ö³öÈëÀàÐÍ
        /// <summary>
        /// Ñ¡ÔñÐé²Ö³öÈëÀàÐÍ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByVirtualStockClass(TextBox txt)
        {
            DAL.ClsGy_VirtualStockClass_View oVSC = new DAL.ClsGy_VirtualStockClass_View();
            if (oVSC.RefreshView())
            {
                txt.Text = oVSC.oModel.HName;
                txt.Tag = oVSC.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¼ì¾ß
        /// <summary>
        /// ¼ì¾ß
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByCheckTools(TextBox txt)
        {
            DAL.ClsGy_CheckToolsFileMain_View oCheck = new DAL.ClsGy_CheckToolsFileMain_View();
            if (oCheck.RefreshView())
            {
                txt.Text = oCheck.oModel.HName;
                txt.Tag = oCheck.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ñ¡Ôñ»õÔ˹«Ë¾
        /// <summary>
        /// Ñ¡Ôñ»õÔ˹«Ë¾
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByConveyComp(TextBox txt)
        {
            DAL.ClsGy_ConveyComp_View oConveyComp = new DAL.ClsGy_ConveyComp_View();
            if (oConveyComp.RefreshView())
            {
                txt.Text = oConveyComp.oModel.HName;
                txt.Tag = oConveyComp.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }


        //Ñ¡Ôñµµ°¸¹ñ
        /// <summary>
        /// Ñ¡Ôñµµ°¸¹ñ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByArchivesArk(TextBox txt)
        {
            DAL.ClsGy_ArchivesArk_View oArchivesArk = new DAL.ClsGy_ArchivesArk_View();
            if (oArchivesArk.RefreshView())
            {
                txt.Text = oArchivesArk.oModel.HName;
                txt.Tag = oArchivesArk.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ñ¡Ôñµµ°¸²ã
        /// <summary>
        /// Ñ¡Ôñµµ°¸²ã
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByArchivesFloor(TextBox txt)
        {
            DAL.ClsGy_ArchivesFloor_View oArchivesFloor = new DAL.ClsGy_ArchivesFloor_View();
            if (oArchivesFloor.RefreshView())
            {
                txt.Text = oArchivesFloor.oModel.HName;
                txt.Tag = oArchivesFloor.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ñ¡ÔñµØÇø
        /// <summary>
        /// Ñ¡ÔñµØÇø
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByAreaSet(TextBox txt)
        {
            DAL.ClsGy_AreaSet_View oAreaSet = new DAL.ClsGy_AreaSet_View();
            if (oAreaSet.RefreshView())
            {
                txt.Text = oAreaSet.omodel.HName;
                txt.Tag = oAreaSet.omodel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //²»Á¼Ô­Òò
        /// <summary>
        /// ²»Á¼Ô­Òò
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByBadReason(TextBox txt)
        {
            DAL.ClsGy_BadReason_View oBadReason = new DAL.ClsGy_BadReason_View();
            if (oBadReason.RefreshView())
            {
                txt.Text = oBadReason.oModel.HName;
                txt.Tag = oBadReason.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //ÒøÐÐ
        /// <summary>
        /// ÒøÐÐ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByBank(TextBox txt)
        {
            DAL.ClsGy_Bank_View oBank = new DAL.ClsGy_Bank_View();
            if (oBank.RefreshView())
            {
                txt.Text = oBank.oModel.HName;
                txt.Tag = oBank.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //³µÁ¾
        /// <summary>
        /// ³µÁ¾
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByCar(TextBox txt)
        {
            DAL.ClsGy_Car_View oCar = new DAL.ClsGy_Car_View();
            if (oCar.RefreshView())
            {
                txt.Text = oCar.oModel.HName;
                txt.Tag = oCar.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¼¯Ìå¼Æ¼þ·½°¸
        /// <summary>
        /// ¼¯Ìå¼Æ¼þ·½°¸
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByClassTimePrjGroup(TextBox txt)
        {
            DAL.ClsGy_ClassTimePrjGroup_View oCTPG = new DAL.ClsGy_ClassTimePrjGroup_View();
            if (oCTPG.RefreshView())
            {
                txt.Text = oCTPG.oModel.HName;
                txt.Tag = oCTPG.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹«Ë¾ÐÔÖÊ
        /// <summary>
        /// ¹«Ë¾ÐÔÖÊ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByComKind(TextBox txt)
        {
            DAL.ClsGy_ComKind_View oComKind = new DAL.ClsGy_ComKind_View();
            if (oComKind.RefreshView())
            {
                txt.Text = oComKind.oModel.HName;
                txt.Tag = oComKind.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹«Ë¾¹æÄ£
        /// <summary>
        /// ¹«Ë¾¹æÄ£
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByComScope(TextBox txt)
        {
            DAL.ClsGy_ComScope_View oComScope = new DAL.ClsGy_ComScope_View();
            if (oComScope.RefreshView())
            {
                txt.Text = oComScope.oModel.HName;
                txt.Tag = oComScope.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹«Ë¾Àà±ð
        /// <summary>
        /// ¹«Ë¾Àà±ð
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByComSort(TextBox txt)
        {
            DAL.ClsGy_ComSort_View oComSort = new DAL.ClsGy_ComSort_View();
            if (oComSort.RefreshView())
            {
                txt.Text = oComSort.oModel.HName;
                txt.Tag = oComSort.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹«Ë¾ÀàÐÍ/
        /// <summary>
        /// ¹«Ë¾ÀàÐÍ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByComType(TextBox txt)
        {
            DAL.ClsGy_ComType_View oComType = new DAL.ClsGy_ComType_View();
            if (oComType.RefreshView())
            {
                txt.Text = oComType.oModel.HName;
                txt.Tag = oComType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹ÊÕÏÔ­Òò
        /// <summary>
        /// ¹ÊÕÏÔ­Òò
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByConkReason(TextBox txt)
        {
            DAL.ClsGy_ConkReason_View oConkReason = new DAL.ClsGy_ConkReason_View();
            if (oConkReason.RefreshView())
            {
                txt.Text = oConkReason.oModel.HName;
                txt.Tag = oConkReason.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹ÊÕÏÀà±ð
        /// <summary>
        /// ¹ÊÕÏÀà±ð
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByConkType(TextBox txt)
        {
            DAL.ClsGy_ConkType_View oConkType = new DAL.ClsGy_ConkType_View();
            if (oConkType.RefreshView())
            {
                txt.Text = oConkType.oModel.HName;
                txt.Tag = oConkType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //³É±¾ÖÐÐÄ
        /// <summary>
        /// ³É±¾ÖÐÐÄ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByCostCenter(TextBox txt)
        {
            DAL.ClsGy_CostCenter_View oCostCenter = new DAL.ClsGy_CostCenter_View();
            if (oCostCenter.RefreshView())
            {
                txt.Text = oCostCenter.oModel.HName;
                txt.Tag = oCostCenter.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //±Ò±ð
        /// <summary>
        /// ±Ò±ð
        /// </summary>
        /// <param name="txt"></param>
        /// <param name="txtHRate"></param>
        public static void SetTextByCur(TextBox txt, TextBox txtHRate)
        {
            DAL.ClsGy_Currency_View oCur = new DAL.ClsGy_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.HExchangeRate.ToString();
                }
            }
            else
            {
                txt.Text = "";
                txtHRate.Text = "1";
            }
        }

        //±Ò±ð
        /// <summary>
        /// ±Ò±ð ·µ»Ø´úÂë
        /// </summary>
        /// <param name="txt"></param>
        /// <param name="txtHRate"></param>
        public static void SetTextByCur(TextBox txt,bool backNumber)
        {
            DAL.ClsGy_Currency_View oCur = new DAL.ClsGy_Currency_View();
            if (oCur.RefreshView())
            {
                if (oCur.GetInfoByID(oCur.oModel.HItemID))
                {
                    txt.Text = oCur.omodel.HNumber;
                    txt.Tag = oCur.omodel.HItemID.ToString(); 
                }
            }
            else
            {
                txt.Text = ""; 
            }
        }

        //¿Í»§
        /// <summary>
        /// ¿Í»§
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByCus(TextBox txt)
        {
            DAL.ClsGy_Customer_View oCus = new DAL.ClsGy_Customer_View();
            if (oCus.RefreshView())
            {
                txt.Text = oCus.oModel.HName;
                txt.Tag = oCus.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¿Í»§·ÖÀà
        /// <summary>
        /// ¿Í»§·ÖÀà
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByCusType(TextBox txt)
        {
            DAL.ClsGy_CusType_View oCusType = new DAL.ClsGy_CusType_View();
            if (oCusType.RefreshView())
            {
                txt.Text = oCusType.oModel.HName;
                txt.Tag = oCusType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //²¿ÃÅ
        /// <summary>
        /// ²¿ÃÅ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByDept(TextBox txt)
        {
            DAL.ClsGy_Department_View oDept = new DAL.ClsGy_Department_View();
            if (oDept.RefreshView())
            {
                txt.Text = oDept.oModel.HName;
                txt.Tag = oDept.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        ////²¿ÃŽӿÚ
        ///// <summary>
        ///// ²¿ÃŽӿÚ
        ///// </summary>
        ///// <param name="txt"></param>
        //public static void SetTextByDept_IF(TextBox txt)
        //{
        //    DAL.ClsIF_Department_View oDept = new DAL.ClsIF_Department_View();
        //    if (oDept.RefreshView())
        //    {
        //        txt.Text = oDept.oModel.HName;
        //        txt.Tag = oDept.oModel.HItemID.ToString();
        //    }
        //    else
        //    {
        //        txt.Text = "";
        //    }
        //}

        //²¿ÃÅ
        /// <summary>
        /// ²¿ÃÅ ·µ»Ø´úÂë
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByDept(TextBox txt,bool backNumber)
        {
            DAL.ClsGy_Department_View oDept = new DAL.ClsGy_Department_View();
            if (oDept.RefreshView())
            {
                txt.Text = oDept.oModel.HNumber;
                txt.Tag = oDept.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //ËÞÉá
        /// <summary>
        /// ËÞÉá
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByDorm(TextBox txt)
        {
            DAL.ClsGy_Dorm_View oDorm = new DAL.ClsGy_Dorm_View();
            if (oDorm.RefreshView())
            {
                txt.Text = oDorm.oModel.HName;
                txt.Tag = oDorm.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¿Û²¹×ÊÁÏ
        /// <summary>
        /// ¿Û²¹×ÊÁÏ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByDuSubsidyItem(TextBox txt)
        {
            DAL.ClsGy_DuSubsidyItem_View oDuSubsidyItem = new DAL.ClsGy_DuSubsidyItem_View();
            if (oDuSubsidyItem.RefreshView())
            {
                txt.Text = oDuSubsidyItem.oModel.HName;
                txt.Tag = oDuSubsidyItem.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ö°Îñ
        /// <summary>
        /// Ö°Îñ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByDuty(TextBox txt)
        {
            DAL.ClsGy_Duty_View oDuty = new DAL.ClsGy_Duty_View();
            if (oDuty.RefreshView())
            {
                txt.Text = oDuty.oModel.HName;
                txt.Tag = oDuty.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ñ¡ÔñÖ°Ô±
        /// <summary>
        /// Ñ¡ÔñÖ°Ô±
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByEmp(TextBox txt)
        {
            DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
            if (oEmp.RefreshView())
            {
                txt.Text = oEmp.oModel.HName;
                txt.Tag = oEmp.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ñ¡ÔñÖ°Ô±
        /// <summary>
        /// Ñ¡ÔñÖ°Ô±
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByEmp(TextBox txt,TextBox txtName)
        {
            DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
            if (oEmp.RefreshView())
            {
                txt.Text = oEmp.oModel.HNumber;
                txt.Tag = oEmp.oModel.HItemID.ToString();
                txtName.Text = oEmp.oModel.HName;
            }
            else
            {
                txt.Text = "";
                txtName.Text = "";
            }
        }

        //ÄÜÔ´ÏîÄ¿
        /// <summary>
        /// ÄÜÔ´ÏîÄ¿
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByEnergy(TextBox txt)
        {
            DAL.ClsGy_Energy_View oEnergy = new DAL.ClsGy_Energy_View();
            if (oEnergy.RefreshView())
            {
                txt.Text = oEnergy.oModel.HName;
                txt.Tag = oEnergy.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //É豸
        /// <summary>
        /// É豸
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByEquipMent(TextBox txt)
        {
            DAL.ClsGy_EquipMent_View oEquipMent = new DAL.ClsGy_EquipMent_View();
            if (oEquipMent.RefreshView())
            {
                txt.Text = oEquipMent.oModel.HName;
                txt.Tag = oEquipMent.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Òì³£ÀàÐÍ
        /// <summary>
        /// Òì³£ÀàÐÍ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByErrType(TextBox txt)
        {
            DAL.ClsGy_ErrType_View oErrType = new DAL.ClsGy_ErrType_View();
            if (oErrType.RefreshView())
            {
                txt.Text = oErrType.oModel.HName;
                txt.Tag = oErrType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //ÆÀ¼ÛÇé¿ö
        /// <summary>
        /// ÆÀ¼ÛÇé¿ö
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByEvaluateStatus(TextBox txt)
        {
            DAL.ClsGy_EvaluateStatus_View oEvaluateStatus = new DAL.ClsGy_EvaluateStatus_View();
            if (oEvaluateStatus.RefreshView())
            {
                txt.Text = oEvaluateStatus.oModel.HName;
                txt.Tag = oEvaluateStatus.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //·ÑÓÃÇé¿ö
        /// <summary>
        /// ·ÑÓÃÇé¿ö
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByExpenseStatus(TextBox txt)
        {
            DAL.ClsGy_ExpenseStatus_View oExpenseStatus = new DAL.ClsGy_ExpenseStatus_View();
            if (oExpenseStatus.RefreshView())
            {
                txt.Text = oExpenseStatus.oModel.HName;
                txt.Tag = oExpenseStatus.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //³§¼Ò
        /// <summary>
        /// ³§¼Ò
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByFactory(TextBox txt)
        {
            DAL.ClsGy_Factory_View oFactory = new DAL.ClsGy_Factory_View();
            if (oFactory.RefreshView())
            {
                txt.Text = oFactory.oModel.HName;
                txt.Tag = oFactory.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //°à×é
        /// <summary>
        /// °à×é
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByGroup(TextBox txt)
        {
            DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();
            if (oGroup.RefreshView())
            {
                txt.Text = oGroup.oModel.HName;
                txt.Tag = oGroup.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //°à×é
        /// <summary>
        /// °à×é
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByGroup(TextBox txt,TextBox txtName)
        {
            DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();
            if (oGroup.RefreshView())
            {
                txt.Text = oGroup.oModel.HNumber;
                txt.Tag = oGroup.oModel.HItemID.ToString();
                txtName.Text = oGroup.oModel.HName;
            }
            else
            {
                txt.Text = "";
                txtName.Text = "";
            }
        }

        //½Ú¼ÙÈÕ
        /// <summary>
        /// ½Ú¼ÙÈÕ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByHoliday(TextBox txt)
        {
            DAL.ClsGy_Holiday_View oHoliday = new DAL.ClsGy_Holiday_View();
            if (oHoliday.RefreshView())
            {
                txt.Text = oHoliday.oModel.HName;
                txt.Tag = oHoliday.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //±£ÑøÏîÄ¿
        /// <summary>
        /// ±£ÑøÏîÄ¿
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByMaintain(TextBox txt)
        {
            DAL.ClsGy_Maintain_View oMaintain = new DAL.ClsGy_Maintain_View();
            if (oMaintain.RefreshView())
            {
                txt.Text = oMaintain.oModel.HName;
                txt.Tag = oMaintain.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¿Í»§¶ÔÓ¦ÎïÁÏ
        /// <summary>
        /// ¿Í»§¶ÔÓ¦ÎïÁÏ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByMateNumRelation(TextBox txt)
        {
            DAL.ClsGy_MateNumRelation_View oMateNumRelation = new DAL.ClsGy_MateNumRelation_View();
            if (oMateNumRelation.RefreshView())
            {
                txt.Text = oMateNumRelation.oModel.HName;
                txt.Tag = oMateNumRelation.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

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

        //ÎïÁÏ
        /// <summary>
        /// ÎïÁÏ Ö»·µ»Ø´úÂë
        /// </summary>
        /// <param name="txtNumber">´úÂëÎı¾¿ò</param>
        public static void SetTextByMaterial(TextBox txtNumber)
        {
            DAL.ClsGy_Material_View oMaterial = new DAL.ClsGy_Material_View();
            if (oMaterial.RefreshView())
            {
                if (oMaterial.GetInfoByID(oMaterial.oModel.HItemID))
                {
                    txtNumber.Text = oMaterial.omodel.HNumber;
                    txtNumber.Tag = oMaterial.omodel.HItemID.ToString();
                   
                }
                else
                {
                    txtNumber.Text = "";
                    txtNumber.Tag = "0";
                }
            }
            else
            {
                txtNumber.Text = "";
                txtNumber.Tag = "0";
            }
        }

        //ÎïÁÏÌØÐÔ
        /// <summary>
        /// ÎïÁÏÌØÐÔ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByMaterTrait(TextBox txt)
        {
            DAL.ClsGy_MaterTrait_View oMaterTrait = new DAL.ClsGy_MaterTrait_View();
            if (oMaterTrait.RefreshView())
            {
                txt.Text = oMaterTrait.oModel.HName;
                txt.Tag = oMaterTrait.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹æ¸ñÐͺÅ
        /// <summary>
        /// ¹æ¸ñÐͺÅ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByModel(TextBox txt)
        {
            DAL.ClsGy_Model_View oModel = new DAL.ClsGy_Model_View();
            if (oModel.RefreshView())
            {
                txt.Text = oModel.oModel.HName;
                txt.Tag = oModel.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¶©µ¥µÈ¼¶
        /// <summary>
        /// ¶©µ¥µÈ¼¶
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByOrderLev(TextBox txt)
        {
            DAL.ClsGy_OrderLev_View oOrderLev = new DAL.ClsGy_OrderLev_View();
            if (oOrderLev.RefreshView())
            {
                txt.Text = oOrderLev.oModel.HName;
                txt.Tag = oOrderLev.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Ö¤¼þÀà±ð
        /// <summary>
        /// Ö¤¼þÀà±ð
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByPaperSort(TextBox txt)
        {
            DAL.ClsGy_PaperSort_View oPaperSort = new DAL.ClsGy_PaperSort_View();
            if (oPaperSort.RefreshView())
            {
                txt.Text = oPaperSort.oModel.HName;
                txt.Tag = oPaperSort.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //×ÊÔ´ÄÜÁ¦
        /// <summary>
        /// ×ÊÔ´ÄÜÁ¦
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByPlanShifts(TextBox txt)
        {
            //DAL.ClsGy_PlanShifts_View oPlanShifts = new DAL.ClsGy_PlanShifts_View();
            //if (oPlanShifts.RefreshView())
            //{
            //    txt.Text = oPlanShifts.oModel.HName;
            //    txt.Tag = oPlanShifts.oModel.HItemID.ToString();
            //}
            //else
            //{
            //    txt.Text = "";
            //}
        }

        //¸Û¿Ú
        /// <summary>
        /// ¸Û¿Ú
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByPort(TextBox txt)
        {
            DAL.ClsGy_Port_View oPort = new DAL.ClsGy_Port_View();
            if (oPort.RefreshView())
            {
                txt.Text = oPort.oModel.HName;
                txt.Tag = oPort.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¸Úλ
        /// <summary>
        /// ¸Úλ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByPost(TextBox txt)
        {
            DAL.ClsGy_Post_View oPost = new DAL.ClsGy_Post_View();
            if (oPost.RefreshView())
            {
                txt.Text = oPost.oModel.HName;
                txt.Tag = oPost.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //²É¹º·½Ê½
        /// <summary>
        /// ²É¹º·½Ê½
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByPoStockStyle(TextBox txt)
        {
            DAL.ClsGy_PoStockStyle_View oPoStockStyle = new DAL.ClsGy_PoStockStyle_View();
            if (oPoStockStyle.RefreshView())
            {
                txt.Text = oPoStockStyle.oModel.HName;
                txt.Tag = oPoStockStyle.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //ίÍ⹤Ðò
        /// <summary>
        /// ίÍ⹤Ðò
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByProcComm(TextBox txt)
        {
            DAL.ClsGy_ProcComm_View oProcComm = new DAL.ClsGy_ProcComm_View();
            if (oProcComm.RefreshView())
            {
                txt.Text = oProcComm.oModel.HName;
                txt.Tag = oProcComm.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹¤Ðò
        /// <summary>
        /// ¹¤Ðò
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByProcess(TextBox txt)
        {
            DAL.ClsGy_Process_View oProcess = new DAL.ClsGy_Process_View();
            if (oProcess.RefreshView())
            {
                txt.Text = oProcess.oModel.HName;
                txt.Tag = oProcess.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹¤¶Î
        /// <summary>
        /// ¹¤¶Î
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByProcMul(TextBox txt)
        {
            DAL.ClsGy_ProcMul_View oProcMul = new DAL.ClsGy_ProcMul_View();
            if (oProcMul.RefreshView())
            {
                txt.Text = oProcMul.oModel.HName;
                txt.Tag = oProcMul.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¶¨¶î¹é¼¯
        /// <summary>
        /// ¶¨¶î¹é¼¯
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByProcPriceRela(TextBox txt)
        {
            DAL.ClsGy_ProcPriceRela_View oProcPriceRela = new DAL.ClsGy_ProcPriceRela_View();
            if (oProcPriceRela.RefreshView())
            {
                txt.Text = oProcPriceRela.oModel.HName;
                txt.Tag = oProcPriceRela.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¶¨¶î¹é¼¯×é
        /// <summary>
        /// ¶¨¶î¹é¼¯×é
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByProcPriceRelaGroup(TextBox txt)
        {
            DAL.ClsGy_ProcPriceRelaGroup_View oPriceRelaGroup = new DAL.ClsGy_ProcPriceRelaGroup_View();
            if (oPriceRelaGroup.RefreshView())
            {
                txt.Text = oPriceRelaGroup.oModel.HName;
                txt.Tag = oPriceRelaGroup.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Éú²úÀàÐÍ
        /// <summary>
        /// Éú²úÀàÐÍ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByProdType(TextBox txt)
        {
            DAL.ClsGy_ProdType_View oProdType = new DAL.ClsGy_ProdType_View();
            if (oProdType.RefreshView())
            {
                txt.Text = oProdType.oModel.HName;
                txt.Tag = oProdType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //²úÆ·ÌØÐÔ
        /// <summary>
        /// ²úÆ·ÌØÐÔ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByProductSpec(TextBox txt)
        {
            DAL.ClsGy_ProductSpec_View oProductSpec = new DAL.ClsGy_ProductSpec_View();
            if (oProductSpec.RefreshView())
            {
                txt.Text = oProductSpec.oModel.HName;
                txt.Tag = oProductSpec.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //ÏîÄ¿¹¤³Ì
        /// <summary>
        /// ÏîÄ¿¹¤³Ì
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByProject(TextBox txt)
        {
            DAL.ClsGy_Project_View oProject = new DAL.ClsGy_Project_View();
            if (oProject.RefreshView())
            {
                txt.Text = oProject.oModel.HName;
                txt.Tag = oProject.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¸¨ÖúÊôÐÔ
        /// <summary>
        /// ¸¨ÖúÊôÐÔ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByProperty(TextBox txt)
        {
            DAL.ClsGy_Property_View oProperty = new DAL.ClsGy_Property_View();
            if (oProperty.RefreshView())
            {
                txt.Text = oProperty.oModel.HName;
                txt.Tag = oProperty.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¸¨ÖúÊôÐÔÀà±ð
        /// <summary>
        /// ¸¨ÖúÊôÐÔÀà±ð
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByPropertyType(TextBox txt)
        {
            DAL.ClsGy_PropertyType_View oPropertyType = new DAL.ClsGy_PropertyType_View();
            if (oPropertyType.RefreshView())
            {
                txt.Text = oPropertyType.oModel.HName;
                txt.Tag = oPropertyType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //άÐÞÏîÄ¿
        /// <summary>
        /// άÐÞÏîÄ¿
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByRepair(TextBox txt)
        {
            DAL.ClsGy_Repair_View oRepair = new DAL.ClsGy_Repair_View();
            if (oRepair.RefreshView())
            {
                txt.Text = oRepair.oModel.HName;
                txt.Tag = oRepair.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //άÐÞÑéÊÕÏîÄ¿
        /// <summary>
        /// άÐÞÑéÊÕÏîÄ¿
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByRepairCheck(TextBox txt)
        {
            DAL.ClsGy_RepairCheck_View oRepairCheck = new DAL.ClsGy_RepairCheck_View();
            if (oRepairCheck.RefreshView())
            {
                txt.Text = oRepairCheck.oModel.HName;
                txt.Tag = oRepairCheck.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //άÐÞ·½Ê½
        /// <summary>
        /// άÐÞ·½Ê½
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByRepairType(TextBox txt)
        {
            DAL.ClsGy_RepairType_View oRepairType = new DAL.ClsGy_RepairType_View();
            if (oRepairType.RefreshView())
            {
                txt.Text = oRepairType.oModel.HName;
                txt.Tag = oRepairType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹¤ÒÕ·Ïß´óÀà
        /// <summary>
        /// ¹¤ÒÕ·Ïß´óÀà
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByRoutingGroup(TextBox txt)
        {
            DAL.ClsGy_RoutingGroup_View oRoutingGroup = new DAL.ClsGy_RoutingGroup_View();
            if (oRoutingGroup.RefreshView())
            {
                txt.Text = oRoutingGroup.oModel.HName;
                txt.Tag = oRoutingGroup.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //°²È«ÏîÄ¿
        /// <summary>
        /// °²È«ÏîÄ¿
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySafety(TextBox txt)
        {
            DAL.ClsGy_Safety_View oSafety = new DAL.ClsGy_Safety_View();
            if (oSafety.RefreshView())
            {
                txt.Text = oSafety.oModel.HName;
                txt.Tag = oSafety.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //±¨·ÏÔ­Òò
        /// <summary>
        /// ±¨·ÏÔ­Òò
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByScrapReason(TextBox txt)
        {
            DAL.ClsGy_ScrapReason_View oScrapReason = new DAL.ClsGy_ScrapReason_View();
            if (oScrapReason.RefreshView())
            {
                txt.Text = oScrapReason.oModel.HName;
                txt.Tag = oScrapReason.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //·þÎñÀàÐÍ
        /// <summary>
        /// ·þÎñÀàÐÍ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySecType(TextBox txt)
        {
            DAL.ClsGy_SecType_View oSecType = new DAL.ClsGy_SecType_View();
            if (oSecType.RefreshView())
            {
                txt.Text = oSecType.oModel.HName;
                txt.Tag = oSecType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //ÏúÊÛ·½Ê½
        /// <summary>
        /// ÏúÊÛ·½Ê½
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySellStyle(TextBox txt)
        {
            DAL.ClsGy_SellStyle_View oSellStyle = new DAL.ClsGy_SellStyle_View();
            if (oSellStyle.RefreshView())
            {
                txt.Text = oSellStyle.oModel.HName;
                txt.Tag = oSellStyle.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //½áË㷽ʽ
        /// <summary>
        /// ½áË㷽ʽ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySettleStyle(TextBox txt)
        {
            DAL.ClsGy_SettleStyle_View oSettleStyle = new DAL.ClsGy_SettleStyle_View();
            if (oSettleStyle.RefreshView())
            {
                txt.Text = oSettleStyle.oModel.HName;
                txt.Tag = oSettleStyle.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //°à´Î
        /// <summary>
        /// °à´Î
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByShifts(TextBox txt)
        {
            DAL.ClsGy_Shifts_View oShifts = new DAL.ClsGy_Shifts_View();
            if (oShifts.RefreshView())
            {
                txt.Text = oShifts.oModel.HName;
                txt.Tag = oShifts.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Éú²ú×ÊÔ´
        /// <summary>
        /// Éú²ú×ÊÔ´
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySource(TextBox txt)
        {
            DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
            if (oSource.RefreshView())
            {
                txt.Text = oSource.oModel.HName;
                txt.Tag = oSource.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Èë¿âÀàÐÍ
        /// <summary>
        /// Èë¿âÀàÐÍ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByStockInStyle(TextBox txt)
        {
            DAL.ClsGy_StockInStyle_View oStockInStyle = new DAL.ClsGy_StockInStyle_View();
            if (oStockInStyle.RefreshView())
            {
                txt.Text = oStockInStyle.oModel.HName;
                txt.Tag = oStockInStyle.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //³ö¿âÀàÐÍ
        /// <summary>
        /// ³ö¿âÀàÐÍ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByStockOutStyle(TextBox txt)
        {
            DAL.ClsGy_StockOutStyle_View oStockOutStyle = new DAL.ClsGy_StockOutStyle_View();
            if (oStockOutStyle.RefreshView())
            {
                txt.Text = oStockOutStyle.oModel.HName;
                txt.Tag = oStockOutStyle.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //²Öλ
        /// <summary>
        /// ²Öλ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByStockPlace(TextBox txt)
        {
            DAL.ClsGy_StockPlace_View oStockPlace = new DAL.ClsGy_StockPlace_View();
            if (oStockPlace.RefreshView())
            {
                txt.Text = oStockPlace.oModel.HName;
                txt.Tag = oStockPlace.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //²Öλ×é
        /// <summary>
        /// ²Öλ×é
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByStockPlaceGroup(TextBox txt)
        {
            DAL.ClsGy_StockPlaceGroup_View oStockPlaceGroup = new DAL.ClsGy_StockPlaceGroup_View();
            if (oStockPlaceGroup.RefreshView())
            {
                txt.Text = oStockPlaceGroup.oModel.HName;
                txt.Tag = oStockPlaceGroup.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹©Ó¦ÉÌ
        /// <summary>
        /// ¹©Ó¦ÉÌ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySupplier(TextBox txt)
        {
            DAL.ClsGy_Supplier_View oSupplier = new DAL.ClsGy_Supplier_View();
            if (oSupplier.RefreshView())
            {
                txt.Text = oSupplier.oModel.HName;
                txt.Tag = oSupplier.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹©Ó¦ÉÌ
        /// <summary>
        /// ¹©Ó¦ÉÌ ·µ»Ø´úÂë
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySupplier(TextBox txt,bool backNumber)
        {
            DAL.ClsGy_Supplier_View oSupplier = new DAL.ClsGy_Supplier_View();
            if (oSupplier.RefreshView())
            {
                txt.Text = oSupplier.oModel.HNumber;
                txt.Tag = oSupplier.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹©Ó¦Àà±ð
        /// <summary>
        /// ¹©Ó¦Àà±ð
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySupSort(TextBox txt)
        {
            DAL.ClsGy_SupSort_View oSupSort = new DAL.ClsGy_SupSort_View();
            if (oSupSort.RefreshView())
            {
                txt.Text = oSupSort.oModel.HName;
                txt.Tag = oSupSort.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹©Ó¦É̵ȼ¶
        /// <summary>
        /// ¹©Ó¦É̵ȼ¶
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySupStatus(TextBox txt)
        {
            DAL.ClsGy_SupStatus_View oSupStatus = new DAL.ClsGy_SupStatus_View();
            if (oSupStatus.RefreshView())
            {
                txt.Text = oSupStatus.oModel.HName;
                txt.Tag = oSupStatus.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹©Ó¦ÉÌÖ¸±ê
        /// <summary>
        /// ¹©Ó¦ÉÌÖ¸±ê
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySupTarget(TextBox txt)
        {
            DAL.ClsGy_SupTarget_View oSupTarget = new DAL.ClsGy_SupTarget_View();
            if (oSupTarget.RefreshView())
            {
                txt.Text = oSupTarget.oModel.HName;
                txt.Tag = oSupTarget.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹©Ó¦ÉÌ·ÖÀà
        /// <summary>
        /// ¹©Ó¦ÉÌ·ÖÀà
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextBySupType(TextBox txt)
        {
            DAL.ClsGy_SupType_View oSupType = new DAL.ClsGy_SupType_View();
            if (oSupType.RefreshView())
            {
                txt.Text = oSupType.oModel.HName;
                txt.Tag = oSupType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //ËùÊôÐÐÒµ
        /// <summary>
        /// ËùÊôÐÐÒµ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByTrade(TextBox txt)
        {
            DAL.ClsGy_Trade_View oTrade = new DAL.ClsGy_Trade_View();
            if (oTrade.RefreshView())
            {
                txt.Text = oTrade.oModel.HName;
                txt.Tag = oTrade.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¼ÆÁ¿µ¥Î»
        /// <summary>
        /// ¼ÆÁ¿µ¥Î»
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByUnit(TextBox txt)
        {
            DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View();
            if (oUnit.RefreshView())
            {
                txt.Text = oUnit.oModel.HName;
                txt.Tag = oUnit.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¼ÆÁ¿µ¥Î»
        /// <summary>
        /// ¼ÆÁ¿µ¥Î»
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByUnit(TextBox txt,string sWhere)
        {
            DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View();
            if (oUnit.RefreshView(sWhere))
            {
                txt.Text = oUnit.oModel.HName;
                txt.Tag = oUnit.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¼ÆÁ¿µ¥Î»×é
        /// <summary>
        /// ¼ÆÁ¿µ¥Î»×é
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByUnitGroup(TextBox txt)
        {
            DAL.ClsGy_UnitGroup_View oUnitGroup = new DAL.ClsGy_UnitGroup_View();
            if (oUnitGroup.RefreshView())
            {
                txt.Text = oUnitGroup.oModel.HName;
                txt.Tag = oUnitGroup.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //²Ö¿â
        /// <summary>
        /// ²Ö¿â
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByWarehouse(TextBox txt)
        {
            DAL.ClsGy_Warehouse_View oWarehouse = new DAL.ClsGy_Warehouse_View();
            if (oWarehouse.RefreshView())
            {
                txt.Text = oWarehouse.oModel.HName;
                txt.Tag = oWarehouse.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //²Ö¿â
        /// <summary>
        /// ²Ö¿â Ö»·µ»Ø´úÂë
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByWarehouse(TextBox txt,bool backNumber)
        {
            DAL.ClsGy_Warehouse_View oWarehouse = new DAL.ClsGy_Warehouse_View();
            if (oWarehouse.RefreshView())
            {
                txt.Text = oWarehouse.oModel.HNumber;
                txt.Tag = oWarehouse.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹¤×÷ÖÐÐÄ
        /// <summary>
        /// ¹¤×÷ÖÐÐÄ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByWorkCenter(TextBox txt)
        {
            DAL.ClsGy_WorkCenter_View oWorkCenter = new DAL.ClsGy_WorkCenter_View();
            if (oWorkCenter.RefreshView())
            {
                txt.Text = oWorkCenter.oModel.HName;
                txt.Tag = oWorkCenter.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹¤×ÊÀàÐÍ
        /// <summary>
        /// ¹¤×ÊÀàÐÍ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByWorkPayType(TextBox txt)
        {
            DAL.ClsGy_WorkPayType_View oWorkPayType = new DAL.ClsGy_WorkPayType_View();
            if (oWorkPayType.RefreshView())
            {
                txt.Text = oWorkPayType.oModel.HName;
                txt.Tag = oWorkPayType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //¹¤ÖÖ
        /// <summary>
        /// ¹¤ÖÖ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByWorkType(TextBox txt)
        {
            DAL.ClsGy_WorkType_View oWorkType = new DAL.ClsGy_WorkType_View();
            if (oWorkType.RefreshView())
            {
                txt.Text = oWorkType.oModel.HName;
                txt.Tag = oWorkType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }


        //Òì³£¹¤¼Û
        /// <summary>
        /// Òì³£¹¤¼Û
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByErrWorkPirce(TextBox txt)
        {
            DAL.ClsGy_ErrWorkPrice_View oWorkPrice = new DAL.ClsGy_ErrWorkPrice_View();
            if (oWorkPrice.RefreshView())
            {
                txt.Text = oWorkPrice.oModel.HName;
                txt.Tag = oWorkPrice.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }


        //²É¼¯Æ÷
        /// <summary>
        /// ²É¼¯Æ÷
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByCollect(TextBox txt)
        {
            DAL.ClsGy_Collect_View oCollect = new DAL.ClsGy_Collect_View();
            if (oCollect.RefreshView())
            {
                txt.Text = oCollect.oModel.HName;
                txt.Tag = oCollect.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Òµ»§
        /// <summary>
        /// Òµ»§
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByRoom(TextBox txt)
        {
            DAL.ClsGy_Room_View oRoom = new DAL.ClsGy_Room_View();
            if (oRoom.RefreshView())
            {
                txt.Text = oRoom.oModel.HName;
                txt.Tag = oRoom.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //Â¥ºÅ
        /// <summary>
        /// Â¥ºÅ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByBuilding(TextBox txt)
        {
            DAL.ClsGy_Building_View oBuilding = new DAL.ClsGy_Building_View();
            if (oBuilding.RefreshView())
            {
                txt.Text = oBuilding.oModel.HName;
                txt.Tag = oBuilding.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        //»§ÐÍ
        /// <summary>
        /// »§ÐÍ
        /// </summary>
        /// <param name="txt"></param>
        public static void SetTextByHouseType(TextBox txt)
        {
            DAL.ClsGy_HouseType_View oHouseType = new DAL.ClsGy_HouseType_View();
            if (oHouseType.RefreshView())
            {
                txt.Text = oHouseType.oModel.HName;
                txt.Tag = oHouseType.oModel.HItemID.ToString();
            }
            else
            {
                txt.Text = "";
            }
        }

        #endregion



        #region  ÉèÖÃÍø¸ñ


        //²Öλ-Íø¸ñ ¸ù¾Ý²Ö¿â
        /// <summary>
        /// ²Öλ-Íø¸ñ ¸ù¾Ý²Ö¿â
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HStockPlaceIDCol"></param>
        /// <param name="HStockPlaceNumberCol"></param>
        /// <param name="HStockPlaceNameCol"></param>
        public static void SetGridByStockPlaceByWh(DataGridView grdMain, int i, int HWhIDCol, int HStockPlaceIDCol, int HStockPlaceNumberCol, int HStockPlaceNameCol)
        {

            DAL.ClsGy_StockPlace_View oStockPlace = new DAL.ClsGy_StockPlace_View();
            if (oStockPlace.RefreshView())
            {
                if (oStockPlace.GetInfoByID(oStockPlace.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = oStockPlace.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = oStockPlace.omodel.HNumber;
                    grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = oStockPlace.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
                grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
                grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
            }
        }


        //²Öλ-Íø¸ñ ¸ù¾Ý²Ö¿â
        /// <summary>
        /// ²Öλ-Íø¸ñ ¸ù¾Ý²Ö¿â
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HStockPlaceIDCol"></param>
        /// <param name="HStockPlaceNumberCol"></param>
        /// <param name="HStockPlaceNameCol"></param>
        public static void SetGridByStockPlaceByWh(DataGridView grdMain, int i, int HWhIDCol, int HStockPlaceIDCol, int HStockPlaceNumberCol, int HStockPlaceNameCol, int HSPGroupIDCol, int HSPGroupNameCol, ref string sBackStr)
        {

            DAL.ClsGy_StockPlace_View oSP = new DAL.ClsGy_StockPlace_View();
            DAL.ClsGy_StockPlaceGroup_View oSPGroup = new DAL.ClsGy_StockPlaceGroup_View();
            if (DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HWhIDCol].Value) == 0)
            {
                sBackStr = "ûÓÐÑ¡Ôñ²Ö¿â£¡";
                return;
            }
            if (oSP.RefreshViewByWh(DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HWhIDCol].Value)))
            {
                if (oSP.GetInfoByID(oSP.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = oSP.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = oSP.omodel.HNumber;
                    grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = oSP.omodel.HName;
                    if (oSPGroup.GetInfoByID(oSP.omodel.HSPGroupID))
                    {
                        grdMain.Rows[i].Cells[HSPGroupIDCol].Value = oSPGroup.omodel.HItemID;
                        grdMain.Rows[i].Cells[HSPGroupNameCol].Value = oSPGroup.omodel.HName;
                    }
                    else
                    {
                        grdMain.Rows[i].Cells[HSPGroupIDCol].Value = "0";
                        grdMain.Rows[i].Cells[HSPGroupNameCol].Value = "";
                    }
                }
                else
                {
                    grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
                    grdMain.Rows[i].Cells[HSPGroupIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSPGroupNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
                grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
                grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
                grdMain.Rows[i].Cells[HSPGroupIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSPGroupNameCol].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(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol)
        {
            DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
            DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_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="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(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol, int HSubjoinCol, int HColorCol)
        {
            DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
            DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_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[HSubjoinCol].Value = oMater.omodel.HSubjoin;
                    grdMain.Rows[i].Cells[HColorCol].Value = oMater.omodel.HColor;
                    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[HSubjoinCol].Value = "";
                    grdMain.Rows[i].Cells[HColorCol].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[HSubjoinCol].Value = "";
                grdMain.Rows[i].Cells[HColorCol].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(DataGridView grdMain, int i, int HWhIDCol, int HWhNumberCol, int HWhNameCol)
        {
            DAL.ClsGy_Warehouse_View oWh = new DAL.ClsGy_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="HQCCheckItemIDCol"></param>
        /// <param name="HQCCheckItemNumberCol"></param>
        /// <param name="HQCCheckItemNameCol"></param>
        public static void SetGridByQCCheckItem(DataGridView grdMain, int i, int HQCCheckItemIDCol, int HQCCheckItemNumberCol, int HQCCheckItemNameCol)
        {
            DAL.ClsGy_QCCheckItem_View oQCCheckItem = new DAL.ClsGy_QCCheckItem_View();
            if (oQCCheckItem.RefreshView())
            {
                if (oQCCheckItem.GetInfoByID(oQCCheckItem.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = oQCCheckItem.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = oQCCheckItem.omodel.HNumber;
                    grdMain.Rows[i].Cells[HQCCheckItemNameCol].Value = oQCCheckItem.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HQCCheckItemNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = "0";
                grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = "";
                grdMain.Rows[i].Cells[HQCCheckItemNameCol].Value = "";
            }
        }


        public static void SetGridByQCCheckClass(DataGridView grdMain, int i, int HQCCheckClassIDCol, int HQCCheckClassNumberCol, int HQCCheckClassNameCol)
        {
            DAL.ClsGy_QCCheckClass_View oQCCheckClass = new DAL.ClsGy_QCCheckClass_View();
            if (oQCCheckClass.RefreshView())
            {
                if (oQCCheckClass.GetInfoByID(oQCCheckClass.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = oQCCheckClass.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = oQCCheckClass.omodel.HNumber;
                    grdMain.Rows[i].Cells[HQCCheckClassNameCol].Value = oQCCheckClass.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HQCCheckClassNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = "0";
                grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = "";
                grdMain.Rows[i].Cells[HQCCheckClassNameCol].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(DataGridView grdMain, int i, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol)
        {

            DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_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="HBadReasonIDCol"></param>
        /// <param name="HBadReasonNumberCol"></param>
        /// <param name="HBadReasonNameCol"></param>
        public static void SetGridByBadReason(DataGridView grdMain, int i, int HBadReasonIDCol, int HBadReasonNumberCol, int HBadReasonNameCol)
        {

            DAL.ClsGy_BadReason_View oBadReason = new DAL.ClsGy_BadReason_View();
            if (oBadReason.RefreshView())
            {
                if (oBadReason.GetInfoByID(oBadReason.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HBadReasonIDCol].Value = oBadReason.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HBadReasonNumberCol].Value = oBadReason.omodel.HNumber;
                    grdMain.Rows[i].Cells[HBadReasonNameCol].Value = oBadReason.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HBadReasonIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HBadReasonNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HBadReasonNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HBadReasonIDCol].Value = "0";
                grdMain.Rows[i].Cells[HBadReasonNumberCol].Value = "";
                grdMain.Rows[i].Cells[HBadReasonNameCol].Value = "";
            }
        }

        //³µÁ¾-Íø¸ñ
        /// <summary>
        /// ³µÁ¾-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HCarIDCol"></param>
        /// <param name="HCarNumberCol"></param>
        /// <param name="HCarNameCol"></param>
        public static void SetGridByCar(DataGridView grdMain, int i, int HCarIDCol, int HCarNumberCol, int HCarNameCol)
        {

            DAL.ClsGy_Car_View oCar = new DAL.ClsGy_Car_View();
            if (oCar.RefreshView())
            {
                if (oCar.GetInfoByID(oCar.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HCarIDCol].Value = oCar.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HCarNumberCol].Value = oCar.omodel.HNumber;
                    grdMain.Rows[i].Cells[HCarNameCol].Value = oCar.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HCarIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HCarNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HCarNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HCarIDCol].Value = "0";
                grdMain.Rows[i].Cells[HCarNumberCol].Value = "";
                grdMain.Rows[i].Cells[HCarNameCol].Value = "";
            }
        }

        //¹ÊÕÏÔ­Òò-Íø¸ñ
        /// <summary>
        /// ¹ÊÕÏÔ­Òò-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HConkReasonIDCol"></param>
        /// <param name="HConkReasonNumberCol"></param>
        /// <param name="HConkReasonNameCol"></param>
        public static void SetGridByConkReason(DataGridView grdMain, int i, int HConkReasonIDCol, int HConkReasonNumberCol, int HConkReasonNameCol)
        {

            DAL.ClsGy_ConkReason_View oConkReason = new DAL.ClsGy_ConkReason_View();
            if (oConkReason.RefreshView())
            {
                if (oConkReason.GetInfoByID(oConkReason.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HConkReasonIDCol].Value = oConkReason.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HConkReasonNumberCol].Value = oConkReason.omodel.HNumber;
                    grdMain.Rows[i].Cells[HConkReasonNameCol].Value = oConkReason.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HConkReasonIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HConkReasonNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HConkReasonNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HConkReasonIDCol].Value = "0";
                grdMain.Rows[i].Cells[HConkReasonNumberCol].Value = "";
                grdMain.Rows[i].Cells[HConkReasonNameCol].Value = "";
            }
        }

        //¹ÊÕÏÀà±ð-Íø¸ñ
        /// <summary>
        /// ¹ÊÕÏÀà±ð-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HConkTypeIDCol"></param>
        /// <param name="HConkTypeNumberCol"></param>
        /// <param name="HConkTypeNameCol"></param>
        public static void SetGridByConkType(DataGridView grdMain, int i, int HConkTypeIDCol, int HConkTypeNumberCol, int HConkTypeNameCol)
        {

            DAL.ClsGy_ConkType_View oConkType = new DAL.ClsGy_ConkType_View();
            if (oConkType.RefreshView())
            {
                if (oConkType.GetInfoByID(oConkType.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HConkTypeIDCol].Value = oConkType.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HConkTypeNumberCol].Value = oConkType.omodel.HNumber;
                    grdMain.Rows[i].Cells[HConkTypeNameCol].Value = oConkType.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HConkTypeIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HConkTypeNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HConkTypeNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HConkTypeIDCol].Value = "0";
                grdMain.Rows[i].Cells[HConkTypeNumberCol].Value = "";
                grdMain.Rows[i].Cells[HConkTypeNameCol].Value = "";
            }
        }

        //³É±¾ÖÐÐÄ-Íø¸ñ
        /// <summary>
        /// ³É±¾ÖÐÐÄ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HCostCenterIDCol"></param>
        /// <param name="HCostCenterNumberCol"></param>
        /// <param name="HCostCenterNameCol"></param>
        public static void SetGridByCostCenter(DataGridView grdMain, int i, int HCostCenterIDCol, int HCostCenterNumberCol, int HCostCenterNameCol)
        {

            DAL.ClsGy_CostCenter_View oCostCenter = new DAL.ClsGy_CostCenter_View();
            if (oCostCenter.RefreshView())
            {
                if (oCostCenter.GetInfoByID(oCostCenter.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HCostCenterIDCol].Value = oCostCenter.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HCostCenterNumberCol].Value = oCostCenter.omodel.HNumber;
                    grdMain.Rows[i].Cells[HCostCenterNameCol].Value = oCostCenter.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HCostCenterIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HCostCenterNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HCostCenterNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HCostCenterIDCol].Value = "0";
                grdMain.Rows[i].Cells[HCostCenterNumberCol].Value = "";
                grdMain.Rows[i].Cells[HCostCenterNameCol].Value = "";
            }
        }

        //±Ò±ð-Íø¸ñ
        /// <summary>
        /// ±Ò±ð-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HCurrencyIDCol"></param>
        /// <param name="HCurrencyNumberCol"></param>
        /// <param name="HCurrencyNameCol"></param>
        public static void SetGridByCurrency(DataGridView grdMain, int i, int HCurrencyIDCol, int HCurrencyNumberCol, int HCurrencyNameCol)
        {

            DAL.ClsGy_Currency_View oCurrency = new DAL.ClsGy_Currency_View();
            if (oCurrency.RefreshView())
            {
                if (oCurrency.GetInfoByID(oCurrency.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HCurrencyIDCol].Value = oCurrency.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HCurrencyNumberCol].Value = oCurrency.omodel.HNumber;
                    grdMain.Rows[i].Cells[HCurrencyNameCol].Value = oCurrency.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HCurrencyIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HCurrencyNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HCurrencyNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HCurrencyIDCol].Value = "0";
                grdMain.Rows[i].Cells[HCurrencyNumberCol].Value = "";
                grdMain.Rows[i].Cells[HCurrencyNameCol].Value = "";
            }
        }

        //¿Í»§-Íø¸ñ
        /// <summary>
        /// ¿Í»§-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HCustomerIDCol"></param>
        /// <param name="HCustomerNumberCol"></param>
        /// <param name="HCustomerNameCol"></param>
        public static void SetGridByCustomer(DataGridView grdMain, int i, int HCustomerIDCol, int HCustomerNumberCol, int HCustomerNameCol)
        {

            DAL.ClsGy_Customer_View oCustomer = new DAL.ClsGy_Customer_View();
            if (oCustomer.RefreshView())
            {
                if (oCustomer.GetInfoByID(oCustomer.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HCustomerIDCol].Value = oCustomer.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HCustomerNumberCol].Value = oCustomer.omodel.HNumber;
                    grdMain.Rows[i].Cells[HCustomerNameCol].Value = oCustomer.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HCustomerIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HCustomerNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HCustomerNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HCustomerIDCol].Value = "0";
                grdMain.Rows[i].Cells[HCustomerNumberCol].Value = "";
                grdMain.Rows[i].Cells[HCustomerNameCol].Value = "";
            }
        }

        //¿Í»§·ÖÀà-Íø¸ñ
        /// <summary>
        /// ¿Í»§·ÖÀà-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HCusTypeIDCol"></param>
        /// <param name="HCusTypeNumberCol"></param>
        /// <param name="HCusTypeNameCol"></param>
        public static void SetGridByCusType(DataGridView grdMain, int i, int HCusTypeIDCol, int HCusTypeNumberCol, int HCusTypeNameCol)
        {

            DAL.ClsGy_CusType_View oCusType = new DAL.ClsGy_CusType_View();
            if (oCusType.RefreshView())
            {
                if (oCusType.GetInfoByID(oCusType.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HCusTypeIDCol].Value = oCusType.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HCusTypeNumberCol].Value = oCusType.omodel.HNumber;
                    grdMain.Rows[i].Cells[HCusTypeNameCol].Value = oCusType.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HCusTypeIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HCusTypeNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HCusTypeNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HCusTypeIDCol].Value = "0";
                grdMain.Rows[i].Cells[HCusTypeNumberCol].Value = "";
                grdMain.Rows[i].Cells[HCusTypeNameCol].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(DataGridView grdMain, int i, int HDeptIDCol, int HDeptNumberCol, int HDeptNameCol)
        {

            DAL.ClsGy_Department_View oDept = new DAL.ClsGy_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="HBuildingIDCol"></param>
        /// <param name="HBuildingNumberCol"></param>
        /// <param name="HBuildingNameCol"></param>
        public static void SetGridByBui(DataGridView grdMain, int i, int HBuildingIDCol, int HBuildingNumberCol, int HBuildingNameCol)
        {

            DAL.ClsGy_Building_View oBui = new DAL.ClsGy_Building_View();
            if (oBui.RefreshView())
            {
                if (oBui.GetInfoByID(oBui.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HBuildingIDCol].Value = oBui.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HBuildingNumberCol].Value = oBui.omodel.HNumber;
                    grdMain.Rows[i].Cells[HBuildingNameCol].Value = oBui.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HBuildingIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HBuildingNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HBuildingNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HBuildingIDCol].Value = "0";
                grdMain.Rows[i].Cells[HBuildingNumberCol].Value = "";
                grdMain.Rows[i].Cells[HBuildingNameCol].Value = "";
            }
        }
        //
        //·¿¼äÀàÐÍ-Íø¸ñ
        /// <summary>
        /// ·¿¼äÀàÐÍ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HBuildingIDCol"></param>
        /// <param name="HBuildingNumberCol"></param>
        /// <param name="HBuildingNameCol"></param>
        public static void SetGridByHouseType(DataGridView grdMain, int i, int HHouseTypeIDCol, int HHouseTypeNumberCol, int HHouseTypeNameCol)
        {

            DAL.ClsGy_HouseType_View oHT = new DAL.ClsGy_HouseType_View();
            if (oHT.RefreshView())
            {
                if (oHT.GetInfoByID(oHT.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HHouseTypeIDCol].Value = oHT.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HHouseTypeNumberCol].Value = oHT.omodel.HNumber;
                    grdMain.Rows[i].Cells[HHouseTypeNameCol].Value = oHT.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HHouseTypeIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HHouseTypeNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HHouseTypeNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HHouseTypeIDCol].Value = "0";
                grdMain.Rows[i].Cells[HHouseTypeNumberCol].Value = "";
                grdMain.Rows[i].Cells[HHouseTypeNameCol].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 SetGridByMaterial(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol)
        {
            DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
            DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_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;

                }
                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 = "";
                }
            }
            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 = "";
            }
        }

        //ËÞÉá-Íø¸ñ
        /// <summary>
        /// ËÞÉá-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HDormIDCol"></param>
        /// <param name="HDormNumberCol"></param>
        /// <param name="HDormNameCol"></param>
        public static void SetGridByDorm(DataGridView grdMain, int i, int HDormIDCol, int HDormNumberCol, int HDormNameCol)
        {

            DAL.ClsGy_Dorm_View oDorm = new DAL.ClsGy_Dorm_View();
            if (oDorm.RefreshView())
            {
                if (oDorm.GetInfoByID(oDorm.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HDormIDCol].Value = oDorm.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HDormNumberCol].Value = oDorm.omodel.HNumber;
                    grdMain.Rows[i].Cells[HDormNameCol].Value = oDorm.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HDormIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HDormNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HDormNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HDormIDCol].Value = "0";
                grdMain.Rows[i].Cells[HDormNumberCol].Value = "";
                grdMain.Rows[i].Cells[HDormNameCol].Value = "";
            }
        }

        //¿Û²¹×ÊÁÏ-Íø¸ñ
        /// <summary>
        /// ¿Û²¹×ÊÁÏ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HDuSubsidyItemIDCol"></param>
        /// <param name="HDuSubsidyItemNumberCol"></param>
        /// <param name="HDuSubsidyItemNameCol"></param>
        public static void SetGridByDuSubsidyItem(DataGridView grdMain, int i, int HDuSubsidyItemIDCol, int HDuSubsidyItemNumberCol, int HDuSubsidyItemNameCol)
        {

            DAL.ClsGy_DuSubsidyItem_View oDuSubsidyItem = new DAL.ClsGy_DuSubsidyItem_View();
            if (oDuSubsidyItem.RefreshView())
            {
                if (oDuSubsidyItem.GetInfoByID(oDuSubsidyItem.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HDuSubsidyItemIDCol].Value = oDuSubsidyItem.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HDuSubsidyItemNumberCol].Value = oDuSubsidyItem.omodel.HNumber;
                    grdMain.Rows[i].Cells[HDuSubsidyItemNameCol].Value = oDuSubsidyItem.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HDuSubsidyItemIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HDuSubsidyItemNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HDuSubsidyItemNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HDuSubsidyItemIDCol].Value = "0";
                grdMain.Rows[i].Cells[HDuSubsidyItemNumberCol].Value = "";
                grdMain.Rows[i].Cells[HDuSubsidyItemNameCol].Value = "";
            }
        }

        //Ö°Îñ-Íø¸ñ
        /// <summary>
        /// Ö°Îñ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HDutyIDCol"></param>
        /// <param name="HDutyNumberCol"></param>
        /// <param name="HDutyNameCol"></param>
        public static void SetGridByDuty(DataGridView grdMain, int i, int HDutyIDCol, int HDutyNumberCol, int HDutyNameCol)
        {

            DAL.ClsGy_Duty_View oDuty = new DAL.ClsGy_Duty_View();
            if (oDuty.RefreshView())
            {
                if (oDuty.GetInfoByID(oDuty.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HDutyIDCol].Value = oDuty.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HDutyNumberCol].Value = oDuty.omodel.HNumber;
                    grdMain.Rows[i].Cells[HDutyNameCol].Value = oDuty.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HDutyIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HDutyNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HDutyNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HDutyIDCol].Value = "0";
                grdMain.Rows[i].Cells[HDutyNumberCol].Value = "";
                grdMain.Rows[i].Cells[HDutyNameCol].Value = "";
            }
        }

        //Ö°Ô±-Íø¸ñ-°´°à×é
        /// <summary>
        /// Ö°Ô±-Íø¸ñ-°´°à×é
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HEmpIDCol"></param>
        /// <param name="HEmpNumberCol"></param>
        /// <param name="HEmpNameCol"></param>
        public static void SetGridByEmp_Group(DataGridView grdMain, int i, int HEmpIDCol, int HEmpNumberCol, int HEmpNameCol, long HGroupID)
        {

            DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
            if (oEmp.RefreshView("and HGroupID=" + HGroupID))
            {
                if (oEmp.GetInfoByID(oEmp.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HEmpIDCol].Value = oEmp.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HEmpNumberCol].Value = oEmp.omodel.HNumber;
                    grdMain.Rows[i].Cells[HEmpNameCol].Value = oEmp.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HEmpIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HEmpNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HEmpNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HEmpIDCol].Value = "0";
                grdMain.Rows[i].Cells[HEmpNumberCol].Value = "";
                grdMain.Rows[i].Cells[HEmpNameCol].Value = "";
            }
        }

        //Ö°Ô±-Íø¸ñ
        /// <summary>
        /// Ö°Ô±-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HEmpIDCol"></param>
        /// <param name="HEmpNumberCol"></param>
        /// <param name="HEmpNameCol"></param>
        public static void SetGridByEmp(DataGridView grdMain, int i, int HEmpIDCol, int HEmpNumberCol, int HEmpNameCol)
        {

            DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
            if (oEmp.RefreshView())
            {
                if (oEmp.GetInfoByID(oEmp.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HEmpIDCol].Value = oEmp.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HEmpNumberCol].Value = oEmp.omodel.HNumber;
                    grdMain.Rows[i].Cells[HEmpNameCol].Value = oEmp.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HEmpIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HEmpNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HEmpNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HEmpIDCol].Value = "0";
                grdMain.Rows[i].Cells[HEmpNumberCol].Value = "";
                grdMain.Rows[i].Cells[HEmpNameCol].Value = "";
            }
        }

        //ÄÜÔ´ÏîÄ¿-Íø¸ñ
        /// <summary>
        /// ÄÜÔ´ÏîÄ¿-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HEnergyIDCol"></param>
        /// <param name="HEnergyNumberCol"></param>
        /// <param name="HEnergyNameCol"></param>
        public static void SetGridByEnergy(DataGridView grdMain, int i, int HEnergyIDCol, int HEnergyNumberCol, int HEnergyNameCol)
        {

            DAL.ClsGy_Energy_View oEnergy = new DAL.ClsGy_Energy_View();
            if (oEnergy.RefreshView())
            {
                if (oEnergy.GetInfoByID(oEnergy.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HEnergyIDCol].Value = oEnergy.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HEnergyNumberCol].Value = oEnergy.omodel.HNumber;
                    grdMain.Rows[i].Cells[HEnergyNameCol].Value = oEnergy.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HEnergyIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HEnergyNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HEnergyNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HEnergyIDCol].Value = "0";
                grdMain.Rows[i].Cells[HEnergyNumberCol].Value = "";
                grdMain.Rows[i].Cells[HEnergyNameCol].Value = "";
            }
        }

        //Òì³£ÀàÐÍ-Íø¸ñ
        /// <summary>
        /// Òì³£ÀàÐÍ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HErrTypeIDCol"></param>
        /// <param name="HErrTypeNumberCol"></param>
        /// <param name="HErrTypeNameCol"></param>
        public static void SetGridByErrType(DataGridView grdMain, int i, int HErrTypeIDCol, int HErrTypeNumberCol, int HErrTypeNameCol)
        {

            DAL.ClsGy_ErrType_View oErrType = new DAL.ClsGy_ErrType_View();
            if (oErrType.RefreshView())
            {
                if (oErrType.GetInfoByID(oErrType.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HErrTypeIDCol].Value = oErrType.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HErrTypeNumberCol].Value = oErrType.omodel.HNumber;
                    grdMain.Rows[i].Cells[HErrTypeNameCol].Value = oErrType.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HErrTypeIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HErrTypeNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HErrTypeNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HErrTypeIDCol].Value = "0";
                grdMain.Rows[i].Cells[HErrTypeNumberCol].Value = "";
                grdMain.Rows[i].Cells[HErrTypeNameCol].Value = "";
            }
        }

        //ÆÀ¼ÛÇé¿ö-Íø¸ñ
        /// <summary>
        /// ÆÀ¼ÛÇé¿ö-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HEvaluateStatusIDCol"></param>
        /// <param name="HEvaluateStatusNumberCol"></param>
        /// <param name="HEvaluateStatusNameCol"></param>
        public static void SetGridByEvaluateStatus(DataGridView grdMain, int i, int HEvaluateStatusIDCol, int HEvaluateStatusNumberCol, int HEvaluateStatusNameCol)
        {

            DAL.ClsGy_EvaluateStatus_View oEvaluateStatus = new DAL.ClsGy_EvaluateStatus_View();
            if (oEvaluateStatus.RefreshView())
            {
                if (oEvaluateStatus.GetInfoByID(oEvaluateStatus.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HEvaluateStatusIDCol].Value = oEvaluateStatus.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HEvaluateStatusNumberCol].Value = oEvaluateStatus.omodel.HNumber;
                    grdMain.Rows[i].Cells[HEvaluateStatusNameCol].Value = oEvaluateStatus.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HEvaluateStatusIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HEvaluateStatusNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HEvaluateStatusNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HEvaluateStatusIDCol].Value = "0";
                grdMain.Rows[i].Cells[HEvaluateStatusNumberCol].Value = "";
                grdMain.Rows[i].Cells[HEvaluateStatusNameCol].Value = "";
            }
        }

        //·ÑÓÃÇé¿ö-Íø¸ñ
        /// <summary>
        /// ·ÑÓÃÇé¿ö-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HExpenseStatusIDCol"></param>
        /// <param name="HExpenseStatusNumberCol"></param>
        /// <param name="HExpenseStatusNameCol"></param>
        public static void SetGridByExpenseStatus(DataGridView grdMain, int i, int HExpenseStatusIDCol, int HExpenseStatusNumberCol, int HExpenseStatusNameCol)
        {

            DAL.ClsGy_ExpenseStatus_View oExpenseStatus = new DAL.ClsGy_ExpenseStatus_View();
            if (oExpenseStatus.RefreshView())
            {
                if (oExpenseStatus.GetInfoByID(oExpenseStatus.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HExpenseStatusIDCol].Value = oExpenseStatus.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HExpenseStatusNumberCol].Value = oExpenseStatus.omodel.HNumber;
                    grdMain.Rows[i].Cells[HExpenseStatusNameCol].Value = oExpenseStatus.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HExpenseStatusIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HExpenseStatusNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HExpenseStatusNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HExpenseStatusIDCol].Value = "0";
                grdMain.Rows[i].Cells[HExpenseStatusNumberCol].Value = "";
                grdMain.Rows[i].Cells[HExpenseStatusNameCol].Value = "";
            }
        }

        //³µÁ¾³§¼Ò-Íø¸ñ
        /// <summary>
        /// ³µÁ¾³§¼Ò-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HFactoryIDCol"></param>
        /// <param name="HFactoryNumberCol"></param>
        /// <param name="HFactoryNameCol"></param>
        public static void SetGridByFactory(DataGridView grdMain, int i, int HFactoryIDCol, int HFactoryNumberCol, int HFactoryNameCol)
        {

            DAL.ClsGy_Factory_View oFactory = new DAL.ClsGy_Factory_View();
            if (oFactory.RefreshView())
            {
                if (oFactory.GetInfoByID(oFactory.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HFactoryIDCol].Value = oFactory.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HFactoryNumberCol].Value = oFactory.omodel.HNumber;
                    grdMain.Rows[i].Cells[HFactoryNameCol].Value = oFactory.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HFactoryIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HFactoryNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HFactoryNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HFactoryIDCol].Value = "0";
                grdMain.Rows[i].Cells[HFactoryNumberCol].Value = "";
                grdMain.Rows[i].Cells[HFactoryNameCol].Value = "";
            }
        }

        //°à×é-Íø¸ñ
        /// <summary>
        /// °à×é-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HGroupIDCol"></param>
        /// <param name="HGroupNumberCol"></param>
        /// <param name="HGroupNameCol"></param>
        public static void SetGridByGroup(DataGridView grdMain, int i, int HGroupIDCol, int HGroupNumberCol, int HGroupNameCol)
        {

            DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();
            if (oGroup.RefreshView())
            {
                if (oGroup.GetInfoByID(oGroup.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HGroupIDCol].Value = oGroup.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HGroupNumberCol].Value = oGroup.omodel.HNumber;
                    grdMain.Rows[i].Cells[HGroupNameCol].Value = oGroup.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HGroupIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HGroupNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HGroupNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HGroupIDCol].Value = "0";
                grdMain.Rows[i].Cells[HGroupNumberCol].Value = "";
                grdMain.Rows[i].Cells[HGroupNameCol].Value = "";
            }
        }

        //½Ú¼ÙÈÕ-Íø¸ñ
        /// <summary>
        /// ½Ú¼ÙÈÕ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HHolidayIDCol"></param>
        /// <param name="HHolidayNumberCol"></param>
        /// <param name="HHolidayNameCol"></param>
        public static void SetGridByHoliday(DataGridView grdMain, int i, int HHolidayIDCol, int HHolidayNumberCol, int HHolidayNameCol)
        {

            DAL.ClsGy_Holiday_View oHoliday = new DAL.ClsGy_Holiday_View();
            if (oHoliday.RefreshView())
            {
                if (oHoliday.GetInfoByID(oHoliday.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HHolidayIDCol].Value = oHoliday.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HHolidayNumberCol].Value = oHoliday.omodel.HNumber;
                    grdMain.Rows[i].Cells[HHolidayNameCol].Value = oHoliday.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HHolidayIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HHolidayNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HHolidayNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HHolidayIDCol].Value = "0";
                grdMain.Rows[i].Cells[HHolidayNumberCol].Value = "";
                grdMain.Rows[i].Cells[HHolidayNameCol].Value = "";
            }
        }

        //±£ÑøÏîÄ¿-Íø¸ñ
        /// <summary>
        /// ±£ÑøÏîÄ¿-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HMaintainIDCol"></param>
        /// <param name="HMaintainNumberCol"></param>
        /// <param name="HMaintainNameCol"></param>
        public static void SetGridByMaintain(DataGridView grdMain, int i, int HMaintainIDCol, int HMaintainNumberCol, int HMaintainNameCol)
        {

            DAL.ClsGy_Maintain_View oMaintain = new DAL.ClsGy_Maintain_View();
            if (oMaintain.RefreshView())
            {
                if (oMaintain.GetInfoByID(oMaintain.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HMaintainIDCol].Value = oMaintain.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HMaintainNumberCol].Value = oMaintain.omodel.HNumber;
                    grdMain.Rows[i].Cells[HMaintainNameCol].Value = oMaintain.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HMaintainIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HMaintainNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HMaintainNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HMaintainIDCol].Value = "0";
                grdMain.Rows[i].Cells[HMaintainNumberCol].Value = "";
                grdMain.Rows[i].Cells[HMaintainNameCol].Value = "";
            }
        }

        //¿Í»§¶ÔÓ¦ÎïÁÏ-Íø¸ñ
        /// <summary>
        /// ¿Í»§¶ÔÓ¦ÎïÁÏ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HMateNumRelationIDCol"></param>
        /// <param name="HMateNumRelationNumberCol"></param>
        /// <param name="HMateNumRelationNameCol"></param>
        public static void SetGridByMateNumRelation(DataGridView grdMain, int i, int HMateNumRelationIDCol, int HMateNumRelationNumberCol, int HMateNumRelationNameCol)
        {

            DAL.ClsGy_MateNumRelation_View oMateNumRelation = new DAL.ClsGy_MateNumRelation_View();
            if (oMateNumRelation.RefreshView())
            {
                if (oMateNumRelation.GetInfoByID(oMateNumRelation.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HMateNumRelationIDCol].Value = oMateNumRelation.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HMateNumRelationNumberCol].Value = oMateNumRelation.omodel.HNumber;
                    grdMain.Rows[i].Cells[HMateNumRelationNameCol].Value = oMateNumRelation.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HMateNumRelationIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HMateNumRelationNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HMateNumRelationNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HMateNumRelationIDCol].Value = "0";
                grdMain.Rows[i].Cells[HMateNumRelationNumberCol].Value = "";
                grdMain.Rows[i].Cells[HMateNumRelationNameCol].Value = "";
            }
        }

        //ÎïÁÏÌØÐÔ-Íø¸ñ
        /// <summary>
        /// ÎïÁÏÌØÐÔ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HMaterTraitIDCol"></param>
        /// <param name="HMaterTraitNumberCol"></param>
        /// <param name="HMaterTraitNameCol"></param>
        public static void SetGridByMaterTrait(DataGridView grdMain, int i, int HMaterTraitIDCol, int HMaterTraitNumberCol, int HMaterTraitNameCol)
        {

            DAL.ClsGy_MaterTrait_View oMaterTrait = new DAL.ClsGy_MaterTrait_View();
            if (oMaterTrait.RefreshView())
            {
                if (oMaterTrait.GetInfoByID(oMaterTrait.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HMaterTraitIDCol].Value = oMaterTrait.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HMaterTraitNumberCol].Value = oMaterTrait.omodel.HNumber;
                    grdMain.Rows[i].Cells[HMaterTraitNameCol].Value = oMaterTrait.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HMaterTraitIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HMaterTraitNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HMaterTraitNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HMaterTraitIDCol].Value = "0";
                grdMain.Rows[i].Cells[HMaterTraitNumberCol].Value = "";
                grdMain.Rows[i].Cells[HMaterTraitNameCol].Value = "";
            }
        }

        //¹æ¸ñÐͺÅ-Íø¸ñ
        /// <summary>
        /// ¹æ¸ñÐͺÅ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HModelIDCol"></param>
        /// <param name="HModelNumberCol"></param>
        /// <param name="HModelNameCol"></param>
        public static void SetGridByModel(DataGridView grdMain, int i, int HModelIDCol, int HModelNumberCol, int HModelNameCol)
        {

            DAL.ClsGy_Model_View oModel = new DAL.ClsGy_Model_View();
            if (oModel.RefreshView())
            {
                if (oModel.GetInfoByID(oModel.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HModelIDCol].Value = oModel.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HModelNumberCol].Value = oModel.omodel.HNumber;
                    grdMain.Rows[i].Cells[HModelNameCol].Value = oModel.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HModelIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HModelNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HModelNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HModelIDCol].Value = "0";
                grdMain.Rows[i].Cells[HModelNumberCol].Value = "";
                grdMain.Rows[i].Cells[HModelNameCol].Value = "";
            }
        }

        //¶©µ¥µÈ¼¶-Íø¸ñ
        /// <summary>
        /// ¶©µ¥µÈ¼¶-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HOrderLevIDCol"></param>
        /// <param name="HOrderLevNumberCol"></param>
        /// <param name="HOrderLevNameCol"></param>
        public static void SetGridByOrderLev(DataGridView grdMain, int i, int HOrderLevIDCol, int HOrderLevNumberCol, int HOrderLevNameCol)
        {

            DAL.ClsGy_OrderLev_View oOrderLev = new DAL.ClsGy_OrderLev_View();
            if (oOrderLev.RefreshView())
            {
                if (oOrderLev.GetInfoByID(oOrderLev.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HOrderLevIDCol].Value = oOrderLev.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HOrderLevNumberCol].Value = oOrderLev.omodel.HNumber;
                    grdMain.Rows[i].Cells[HOrderLevNameCol].Value = oOrderLev.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HOrderLevIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HOrderLevNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HOrderLevNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HOrderLevIDCol].Value = "0";
                grdMain.Rows[i].Cells[HOrderLevNumberCol].Value = "";
                grdMain.Rows[i].Cells[HOrderLevNameCol].Value = "";
            }
        }

        //Ö¤¼þÀà±ð-Íø¸ñ
        /// <summary>
        /// Ö¤¼þÀà±ð-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HPaperSortIDCol"></param>
        /// <param name="HPaperSortNumberCol"></param>
        /// <param name="HPaperSortNameCol"></param>
        public static void SetGridByPaperSort(DataGridView grdMain, int i, int HPaperSortIDCol, int HPaperSortNumberCol, int HPaperSortNameCol)
        {

            DAL.ClsGy_PaperSort_View oPaperSort = new DAL.ClsGy_PaperSort_View();
            if (oPaperSort.RefreshView())
            {
                if (oPaperSort.GetInfoByID(oPaperSort.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HPaperSortIDCol].Value = oPaperSort.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HPaperSortNumberCol].Value = oPaperSort.omodel.HNumber;
                    grdMain.Rows[i].Cells[HPaperSortNameCol].Value = oPaperSort.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HPaperSortIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HPaperSortNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HPaperSortNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HPaperSortIDCol].Value = "0";
                grdMain.Rows[i].Cells[HPaperSortNumberCol].Value = "";
                grdMain.Rows[i].Cells[HPaperSortNameCol].Value = "";
            }
        }

        //¸Û¿Ú-Íø¸ñ
        /// <summary>
        /// ¸Û¿Ú-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HPortIDCol"></param>
        /// <param name="HPortNumberCol"></param>
        /// <param name="HPortNameCol"></param>
        public static void SetGridByPort(DataGridView grdMain, int i, int HPortIDCol, int HPortNumberCol, int HPortNameCol)
        {

            DAL.ClsGy_Port_View oPort = new DAL.ClsGy_Port_View();
            if (oPort.RefreshView())
            {
                if (oPort.GetInfoByID(oPort.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HPortIDCol].Value = oPort.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HPortNumberCol].Value = oPort.omodel.HNumber;
                    grdMain.Rows[i].Cells[HPortNameCol].Value = oPort.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HPortIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HPortNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HPortNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HPortIDCol].Value = "0";
                grdMain.Rows[i].Cells[HPortNumberCol].Value = "";
                grdMain.Rows[i].Cells[HPortNameCol].Value = "";
            }
        }

        //¸Úλ-Íø¸ñ
        /// <summary>
        /// ¸Úλ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HPostIDCol"></param>
        /// <param name="HPostNumberCol"></param>
        /// <param name="HPostNameCol"></param>
        public static void SetGridByPost(DataGridView grdMain, int i, int HPostIDCol, int HPostNumberCol, int HPostNameCol)
        {

            DAL.ClsGy_Post_View oPost = new DAL.ClsGy_Post_View();
            if (oPost.RefreshView())
            {
                if (oPost.GetInfoByID(oPost.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HPostIDCol].Value = oPost.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HPostNumberCol].Value = oPost.omodel.HNumber;
                    grdMain.Rows[i].Cells[HPostNameCol].Value = oPost.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HPostIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HPostNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HPostNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HPostIDCol].Value = "0";
                grdMain.Rows[i].Cells[HPostNumberCol].Value = "";
                grdMain.Rows[i].Cells[HPostNameCol].Value = "";
            }
        }

        //ίÍ⹤Ðò-Íø¸ñ
        /// <summary>
        /// ίÍ⹤Ðò-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HProcCommIDCol"></param>
        /// <param name="HProcCommNumberCol"></param>
        /// <param name="HProcCommNameCol"></param>
        public static void SetGridByProcComm(DataGridView grdMain, int i, int HProcCommIDCol, int HProcCommNumberCol, int HProcCommNameCol)
        {

            DAL.ClsGy_ProcComm_View oProcComm = new DAL.ClsGy_ProcComm_View();
            if (oProcComm.RefreshView())
            {
                if (oProcComm.GetInfoByID(oProcComm.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HProcCommIDCol].Value = oProcComm.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HProcCommNumberCol].Value = oProcComm.omodel.HNumber;
                    grdMain.Rows[i].Cells[HProcCommNameCol].Value = oProcComm.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HProcCommIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HProcCommNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HProcCommNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HProcCommIDCol].Value = "0";
                grdMain.Rows[i].Cells[HProcCommNumberCol].Value = "";
                grdMain.Rows[i].Cells[HProcCommNameCol].Value = "";
            }
        }

        //¹¤Ðò-Íø¸ñ
        /// <summary>
        /// ¹¤Ðò-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HProcIDCol"></param>
        /// <param name="HProcNumberCol"></param>
        /// <param name="HProcNameCol"></param>
        public static void SetGridByProc(DataGridView grdMain, int i, int HProcIDCol, int HProcNumberCol, int HProcNameCol)
        {

            DAL.ClsGy_Process_View oProc = new DAL.ClsGy_Process_View();
            if (oProc.RefreshView())
            {
                if (oProc.GetInfoByID(oProc.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HProcIDCol].Value = oProc.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber;
                    grdMain.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HProcIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HProcNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HProcNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HProcIDCol].Value = "0";
                grdMain.Rows[i].Cells[HProcNumberCol].Value = "";
                grdMain.Rows[i].Cells[HProcNameCol].Value = "";
            }
        }

        //¹¤¶Î-Íø¸ñ
        /// <summary>
        /// ¹¤¶Î-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HProcMulIDCol"></param>
        /// <param name="HProcMulNumberCol"></param>
        /// <param name="HProcMulNameCol"></param>
        public static void SetGridByProcMul(DataGridView grdMain, int i, int HProcMulIDCol, int HProcMulNumberCol, int HProcMulNameCol)
        {

            DAL.ClsGy_ProcMul_View oProcMul = new DAL.ClsGy_ProcMul_View();
            if (oProcMul.RefreshView())
            {
                if (oProcMul.GetInfoByID(oProcMul.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HProcMulIDCol].Value = oProcMul.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HProcMulNumberCol].Value = oProcMul.omodel.HNumber;
                    grdMain.Rows[i].Cells[HProcMulNameCol].Value = oProcMul.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HProcMulIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HProcMulNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HProcMulNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HProcMulIDCol].Value = "0";
                grdMain.Rows[i].Cells[HProcMulNumberCol].Value = "";
                grdMain.Rows[i].Cells[HProcMulNameCol].Value = "";
            }
        }

        //¶¨¶î¹é¼¯-Íø¸ñ
        /// <summary>
        /// ¶¨¶î¹é¼¯-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HProcPriceRelaIDCol"></param>
        /// <param name="HProcPriceRelaNumberCol"></param>
        /// <param name="HProcPriceRelaNameCol"></param>
        public static void SetGridByProcPriceRela(DataGridView grdMain, int i, int HProcPriceRelaIDCol, int HProcPriceRelaNumberCol, int HProcPriceRelaNameCol)
        {

            DAL.ClsGy_ProcPriceRela_View oProcPriceRela = new DAL.ClsGy_ProcPriceRela_View();
            if (oProcPriceRela.RefreshView())
            {
                if (oProcPriceRela.GetInfoByID(oProcPriceRela.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HProcPriceRelaIDCol].Value = oProcPriceRela.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HProcPriceRelaNumberCol].Value = oProcPriceRela.omodel.HNumber;
                    grdMain.Rows[i].Cells[HProcPriceRelaNameCol].Value = oProcPriceRela.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HProcPriceRelaIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HProcPriceRelaNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HProcPriceRelaNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HProcPriceRelaIDCol].Value = "0";
                grdMain.Rows[i].Cells[HProcPriceRelaNumberCol].Value = "";
                grdMain.Rows[i].Cells[HProcPriceRelaNameCol].Value = "";
            }
        }

        //¶¨¶î¹é¼¯×é-Íø¸ñ
        /// <summary>
        /// ¶¨¶î¹é¼¯×é-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HProcPriceRelaGroupIDCol"></param>
        /// <param name="HProcPriceRelaGroupNumberCol"></param>
        /// <param name="HProcPriceRelaGroupNameCol"></param>
        public static void SetGridByProcPriceRelaGroup(DataGridView grdMain, int i, int HProcPriceRelaGroupIDCol, int HProcPriceRelaGroupNumberCol, int HProcPriceRelaGroupNameCol)
        {

            DAL.ClsGy_ProcPriceRelaGroup_View oProcPriceRelaGroup = new DAL.ClsGy_ProcPriceRelaGroup_View();
            if (oProcPriceRelaGroup.RefreshView())
            {
                if (oProcPriceRelaGroup.GetInfoByID(oProcPriceRelaGroup.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HProcPriceRelaGroupIDCol].Value = oProcPriceRelaGroup.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HProcPriceRelaGroupNumberCol].Value = oProcPriceRelaGroup.omodel.HNumber;
                    grdMain.Rows[i].Cells[HProcPriceRelaGroupNameCol].Value = oProcPriceRelaGroup.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HProcPriceRelaGroupIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HProcPriceRelaGroupNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HProcPriceRelaGroupNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HProcPriceRelaGroupIDCol].Value = "0";
                grdMain.Rows[i].Cells[HProcPriceRelaGroupNumberCol].Value = "";
                grdMain.Rows[i].Cells[HProcPriceRelaGroupNameCol].Value = "";
            }
        }

        //Éú²úÀàÐÍ-Íø¸ñ
        /// <summary>
        /// Éú²úÀàÐÍ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HProdTypeIDCol"></param>
        /// <param name="HProdTypeNumberCol"></param>
        /// <param name="HProdTypeNameCol"></param>
        public static void SetGridByProdType(DataGridView grdMain, int i, int HProdTypeIDCol, int HProdTypeNumberCol, int HProdTypeNameCol)
        {

            DAL.ClsGy_ProdType_View oProdType = new DAL.ClsGy_ProdType_View();
            if (oProdType.RefreshView())
            {
                if (oProdType.GetInfoByID(oProdType.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HProdTypeIDCol].Value = oProdType.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HProdTypeNumberCol].Value = oProdType.omodel.HNumber;
                    grdMain.Rows[i].Cells[HProdTypeNameCol].Value = oProdType.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HProdTypeIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HProdTypeNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HProdTypeNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HProdTypeIDCol].Value = "0";
                grdMain.Rows[i].Cells[HProdTypeNumberCol].Value = "";
                grdMain.Rows[i].Cells[HProdTypeNameCol].Value = "";
            }
        }

        //²úÆ·ÌØÐÔ-Íø¸ñ
        /// <summary>
        /// ²úÆ·ÌØÐÔ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HProductSpecIDCol"></param>
        /// <param name="HProductSpecNumberCol"></param>
        /// <param name="HProductSpecNameCol"></param>
        public static void SetGridByProductSpec(DataGridView grdMain, int i, int HProductSpecIDCol, int HProductSpecNumberCol, int HProductSpecNameCol)
        {

            DAL.ClsGy_ProductSpec_View oProductSpec = new DAL.ClsGy_ProductSpec_View();
            if (oProductSpec.RefreshView())
            {
                if (oProductSpec.GetInfoByID(oProductSpec.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HProductSpecIDCol].Value = oProductSpec.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HProductSpecNumberCol].Value = oProductSpec.omodel.HNumber;
                    grdMain.Rows[i].Cells[HProductSpecNameCol].Value = oProductSpec.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HProductSpecIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HProductSpecNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HProductSpecNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HProductSpecIDCol].Value = "0";
                grdMain.Rows[i].Cells[HProductSpecNumberCol].Value = "";
                grdMain.Rows[i].Cells[HProductSpecNameCol].Value = "";
            }
        }

        //ÏîÄ¿¹¤³Ì-Íø¸ñ
        /// <summary>
        /// ÏîÄ¿¹¤³Ì-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HProjectIDCol"></param>
        /// <param name="HProjectNumberCol"></param>
        /// <param name="HProjectNameCol"></param>
        public static void SetGridByProject(DataGridView grdMain, int i, int HProjectIDCol, int HProjectNumberCol, int HProjectNameCol)
        {

            DAL.ClsGy_Project_View oProject = new DAL.ClsGy_Project_View();
            if (oProject.RefreshView())
            {
                if (oProject.GetInfoByID(oProject.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HProjectIDCol].Value = oProject.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HProjectNumberCol].Value = oProject.omodel.HNumber;
                    grdMain.Rows[i].Cells[HProjectNameCol].Value = oProject.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HProjectIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HProjectNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HProjectNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HProjectIDCol].Value = "0";
                grdMain.Rows[i].Cells[HProjectNumberCol].Value = "";
                grdMain.Rows[i].Cells[HProjectNameCol].Value = "";
            }
        }

        //¸¨ÖúÊôÐÔ-Íø¸ñ
        /// <summary>
        /// ¸¨ÖúÊôÐÔ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HPropertyIDCol"></param>
        /// <param name="HPropertyNumberCol"></param>
        /// <param name="HPropertyNameCol"></param>
        public static void SetGridByProperty(DataGridView grdMain, int i, int HPropertyIDCol, int HPropertyNumberCol, int HPropertyNameCol)
        {

            DAL.ClsGy_Property_View oProperty = new DAL.ClsGy_Property_View();
            if (oProperty.RefreshView())
            {
                if (oProperty.GetInfoByID(oProperty.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HPropertyIDCol].Value = oProperty.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HPropertyNumberCol].Value = oProperty.omodel.HNumber;
                    grdMain.Rows[i].Cells[HPropertyNameCol].Value = oProperty.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HPropertyIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HPropertyNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HPropertyNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HPropertyIDCol].Value = "0";
                grdMain.Rows[i].Cells[HPropertyNumberCol].Value = "";
                grdMain.Rows[i].Cells[HPropertyNameCol].Value = "";
            }
        }

        //¸¨ÖúÊôÐÔÀà±ð-Íø¸ñ
        /// <summary>
        /// ¸¨ÖúÊôÐÔÀà±ð-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HPropertyTypeIDCol"></param>
        /// <param name="HPropertyTypeNumberCol"></param>
        /// <param name="HPropertyTypeNameCol"></param>
        public static void SetGridByPropertyType(DataGridView grdMain, int i, int HPropertyTypeIDCol, int HPropertyTypeNumberCol, int HPropertyTypeNameCol)
        {

            DAL.ClsGy_PropertyType_View oPropertyType = new DAL.ClsGy_PropertyType_View();
            if (oPropertyType.RefreshView())
            {
                if (oPropertyType.GetInfoByID(oPropertyType.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HPropertyTypeIDCol].Value = oPropertyType.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HPropertyTypeNumberCol].Value = oPropertyType.omodel.HNumber;
                    grdMain.Rows[i].Cells[HPropertyTypeNameCol].Value = oPropertyType.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HPropertyTypeIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HPropertyTypeNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HPropertyTypeNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HPropertyTypeIDCol].Value = "0";
                grdMain.Rows[i].Cells[HPropertyTypeNumberCol].Value = "";
                grdMain.Rows[i].Cells[HPropertyTypeNameCol].Value = "";
            }
        }

        //άÐÞÏîÄ¿-Íø¸ñ
        /// <summary>
        /// άÐÞÏîÄ¿-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HRepairIDCol"></param>
        /// <param name="HRepairNumberCol"></param>
        /// <param name="HRepairNameCol"></param>
        public static void SetGridByRepair(DataGridView grdMain, int i, int HRepairIDCol, int HRepairNumberCol, int HRepairNameCol)
        {

            DAL.ClsGy_Repair_View oRepair = new DAL.ClsGy_Repair_View();
            if (oRepair.RefreshView())
            {
                if (oRepair.GetInfoByID(oRepair.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HRepairIDCol].Value = oRepair.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HRepairNumberCol].Value = oRepair.omodel.HNumber;
                    grdMain.Rows[i].Cells[HRepairNameCol].Value = oRepair.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HRepairIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HRepairNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HRepairNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HRepairIDCol].Value = "0";
                grdMain.Rows[i].Cells[HRepairNumberCol].Value = "";
                grdMain.Rows[i].Cells[HRepairNameCol].Value = "";
            }
        }

        //άÐÞÑéÊÕÏîÄ¿-Íø¸ñ
        /// <summary>
        /// άÐÞÑéÊÕÏîÄ¿-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HRepairCheckIDCol"></param>
        /// <param name="HRepairCheckNumberCol"></param>
        /// <param name="HRepairCheckNameCol"></param>
        public static void SetGridByRepairCheck(DataGridView grdMain, int i, int HRepairCheckIDCol, int HRepairCheckNumberCol, int HRepairCheckNameCol)
        {

            DAL.ClsGy_RepairCheck_View oRepairCheck = new DAL.ClsGy_RepairCheck_View();
            if (oRepairCheck.RefreshView())
            {
                if (oRepairCheck.GetInfoByID(oRepairCheck.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HRepairCheckIDCol].Value = oRepairCheck.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HRepairCheckNumberCol].Value = oRepairCheck.omodel.HNumber;
                    grdMain.Rows[i].Cells[HRepairCheckNameCol].Value = oRepairCheck.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HRepairCheckIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HRepairCheckNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HRepairCheckNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HRepairCheckIDCol].Value = "0";
                grdMain.Rows[i].Cells[HRepairCheckNumberCol].Value = "";
                grdMain.Rows[i].Cells[HRepairCheckNameCol].Value = "";
            }
        }

        //άÐÞ·½Ê½-Íø¸ñ
        /// <summary>
        /// άÐÞ·½Ê½-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HRepairTypeIDCol"></param>
        /// <param name="HRepairTypeNumberCol"></param>
        /// <param name="HRepairTypeNameCol"></param>
        public static void SetGridByRepairType(DataGridView grdMain, int i, int HRepairTypeIDCol, int HRepairTypeNumberCol, int HRepairTypeNameCol)
        {

            DAL.ClsGy_RepairType_View oRepairType = new DAL.ClsGy_RepairType_View();
            if (oRepairType.RefreshView())
            {
                if (oRepairType.GetInfoByID(oRepairType.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HRepairTypeIDCol].Value = oRepairType.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HRepairTypeNumberCol].Value = oRepairType.omodel.HNumber;
                    grdMain.Rows[i].Cells[HRepairTypeNameCol].Value = oRepairType.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HRepairTypeIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HRepairTypeNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HRepairTypeNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HRepairTypeIDCol].Value = "0";
                grdMain.Rows[i].Cells[HRepairTypeNumberCol].Value = "";
                grdMain.Rows[i].Cells[HRepairTypeNameCol].Value = "";
            }
        }

        //¹¤ÒÕ·Ïß´óÀà-Íø¸ñ
        /// <summary>
        /// ¹¤ÒÕ·Ïß´óÀà-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HRoutingGroupIDCol"></param>
        /// <param name="HRoutingGroupNumberCol"></param>
        /// <param name="HRoutingGroupNameCol"></param>
        public static void SetGridByRoutingGroup(DataGridView grdMain, int i, int HRoutingGroupIDCol, int HRoutingGroupNumberCol, int HRoutingGroupNameCol)
        {

            DAL.ClsGy_RoutingGroup_View oRoutingGroup = new DAL.ClsGy_RoutingGroup_View();
            if (oRoutingGroup.RefreshView())
            {
                if (oRoutingGroup.GetInfoByID(oRoutingGroup.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HRoutingGroupIDCol].Value = oRoutingGroup.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HRoutingGroupNumberCol].Value = oRoutingGroup.omodel.HNumber;
                    grdMain.Rows[i].Cells[HRoutingGroupNameCol].Value = oRoutingGroup.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HRoutingGroupIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HRoutingGroupNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HRoutingGroupNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HRoutingGroupIDCol].Value = "0";
                grdMain.Rows[i].Cells[HRoutingGroupNumberCol].Value = "";
                grdMain.Rows[i].Cells[HRoutingGroupNameCol].Value = "";
            }
        }

        //°²È«ÏîÄ¿-Íø¸ñ
        /// <summary>
        /// °²È«ÏîÄ¿-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HSafetyIDCol"></param>
        /// <param name="HSafetyNumberCol"></param>
        /// <param name="HSafetyNameCol"></param>
        public static void SetGridBySafety(DataGridView grdMain, int i, int HSafetyIDCol, int HSafetyNumberCol, int HSafetyNameCol)
        {

            DAL.ClsGy_Safety_View oSafety = new DAL.ClsGy_Safety_View();
            if (oSafety.RefreshView())
            {
                if (oSafety.GetInfoByID(oSafety.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HSafetyIDCol].Value = oSafety.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HSafetyNumberCol].Value = oSafety.omodel.HNumber;
                    grdMain.Rows[i].Cells[HSafetyNameCol].Value = oSafety.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HSafetyIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSafetyNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HSafetyNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HSafetyIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSafetyNumberCol].Value = "";
                grdMain.Rows[i].Cells[HSafetyNameCol].Value = "";
            }
        }

        //±¨·ÏÔ­Òò-Íø¸ñ
        /// <summary>
        /// ±¨·ÏÔ­Òò-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HScrapReasonIDCol"></param>
        /// <param name="HScrapReasonNumberCol"></param>
        /// <param name="HScrapReasonNameCol"></param>
        public static void SetGridByScrapReason(DataGridView grdMain, int i, int HScrapReasonIDCol, int HScrapReasonNumberCol, int HScrapReasonNameCol)
        {

            DAL.ClsGy_ScrapReason_View oScrapReason = new DAL.ClsGy_ScrapReason_View();
            if (oScrapReason.RefreshView())
            {
                if (oScrapReason.GetInfoByID(oScrapReason.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HScrapReasonIDCol].Value = oScrapReason.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HScrapReasonNumberCol].Value = oScrapReason.omodel.HNumber;
                    grdMain.Rows[i].Cells[HScrapReasonNameCol].Value = oScrapReason.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HScrapReasonIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HScrapReasonNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HScrapReasonNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HScrapReasonIDCol].Value = "0";
                grdMain.Rows[i].Cells[HScrapReasonNumberCol].Value = "";
                grdMain.Rows[i].Cells[HScrapReasonNameCol].Value = "";
            }
        }

        //·þÎñÀàÐÍ-Íø¸ñ
        /// <summary>
        /// ·þÎñÀàÐÍ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HSecTypeIDCol"></param>
        /// <param name="HSecTypeNumberCol"></param>
        /// <param name="HSecTypeNameCol"></param>
        public static void SetGridBySecType(DataGridView grdMain, int i, int HSecTypeIDCol, int HSecTypeNumberCol, int HSecTypeNameCol)
        {

            DAL.ClsGy_SecType_View oSecType = new DAL.ClsGy_SecType_View();
            if (oSecType.RefreshView())
            {
                if (oSecType.GetInfoByID(oSecType.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HSecTypeIDCol].Value = oSecType.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HSecTypeNumberCol].Value = oSecType.omodel.HNumber;
                    grdMain.Rows[i].Cells[HSecTypeNameCol].Value = oSecType.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HSecTypeIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSecTypeNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HSecTypeNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HSecTypeIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSecTypeNumberCol].Value = "";
                grdMain.Rows[i].Cells[HSecTypeNameCol].Value = "";
            }
        }

        //ÏúÊÛ·½Ê½-Íø¸ñ
        /// <summary>
        /// ÏúÊÛ·½Ê½-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HSellStyleIDCol"></param>
        /// <param name="HSellStyleNumberCol"></param>
        /// <param name="HSellStyleNameCol"></param>
        public static void SetGridBySellStyle(DataGridView grdMain, int i, int HSellStyleIDCol, int HSellStyleNumberCol, int HSellStyleNameCol)
        {

            DAL.ClsGy_SellStyle_View oSellStyle = new DAL.ClsGy_SellStyle_View();
            if (oSellStyle.RefreshView())
            {
                if (oSellStyle.GetInfoByID(oSellStyle.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HSellStyleIDCol].Value = oSellStyle.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HSellStyleNumberCol].Value = oSellStyle.omodel.HNumber;
                    grdMain.Rows[i].Cells[HSellStyleNameCol].Value = oSellStyle.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HSellStyleIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSellStyleNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HSellStyleNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HSellStyleIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSellStyleNumberCol].Value = "";
                grdMain.Rows[i].Cells[HSellStyleNameCol].Value = "";
            }
        }

        //½áË㷽ʽ-Íø¸ñ
        /// <summary>
        /// ½áË㷽ʽ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HSettleStyleIDCol"></param>
        /// <param name="HSettleStyleNumberCol"></param>
        /// <param name="HSettleStyleNameCol"></param>
        public static void SetGridBySettleStyle(DataGridView grdMain, int i, int HSettleStyleIDCol, int HSettleStyleNumberCol, int HSettleStyleNameCol)
        {

            DAL.ClsGy_SettleStyle_View oSettleStyle = new DAL.ClsGy_SettleStyle_View();
            if (oSettleStyle.RefreshView())
            {
                if (oSettleStyle.GetInfoByID(oSettleStyle.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HSettleStyleIDCol].Value = oSettleStyle.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HSettleStyleNumberCol].Value = oSettleStyle.omodel.HNumber;
                    grdMain.Rows[i].Cells[HSettleStyleNameCol].Value = oSettleStyle.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HSettleStyleIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSettleStyleNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HSettleStyleNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HSettleStyleIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSettleStyleNumberCol].Value = "";
                grdMain.Rows[i].Cells[HSettleStyleNameCol].Value = "";
            }
        }

        //°à´Î-Íø¸ñ
        /// <summary>
        /// °à´Î-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HShiftsIDCol"></param>
        /// <param name="HShiftsNumberCol"></param>
        /// <param name="HShiftsNameCol"></param>
        public static void SetGridByShifts(DataGridView grdMain, int i, int HShiftsIDCol, int HShiftsNumberCol, int HShiftsNameCol)
        {

            DAL.ClsGy_Shifts_View oShifts = new DAL.ClsGy_Shifts_View();
            if (oShifts.RefreshView())
            {
                if (oShifts.GetInfoByID(oShifts.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HShiftsIDCol].Value = oShifts.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HShiftsNumberCol].Value = oShifts.omodel.HNumber;
                    grdMain.Rows[i].Cells[HShiftsNameCol].Value = oShifts.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HShiftsIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HShiftsNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HShiftsNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HShiftsIDCol].Value = "0";
                grdMain.Rows[i].Cells[HShiftsNumberCol].Value = "";
                grdMain.Rows[i].Cells[HShiftsNameCol].Value = "";
            }
        }

        //Éú²ú×ÊÔ´-Íø¸ñ
        /// <summary>
        /// Éú²ú×ÊÔ´-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HSourceIDCol"></param>
        /// <param name="HSourceNumberCol"></param>
        /// <param name="HSourceNameCol"></param>
        public static void SetGridBySource(DataGridView grdMain, int i, int HSourceIDCol, int HSourceNumberCol, int HSourceNameCol)
        {

            DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
            if (oSource.RefreshView())
            {
                if (oSource.GetInfoByID(oSource.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HSourceIDCol].Value = oSource.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HSourceNumberCol].Value = oSource.omodel.HNumber;
                    grdMain.Rows[i].Cells[HSourceNameCol].Value = oSource.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HSourceIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSourceNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HSourceNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HSourceIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSourceNumberCol].Value = "";
                grdMain.Rows[i].Cells[HSourceNameCol].Value = "";
            }
        }

        


        //²Öλ-Íø¸ñ
        /// <summary>
        /// ²Öλ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HStockPlaceIDCol"></param>
        /// <param name="HStockPlaceNumberCol"></param>
        /// <param name="HStockPlaceNameCol"></param>
        public static void SetGridByStockPlace(DataGridView grdMain, int i, int HStockPlaceIDCol, int HStockPlaceNumberCol, int HStockPlaceNameCol)
        {

            DAL.ClsGy_StockPlace_View oStockPlace = new DAL.ClsGy_StockPlace_View();
            if (oStockPlace.RefreshView())
            {
                if (oStockPlace.GetInfoByID(oStockPlace.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = oStockPlace.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = oStockPlace.omodel.HNumber;
                    grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = oStockPlace.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
                grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
                grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
            }
        }

        //²Öλ×é-Íø¸ñ
        /// <summary>
        /// ²Öλ×é-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HStockPlaceGroupIDCol"></param>
        /// <param name="HStockPlaceGroupNumberCol"></param>
        /// <param name="HStockPlaceGroupNameCol"></param>
        public static void SetGridByStockPlaceGroup(DataGridView grdMain, int i, int HStockPlaceGroupIDCol, int HStockPlaceGroupNumberCol, int HStockPlaceGroupNameCol)
        {

            DAL.ClsGy_StockPlaceGroup_View oStockPlaceGroup = new DAL.ClsGy_StockPlaceGroup_View();
            if (oStockPlaceGroup.RefreshView())
            {
                if (oStockPlaceGroup.GetInfoByID(oStockPlaceGroup.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HStockPlaceGroupIDCol].Value = oStockPlaceGroup.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HStockPlaceGroupNumberCol].Value = oStockPlaceGroup.omodel.HNumber;
                    grdMain.Rows[i].Cells[HStockPlaceGroupNameCol].Value = oStockPlaceGroup.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HStockPlaceGroupIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HStockPlaceGroupNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HStockPlaceGroupNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HStockPlaceGroupIDCol].Value = "0";
                grdMain.Rows[i].Cells[HStockPlaceGroupNumberCol].Value = "";
                grdMain.Rows[i].Cells[HStockPlaceGroupNameCol].Value = "";
            }
        }

        //¹©Ó¦ÉÌ-Íø¸ñ
        /// <summary>
        /// ¹©Ó¦ÉÌ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HSupplierIDCol"></param>
        /// <param name="HSupplierNumberCol"></param>
        /// <param name="HSupplierNameCol"></param>
        public static void SetGridBySupplier(DataGridView grdMain, int i, int HSupplierIDCol, int HSupplierNumberCol, int HSupplierNameCol)
        {

            DAL.ClsGy_Supplier_View oSupplier = new DAL.ClsGy_Supplier_View();
            if (oSupplier.RefreshView())
            {
                if (oSupplier.GetInfoByID(oSupplier.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HSupplierIDCol].Value = oSupplier.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HSupplierNumberCol].Value = oSupplier.omodel.HNumber;
                    grdMain.Rows[i].Cells[HSupplierNameCol].Value = oSupplier.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HSupplierIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSupplierNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HSupplierNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HSupplierIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSupplierNumberCol].Value = "";
                grdMain.Rows[i].Cells[HSupplierNameCol].Value = "";
            }
        }

        //¹©Ó¦ÉÌÖ¸±ê-Íø¸ñ
        /// <summary>
        /// ¹©Ó¦ÉÌÖ¸±ê-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HSupTargetIDCol"></param>
        /// <param name="HSupTargetNumberCol"></param>
        /// <param name="HSupTargetNameCol"></param>
        public static void SetGridBySupTarget(DataGridView grdMain, int i, int HSupTargetIDCol, int HSupTargetNumberCol, int HSupTargetNameCol)
        {

            DAL.ClsGy_SupTarget_View oSupTarget = new DAL.ClsGy_SupTarget_View();
            if (oSupTarget.RefreshView())
            {
                if (oSupTarget.GetInfoByID(oSupTarget.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HSupTargetIDCol].Value = oSupTarget.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HSupTargetNumberCol].Value = oSupTarget.omodel.HNumber;
                    grdMain.Rows[i].Cells[HSupTargetNameCol].Value = oSupTarget.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HSupTargetIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HSupTargetNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HSupTargetNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HSupTargetIDCol].Value = "0";
                grdMain.Rows[i].Cells[HSupTargetNumberCol].Value = "";
                grdMain.Rows[i].Cells[HSupTargetNameCol].Value = "";
            }
        }

        //¼ÆÁ¿µ¥Î»×é-Íø¸ñ
        /// <summary>
        /// ¼ÆÁ¿µ¥Î»×é-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HUnitGroupIDCol"></param>
        /// <param name="HUnitGroupNumberCol"></param>
        /// <param name="HUnitGroupNameCol"></param>
        public static void SetGridByUnitGroup(DataGridView grdMain, int i, int HUnitGroupIDCol, int HUnitGroupNumberCol, int HUnitGroupNameCol)
        {

            DAL.ClsGy_UnitGroup_View oUnitGroup = new DAL.ClsGy_UnitGroup_View();
            if (oUnitGroup.RefreshView())
            {
                if (oUnitGroup.GetInfoByID(oUnitGroup.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HUnitGroupIDCol].Value = oUnitGroup.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HUnitGroupNumberCol].Value = oUnitGroup.omodel.HNumber;
                    grdMain.Rows[i].Cells[HUnitGroupNameCol].Value = oUnitGroup.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HUnitGroupIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HUnitGroupNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HUnitGroupNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HUnitGroupIDCol].Value = "0";
                grdMain.Rows[i].Cells[HUnitGroupNumberCol].Value = "";
                grdMain.Rows[i].Cells[HUnitGroupNameCol].Value = "";
            }
        }

        //¹¤×÷ÖÐÐÄ-Íø¸ñ
        /// <summary>
        /// ¹¤×÷ÖÐÐÄ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HWorkCenterIDCol"></param>
        /// <param name="HWorkCenterNumberCol"></param>
        /// <param name="HWorkCenterNameCol"></param>
        public static void SetGridByWorkCenter(DataGridView grdMain, int i, int HWorkCenterIDCol, int HWorkCenterNumberCol, int HWorkCenterNameCol)
        {

            DAL.ClsGy_WorkCenter_View oWorkCenter = new DAL.ClsGy_WorkCenter_View();
            if (oWorkCenter.RefreshView())
            {
                if (oWorkCenter.GetInfoByID(oWorkCenter.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HWorkCenterIDCol].Value = oWorkCenter.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HWorkCenterNumberCol].Value = oWorkCenter.omodel.HNumber;
                    grdMain.Rows[i].Cells[HWorkCenterNameCol].Value = oWorkCenter.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HWorkCenterIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HWorkCenterNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HWorkCenterNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HWorkCenterIDCol].Value = "0";
                grdMain.Rows[i].Cells[HWorkCenterNumberCol].Value = "";
                grdMain.Rows[i].Cells[HWorkCenterNameCol].Value = "";
            }
        }

        //¹¤×ÊÀàÐÍ-Íø¸ñ
        /// <summary>
        /// ¹¤×ÊÀàÐÍ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HWorkPayTypeIDCol"></param>
        /// <param name="HWorkPayTypeNumberCol"></param>
        /// <param name="HWorkPayTypeNameCol"></param>
        public static void SetGridByWorkPayType(DataGridView grdMain, int i, int HWorkPayTypeIDCol, int HWorkPayTypeNumberCol, int HWorkPayTypeNameCol)
        {

            DAL.ClsGy_WorkPayType_View oWorkPayType = new DAL.ClsGy_WorkPayType_View();
            if (oWorkPayType.RefreshView())
            {
                if (oWorkPayType.GetInfoByID(oWorkPayType.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HWorkPayTypeIDCol].Value = oWorkPayType.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HWorkPayTypeNumberCol].Value = oWorkPayType.omodel.HNumber;
                    grdMain.Rows[i].Cells[HWorkPayTypeNameCol].Value = oWorkPayType.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HWorkPayTypeIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HWorkPayTypeNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HWorkPayTypeNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HWorkPayTypeIDCol].Value = "0";
                grdMain.Rows[i].Cells[HWorkPayTypeNumberCol].Value = "";
                grdMain.Rows[i].Cells[HWorkPayTypeNameCol].Value = "";
            }
        }

        //¹¤ÖÖ-Íø¸ñ
        /// <summary>
        /// ¹¤ÖÖ-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HWorkTypeIDCol"></param>
        /// <param name="HWorkTypeNumberCol"></param>
        /// <param name="HWorkTypeNameCol"></param>
        public static void SetGridByWorkType(DataGridView grdMain, int i, int HWorkTypeIDCol, int HWorkTypeNumberCol, int HWorkTypeNameCol)
        {
            DAL.ClsGy_WorkType_View oWorkType = new DAL.ClsGy_WorkType_View();
            if (oWorkType.RefreshView())
            {
                if (oWorkType.GetInfoByID(oWorkType.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HWorkTypeIDCol].Value = oWorkType.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HWorkTypeNumberCol].Value = oWorkType.omodel.HNumber;
                    grdMain.Rows[i].Cells[HWorkTypeNameCol].Value = oWorkType.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HWorkTypeIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HWorkTypeNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HWorkTypeNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HWorkTypeIDCol].Value = "0";
                grdMain.Rows[i].Cells[HWorkTypeNumberCol].Value = "";
                grdMain.Rows[i].Cells[HWorkTypeNameCol].Value = "";
            }
        }


        //ÐéÄâ²Ö¿â-Íø¸ñ
        /// <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 SetGridByVirtualWarehouse(DataGridView grdMain, int i, int HWhIDCol, int HWhNumberCol, int HWhNameCol)
        {
            DAL.ClsGy_VirtualWarehouse_View oWh = new DAL.ClsGy_VirtualWarehouse_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="HStockPlaceIDCol"></param>
        /// <param name="HStockPlaceNumberCol"></param>
        /// <param name="HStockPlaceNameCol"></param>
        public static void SetGridByVirtualStockPlace(DataGridView grdMain, int i, int HVirtualStockPlaceIDCol, int HVirtualStockPlaceNumberCol, int HVirtualStockPlaceNameCol)
        {

            DAL.ClsGy_VirtualStockPlace_View oVirtualStockPlace = new DAL.ClsGy_VirtualStockPlace_View();
            if (oVirtualStockPlace.RefreshView())
            {
                if (oVirtualStockPlace.GetInfoByID(oVirtualStockPlace.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HVirtualStockPlaceIDCol].Value = oVirtualStockPlace.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HVirtualStockPlaceNumberCol].Value = oVirtualStockPlace.omodel.HNumber;
                    grdMain.Rows[i].Cells[HVirtualStockPlaceNameCol].Value = oVirtualStockPlace.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HVirtualStockPlaceIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HVirtualStockPlaceNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HVirtualStockPlaceNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HVirtualStockPlaceIDCol].Value = "0";
                grdMain.Rows[i].Cells[HVirtualStockPlaceNumberCol].Value = "";
                grdMain.Rows[i].Cells[HVirtualStockPlaceNameCol].Value = "";
            }
        }




        //µã¼ìÏîÄ¿-Íø¸ñ
        /// <summary>
        /// µã¼ìÏîÄ¿-Íø¸ñ
        /// </summary>
        /// <param name="grdMain"></param>
        /// <param name="i"></param>
        /// <param name="HEmpIDCol"></param>
        /// <param name="HEmpNumberCol"></param>
        /// <param name="HEmpNameCol"></param>
        public static void SetGridByDotCheckItem(DataGridView grdMain, int i, int HDotCheckItemIDCol, int HDotCheckItemNumberCol, int HDotCheckItemNameCol)
        {

            DAL.ClsGy_DotCheck_View oDot = new DAL.ClsGy_DotCheck_View();
            if (oDot.RefreshView())
            {
                if (oDot.GetInfoByID(oDot.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HDotCheckItemIDCol].Value = oDot.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HDotCheckItemNumberCol].Value = oDot.omodel.HNumber;
                    grdMain.Rows[i].Cells[HDotCheckItemNameCol].Value = oDot.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HDotCheckItemIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HDotCheckItemNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HDotCheckItemNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HDotCheckItemIDCol].Value = "0";
                grdMain.Rows[i].Cells[HDotCheckItemNumberCol].Value = "";
                grdMain.Rows[i].Cells[HDotCheckItemNameCol].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 SetGridByQCCheckClass(DataGridView grdMain, int i, int HQCCheckClassIDCol, int HQCCheckClassNumberCol, int HQCCheckClassNameCol)
        //{

        //    DAL.ClsGy_QCCheckClass_View oQCCheckClass = new DAL.ClsGy_QCCheckClass_View();
        //    if (oQCCheckClass.RefreshView())
        //    {
        //        if (oQCCheckClass.GetInfoByID(oQCCheckClass.oModel.HItemID))
        //        {
        //            grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = oQCCheckClass.omodel.HItemID.ToString();
        //            grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = oQCCheckClass.omodel.HNumber;
        //            grdMain.Rows[i].Cells[HQCCheckClassNameCol].Value = oQCCheckClass.omodel.HName;
        //        }
        //        else
        //        {
        //            grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = "0";
        //            grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = "";
        //            grdMain.Rows[i].Cells[HQCCheckClassNameCol].Value = "";
        //        }
        //    }
        //    else
        //    {
        //        grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = "0";
        //        grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = "";
        //        grdMain.Rows[i].Cells[HQCCheckClassNameCol].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 SetGridByQCCheckItem(DataGridView grdMain, int i, int HQCCheckItemIDCol, int HQCCheckItemNumberCol, int HQCCheckItemNameCol)
        //{

        //    DAL.ClsGy_QCCheckItem_View oQCCheckItem = new DAL.ClsGy_QCCheckItem_View();
        //    if (oQCCheckItem.RefreshView())
        //    {
        //        if (oQCCheckItem.GetInfoByID(oQCCheckItem.oModel.HItemID))
        //        {
        //            grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = oQCCheckItem.omodel.HItemID.ToString();
        //            grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = oQCCheckItem.omodel.HNumber;
        //            grdMain.Rows[i].Cells[HQCCheckItemNameCol].Value = oQCCheckItem.omodel.HName;
        //        }
        //        else
        //        {
        //            grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = "0";
        //            grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = "";
        //            grdMain.Rows[i].Cells[HQCCheckItemNameCol].Value = "";
        //        }
        //    }
        //    else
        //    {
        //        grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = "0";
        //        grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = "";
        //        grdMain.Rows[i].Cells[HQCCheckItemNameCol].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 SetGridByCheckTools(DataGridView grdMain, int i, int HCheckToolsIDCol, int HCheckToolsNumberCol, int HCheckToolsNameCol)
        {

            DAL.ClsGy_CheckToolsFileMain_View oCheck = new DAL.ClsGy_CheckToolsFileMain_View();
            if (oCheck.RefreshView())
            {
                if (oCheck.GetInfoByID(oCheck.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HCheckToolsIDCol].Value = oCheck.oModel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HCheckToolsNumberCol].Value = oCheck.oModel.HNumber;
                    grdMain.Rows[i].Cells[HCheckToolsNameCol].Value = oCheck.oModel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HCheckToolsIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HCheckToolsNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HCheckToolsNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HCheckToolsIDCol].Value = "0";
                grdMain.Rows[i].Cells[HCheckToolsNumberCol].Value = "";
                grdMain.Rows[i].Cells[HCheckToolsNameCol].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 SetGridByMouldFile(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol)
        {

            DAL.ClsGy_MouldFileMain_View oMFM = new DAL.ClsGy_MouldFileMain_View();
            if (oMFM.RefreshView())
            {
                if (oMFM.GetInfoByID(oMFM.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HMaterIDCol].Value = oMFM.oModel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HMaterNumberCol].Value = oMFM.oModel.HNumber;
                    grdMain.Rows[i].Cells[HMaterNameCol].Value = oMFM.oModel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
                grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
                grdMain.Rows[i].Cells[HMaterNameCol].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 SetGridByTech(DataGridView grdMain, int i, int HTechParamIDCol, int HTechParamNumberCol, int HTechParamNameCol)
        {

            DAL.ClsGy_TechnologyParameter_View oTech = new DAL.ClsGy_TechnologyParameter_View();
            if (oTech.RefreshView())
            {
                if (oTech.GetInfoByID(oTech.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HTechParamIDCol].Value = oTech.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HTechParamNumberCol].Value = oTech.omodel.HNumber;
                    grdMain.Rows[i].Cells[HTechParamNameCol].Value = oTech.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HTechParamIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HTechParamNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HTechParamNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HTechParamIDCol].Value = "0";
                grdMain.Rows[i].Cells[HTechParamNumberCol].Value = "";
                grdMain.Rows[i].Cells[HTechParamNameCol].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 SetGridByTechU(DataGridView grdMain, int i, int HTechParamUnitIDCol, int HTechParamUnitNumberCol, int HTechParamUnitNameCol)
        {

            DAL.ClsGy_TechnologyParameterUnit_View oTechU = new DAL.ClsGy_TechnologyParameterUnit_View();
            if (oTechU.RefreshView())
            {
                if (oTechU.GetInfoByID(oTechU.oModel.HItemID))
                {
                    grdMain.Rows[i].Cells[HTechParamUnitIDCol].Value = oTechU.omodel.HItemID.ToString();
                    grdMain.Rows[i].Cells[HTechParamUnitNumberCol].Value = oTechU.omodel.HNumber;
                    grdMain.Rows[i].Cells[HTechParamUnitNameCol].Value = oTechU.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HTechParamUnitIDCol].Value = "0";
                    grdMain.Rows[i].Cells[HTechParamUnitNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HTechParamUnitNameCol].Value = "";
                }
            }
            else
            {
                grdMain.Rows[i].Cells[HTechParamUnitIDCol].Value = "0";
                grdMain.Rows[i].Cells[HTechParamUnitNumberCol].Value = "";
                grdMain.Rows[i].Cells[HTechParamUnitNameCol].Value = "";
            }
        }
        #endregion
    }
}