/////////////////////////// // Lấy danh sách KHÁCH HÀNG /////////////////////////// public List <Customer> GetCustomer(string sql) { List <Customer> list = new List <Customer>(); string MaKH, HoTen, NgaySinh, GioiTinh, DiaChi; int SDT; dp.Connect(); try { SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { MaKH = dr.GetString(0); HoTen = dr.GetString(1); NgaySinh = dr.GetString(2); GioiTinh = dr.GetString(3); SDT = dr.GetInt32(4); DiaChi = dr.GetString(5); Customer cus = new Customer(MaKH, HoTen, NgaySinh, GioiTinh, SDT, DiaChi); list.Add(cus); } return(list); } catch (Exception ex) { throw ex; } finally { dp.Disconnect(); } }
public static List <ChiTietPhieuXuatDTO> SelectChiTietPhieuXuatAll() { DataTable dataTable = DataProvider.ExecuteReader("usp_SelectChiTietPhieuXuatAll"); List <ChiTietPhieuXuatDTO> listChiTietPhieuXuatDTO = new List <ChiTietPhieuXuatDTO>(); if (dataTable.Rows.Count > 0) { foreach (DataRow dataRow in dataTable.Rows) { ChiTietPhieuXuatDTO chiTietPhieuXuatDTO = new ChiTietPhieuXuatDTO(); chiTietPhieuXuatDTO.MaChiTietPhieuXuat = dataRow["MaChiTietPhieuXuat"].ToString(); chiTietPhieuXuatDTO.MaPhieuXuat = dataRow["MaPhieuXuat"].ToString(); chiTietPhieuXuatDTO.MaSanPham = dataRow["MaSanPham"].ToString(); chiTietPhieuXuatDTO.CV = Int32.Parse(dataRow["CV"].ToString()); chiTietPhieuXuatDTO.DonGia = Int32.Parse(dataRow["DonGia"].ToString()); chiTietPhieuXuatDTO.SoLuong = Int32.Parse(dataRow["SoLuong"].ToString()); chiTietPhieuXuatDTO.ThanhTien = Int32.Parse(dataRow["ThanhTien"].ToString()); listChiTietPhieuXuatDTO.Add(chiTietPhieuXuatDTO); } } else { listChiTietPhieuXuatDTO = null; } return(listChiTietPhieuXuatDTO); }
public static ChiTietPhieuXuatDTO SelectChiTietPhieuXuatById(string MaChiTietPhieuXuat) { List <SqlParameter> sqlParamas = new List <SqlParameter>(); sqlParamas.Add(new SqlParameter("@MaChiTietPhieuXuat", MaChiTietPhieuXuat)); DataTable dataTable = DataProvider.ExecuteReader("usp_SelectChiTietPhieuXuatById", sqlParamas); ChiTietPhieuXuatDTO chiTietPhieuXuatDTO = new ChiTietPhieuXuatDTO(); if (dataTable.Rows.Count > 0) { DataRow dataRow = dataTable.Rows[0]; chiTietPhieuXuatDTO.MaChiTietPhieuXuat = dataRow["MaChiTietPhieuXuat"].ToString(); chiTietPhieuXuatDTO.MaPhieuXuat = dataRow["MaPhieuXuat"].ToString(); chiTietPhieuXuatDTO.MaSanPham = dataRow["MaSanPham"].ToString(); chiTietPhieuXuatDTO.CV = Int32.Parse(dataRow["CV"].ToString()); chiTietPhieuXuatDTO.DonGia = Int32.Parse(dataRow["DonGia"].ToString()); chiTietPhieuXuatDTO.SoLuong = Int32.Parse(dataRow["SoLuong"].ToString()); } else { chiTietPhieuXuatDTO = null; } return(chiTietPhieuXuatDTO); }
public static ThanhVienDTO SelectThanhVienById(string MaThanhVien) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@MaThanhVien", MaThanhVien)); DataTable dataTable = new DataTable(); dataTable = DataProvider.ExecuteReader("usp_SelectThanhVienById", sqlParams); ThanhVienDTO tvDTO = new ThanhVienDTO(); //List<ThanhVienDTO> lsttvDTO = new List<ThanhVienDTO>(); if (dataTable.Rows.Count > 0) { DataRow dtRow = dataTable.Rows[0]; tvDTO.MaThanhVien = dtRow["MaThanhVien"].ToString(); tvDTO.TenThanhVien = dtRow["TenThanhVien"].ToString(); tvDTO.CV = int.Parse(dtRow["CV"].ToString()); tvDTO.DiaChi = dtRow["DiaChi"].ToString(); tvDTO.TienNo = float.Parse(dtRow["TienNo"].ToString()); //lsttvDTO.Add(tvDTO); } else { tvDTO = null; } return(tvDTO); }
public static List <ChiTietPhieuXuatDTO> SelectChiTietPhieuXuatByMaPhieuXuat(string MaPhieuXuat) { List <SqlParameter> sqlParamas = new List <SqlParameter>(); sqlParamas.Add(new SqlParameter("@MaPhieuXuat", MaPhieuXuat)); DataTable dataTable = new DataTable(); dataTable = DataProvider.ExecuteReader("usp_SelectChiTietPhieuXuatByMaPhieuXuat", sqlParamas); List <ChiTietPhieuXuatDTO> listChiTietPhieuXuatDTO = new List <ChiTietPhieuXuatDTO>(); if (dataTable.Rows.Count > 0) { foreach (DataRow dataRow in dataTable.Rows) { ChiTietPhieuXuatDTO chiTietPhieuXuatDTO = new ChiTietPhieuXuatDTO(); chiTietPhieuXuatDTO.MaChiTietPhieuXuat = dataRow["MaChiTietPhieuXuat"].ToString(); chiTietPhieuXuatDTO.MaPhieuXuat = dataRow["MaPhieuXuat"].ToString(); chiTietPhieuXuatDTO.MaSanPham = dataRow["MaSanPham"].ToString(); chiTietPhieuXuatDTO.CV = Int32.Parse(dataRow["CV"].ToString()); chiTietPhieuXuatDTO.DonGia = Int32.Parse(dataRow["DonGia"].ToString()); chiTietPhieuXuatDTO.SoLuong = Int32.Parse(dataRow["SoLuong"].ToString()); chiTietPhieuXuatDTO.ThanhTien = Int32.Parse(dataRow["ThanhTien"].ToString()); listChiTietPhieuXuatDTO.Add(chiTietPhieuXuatDTO); } } else { listChiTietPhieuXuatDTO = null; } return(listChiTietPhieuXuatDTO); }
public static PhieuXuatDTO SelectPhieuXuatById(string MaPhieuXuat) { List <SqlParameter> sqlParamas = new List <SqlParameter>(); sqlParamas.Add(new SqlParameter("@MaPhieuXuat", MaPhieuXuat)); DataTable dataTable = DataProvider.ExecuteReader("usp_SelectPhieuXuatById", sqlParamas); PhieuXuatDTO phieuXuatDTO = new PhieuXuatDTO(); if (dataTable.Rows.Count > 0) { DataRow dataRow = dataTable.Rows[0]; phieuXuatDTO.MaPhieuXuat = dataRow["MaPhieuXuat"].ToString(); phieuXuatDTO.NgayBan = DateTime.Parse(dataRow["NgayBan"].ToString()); phieuXuatDTO.MaThanhVien = dataRow["MaThanhVien"].ToString(); phieuXuatDTO.MaNhanVien = dataRow["MaNhanVien"].ToString(); phieuXuatDTO.TenKhachHang = dataRow["TenKhachHang"].ToString(); phieuXuatDTO.DiaChi = dataRow["DiaChi"].ToString(); phieuXuatDTO.MaLoaiPhieuXuat = dataRow["MaLoaiPhieuXuat"].ToString(); } else { phieuXuatDTO = null; } return(phieuXuatDTO); }
public static List <ThanhVienDTO> SelectThanhVienAll() { DataTable dataTable = new DataTable(); dataTable = DataProvider.ExecuteReader("usp_SelectThanhVienAll"); List <ThanhVienDTO> lsttvDTO = new List <ThanhVienDTO>(); if (dataTable.Rows.Count > 0) { foreach (DataRow dtRow in dataTable.Rows) { ThanhVienDTO tvDTO = new ThanhVienDTO(); tvDTO.MaThanhVien = dtRow["MaThanhVien"].ToString(); tvDTO.TenThanhVien = dtRow["TenThanhVien"].ToString(); tvDTO.CV = int.Parse(dtRow["CV"].ToString()); tvDTO.DiaChi = dtRow["DiaChi"].ToString(); tvDTO.TienNo = float.Parse(dtRow["TienNo"].ToString()); lsttvDTO.Add(tvDTO); } } else { lsttvDTO = null; } return(lsttvDTO); }
public List <MatHang> LoadData() { try { dp.Connect(); string sqlstr = "SELECT * FROM MatHang"; List <MatHang> list = new List <MatHang>(); SqlDataReader dr = dp.ExecuteReader(sqlstr); //List<MatHang> list = new List<MatHang>(); while (dr.Read()) { string maMatHang = dr.GetString(0); string tenMatHang = dr.GetString(1); string maNhaCungCap = dr.GetString(2); string tenNhaCungCap = dr.GetString(3); int donGia = dr.GetInt32(4); int giaBan = dr.GetInt32(5); string maLoaiTien = dr.GetString(6); int namSanXuat = dr.GetInt32(7); MatHang N = new MatHang(maMatHang, tenMatHang, maNhaCungCap, tenNhaCungCap, donGia, giaBan, maLoaiTien, namSanXuat); list.Add(N); } dr.Close(); return(list); } catch (SqlException ex) { throw ex; } finally { dp.Disconnect(); } }
public static List <PhieuXuatDTO> SelectPhieuXuatAll() { DataTable dataTable = DataProvider.ExecuteReader("usp_SelectPhieuXuatAll"); List <PhieuXuatDTO> listPhieuXuatDTO = new List <PhieuXuatDTO>(); if (dataTable.Rows.Count > 0) { foreach (DataRow dataRow in dataTable.Rows) { PhieuXuatDTO phieuXuatDTO = new PhieuXuatDTO(); phieuXuatDTO.MaPhieuXuat = dataRow["MaPhieuXuat"].ToString(); phieuXuatDTO.NgayBan = DateTime.Parse(dataRow["NgayBan"].ToString()); phieuXuatDTO.MaThanhVien = dataRow["MaThanhVien"].ToString(); phieuXuatDTO.MaNhanVien = dataRow["MaNhanVien"].ToString(); phieuXuatDTO.TenKhachHang = dataRow["TenKhachHang"].ToString(); phieuXuatDTO.DiaChi = dataRow["DiaChi"].ToString(); phieuXuatDTO.MaLoaiPhieuXuat = dataRow["MaLoaiPhieuXuat"].ToString(); listPhieuXuatDTO.Add(phieuXuatDTO); } } else { listPhieuXuatDTO = null; } return(listPhieuXuatDTO); }
public static List <ChiTietPhieuNhapDTO> SelectChiTietPhieuNhapByMaPhieuNhap(string maPhieuNhap) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@MaPhieuNhap", maPhieuNhap)); DataTable dataTable = DataProvider.ExecuteReader("usp_SelectChiTietPhieuNhapByMaPhieuNhap", sqlParams); List <ChiTietPhieuNhapDTO> listChiTietPhieuNhapDTO = new List <ChiTietPhieuNhapDTO>(); if (dataTable.Rows.Count > 0) { foreach (DataRow dataRow in dataTable.Rows) { ChiTietPhieuNhapDTO chiTietPhieuNhapDTO = new ChiTietPhieuNhapDTO(); chiTietPhieuNhapDTO.MaChiTietPhieuNhap = dataRow["MaChiTietPhieuNhap"].ToString(); chiTietPhieuNhapDTO.MaPhieuNhap = dataRow["MaPhieuNhap"].ToString(); chiTietPhieuNhapDTO.MaSanPham = dataRow["MaSanPham"].ToString(); chiTietPhieuNhapDTO.SLNhan = Int32.Parse(dataRow["SLNhan"].ToString()); chiTietPhieuNhapDTO.GhiChu = dataRow["GhiChu"].ToString(); listChiTietPhieuNhapDTO.Add(chiTietPhieuNhapDTO); } } else { listChiTietPhieuNhapDTO = null; } return(listChiTietPhieuNhapDTO); }
public static DonHangDTO SearchDonHangById(string maDonHang) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@MaDonHang", maDonHang)); DataTable dataTable = DataProvider.ExecuteReader("usp_SearchDonHangById", sqlParams); DonHangDTO donHangDTO = new DonHangDTO(); if (dataTable.Rows.Count > 0) { DataRow dataRow = dataTable.Rows[0]; donHangDTO.MaDonHang = dataRow["MaDonHang"].ToString(); donHangDTO.NgayLap = DateTime.Parse(dataRow["NgayLap"].ToString()); donHangDTO.MaNhanVien = dataRow["MaNhanVien"].ToString(); donHangDTO.ThanhTien = float.Parse(dataRow["ThanhTien"].ToString()); donHangDTO.TrangThai = dataRow["TrangThai"].ToString(); } else { donHangDTO = null; } return(donHangDTO); }
public static ChiTietPhieuNhapDTO SelectChiTietPhieuNhapById(string maChiTietPhieuNhap) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@MaChiTietPhieuNhap", maChiTietPhieuNhap)); DataTable dataTable = DataProvider.ExecuteReader("usp_SelectChiTietPhieuNhapById", sqlParams); ChiTietPhieuNhapDTO chiTietPhieuNhapDTO = new ChiTietPhieuNhapDTO(); if (dataTable.Rows.Count > 0) { DataRow dataRow = dataTable.Rows[0]; chiTietPhieuNhapDTO.MaChiTietPhieuNhap = dataRow["MaChiTietPhieuNhap"].ToString(); chiTietPhieuNhapDTO.MaPhieuNhap = dataRow["MaPhieuNhap"].ToString(); chiTietPhieuNhapDTO.MaSanPham = dataRow["MaSanPham"].ToString(); chiTietPhieuNhapDTO.SLNhan = Int32.Parse(dataRow["SLNhan"].ToString()); chiTietPhieuNhapDTO.GhiChu = dataRow["GhiChu"].ToString(); } else { chiTietPhieuNhapDTO = null; } return(chiTietPhieuNhapDTO); }
public static SanPhamDTO SelectSanPhamById(string MaSanPham) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@MaSanPham", MaSanPham)); DataTable dataTable = new DataTable(); dataTable = DataProvider.ExecuteReader("usp_SelectSanPhamById", sqlParams); SanPhamDTO spDTO = new SanPhamDTO(); if (dataTable.Rows.Count > 0) { DataRow dtRow = dataTable.Rows[0]; //List<SanPhamDTO> lstspDTO = new List<SanPhamDTO>(); spDTO.MaSanPham = dtRow["MaSanPham"].ToString(); spDTO.TenSanPham = dtRow["TenSanPham"].ToString(); spDTO.CV = int.Parse(dtRow["CV"].ToString()); spDTO.DonGia = float.Parse(dtRow["DonGia"].ToString()); spDTO.DonGiaTV = float.Parse(dtRow["DonGiaTV"].ToString()); spDTO.SoLuongTon = int.Parse(dtRow["SoLuongTon"].ToString()); spDTO.MaLoaiSanPham = dtRow["MaLoaiSanPham"].ToString(); //select sp.MaSanPham, sp.TenSanPham, sp.CV, sp.DonGia, sp.DonGiaTV, sp.SoLuongTon, sp.MaLoaiSanPham // lstspDTO.Add(spDTO); } else { spDTO = null; } return(spDTO); }
public static List <SanPhamDTO> SelectSanPhamAll() { DataTable dataTable = new DataTable(); dataTable = DataProvider.ExecuteReader("usp_SelectSanPhamAll"); List <SanPhamDTO> lstspDTO = new List <SanPhamDTO>(); if (dataTable.Rows.Count > 0) { foreach (DataRow dtRow in dataTable.Rows) { SanPhamDTO spDTO = new SanPhamDTO(); spDTO.MaSanPham = dtRow["MaSanPham"].ToString(); spDTO.TenSanPham = dtRow["TenSanPham"].ToString(); spDTO.CV = int.Parse(dtRow["CV"].ToString()); spDTO.DonGia = float.Parse(dtRow["DonGia"].ToString()); spDTO.DonGiaTV = float.Parse(dtRow["DonGiaTV"].ToString()); spDTO.SoLuongTon = int.Parse(dtRow["SoLuongTon"].ToString()); spDTO.MaLoaiSanPham = dtRow["MaLoaiSanPham"].ToString(); //select sp.MaSanPham, sp.TenSanPham, sp.CV, sp.DonGia, sp.DonGiaTV, sp.SoLuongTon, sp.MaLoaiSanPham lstspDTO.Add(spDTO); } } else { lstspDTO = null; } return(lstspDTO); }
public List <Nhanvien> LoadData() { try { dp.Connect(); string sqlstr = "SELECT * FROM NhanVien"; List <Nhanvien> list = new List <Nhanvien>(); SqlDataReader dr = dp.ExecuteReader(sqlstr); //List<Nhanvien> list = new List<Nhanvien>(); while (dr.Read()) { string maNV = dr.GetString(0); string hoTen = dr.GetString(1); string tenQuayGiaoDich = dr.GetString(2); string diaChi = dr.GetString(3); string soDienThoai = dr.GetString(4); Nhanvien N = new Nhanvien(maNV, hoTen, tenQuayGiaoDich, diaChi, soDienThoai); list.Add(N); } dr.Close(); return(list); } catch (SqlException ex) { throw ex; } finally { dp.Disconnect(); } }
/////////////////////////// // Lấy danh sách Ghế /////////////////////////// public List <Seat> GetSeat(string sql) { List <Seat> list = new List <Seat>(); string MaVe, Loai, HangGhe; bool TinhTrang; int Gia; dp.Connect(); try { SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { MaVe = dr.GetString(0); Loai = dr.GetString(1); HangGhe = dr.GetString(2); Gia = dr.GetInt32(3); TinhTrang = dr.GetBoolean(4); Seat seat = new Seat(MaVe, Loai, HangGhe, Gia, TinhTrang); list.Add(seat); } return(list); } catch (Exception ex) { throw ex; } finally { dp.Disconnect(); } }
public List <DTOCTHoaDon> GetCTHD(string sql) { dp.connect(); List <DTOCTHoaDon> list = new List <DTOCTHoaDon>(); { string m, ms; int sl, dg, tt; try { SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { m = dr.GetString(0); ms = dr.GetString(1); sl = dr.GetInt32(2); dg = dr.GetInt32(3); tt = dr.GetInt32(4); DTOCTHoaDon cthd = new DTOCTHoaDon(m, ms, sl, dg, tt); list.Add(cthd); } dr.Close(); return(list); } catch (SqlException ex) { throw ex; } finally { dp.disconnect(); } } }
public List <DTOHoaDon> GetHD(string sql) { dp.connect(); List <DTOHoaDon> list = new List <DTOHoaDon>(); { string mh, mk, mn; DateTime nx; int tt; try { SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { mh = dr.GetString(0); mk = dr.GetString(1); nx = dr.GetDateTime(2); tt = dr.GetInt32(3); mn = dr.GetString(4); DTOHoaDon hd = new DTOHoaDon(mh, mk, nx, tt, mn); list.Add(hd); } dr.Close(); return(list); } catch (SqlException ex) { throw ex; } finally { dp.disconnect(); } } }
public List <DTO_Customer> GetCustomer() { List <DTO_Customer> list = new List <DTO_Customer>(); int makh; string hokh, tenkh, sdt, gioitinh, diachithuongtru, email; DateTime ngaysinh; try { string sql = "SELECT * FROM KhachHang"; SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { makh = dr.GetInt32(0); hokh = dr.GetString(1); tenkh = dr.GetString(2); gioitinh = dr.GetString(3); sdt = dr.GetString(4); ngaysinh = dr.GetDateTime(5); diachithuongtru = dr.GetString(6); email = dr.GetString(7); DTO_Customer emp = new DTO_Customer(makh, hokh, tenkh, gioitinh, sdt, ngaysinh, diachithuongtru, email); list.Add(emp); } return(list); } catch (SqlException ex) { throw ex; } }
public static HoaDon GetLastBill(int maBan) { provider = new DataProvider(); provider.Connect(); string cmdStr = "Execute proc_GetLastBill " + maBan; SqlDataReader reader = provider.ExecuteReader(cmdStr); HoaDon bill = new HoaDon(); if (reader.Read()) { bill.MaHoaDon = reader.GetInt32(0); bill.MaBan = reader.GetInt32(1); bill.MaNhanVien = reader.GetInt32(2); if (!reader.IsDBNull(3)) { bill.ThoiGianLap = reader.GetDateTime(3); } bill.TongTien = reader.GetInt32(4); } provider.Disconnect(); return(bill); }
public static List <HoaDon> LoadAll(int pageNumber, int billsPerPage) { provider = new DataProvider(); provider.Connect(); string cmdStr = "Execute proc_LoadAllBills " + pageNumber + ", " + billsPerPage; SqlDataReader reader = provider.ExecuteReader(cmdStr); List <HoaDon> billList = new List <HoaDon>(); while (reader.Read()) { int maHoaDon = reader.GetInt32(0); int maBan = reader.GetInt32(1); int maNhanVen = reader.GetInt32(2); DateTime?thoiGianLap; if (!reader.IsDBNull(3)) { thoiGianLap = reader.GetDateTime(3); } else { thoiGianLap = null; } int tongTien = reader.GetInt32(4); billList.Add(new HoaDon(maHoaDon, maBan, maNhanVen, thoiGianLap, tongTien)); } provider.Disconnect(); return(billList); }
public static List <ChiTietDonHangDTO> SelectChiTietDonHangByMaDonHang(string MaDonHang) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@MaDonHang", MaDonHang)); DataTable dataTable = new DataTable(); dataTable = DataProvider.ExecuteReader("usp_SelectChiTietDonHangByMaDonHang", sqlParams); List <ChiTietDonHangDTO> lstctdhDTO = new List <ChiTietDonHangDTO>(); if (dataTable.Rows.Count > 0) { //<ChiTietDonHangDTO> lstctdhDTO = new List<ChiTietDonHangDTO>(); foreach (DataRow dtRow in dataTable.Rows) { ChiTietDonHangDTO ctdhDTO = new ChiTietDonHangDTO(); ctdhDTO.MaChiTietDonHang = dtRow["MaChiTietDonHang"].ToString(); ctdhDTO.MaDonHang = dtRow["MaDonHang"].ToString(); ctdhDTO.MaSanPham = dtRow["MaSanPham"].ToString(); ctdhDTO.CV = int.Parse(dtRow["CV"].ToString()); ctdhDTO.SoLuong = int.Parse(dtRow["SoLuong"].ToString()); ctdhDTO.DonGia = float.Parse(dtRow["DonGia"].ToString()); ctdhDTO.ThanhTien = float.Parse(dtRow["ThanhTien"].ToString()); ctdhDTO.SLDaNhan = int.Parse(dtRow["SLDaNhan"].ToString()); lstctdhDTO.Add(ctdhDTO); //select ct.MaChiTietDonHang, ct.MaDonHang, ct.MaSanPham, ct.CV, ct.SoLuong, ct.DonGia, ct.ThanhTien } } else { lstctdhDTO = null; } return(lstctdhDTO); }
public static HoaDon GetBill(int maHoaDon) { provider = new DataProvider(); provider.Connect(); string cmdStr = "Execute proc_GetBill " + maHoaDon; SqlDataReader reader = provider.ExecuteReader(cmdStr); HoaDon bill = null; if (reader.Read()) { DateTime?thoiGianLap; if (!reader.IsDBNull(3)) { thoiGianLap = reader.GetDateTime(3); } else { thoiGianLap = null; } bill = new HoaDon { MaHoaDon = reader.GetInt32(0), MaBan = reader.GetInt32(1), MaNhanVien = reader.GetInt32(2), ThoiGianLap = thoiGianLap, TongTien = reader.GetInt32(4) }; } provider.Disconnect(); return(bill); }
public static List <PhieuNhapDTO> SelectPhieuNhapByMaDonHang(string MaDonHang) { List <SqlParameter> sqlParamas = new List <SqlParameter>(); sqlParamas.Add(new SqlParameter("@MaDonHang", MaDonHang)); DataTable dataTable = DataProvider.ExecuteReader("usp_SelectPhieuNhapByMaDonHang", sqlParamas); List <PhieuNhapDTO> listPhieuNhapDTO = new List <PhieuNhapDTO>(); if (dataTable.Rows.Count > 0) { foreach (DataRow dataRow in dataTable.Rows) { PhieuNhapDTO phieuNhapDTO = new PhieuNhapDTO(); phieuNhapDTO.MaPhieuNhap = dataRow["MaPhieuNhap"].ToString(); phieuNhapDTO.MaDonHang = dataRow["MaDonHang"].ToString(); phieuNhapDTO.NgayNhan = DateTime.Parse(dataRow["NgayNhan"].ToString()); phieuNhapDTO.MaNhanVien = dataRow["MaNhanVien"].ToString(); listPhieuNhapDTO.Add(phieuNhapDTO); } } else { listPhieuNhapDTO = null; } return(listPhieuNhapDTO); }
public List <DTOChiTietThue> GetCTT(string sql) { dp.connect(); List <DTOChiTietThue> list = new List <DTOChiTietThue>(); { string map, makh; DateTime nt, ndk, ntr; try { SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { map = dr.GetString(0); makh = dr.GetString(1); nt = dr.GetDateTime(2); ndk = dr.GetDateTime(3); ntr = dr.GetDateTime(4); DTOChiTietThue ctt = new DTOChiTietThue(map, makh, nt, ndk, ntr); list.Add(ctt); } dr.Close(); return(list); } catch (SqlException ex) { throw ex; } } }
public List <DTOKhachHang> GetKH(string sql) { dp.connect(); List <DTOKhachHang> list = new List <DTOKhachHang>(); { string ma, ho, ten, cmnd, dc, sdt; DateTime ngaysinh; try { SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { ma = dr.GetString(0); ho = dr.GetString(1); ten = dr.GetString(2); ngaysinh = dr.GetDateTime(3); cmnd = dr.GetString(4); dc = dr.GetString(5); sdt = dr.GetString(6); //fax = dr.GetString(7); DTOKhachHang kh = new DTOKhachHang(ma, ho, ten, ngaysinh, cmnd, dc, sdt); list.Add(kh); } dr.Close(); return(list); } catch (SqlException ex) { throw ex; } finally { dp.disconnect(); } } }
public List <DTONhanVien> GetNV(string sql) { dp.connect(); List <DTONhanVien> list = new List <DTONhanVien>(); { string ma, ho, ten, cmnd, dc, sdt, gt, bc; DateTime ngaysinh; try { SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { ma = dr.GetString(0); ho = dr.GetString(1); ten = dr.GetString(2); ngaysinh = dr.GetDateTime(3); gt = dr.GetString(4); cmnd = dr.GetString(5); dc = dr.GetString(7); sdt = dr.GetString(6); bc = dr.GetString(8); DTONhanVien nv = new DTONhanVien(ma, ho, ten, ngaysinh, gt, cmnd, sdt, dc, bc); list.Add(nv); } dr.Close(); return(list); } catch (SqlException ex) { throw ex; } finally { dp.disconnect(); } } }
public static NhanVien GetEmployee(int maNhanVien) { provider = new DataProvider(); provider.Connect(); string cmdStr = "Execute proc_GetEmployee " + maNhanVien; SqlDataReader reader = provider.ExecuteReader(cmdStr); NhanVien employee = new NhanVien(); if (reader.Read()) { employee.MaNhanVien = reader.GetInt32(0); employee.HoTen = reader.GetString(1); employee.NgaySinh = reader.GetDateTime(2); employee.GioiTinh = reader.GetString(3); employee.DiaChi = reader.GetString(4); employee.SoDienThoai = reader.GetString(5); employee.NgayVaoLam = reader.GetDateTime(6); employee.ChucVu = reader.GetString(7); employee.Luong = reader.GetInt32(8); } provider.Disconnect(); return(employee); }
public static List <ThucDon> LoadAll(string tenMon = "") { provider = new DataProvider(); provider.Connect(); string cmdStr; if (tenMon == string.Empty) { cmdStr = "Execute proc_LoadAllDishes"; } else { cmdStr = "Execute proc_LoadAllDishesWithName N'" + tenMon + "'"; } SqlDataReader reader = provider.ExecuteReader(cmdStr); List <ThucDon> list = new List <ThucDon>(); while (reader.Read()) { list.Add(new ThucDon(reader.GetString(0), reader.GetInt32(1), reader.GetString(2))); } provider.Disconnect(); return(list); }
public decimal GETMONEY(int ID) { try { string sql = "select * from dbo.MonNuoc where MaMonNuoc = " + ID; SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { return(dr.GetDecimal(dr.GetOrdinal("GiaTien"))); } } catch { } return(0); }