public static LienHeCollection SelectAll()
{
LienHeCollection List = new LienHeCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLienHe_Select_SelectAll_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static LienHeCollection SelectByActive(bool active)
{
LienHeCollection list = new LienHeCollection();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("active", active);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLienHe_Select_SelectByActive", obj))
{
while (rd.Read())
{
list.Add(getFromReader(rd));
}
}
return(list);
}
public static LienHeCollection SelectByGH_ID(Int32 GH_ID) // manhtv
{
LienHeCollection list = new LienHeCollection();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("gh_id", GH_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLienHe_Select_SelectByGhId_hiennb", obj))
{
while (rd.Read())
{
list.Add(getFromReader(rd));
}
}
return(list);
}