public static clsChatLieu_DTO LayChatLieu(string maCL)
{
clsChatLieu_DTO ChatLieu = new clsChatLieu_DTO();
string query = string.Format("select * from ChatLieu where MaChatLieu = '{0}'", maCL);
SqlDataReader dr = DataProvider.Retrieve_Table(query);
if (dr.Read())
{
if (!dr.IsDBNull(0))
{
ChatLieu.MaChatLieu = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
ChatLieu.TenChatLieu = dr.GetString(1);
}
if (!dr.IsDBNull(2))
{
ChatLieu.TrangThai = dr.GetBoolean(2);
}
}
DataProvider.CloseConnect();
return(ChatLieu);
}
public static List <clsHoaDonBan_DTO> LayDSHDBan()
{
List <clsHoaDonBan_DTO> dsCT = new List <clsHoaDonBan_DTO>();
string query = "select * from ChiTietHDBan where TrangThai = 1";
SqlDataReader dr = DataProvider.Retrieve_Table(query);
while (dr.Read())
{
clsHoaDonBan_DTO ct = new clsHoaDonBan_DTO();
if (!dr.IsDBNull(0))
{
ct.MaHDBan = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
ct.MaNVLap = dr.GetString(1);
}
if (!dr.IsDBNull(2))
{
ct.NgayLapHD = dr.GetDateTime(2);
}
if (!dr.IsDBNull(3))
{
ct.ThanhTien = dr.GetInt32(3);
}
if (!dr.IsDBNull(4))
{
ct.TrangThai = dr.GetBoolean(4);
}
dsCT.Add(ct);
}
DataProvider.CloseConnect();
return(dsCT);
}
public static List <clsSize_DTO> Retrieve_Size(string condition)
{
List <clsSize_DTO> dsSize = new List <clsSize_DTO>();
string sql = @"select * from Size where trangthai = 1";
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
while (dr.Read())
{
clsSize_DTO size = new clsSize_DTO();
if (!dr.IsDBNull(0))
{
size.MaSize = (string)dr["MaSize"];
}
if (!dr.IsDBNull(1))
{
size.TenSize = (string)dr["TenSize"];
}
if (!dr.IsDBNull(2))
{
size.TrangThai = (Boolean)dr["TrangThai"];
}
dsSize.Add(size);
}
DataProvider.CloseConnect();
return(dsSize);
}
public static List <clsLoaiSanPham_DTO> Retrieve_LoaiSanPham()
{
List <clsLoaiSanPham_DTO> dsLSP = new List <clsLoaiSanPham_DTO>();
string sql = @"select * from LoaiSanPham";
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
while (dr.Read())
{
clsLoaiSanPham_DTO lsp = new clsLoaiSanPham_DTO();
if (!dr.IsDBNull(0))
{
lsp.MaLoaiSP = (string)dr["MaLoaiSP"];
}
if (!dr.IsDBNull(1))
{
lsp.TenLoaiSP = (string)dr["TenLoaiSP"];
}
if (!dr.IsDBNull(2))
{
lsp.TrangThai = (Boolean)dr["TrangThai"];
}
dsLSP.Add(lsp);
}
DataProvider.CloseConnect();
return(dsLSP);
}
public static List <clsChatLieu_DTO> LayDSChatLieu()
{
List <clsChatLieu_DTO> dsCL = new List <clsChatLieu_DTO>();
string query = "select * from ChatLieu";
SqlDataReader dr = DataProvider.Retrieve_Table(query);
while (dr.Read())
{
clsChatLieu_DTO ChatLieu = new clsChatLieu_DTO();
if (!dr.IsDBNull(0))
{
ChatLieu.MaChatLieu = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
ChatLieu.TenChatLieu = dr.GetString(1);
}
if (!dr.IsDBNull(2))
{
ChatLieu.TrangThai = dr.GetBoolean(2);
}
dsCL.Add(ChatLieu);
}
DataProvider.CloseConnect();
return(dsCL);
}
public static List <clsMau_DTO> Retrieve_Mau(string condition)
{
List <clsMau_DTO> dsMau = new List <clsMau_DTO>();
string sql = @"select * from Mau where trangthai = 1";
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
while (dr.Read())
{
clsMau_DTO mau = new clsMau_DTO();
if (!dr.IsDBNull(0))
{
mau.MaMau = (string)dr["MaMau"];
}
if (!dr.IsDBNull(1))
{
mau.TenMau = (string)dr["TenMau"];
}
if (!dr.IsDBNull(2))
{
mau.TrangThai = (Boolean)dr["TrangThai"];
}
dsMau.Add(mau);
}
DataProvider.CloseConnect();
return(dsMau);
}
public static bool ThemHDNhap(clsHoaDonNhap_DTO hd)
{
string query = string.Format("insert into HoaDonNhap(MaHdNhap, MaNVLap, NgayLapHD, TongTien, TrangThai) values('{0}', '{1}', '{2}',{3}, '{4}')", hd.MaHDNhap, hd.MaNVLap, hd.NgayLapHD, hd.TongTien, hd.TrangThai);
int kq = DataProvider.ExecuteInsertUpdateDelete(query);
DataProvider.CloseConnect();
return(kq == 1);
}
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);
}
public static int DemSLSanPham()
{
string query = "select count(*) from SanPham";
int kq = DataProvider.Retrieve_Count(query);
DataProvider.CloseConnect();
return(kq);
}
public static int LaySoLuongTonKho(string maCTSP)
{
string query = string.Format("select SoLuongTonKho from ChiTietSanPham where MaChiTietSP = '{0}'", maCTSP);
int kq = DataProvider.Retrieve_Count(query);
DataProvider.CloseConnect();
return(kq);
}
public static bool CapNhatSoLuong(string maCTSP, int SL)
{
string query = string.Format("update ChiTietSanPham set SoLuongTonKho = {0} where maChiTietSP = '{1}'", SL, maCTSP);
int kq = DataProvider.ExecuteInsertUpdateDelete(query);
DataProvider.CloseConnect();
return(kq == 1);
}
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);
}
public static bool CapNhatSanPham(clsSanPham_DTO sp)
{
string query = string.Format("update SanPham set TenSP = N'{0}', MaLoaiSP = '{1}', MaNhaSX = '{2}', NgayNhapKho ='{3}', GioiTinh = N'{4}', TrangThai = '{5}' where MaSP = '{6}'", sp.TenSP, sp.MaLoaiSP, sp.MaNhaSX, sp.NgayNhapKho, sp.GioiTinh, sp.TrangThai_SP, sp.MaSP);
int kq = DataProvider.ExecuteInsertUpdateDelete(query);
DataProvider.CloseConnect();
return(kq == 1);
}
public static bool ThemChiTietHDNhap(clsChiTietHDNhap_DTO cthd)
{
string query = string.Format("insert into ChiTietHDNhap(MaHDNhap, MaChiTietSP, DonGiaNhap, SoLuong, TrangThai) values('{0}', '{1}', {2}, {3} ,'{4}')", cthd.MaHDNhap, cthd.MaChiTietSP, cthd.DonGia, cthd.SoLuong, cthd.TrangThai);
int kq = DataProvider.ExecuteInsertUpdateDelete(query);
DataProvider.CloseConnect();
return(kq == 1);
}
public static bool ThemSanPham(clsSanPham_DTO sp)
{
string query = string.Format("insert into SanPham(MaSP, TenSP, MaLoaiSP, MaNhaSX, NgayNhapKho, GioiTinh, TrangThai) values('{0}',N'{1}','{2}','{3}','{4}',N'{5}','{6}')", sp.MaSP, sp.TenSP, sp.MaLoaiSP, sp.MaNhaSX, sp.NgayNhapKho, sp.GioiTinh, sp.TrangThai_SP);
int kq = DataProvider.ExecuteInsertUpdateDelete(query);
DataProvider.CloseConnect();
return(kq == 1);
}
public static bool CapNhatTrangThai(bool trangThai, string maSP, string maMau, string maChatLieu, string maSize)
{
string query = string.Format("update ChiTietSanPham set TrangThai = '{0}' where maSP = '{1}' and maMau = '{2}' and maChatLieu ='{3}' and maSize = '{4}'", trangThai, maSP, maMau, maChatLieu, maSize);
int kq = DataProvider.ExecuteInsertUpdateDelete(query);
DataProvider.CloseConnect();
return(kq == 1);
}
public static bool KtraDangNhap(string TenTaiKhoan, string MatKhau)
{
string query = string.Format("SELECT COUNT(*) FROM NhanVien WHERE TenTaiKhoan = '{0}' AND MatKhau = '{1}'", TenTaiKhoan, MatKhau);
bool kq = (DataProvider.Retrieve_Count(query) == 1);
DataProvider.CloseConnect();
return(kq);
}
public static int DemSLSanPham(string ten)
{
string query = "select count(*) from SanPham where TenSP = N'" + ten + "'";
int kq = DataProvider.Retrieve_Count(query);
DataProvider.CloseConnect();
return(kq);
}
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);
}
public static List <clsHoaDonNhap_DTO> LayDSHD(string maHD)
{
List <clsHoaDonNhap_DTO> dsHDNhap = new List <clsHoaDonNhap_DTO>();
string query = string.Format("select * from HoaDonNhap");
if (maHD != "")
{
query += string.Format(" where MaHDNhap = '{0}'", maHD);
}
SqlDataReader dr = DataProvider.Retrieve_Table(query);
while (dr.Read())
{
clsHoaDonNhap_DTO hd = new clsHoaDonNhap_DTO();
if (!dr.IsDBNull(0))
{
hd.MaHDNhap = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
hd.MaNVLap = dr.GetString(1);
}
if (!dr.IsDBNull(2))
{
hd.NgayLapHD = dr.GetDateTime(2);
}
if (!dr.IsDBNull(3))
{
hd.TongTien = dr.GetDecimal(3);
}
if (!dr.IsDBNull(4))
{
hd.TrangThai = dr.GetBoolean(4);
}
dsHDNhap.Add(hd);
}
DataProvider.CloseConnect();
return(dsHDNhap);
}
public static List <clsNhaSanXuat_DTO> LayDSNSX(string maNSX)
{
List <clsNhaSanXuat_DTO> dsNSX = new List <clsNhaSanXuat_DTO>();
string query = "select * from NhaSanXuat";
if (maNSX != "")
{
query += string.Format(" where MaNhaSx = '{0}'", maNSX);
}
SqlDataReader dr = DataProvider.Retrieve_Table(query);
while (dr.Read())
{
clsNhaSanXuat_DTO nsx = new clsNhaSanXuat_DTO();
if (!dr.IsDBNull(0))
{
nsx.MaNhaSX = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
nsx.TenNhaSX = dr.GetString(1);
}
if (!dr.IsDBNull(2))
{
nsx.DiaChi = dr.GetString(2);
}
if (!dr.IsDBNull(3))
{
nsx.Email = dr.GetString(3);
}
if (!dr.IsDBNull(4))
{
nsx.SDT = dr.GetString(4);
}
if (!dr.IsDBNull(5))
{
nsx.TrangThai = dr.GetBoolean(5);
}
dsNSX.Add(nsx);
}
DataProvider.CloseConnect();
return(dsNSX);
}
public static List <clsSanPham_DTO> LayDSSPTheoTen(string tenSP)
{
List <clsSanPham_DTO> dsSanPham = new List <clsSanPham_DTO>();
string sql = string.Format("SELECT * FROM SanPham WHERE TrangThai = 1 and TenSP Like N'%{0}%'", tenSP);
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
while (dr.Read())
{
clsSanPham_DTO sp = new clsSanPham_DTO();
if (!dr.IsDBNull(0))
{
sp.MaSP = (string)dr["MaSP"];
}
if (!dr.IsDBNull(1))
{
sp.TenSP = (string)dr["TenSP"];
}
if (!dr.IsDBNull(2))
{
sp.MaLoaiSP = (string)dr["MaLoaiSP"];
}
if (!dr.IsDBNull(3))
{
sp.MaNhaSX = (string)dr["MaNhaSX"];
}
if (!dr.IsDBNull(4))
{
sp.NgayNhapKho = (DateTime)dr["NgayNhapKho"];
}
if (!dr.IsDBNull(5))
{
sp.GioiTinh = (string)dr["GioiTinh"];
}
if (!dr.IsDBNull(6))
{
sp.TrangThai_SP = (bool)dr["TrangThai"];
}
dsSanPham.Add(sp);
}
DataProvider.CloseConnect();
return(dsSanPham);
}
// Retrieve table SanPham
public static List <clsSanPham_DTO> RetrieveTable_SanPham(List <string> condition)
{
List <clsSanPham_DTO> dsSanPham = new List <clsSanPham_DTO>();
string sql = @"SELECT * FROM SanPham WHERE TrangThai = 1";
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
while (dr.Read())
{
clsSanPham_DTO sp = new clsSanPham_DTO();
if (!dr.IsDBNull(0))
{
sp.MaSP = (string)dr["MaSP"];
}
if (!dr.IsDBNull(1))
{
sp.TenSP = (string)dr["TenSP"];
}
if (!dr.IsDBNull(2))
{
sp.MaLoaiSP = (string)dr["MaLoaiSP"];
}
if (!dr.IsDBNull(3))
{
sp.MaNhaSX = (string)dr["MaNhaSX"];
}
if (!dr.IsDBNull(4))
{
sp.NgayNhapKho = (DateTime)dr["NgayNhapKho"];
}
if (!dr.IsDBNull(5))
{
sp.GioiTinh = (string)dr["GioiTinh"];
}
if (!dr.IsDBNull(6))
{
sp.TrangThai_SP = (bool)dr["TrangThai"];
}
dsSanPham.Add(sp);
}
DataProvider.CloseConnect();
return(dsSanPham);
}
public static List <clsChiTietHDNhap_DTO> LayDSCTHDNhap(string maCTSP)
{
List <clsChiTietHDNhap_DTO> dsCTHD = new List <clsChiTietHDNhap_DTO>();
string query = "select * from ChiTietHDNhap ";
if (maCTSP != "")
{
query += string.Format(" where MaChiTietSP = '{0}'", maCTSP);
}
SqlDataReader dr = DataProvider.Retrieve_Table(query);
while (dr.Read())
{
clsChiTietHDNhap_DTO cthd = new clsChiTietHDNhap_DTO();
if (!dr.IsDBNull(0))
{
cthd.MaHDNhap = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
cthd.MaChiTietSP = dr.GetString(1);
}
if (!dr.IsDBNull(2))
{
cthd.DonGia = dr.GetInt32(2);
}
if (!dr.IsDBNull(3))
{
cthd.SoLuong = dr.GetInt32(3);
}
if (!dr.IsDBNull(4))
{
cthd.TrangThai = dr.GetBoolean(4);
}
dsCTHD.Add(cthd);
}
DataProvider.CloseConnect();
return(dsCTHD);
}
public static clsSanPham_DTO Retrieve_SanPham(string masp)
{
clsSanPham_DTO sp = null;
string sql = string.Format("SELECT * FROM SanPham WHERE MaSP = '{0}'", masp);
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
if (dr.Read())
{
sp = new clsSanPham_DTO();
if (!dr.IsDBNull(0))
{
sp.MaSP = (string)dr["MaSP"];
}
if (!dr.IsDBNull(1))
{
sp.TenSP = (string)dr["TenSP"];
}
if (!dr.IsDBNull(2))
{
sp.MaLoaiSP = (string)dr["MaLoaiSP"];
}
if (!dr.IsDBNull(3))
{
sp.MaNhaSX = (string)dr["MaNhaSX"];
}
if (!dr.IsDBNull(4))
{
sp.NgayNhapKho = (DateTime)dr["NgayNhapKho"];
}
if (!dr.IsDBNull(5))
{
sp.GioiTinh = (string)dr["GioiTinh"];
}
if (!dr.IsDBNull(6))
{
sp.TrangThai_SP = (bool)dr["TrangThai"];
}
}
DataProvider.CloseConnect();
return(sp);
}
public static clsSize_DTO LaySize(string maSize)
{
clsSize_DTO size = new clsSize_DTO();
string sql = string.Format("select * from Size where trangthai = 1 and MaSize = '{0}'", maSize);
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
if (dr.Read())
{
if (!dr.IsDBNull(0))
{
size.MaSize = (string)dr["MaSize"];
}
if (!dr.IsDBNull(1))
{
size.TenSize = (string)dr["TenSize"];
}
if (!dr.IsDBNull(2))
{
size.TrangThai = (Boolean)dr["TrangThai"];
}
}
DataProvider.CloseConnect();
return(size);
}
public static clsMau_DTO LayMau(string maMau)
{
clsMau_DTO mau = new clsMau_DTO();
string sql = string.Format("select * from Mau where MaMau = '{0}'", maMau);
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
if (dr.Read())
{
if (!dr.IsDBNull(0))
{
mau.MaMau = (string)dr["MaMau"];
}
if (!dr.IsDBNull(1))
{
mau.TenMau = (string)dr["TenMau"];
}
if (!dr.IsDBNull(2))
{
mau.TrangThai = (Boolean)dr["TrangThai"];
}
}
DataProvider.CloseConnect();
return(mau);
}
public static clsLoaiSanPham_DTO Retrieve_LoaiSanPham(string maLoai)
{
clsLoaiSanPham_DTO lsp = new clsLoaiSanPham_DTO();
string sql = string.Format("select * from LoaiSanPham where MaLoaiSP = '{0}'", maLoai);
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
if (dr.Read())
{
if (!dr.IsDBNull(0))
{
lsp.MaLoaiSP = (string)dr["MaLoaiSP"];
}
if (!dr.IsDBNull(1))
{
lsp.TenLoaiSP = (string)dr["TenLoaiSP"];
}
if (!dr.IsDBNull(2))
{
lsp.TrangThai = (Boolean)dr["TrangThai"];
}
}
DataProvider.CloseConnect();
return(lsp);
}
public static clsNhanVien_DTO LayThongTinNV(string Username)
{
clsNhanVien_DTO nv = new clsNhanVien_DTO();
string query = string.Format("SELECT * FROM NhanVien WHERE TrangThai = 1 AND TenTaiKhoan = '{0}'", Username);
SqlDataReader dr = DataProvider.Retrieve_Table(query);
if (dr.Read())
{
if (!dr.IsDBNull(0))
{
nv.MaNV = (string)dr["MaNV"];
}
if (!dr.IsDBNull(1))
{
nv.HoTen = (string)dr["HoTen"];
}
if (!dr.IsDBNull(2))
{
nv.DiaChi = (string)dr["DiaChi"];
}
if (!dr.IsDBNull(3))
{
nv.NgaySinh = (DateTime)dr["NgaySinh"];
}
if (!dr.IsDBNull(4))
{
nv.SDT = (string)dr["SDT"];
}
if (!dr.IsDBNull(5))
{
nv.Email = (string)dr["Email"];
}
if (!dr.IsDBNull(6))
{
nv.Luong = (decimal)dr[6];
}
if (!dr.IsDBNull(7))
{
nv.CMND = (string)dr["CMND"];
}
if (!dr.IsDBNull(8))
{
nv.AnhDaiDien = (string)dr["AnhDaiDien"];
}
if (!dr.IsDBNull(9))
{
nv.ChucVu = (string)dr[9];
}
if (!dr.IsDBNull(10))
{
nv.TenTaiKhoan = (string)dr[10];
}
if (!dr.IsDBNull(11))
{
nv.MatKhau = (string)dr[11];
}
if (!dr.IsDBNull(12))
{
nv.TrangThai_NV = dr.GetBoolean(12);
}
}
DataProvider.CloseConnect();
return(nv);
}
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);
}
