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