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