Exemplo n.º 1
0
        private void btnThem_Click(object sender, EventArgs e)
        {
            SanPhamBus    bussp = new SanPhamBus();
            SanPhamEntity sp    = new SanPhamEntity();
            KetNoiCSDL    con   = new KetNoiCSDL();

            try
            {
                sp.MaSP    = con.SinhMa("SANPHAM", "SP");
                sp.TenSP   = txtTenSP.Text;
                sp.SoLuong = int.Parse(txtSoLuong.Text);
                sp.GiaBan  = int.Parse(txtGiaBan.Text);
                sp.GiaNhap = int.Parse(txtGiaNhap.Text);
                sp.MaLH    = cboLoaiHang.SelectedValue.ToString();
                sp.NhaCC   = cboNhaCC.SelectedValue.ToString();
                sp.NSX     = dtNgaySX.Value.ToString();
                sp.MoTa    = rtbMoTa.Text;
                sp.HinhAnh = null;
                bussp.ThemSanPham(sp);
                MessageBox.Show("Nhập hàng thành công", "Thông báo");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemplo n.º 2
0
        public void XoaNhanVien(SanPhamEntity nv)
        {
            KetNoiCSDL.MoKetNoi();
            string     sql = @"DELETE SANPHAM WHERE MaSP=@MaSP";
            SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);

            cmd.Parameters.AddWithValue("@MaSP", nv.MaSP);
            cmd.ExecuteNonQuery();
            KetNoiCSDL.DongKetNoi();
        }
Exemplo n.º 3
0
        public void ThemSanPham(SanPhamEntity nv)
        {
            KetNoiCSDL.MoKetNoi();
            string     sql = "INSERT INTO SANPHAM(MaSP, TenSP,MaLH,SoLuong,GiaNhap,GiaBan,MoTa,NSX,NhaCC) VALUES(@MaSP,@TenSP,@MaLH,@SoLuong,@GiaNhap,@GiaBan,@MoTa,@NSX,@NhaCC)";
            SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);

            // cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@MaSP", nv.MaSP);
            cmd.Parameters.AddWithValue("@TenSP", nv.TenSP);
            cmd.Parameters.AddWithValue("@MaLH", nv.MaLH);
            cmd.Parameters.AddWithValue("@SoLuong", nv.SoLuong);
            cmd.Parameters.AddWithValue("@GiaNhap", nv.GiaNhap);
            cmd.Parameters.AddWithValue("@GiaBan", nv.GiaBan);
            cmd.Parameters.AddWithValue("@MoTa", nv.MoTa);
            cmd.Parameters.AddWithValue("@NSX", nv.NSX);

            cmd.Parameters.AddWithValue("@NhaCC", nv.NhaCC);
            cmd.ExecuteNonQuery();
            KetNoiCSDL.DongKetNoi();
        }
Exemplo n.º 4
0
        public void SuaSanPham(SanPhamEntity nv)
        {
            KetNoiCSDL.MoKetNoi();
            string sql = "UPDATE SANPHAM SET  TenSP=@TenSP, MaLH =@MaLH, SoLuong =@SoLuong, GiaNhap =@GiaNhap, GiaBan =@GiaBan, MoTa =@MoTa,NSX=@NSX,NhaCC=@NhaCC Where MaSP=@MaSP";

            SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);

            //cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@TenSP", nv.TenSP);
            cmd.Parameters.AddWithValue("@MaLH", nv.MaLH);
            cmd.Parameters.AddWithValue("@SoLuong", nv.SoLuong);
            cmd.Parameters.AddWithValue("@GiaNHap", nv.GiaNhap);
            cmd.Parameters.AddWithValue("@GiaBan", nv.GiaBan);
            cmd.Parameters.AddWithValue("@MoTa", nv.MoTa);
            cmd.Parameters.AddWithValue("@NSX", nv.NSX);

            cmd.Parameters.AddWithValue("@NhaCC", nv.NhaCC);
            cmd.ExecuteNonQuery();

            KetNoiCSDL.DongKetNoi();
        }