Пример #1
0
 /// <summary>
 /// 상위품목명과 제품명 콤보박스를 바인딩해온다.
 /// 작성자: 최현호 / 작성일: 210210
 /// </summary>
 private void CBBinding()
 {
     try
     {
         allList = service.GetBOMCBProdName();
         CommonUtil.BOMProdName(cbParent, allList);
         CommonUtil.BOMProdName(cbProd, allList);
     }
     catch (Exception err)
     {
         MessageBox.Show(err.Message);
     }
 }
Пример #2
0
        /// <summary>
        /// 폼 로드이벤트
        /// 컬럼헤더를 바인딩하고 DB에서 0레벨 BOM을 우선 조회한다.
        /// 작성자: 최현호 / 작성일: 210210
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void frmBOM_Load(object sender, EventArgs e)
        {
            try
            {
                #region 0레벨 BOM GridView
                CommonUtil.SetInitGridView(dgvBOM_Lv0);
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "번호", "bom_id", 40);                        //0
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "상위BOMID", "bom_parent_id", 10, false);     //1
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "상위품목ID", "prod_parent_id", 10, false);     //2
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "상위품목명", "prod_parent_name", 10, false);    //3
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "품목코드", "product_id", 80);                  //4
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "품목명", "product_name", 90);                 //5
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "분류", "product_type", 60);                  //6
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "단위", "product_unit", 60);                  //7
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "소요량", "bom_use_count", 70);                //8
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "레벨", "bom_level", 40);                     //9
                CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "비고", "bom_comment", 140, false);           //10
                #endregion

                #region BOMAll GridView
                CommonUtil.SetInitGridView(dgvBOMAll);
                CommonUtil.AddGridTextColumn(dgvBOMAll, "번호", "bom_id", 80);                         //0
                CommonUtil.AddGridTextColumn(dgvBOMAll, "품목코드", "product_id", 140);                  //1
                CommonUtil.AddGridTextColumn(dgvBOMAll, "품목명", "product_name", 160);                 //2
                CommonUtil.AddGridTextColumn(dgvBOMAll, "분류", "product_type", 160);                  //3
                CommonUtil.AddGridTextColumn(dgvBOMAll, "단위", "product_unit", 140);                  //4
                CommonUtil.AddGridTextColumn(dgvBOMAll, "소요량", "bom_use_count", 150);                //5
                CommonUtil.AddGridTextColumn(dgvBOMAll, "레벨", "bom_level", 140);                     //6
                #endregion

                gbBOM.Visible = false;

                allList = service.GetBOMCBProdName();
                CommonUtil.BOMProdName(cbProdName, allList);

                ProdStatusService service2 = new ProdStatusService();
                GetProdType = service2.GetProdType();
                CommonUtil.ProdTypeBinding(cbProdType, GetProdType);

                DGV_Binding_Lv0();
            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }
        }