public List <CTPM> getAll(string Top, string Where, string Order)
{
List <CTPM> lst = new List <CTPM>();
string selectQuery = "select ";
if (Top.Length != 0)
{
selectQuery += "Top " + Top;
}
selectQuery += "* ";
selectQuery += "from tb_CTPM ";
if (Where.Length != 0)
{
selectQuery += "Where " + Where;
}
if (Order.Length != 0)
{
selectQuery += "Order by " + Order;
}
using (SqlCommand cmd = new SqlCommand(selectQuery, openConnection()))
{
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
CTPM obj = new CTPM();
obj.CTPMIDataReader(dr);
lst.Add(obj);
}
dr.Close();
}
return(lst);
}
public List <CTPM> getCTPM(String maKH)
{
List <CTPM> lst = new List <CTPM>();
String sql = String.Format("select tb_CTPM.* from tb_CTPM,tb_PhieuMuon where tb_PhieuMuon.maPM = tb_CTPM.maPM and maDocGia = '{0}'", maKH);
using (SqlCommand cmd = new SqlCommand(sql, openConnection()))
{
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
CTPM obj = new CTPM();
obj.CTPMIDataReader(dr);
lst.Add(obj);
}
dr.Close();
}
return(lst);
}