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