예제 #1
0
        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();
                }
            }
        }
예제 #2
0
        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();
            }
        }
예제 #3
0
        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 = "등록";
            }
        }
예제 #4
0
        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;
            }
        }
예제 #5
0
 public bool UpsertGroup(ProductGroupVO pdgVO)
 {
     return(dac.UpsertGroup(pdgVO));
 }