public static List <KhachHangDTO> LayDanhSachKhachHang() { List <KhachHangDTO> lkh = new List <KhachHangDTO>(); try { SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachKhachHang"); while (reader.Read()) { KhachHangDTO kh = new KhachHangDTO(); kh.MaKH = reader.GetString(0); kh.HoTen = reader.GetString(1); kh.NgaySinh = reader.GetDateTime(2); kh.Cmnd = reader.GetString(3); kh.Sdt = reader.GetString(4); kh.DiaChi = reader.GetString(5); kh.NgayDK = reader.GetDateTime(6); kh.Loai = reader.GetString(7); kh.DoanhSo = (uint)reader.GetDecimal(8); lkh.Add(kh); } reader.Close(); } catch { } return(lkh); }
public static List <HoaDonDTO> LayDanhSachHoaDon() { List <HoaDonDTO> lhd = new List <HoaDonDTO>(); try { SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachHoaDon"); while (reader.Read()) { HoaDonDTO hd = new HoaDonDTO(); hd.SoHD = reader.GetInt32(0); hd.MaKH = reader.GetString(1); hd.MaNV = reader.GetString(2); hd.NgayHoaDon = reader.GetDateTime(3); hd.TriGia = (int)reader.GetDecimal(4); lhd.Add(hd); } reader.Close(); } catch { } return(lhd); }
public static List <string> LayDanhSachMaSP() { SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachMaSP"); List <string> dssp = new List <string>(); while (reader.Read()) { string sp = reader.GetString(0); dssp.Add(sp); } reader.Close(); return(dssp); }
public static List <DanhMucDTO> LayDanhMuc() { SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachDanhMuc"); List <DanhMucDTO> danhmuc = new List <DanhMucDTO>(); while (reader.Read()) { DanhMucDTO d = new DanhMucDTO(); d.MaDanhMuc = reader.GetString(0); d.TenDanhMuc = reader.GetString(1); danhmuc.Add(d); } reader.Close(); return(danhmuc); }
public static List <TaiKhoanDTO> LayMaNVChuaTaoTK() { SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayMaNVChuaTaoTK"); List <TaiKhoanDTO> ltk = new List <TaiKhoanDTO>(); while (reader.Read()) { TaiKhoanDTO tk = new TaiKhoanDTO(); tk.id = "1"; tk.pass = "******"; tk.manv = reader.GetString(0); tk.chucvu = reader.GetString(1); ltk.Add(tk); } reader.Close(); return(ltk); }
public static List <TaiKhoanDTO> LayDanhSachTaiKhoan() { SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachTaiKhoan"); List <TaiKhoanDTO> ltk = new List <TaiKhoanDTO>(); while (reader.Read()) { TaiKhoanDTO tk = new TaiKhoanDTO(); tk.id = reader.GetString(0); tk.pass = reader.GetString(1); tk.manv = reader.GetString(2); tk.chucvu = reader.GetString(3); ltk.Add(tk); } reader.Close(); return(ltk); }
public static List <SanPhamDTO> LayDanhSachSanPham() { SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayToanBoSanPham"); List <SanPhamDTO> lsp = new List <SanPhamDTO>(); while (reader.Read()) { SanPhamDTO sp = new SanPhamDTO(); sp.MaSP = reader.GetString(0); sp.TenSP = reader.GetString(1); sp.TenDanhMuc = reader.GetString(2); sp.TenLoaiSP = reader.GetString(3); sp.XuatXu = reader.GetString(4); sp.DonViTinh = reader.GetString(5); sp.GiaBan = (int)reader.GetDecimal(6); sp.SoLuong = reader.GetInt32(7); lsp.Add(sp); } reader.Close(); return(lsp); }
public static List <NhanVienDTO> LayDanhSachNhanVien() { SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachNhanVien"); List <NhanVienDTO> lnv = new List <NhanVienDTO>(); while (reader.Read()) { NhanVienDTO nv = new NhanVienDTO(); nv.MaNV = reader.GetString(0); nv.HoTen = reader.GetString(1); nv.NgaySinh = reader.GetDateTime(2); nv.NgayVaoLam = reader.GetDateTime(3); nv.SDT = reader.GetString(4); nv.DiaChi = reader.GetString(5); nv.ChucVu = reader.GetString(6); nv.CMND = reader.GetString(7); nv.Anh = (byte[])reader.GetValue(8); lnv.Add(nv); } reader.Close(); return(lnv); }