/// <summary> /// 컬럼 헤더 텍스트 바인딩 /// 데이터 조회해서 바인딩 /// 품목명, 창고명, 품목분류 콤보박스바인딩 /// 작성자: 최현호 / 작성일: 210210 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frmPDStock_Load(object sender, EventArgs e) { try { CommonUtil.SetInitGridView(dgv_PDStock); //CommonUtil.AddGridTextColumn(dgv_PDStock, "번호", "ps_id", 80); CommonUtil.AddGridTextColumn(dgv_PDStock, "품목코드", "product_id", 220); CommonUtil.AddGridTextColumn(dgv_PDStock, "품목명", "product_name", 220); CommonUtil.AddGridTextColumn(dgv_PDStock, "분류", "product_type", 220); CommonUtil.AddGridTextColumn(dgv_PDStock, "창고명", "w_name", 170); CommonUtil.AddGridTextColumn(dgv_PDStock, "회사명", "company_name", 150); CommonUtil.AddGridTextColumn(dgv_PDStock, "재고량", "ps_stock", 150); DGVBinding(); ProdStatusService service = new ProdStatusService(); prodName = service.GetProdName(); CommonUtil.ProdStatus_ProdNameBinding(cbProdName, prodName); whName = service.GetWHName(); CommonUtil.ProdStatus_WHNameBinding(cbWHName, whName); pdType = service.GetProdType(); CommonUtil.ProdTypeBinding(cbProdType, pdType); } 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); } }