Esempio n. 1
0
        public static bool CapNhatCTSP(clsChiTietSanPham_DTO ctsp)
        {
            string query = string.Format("update ChiTietSanPham set HinhAnh = '{0}', GiaBan = {1}, TrangThai = '{2}' where MaSP = '{3}' and MaMau = '{4}' and MaChatLieu = '{5}' and MaSize = '{6}'", ctsp.HinhAnh, ctsp.GiaTien, ctsp.TrangThai, ctsp.MaSP, ctsp.MaMau, ctsp.MaChatLieu, ctsp.MaSize);
            int    kq    = DataProvider.ExecuteInsertUpdateDelete(query);

            DataProvider.CloseConnect();
            return(kq == 1);
        }
Esempio n. 2
0
        public static bool ThemChiTietSP(clsChiTietSanPham_DTO ctsp)
        {
            string query = string.Format("insert into ChiTietSanPham(MaChiTietSP, MaSP, MaMau, MaChatLieu, MaSize, HinhAnh, SoLuongTonKho, GiaBan, TrangThai) values('{8}', '{0}','{1}', '{2}', '{3}', '{4}', {5}, {6}, '{7}')", ctsp.MaSP, ctsp.MaMau, ctsp.MaChatLieu, ctsp.MaSize, ctsp.HinhAnh, ctsp.SoLuongTonKho, ctsp.GiaTien, ctsp.TrangThai, ctsp.MaChiTietSP);
            int    kq    = DataProvider.ExecuteInsertUpdateDelete(query);

            DataProvider.CloseConnect();
            return(kq == 1);
        }
Esempio n. 3
0
        public static List <clsChiTietSanPham_DTO> LayDSCTSPTheoMaSP(string maSP)
        {
            List <clsChiTietSanPham_DTO> dsCtsp = new List <clsChiTietSanPham_DTO>();
            string        query = string.Format("select * from ChiTietSanPham where trangthai = 1  and MaSP = '{0}'", maSP);
            SqlDataReader dr    = DataProvider.Retrieve_Table(query);

            while (dr.Read())
            {
                clsChiTietSanPham_DTO ctsp = new clsChiTietSanPham_DTO();
                if (!dr.IsDBNull(0))
                {
                    ctsp.MaChiTietSP = (string)dr["MaChiTietSP"];
                }
                if (!dr.IsDBNull(1))
                {
                    ctsp.MaSP = (string)dr["MaSP"];
                }

                if (!dr.IsDBNull(2))
                {
                    ctsp.MaMau = (string)dr["MaMau"];
                }
                if (!dr.IsDBNull(3))
                {
                    ctsp.MaChatLieu = (string)dr["MaChatLieu"];
                }
                if (!dr.IsDBNull(4))
                {
                    ctsp.MaSize = (string)dr["MaSize"];
                }
                if (!dr.IsDBNull(5))
                {
                    ctsp.HinhAnh = (string)dr["HinhAnh"];
                }
                if (!dr.IsDBNull(6))
                {
                    ctsp.SoLuongTonKho = (int)dr["SoLuongTonKho"];
                }
                if (!dr.IsDBNull(7))
                {
                    ctsp.GiaTien = dr.GetInt32(7);
                }
                if (!dr.IsDBNull(8))
                {
                    ctsp.TrangThai = (Boolean)dr["TrangThai"];
                }
                dsCtsp.Add(ctsp);
            }


            DataProvider.CloseConnect();

            return(dsCtsp);
        }
