/// <summary>
/// 작성자: 최현호 / 작성일: 210212
/// </summary>
/// <param name="vo"></param>
/// <returns></returns>
public bool Update(ProdStatusVO vo)
{
try
{
string sql = @"EXEC SP_UpdateProductStatus @product_id, @product_name, @product_unit, @product_type, @product_lorder_count, @product_safety_count, @company_id, @product_exam, @product_stnd, @product_comment, @w_id, @product_deleted";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@product_id", vo.product_id);
cmd.Parameters.AddWithValue("@product_name", vo.product_name);
cmd.Parameters.AddWithValue("@product_unit", vo.product_unit);
cmd.Parameters.AddWithValue("@product_type", vo.product_type);
cmd.Parameters.AddWithValue("@product_lorder_count", vo.product_lorder_count);
cmd.Parameters.AddWithValue("@product_safety_count", vo.product_safety_count);
cmd.Parameters.AddWithValue("@company_id", vo.company_name);
cmd.Parameters.AddWithValue("@product_exam", vo.product_exam);
cmd.Parameters.AddWithValue("@product_stnd", vo.product_stnd);
cmd.Parameters.AddWithValue("@product_comment", vo.product_comment);
cmd.Parameters.AddWithValue("@w_id", vo.w_name);
cmd.Parameters.AddWithValue("@product_deleted", vo.product_deleted);
int iRowAffect = cmd.ExecuteNonQuery();
conn.Close();
return(iRowAffect > 0);
}
}
catch (Exception)
{
throw;
}
}
public bool Update(ProdStatusVO vo)
{
ProdStatusDAC dac = new ProdStatusDAC();
return(dac.Update(vo));
}
public bool Insert(ProdStatusVO vo)
{
ProdStatusDAC dac = new ProdStatusDAC();
return(dac.Insert(vo));
}
private void btnEdit_Click(object sender, EventArgs e)
{
try
{
ProdStatusService service = new ProdStatusService();
if (label1.Text == "품목 등록")
{
ProdStatusVO vo = new ProdStatusVO
{
product_id = txtProdID.Text,
product_type = cbProdType.Text,
product_unit = cbUnit.Text,
product_lorder_count = int.Parse(nuMinOrder.Value.ToString()),
product_safety_count = int.Parse(nuSafeCount.Value.ToString()),
product_name = cbProdName.Text,
company_name = cbCompany.Text,
w_name = cbWHouse.Text,
product_exam = cbExamYN.Text,
product_stnd = txtStnd.Text,
product_comment = txtComment.Text,
product_deleted = cbDeleted.Text
};
bool result = service.Insert(vo);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
else if (label1.Text == "품목 수정")
{
ProdStatusVO vo = new ProdStatusVO
{
product_id = txtProdID.Text,
product_type = cbProdType.Text,
product_unit = cbUnit.Text,
product_lorder_count = int.Parse(nuMinOrder.Value.ToString()),
product_safety_count = int.Parse(nuSafeCount.Value.ToString()),
product_name = cbProdName.Text,
company_name = cbCompany.Text,
w_name = cbWHouse.Text,
product_exam = cbExamYN.Text,
product_stnd = txtStnd.Text,
product_comment = txtComment.Text,
product_deleted = cbDeleted.Text
};
bool result = service.Update(vo);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
