private void UpsertMethod(string Category, int Group_ID)
{
ProductGroupVO list = new ProductGroupVO
{
Product_Group_Name = txtProductName.Text,
Product_Group_Use = UseChar,
Product_Group_Note1 = txtNote1.Text,
Product_Group_Note2 = txtNote2.Text,
Final_Regist_Employee = employee, // 회원가입이 완성되면 직업명 넣어줄 것
Final_Regist_Time = DateTime.Now,
Product_Group_Seq = numSEQ.Value.ToInt(),
Category = Category,
Product_Group_ID = Group_ID
};
if (MessageBox.Show($"그룹을 {Status}하시겠습니까?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (service.UpsertGroup(list))
{
MessageBox.Show($"그룹이 {Status}되었습니다.");
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
private void dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dgv[2, e.RowIndex].Value.ToString() == "반제품" || dgv[2, e.RowIndex].Value.ToString() == "재료")
{
MessageBox.Show("반제품, 재료는 수정이 불가능합니다.");
return;
}
ProductGroupVO vo = new ProductGroupVO
{
Product_Group_ID = dgv[1, e.RowIndex].Value.ToInt(),
Product_Group_Use_String = dgv[3, e.RowIndex].Value.ToString(),
Product_Group_Seq = dgv[4, e.RowIndex].Value.ToInt(),
Product_Group_Name = dgv[2, e.RowIndex].Value.ToString(),
Product_Group_Note1 = dgv[5, e.RowIndex].Value.ToString(),
Product_Group_Note2 = dgv[6, e.RowIndex].Value.ToString()
};
ProductGroupInfoForm frm = new ProductGroupInfoForm(emp.Employee_name, true, vo);
if (frm.ShowDialog() == DialogResult.OK)
{
ReviewDGV();
}
}
public ProductGroupInfoForm(string employee, bool IsUpdate = false, ProductGroupVO groupVO = null)
{
InitializeComponent();
this.IsUpdate = IsUpdate;
this.groupVO = groupVO;
this.employee = employee;
if (IsUpdate == true)
{
this.Text = "제품 그룹 수정";
Status = "수정";
}
else
{
Status = "등록";
}
}
public bool UpsertGroup(ProductGroupVO pdgVO)
{
try
{
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
{
conn.Open();
string sql = @"SP_PRODUCT_GROUP_INSERT";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_PRODUCT_GROUP_ID", pdgVO.Product_Group_ID);
cmd.Parameters.AddWithValue("@P_PRODUCT_GROUP_NAME", pdgVO.Product_Group_Name);
cmd.Parameters.AddWithValue("@P_PRODUCT_NOTE1", pdgVO.Product_Group_Note1);
cmd.Parameters.AddWithValue("@P_PRODUCT_NOTE2", pdgVO.Product_Group_Note2);
cmd.Parameters.AddWithValue("@P_PRODUCT_USE", pdgVO.Product_Group_Use);
cmd.Parameters.AddWithValue("@P_FINAL_REGIST_TIME", pdgVO.Final_Regist_Time);
cmd.Parameters.AddWithValue("@P_FINAL_REGIST_EMPLOYEE", pdgVO.Final_Regist_Employee);
cmd.Parameters.AddWithValue("@P_PRODUCT_SEQ", pdgVO.Product_Group_Seq);
cmd.Parameters.AddWithValue("@P_Category", pdgVO.Category);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
catch (Exception err)
{
throw err;
}
}
public bool UpsertGroup(ProductGroupVO pdgVO)
{
return(dac.UpsertGroup(pdgVO));
}