Esempio n. 4
0
        void getData(clsChiTietHDNhap_DTO cthd, clsChiTietSanPham_DTO ctsp, clsSanPham_DTO sp, int i)
        {
            sp.TenSP = dgvHoaDonNhap.Rows[i].Cells["colTen"].Value.ToString();
            int n = clsSanPham_BUS.DemSLSanPham(sp.TenSP);

            if (n == 0)
            {
                sp.MaSP = autoID_SP();
            }
            else
            {
                List <clsSanPham_DTO> SP = clsSanPham_BUS.LayDSSPTheoTen(sp.TenSP);
                sp.MaSP = SP[0].MaSP;
            }
            sp.MaLoaiSP     = dgvHoaDonNhap.Rows[i].Cells["colLoaiSP"].Value.ToString();
            sp.MaNhaSX      = dgvHoaDonNhap.Rows[i].Cells["colTenNSX"].Value.ToString();
            sp.NgayNhapKho  = DateTime.Now;
            sp.GioiTinh     = dgvHoaDonNhap.Rows[i].Cells["colGioiTinh"].Value.ToString();
            sp.TrangThai_SP = true;


            ctsp.MaSP       = sp.MaSP;
            ctsp.MaMau      = dgvHoaDonNhap.Rows[i].Cells["colMaMau"].Value.ToString();
            ctsp.MaChatLieu = dgvHoaDonNhap.Rows[i].Cells["colMaChatLieu"].Value.ToString();
            ctsp.MaSize     = dgvHoaDonNhap.Rows[i].Cells["colMaSize"].Value.ToString();

            n = clsChiTietSanPham_BUS.Retrieve_ChiTietSanPham(ctsp.MaSP, ctsp.MaMau, ctsp.MaChatLieu, ctsp.MaSize).Count;
            if (n == 0)
            {
                ctsp.MaChiTietSP = autoID_CTSP();
            }
            else
            {
                List <clsChiTietSanPham_DTO> CT = clsChiTietSanPham_BUS.Retrieve_ChiTietSanPham(ctsp.MaSP, ctsp.MaMau, ctsp.MaChatLieu, ctsp.MaSize);
                ctsp.MaChiTietSP = CT[0].MaChiTietSP;
            }

            ctsp.GiaTien       = Convert.ToInt32(dgvHoaDonNhap.Rows[i].Cells["colGiaBan"].Value.ToString());
            ctsp.HinhAnh       = "Data\\AnhDaiDien\\" + ofdHinh.SafeFileName;
            ctsp.SoLuongTonKho = Program.convertToInt(dgvHoaDonNhap.Rows[i].Cells["colSoLuong"].Value.ToString());
            ctsp.TrangThai     = true;

            cthd.MaChiTietSP = ctsp.MaChiTietSP;
            cthd.DonGia      = Program.convertToInt(dgvHoaDonNhap.Rows[i].Cells["colGiaNhap"].Value.ToString());
            cthd.SoLuong     = ctsp.SoLuongTonKho;
            cthd.TrangThai   = true;
        }
