/// <summary> /// 데이터 그리드 바인딩 /// </summary> private void DataGridViewBinding() { try { dgvBOM.DataSource = null; BOMService bom = new BOMService(); dgvBOM.DataSource = bom.SelectBOM(); } catch (Exception err) { this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}"); } }
/// <summary> /// 조회 버튼 이벤트 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void Search(object sender, EventArgs e) { if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this) { try { if (ITEM_NAEM.Text.Length < 1) { MessageBox.Show("검색하실 품목명을 입력해주세요"); return; } BOMService bom = new BOMService(); dgvBOM.DataSource = bom.SearchBOM(day.Value.ToShortDateString(), ITEM_NAEM.Text, BOM_USE_YN.Text); } catch (Exception err) { this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}"); } } }
/// <summary> /// 입력 버튼 이벤트 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { try { if (ITEM_CODE.Text.Length < 1 || BOM_QTY.Text.Length < 1 || BOM_USE_YN.Text.Length < 1 || BOM_AUTOREDUCE_YN.Text.Length < 1 || BOM_PLAN_YN.Text.Length < 1) { MessageBox.Show("필수 입력사항을 입력해주세요."); return; } BOM_VO vo = new BOM_VO(); vo.BOM_CODE = code; vo.BOM_PARENT_CODE = (BOM_PARENT_CODE.Text == "-") ? "-" : BOM_PARENT_CODE.SelectedValue.ToString(); vo.ITEM_CODE = ITEM_CODE.SelectedValue.ToString(); vo.BOM_QTY = (BOM_QTY.Text.Length < 1) ? 1 : int.Parse(BOM_QTY.Text); vo.BOM_STARTDATE = BOM_STARTDATE.Value.ToShortDateString(); vo.BOM_ENDDATE = BOM_ENDDATE.Value.ToShortDateString(); vo.BOM_USE_YN = BOM_USE_YN.Text; vo.BOM_LAST_MDFR = BOM_LAST_MDFR.Text; vo.BOM_LAST_MDFY = BOM_LAST_MDFY.Value.ToShortDateString(); vo.BOM_AUTOREDUCE_YN = BOM_AUTOREDUCE_YN.Text; vo.BOM_PLAN_YN = BOM_PLAN_YN.Text; vo.BOM_REMARK = BOM_REMARK.Text; BOMService item = new BOMService(); string result = item.SaveBOM(vo); if (result == "C200") { MessageBox.Show("성공적으로 입력되었습니다."); this.DialogResult = DialogResult.OK; //this.Close(); } else if (result == "C201") { MessageBox.Show("BOM이 중복되었습니다. 다시 입력해주세요"); } } catch (Exception err) { this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}"); } }
/// <summary> /// 삭제 버튼 이벤트 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void Delete(object sender, EventArgs e) { if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this) { try { dgvBOM.EndEdit(); StringBuilder sb = new StringBuilder(); int cnt = 0; //품목 선택후 List를 전달 foreach (DataGridViewRow item in dgvBOM.Rows) { if (Convert.ToBoolean(item.Cells[1].Value)) { sb.Append(item.Cells[2].Value.ToString() + "@"); cnt++; } } if (sb.Length < 1) { MessageBox.Show("미사용 항목을 선택하여 주십시오."); return; } sb.Remove(sb.Length - 1, 1); if (MessageBox.Show($"총 {cnt}개의 항목을 미사용 하겠습니까?? 하위항목도 미사용됨니다. ", "미사용", MessageBoxButtons.YesNo) == DialogResult.Yes) { BOMService service = new BOMService(); if (service.DeleteBOM(sb)) { MessageBox.Show("미사용 완료"); DataGridViewBinding(); } } } catch (Exception err) { this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}"); } } }
/// <summary> /// 업데이트 팝업 시 해당 코드이 정보를 뿌려주는 함수 /// </summary> /// <param name="code"></param> private void GetBOM(int code) { try { BOMService item = new BOMService(); BOM_VO vo = item.GetBOM(code); BOM_PARENT_CODE.SelectedValue = vo.BOM_PARENT_CODE; ITEM_CODE.SelectedValue = vo.ITEM_CODE; BOM_QTY.Text = vo.BOM_QTY.ToString(); BOM_STARTDATE.Text = vo.BOM_STARTDATE; BOM_ENDDATE.Text = vo.BOM_ENDDATE; BOM_USE_YN.Text = vo.BOM_USE_YN; BOM_LAST_MDFR.Text = vo.BOM_LAST_MDFR; BOM_LAST_MDFY.Text = vo.BOM_LAST_MDFY; BOM_AUTOREDUCE_YN.Text = vo.BOM_AUTOREDUCE_YN; BOM_PLAN_YN.Text = vo.BOM_PLAN_YN; BOM_REMARK.Text = vo.BOM_REMARK; } catch (Exception err) { this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}"); } }