/// <summary>
/// 삭제확인 메세지 출력 후 확인버튼 클릭시 삭제 진행
/// 결과를 Bool 타입으로 받아서 True/False에 따라 확인/오류 메세지 출력
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void newBtns_btnDelete_Event(object sender, EventArgs e)
{
try
{
if (MessageBox.Show(Properties.Resources.msgDelete, "삭제확인 ", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
service = new MatPriceService();
bool result = service.Delete(priceID);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
DGV_Binding();
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 제품ID를 가져와서 ValueMember, 제품명은 DisplayMember
/// 거래처ID를 가져와서 ValueMember, 거래처명은 DisplayMember
/// 작성자: 최현호
/// 작성일: 21-01-24
/// </summary>
private void cboBinding()
{
try
{
if (label1.Text == "영업단가관리 등록" || label1.Text == "영업단가관리 수정")
{
SalesPriceService service = new SalesPriceService();
prodName = service.GetProdName();
CommonUtil.ProdNameBinding(cbProductName, prodName);
service = new SalesPriceService();
companyName = service.GetCompanyName();
CommonUtil.CompanyNameBinding(cbCompanyName, companyName);
}
else if (label1.Text == "자재단가관리 등록" || label1.Text == "자재단가관리 수정")
{
MatPriceService Mservice = new MatPriceService();
matprodName = Mservice.GetProdName();
CommonUtil.Mat_ProdNameBinding(cbProductName, matprodName);
Mservice = new MatPriceService();
matcompanyName = Mservice.GetCompanyNameName();
CommonUtil.Mat_CompanyNameBinding(cbCompanyName, matcompanyName);
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
private void DGV_Binding()
{
try
{
service = new MatPriceService();
allList = service.GetMatInfo();
dgvMatPrice.DataSource = allList;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnWhere_Click(object sender, EventArgs e)
{
try
{
service = new MatPriceService();
allList = service.GetWhereInfo(txtProdName.Text, txtCompanyName.Text);
dgvMatPrice.DataSource = allList;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 체크박스 True일 경우 자재단가 사용유무가 Y,N 모두 바인딩
/// 체크박스 False일 경우 사용유무가 Y인 것만 바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cheView_Click(object sender, EventArgs e)
{
try
{
if (cheView.Checked)
{
service = new MatPriceService();
allList = service.GetMatInfo();
dgvMatPrice.DataSource = allList;
}
else if (!cheView.Checked)
{
service = new MatPriceService();
allList = service.GetMatNInfo();
dgvMatPrice.DataSource = allList;
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
SalesPriceService Sservice;
MatPriceService Mservice;
if (label1.Text == "영업단가관리 등록")
{
if (cbProductName.SelectedIndex != 0 || cbCompanyName.SelectedIndex != 0 || cbYN.SelectedIndex != 0 || txtPricePresent.Text != null)
{
SalesPriceVO vo = new SalesPriceVO
{
product_name = cbProductName.Text,
company_name = cbCompanyName.Text,
price_sdate = dtpStart.Value.ToString(),
price_edate = dtpEnd.Value.ToString(),
price_yn = cbYN.Text,
price_present = int.Parse(txtPricePresent.Text),
price_comment = txtComment.Text
};
Sservice = new SalesPriceService();
bool result = Sservice.Insert(vo);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
cboBinding();
ClearTB();
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
}
else if (label1.Text == "영업단가관리 수정")
{
try
{
SalesPriceVO vo = new SalesPriceVO
{
price_id = int.Parse(label1.Tag.ToString()),
product_name = cbProductName.Text,
company_name = cbCompanyName.Text,
price_present = int.Parse(txtPricePresent.Text),
price_sdate = Convert.ToDateTime(dtpStart.Value).ToString(),
price_edate = Convert.ToDateTime(dtpEnd.Value).ToString(),
price_yn = cbYN.Text,
price_comment = txtComment.Text
};
Sservice = new SalesPriceService();
bool result = Sservice.Update(vo);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
cboBinding();
ClearTB();
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
else if (label1.Text == "자재단가관리 등록")
{
if (cbProductName.SelectedIndex != 0 || cbCompanyName.SelectedIndex != 0 || cbYN.SelectedIndex != 0 || txtPricePresent.Text != null)
{
MatPriceVO vo = new MatPriceVO()
{
product_name = cbProductName.Text,
company_name = cbCompanyName.Text,
price_sdate = dtpStart.Value.ToString(),
price_edate = dtpEnd.Value.ToString(),
price_yn = cbYN.Text,
price_present = int.Parse(txtPricePresent.Text),
price_comment = txtComment.Text
};
Mservice = new MatPriceService();
bool result = Mservice.Insert(vo);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
cboBinding();
ClearTB();
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
}
else if (label1.Text == "자재단가관리 수정")
{
try
{
MatPriceVO vo = new MatPriceVO
{
price_id = int.Parse(label1.Tag.ToString()),
product_name = cbProductName.Text,
company_name = cbCompanyName.Text,
price_present = int.Parse(txtPricePresent.Text),
price_sdate = Convert.ToDateTime(dtpStart.Value).ToString(),
price_edate = Convert.ToDateTime(dtpEnd.Value).ToString(),
price_yn = cbYN.Text,
price_comment = txtComment.Text
};
Mservice = new MatPriceService();
bool result = Mservice.Update(vo);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
cboBinding();
ClearTB();
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
}
