/// <summary> /// 삭제확인 메세지 출력 후 확인시 삭제진행 /// 결과를 True/False로 받아와서 확인/오류 메세지 출력 /// 작성자: 최현호 / 작성일: 210210 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void newBtns1_btnDelete_Event(object sender, EventArgs e) { try { if (MessageBox.Show(Properties.Resources.msgDelete, "삭제확인 ", MessageBoxButtons.YesNo) == DialogResult.Yes) { PDStockVO vo = new PDStockVO { ps_id = ps_id, product_id = product_id }; bool result = service.Delete(vo); if (result) { MessageBox.Show(Properties.Resources.msgOK); DGVBinding(product_id); } else { MessageBox.Show(Properties.Resources.msgError); } } } catch (Exception err) { MessageBox.Show(err.Message); } }
/// <summary> /// PDStockVO 타입의 vo에 각 컨트롤의 내용을 담아서 DAC단의 파라미터로 전달 /// 결과를 Bool타입으로 받아서 True/False에 따라 확인/오류 메세지 출력 /// 작성자: 최현호 / 작성일: 210210 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnEdit_Click(object sender, EventArgs e) { try { PDStockVO vo = new PDStockVO { ps_id = int.Parse(lblPSID.Text), product_id = txtProduct_id.Text, ps_stock = int.Parse(nuStock.Value.ToString()), ps_idate = dtp_idate.Value.ToShortDateString(), ps_odate = dtp_odate.Value.ToShortDateString() }; bool result = service.Update(vo); if (result) { MessageBox.Show(Properties.Resources.msgOK); this.Close(); } else { MessageBox.Show(Properties.Resources.msgError); } } catch (Exception err) { MessageBox.Show(err.Message); } }
/// <summary> /// 작성자: 최현호 / 작성일: 210212 /// </summary> /// <param name="vo"></param> /// <returns></returns> public bool Update(PDStockVO vo) { try { string sql = @"update TBL_PRODUCT_STOCK set ps_stock = @ps_stock, ps_idate = @ps_idate, ps_odate = @ps_odate where ps_id = @ps_id and product_id = @product_id"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@ps_stock", vo.ps_stock); cmd.Parameters.AddWithValue("@ps_idate", vo.ps_idate); cmd.Parameters.AddWithValue("@ps_odate", vo.ps_odate); cmd.Parameters.AddWithValue("@ps_id", vo.ps_id); cmd.Parameters.AddWithValue("@product_id", vo.product_id); int iRowAffect = cmd.ExecuteNonQuery(); conn.Close(); return(iRowAffect > 0); } } catch (Exception) { throw; } }
public bool Delete(PDStockVO vo) { PDStockDAC dac = new PDStockDAC(); return(dac.Delete(vo)); }
public bool Update(PDStockVO vo) { PDStockDAC dac = new PDStockDAC(); return(dac.Update(vo)); }