public DataTable GetTable() { /* * DataTable dt = GetData("HoaDon"); * List<HoaDon> list = new List<HoaDon>(); * foreach (DataRow row in dt.Rows) * { * list.Add(new HoaDon(row["MaHD"].ToString(),row["MaKH"].ToString(),row["MaNV"].ToString(),Convert.ToDateTime(row["NgayLap"]))); * } * return list;*/ return(_dbConnect.ExecuteQuery("select * from HoaDon")); }
public DataTable GetTable(string whereMaHH = "", string whereTenHH = "") { string strSql = string.Format("select * from HangHoa where MaHH like '{0}%' and TenHH like N'%{1}%'", whereMaHH, whereTenHH); return(_dbConnect.ExecuteQuery(strSql)); }
public DataTable GetTable() { return(_dbConnect.ExecuteQuery("select * from ChiTietHoaDon")); }
public DataTable GetTable() { return(_dbConnect.ExecuteQuery("select * from KhachHang")); }
public DataTable SalaryOfEmployee() { return(db.ExecuteQuery("select MaNV[Mã Nhân Viên], TenNV[Tên Nhân Viên], ChucDanh[Chức Danh], Luong[Lương] from NhanVien")); }
public DataTable GetTable() { return(_dbConnect.ExecuteQuery("select * from NhanVien")); }