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