Esempio n. 5
0
        private void btnSua_Click(object sender, EventArgs e)
        {
            clsSanPham_DTO        sp   = new clsSanPham_DTO();
            clsChiTietSanPham_DTO ctsp = new clsChiTietSanPham_DTO();

            getData(ctsp, sp);
            if (clsSanPham_BUS.CapNhatSanPham(sp))
            {
                if (clsChiTietSanPham_BUS.CapNhatCTSP(ctsp))
                {
                    MessageBox.Show("Cập nhật thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    List <clsChiTietSanPham_DTO> dsSP = clsChiTietSanPham_BUS.Retrieve_ChiTietSanPham("", "", "", "", false, 0, 0, 0, "");

                    dgvSanPham.AutoGenerateColumns = false;
                    dgvSanPham.DataSource          = dsSP;
                    resetControl();
                }
            }
        }
Esempio n. 6
0
        void getData(clsChiTietSanPham_DTO ctsp, clsSanPham_DTO sp)
        {
            ctsp.MaSP          = lblMa.Text;
            ctsp.MaMau         = cboMau.SelectedValue.ToString();
            ctsp.MaChatLieu    = cboChatLieu.SelectedValue.ToString();
            ctsp.MaSize        = cboSize.SelectedValue.ToString();
            ctsp.HinhAnh       = lblDuongDan.Text;
            ctsp.SoLuongTonKho = Program.convertToInt(lblSLTK.Text);
            ctsp.TrangThai     = true;

            sp.MaSP = ctsp.MaSP;
            clsSanPham_DTO SP = clsSanPham_BUS.Retrieve_SanPham(sp.MaSP);

            sp.NgayNhapKho  = SP.NgayNhapKho;
            sp.MaLoaiSP     = cboLoai.SelectedValue.ToString();
            sp.TenSP        = txtTenHang.Text;
            sp.MaNhaSX      = cboNSX.SelectedValue.ToString();
            sp.GioiTinh     = radNam.Checked ? "Nam" : "Nữ";
            sp.TrangThai_SP = true;
        }
Esempio n. 7
0
 public static bool CapNhatCTSP(clsChiTietSanPham_DTO ctsp)
 {
     return(clsChiTietSanPham_DAO.CapNhatCTSP(ctsp));
 }
Esempio n. 8
0
 public static bool ThemChiTietSP(clsChiTietSanPham_DTO ctsp)
 {
     return(clsChiTietSanPham_DAO.ThemChiTietSP(ctsp));
 }
Esempio n. 9
0
        public static List <clsChiTietSanPham_DTO> Retrieve_ChiTietSanPham(string tenSP, string maMau, string maCL, string maSize, bool lonHon, int soLuong, int giaBanMin, int giaBanMax, string loaiSP)
        {
            List <clsChiTietSanPham_DTO> dsChiTietSP = new List <clsChiTietSanPham_DTO>();

            string sql = @"select * from ChiTietSanPham, SanPham where ChiTietSanPham.trangthai = 1 and ChiTietSanPham.MaSP = SanPham.MaSP";

            if (tenSP != "")
            {
                sql += string.Format(" and TenSP Like N'%{0}%'", tenSP);
            }

            if (maMau != "")
            {
                sql += string.Format(" and MaMau = '{0}'", maMau);
            }
            if (maCL != "")
            {
                sql += string.Format(" and MaChatLieu = '{0}'", maCL);
            }
            if (maSize != "")
            {
                sql += string.Format(" and maSize = '{0}'", maSize);
            }
            if (soLuong > 0)
            {
                if (lonHon)
                {
                    sql += string.Format(" and SoLuongTonKho >= {0}", soLuong);
                }
                else
                {
                    sql += string.Format(" and SoLuongTonKho <= {0}", soLuong);
                }
            }

            if (giaBanMin > 0)
            {
                sql += string.Format(" and GiaBan >= {0}", giaBanMin);
            }

            if (giaBanMax > 0)
            {
                sql += string.Format(" and GiaBan <= {0}", giaBanMax);
            }

            if (loaiSP != "")
            {
                sql += string.Format(" and MaLoaiSP = '{0}'", loaiSP);
            }


            SqlDataReader dr = DataProvider.Retrieve_Table(sql);

            while (dr.Read())
            {
                clsChiTietSanPham_DTO ctsp = new clsChiTietSanPham_DTO();

                if (!dr.IsDBNull(0))
                {
                    ctsp.MaChiTietSP = (string)dr["MaChiTietSP"];
                }
                if (!dr.IsDBNull(1))
                {
                    ctsp.MaSP = (string)dr["MaSP"];
                }

                if (!dr.IsDBNull(2))
                {
                    ctsp.MaMau = (string)dr["MaMau"];
                }
                if (!dr.IsDBNull(3))
                {
                    ctsp.MaChatLieu = (string)dr["MaChatLieu"];
                }
                if (!dr.IsDBNull(4))
                {
                    ctsp.MaSize = (string)dr["MaSize"];
                }
                if (!dr.IsDBNull(5))
                {
                    ctsp.HinhAnh = (string)dr["HinhAnh"];
                }
                if (!dr.IsDBNull(6))
                {
                    ctsp.SoLuongTonKho = (int)dr["SoLuongTonKho"];
                }
                if (!dr.IsDBNull(7))
                {
                    ctsp.GiaTien = dr.GetInt32(7);
                }
                if (!dr.IsDBNull(8))
                {
                    ctsp.TrangThai = (Boolean)dr["TrangThai"];
                }
                dsChiTietSP.Add(ctsp);
            }
            DataProvider.CloseConnect();
            return(dsChiTietSP);
        }
Esempio n. 10
0
        private void btnXacNhan_Click(object sender, EventArgs e)
        {
            bool              check = true;
            string            maHD  = autoID_HDNhap();
            int               n     = dgvHoaDonNhap.Rows.Count;
            clsHoaDonNhap_DTO hd    = new clsHoaDonNhap_DTO();

            hd.MaHDNhap  = maHD;
            hd.MaNVLap   = Program.NV_Login.MaNV;
            hd.NgayLapHD = DateTime.Now;
            hd.TrangThai = true;
            hd.TongTien  = Program.convertToInt(lblTongTien.Text.Substring(0, lblTongTien.Text.Length - 4));
            if (clsHoaDonNhap_BUS.ThemHDNhap(hd))
            {
                for (int i = 0; i < n; i++)
                {
                    clsChiTietHDNhap_DTO  cthd = new clsChiTietHDNhap_DTO();
                    clsChiTietSanPham_DTO ctsp = new clsChiTietSanPham_DTO();
                    clsSanPham_DTO        sp   = new clsSanPham_DTO();
                    getData(cthd, ctsp, sp, i);
                    cthd.MaHDNhap = hd.MaHDNhap;
                    List <clsChiTietSanPham_DTO> ct = clsChiTietSanPham_BUS.Retrieve_ChiTietSanPham(sp.MaSP, ctsp.MaMau, ctsp.MaChatLieu, ctsp.MaSize);
                    if (ct.Count > 0)
                    {
                        if (ct[0].MaSP != null)
                        {
                            if (clsChiTietSanPham_BUS.CapNhatSoLuong(ctsp.MaChiTietSP, cthd.SoLuong) && clsChiTietHDNhap_BUS.ThemChiTietHDNhap(cthd))
                            {
                                MessageBox.Show("Thêm số lượng thành công");
                            }
                            else
                            {
                                check = false;
                                break;
                            }
                        }
                    }
                    else if (clsSanPham_BUS.DemSLSanPham(dgvHoaDonNhap.Rows[i].Cells["colTen"].Value.ToString()) > 0)
                    {
                        if (clsSanPham_BUS.Retrieve_SanPham(sp.MaSP).MaSP != null)
                        {
                            if (clsChiTietSanPham_BUS.ThemChiTietSP(ctsp) && clsChiTietHDNhap_BUS.ThemChiTietHDNhap(cthd))
                            {
                                MessageBox.Show("Thêm mẫu mã thành công");
                            }
                            else
                            {
                                check = false;
                                break;
                            }
                        }
                    }

                    else if (clsSanPham_BUS.ThemSanPham(sp) && clsChiTietSanPham_BUS.ThemChiTietSP(ctsp) && clsChiTietHDNhap_BUS.ThemChiTietHDNhap(cthd))
                    {
                        MessageBox.Show("Thêm sản phẩm mới thành công");
                    }
                    else
                    {
                        check = false;
                    }
                }

                if (!check)
                {
                    MessageBox.Show("Thất bại");
                }
                else
                {
                    while (dgvHoaDonNhap.Rows.Count > 0)
                    {
                        dgvHoaDonNhap.Rows.Remove(dgvHoaDonNhap.Rows[0]);
                    }
                }
            }
            else
            {
                MessageBox.Show("Không thể tạo hóa đơn");
            }

            lblTongTien.Text = "0 VNĐ";
        }