/// <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); } }
/// <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); } }