public static DataTable findWithID(String id)
{
string sql = String.Format("select * from SACH where masach = '{0}'", id);
var result = ProcessData.ExcuteQuery(sql);
return(result);
}
public static DataTable readAll()
{
string sql = "select * from SACH";
var result = ProcessData.ExcuteQuery(sql);
return(result);
}
public static DataTable findWithReaderID(String readerid)
{
string sql = String.Format("select * from phieumuon where madocgia = '{0}'", readerid);
var result = ProcessData.ExcuteQuery(sql);
return(result);
}
public static DataTable findWithBookID(String bookid)
{
string sql = String.Format("select * from phieumuon where masach = '{0}'", bookid);
var result = ProcessData.ExcuteQuery(sql);
return(result);
}
public static DataTable findWithReturnID(String returnid)
{
string sql = String.Format("select * from phieutra where maphieutra = '{0}'", returnid);
var result = ProcessData.ExcuteQuery(sql);
return(result);
}