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