public DataTable getRequestById(int _id) { string query = "select * from YEUCAUSUACHUA where MaYeuCau = @_id"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@_id", SqlDbType.VarChar); sqlParameters[0].Value = Convert.ToString(_id); return(conn.executeSelectQuery(query, sqlParameters)); }
public DataTable getDeviceById(int _id) { string query = "select * from THIETBISUACHUA where MaThietBi = @_id"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@_id", SqlDbType.VarChar); sqlParameters[0].Value = Convert.ToString(_id); return(conn.executeSelectQuery(query, sqlParameters)); }
public DataTable getFullInfoByRequestId(int _id) { string query = "select y.MaYeuCau, TenThietBi, NgayNhan, TenNhanHieu, Model, HoTen, SoDienThoai, DiaChi, DaSuaChua, SoLuong, MoTaTinhTrang, ChiTiet, TienCong, MoTaLoi from YEUCAUSUACHUA y inner join KHACHHANG k on y.MaKH = k.MaKhachHang join THIETBISUACHUA t on y.MaMonHang = t.MaThietBi join NHANHIEU n on t.MaNhanHieu = n.MaNhanHieu left join SUACHUA s on s.MaYeuCau = y.MaYeuCau where s.MaYeuCau = @_id"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@_id", SqlDbType.VarChar); sqlParameters[0].Value = Convert.ToString(_id); return(conn.executeSelectQuery(query, sqlParameters)); }
public DataTable getBrandById(int _id) { string query = "select * from NhanHieu where MaNhanHieu = @_id"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@_id", SqlDbType.VarChar); sqlParameters[0].Value = Convert.ToString(_id); return(conn.executeSelectQuery(query, sqlParameters)); }
public DataTable getCustomerById(int _id) { string query = "select * from KhachHang where MaKhachHang = @_id"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@_id", SqlDbType.VarChar); sqlParameters[0].Value = Convert.ToString(_id); return(conn.executeSelectQuery(query, sqlParameters)); }
public DataTable getRequestSpecificDayStatistic(DateTime date) { string query = "select count(*) from YEUCAUSUACHUA where NgayNhan = @_date"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@_date", SqlDbType.VarChar); sqlParameters[0].Value = Convert.ToString(date.ToString("MM-dd-yyyy")); return(conn.executeSelectQuery(query, sqlParameters)); }