public static MauTaiLieuCollection SelectAll()
{
MauTaiLieuCollection List = new MauTaiLieuCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblMauTaiLieu_Select_SelectAll_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static MauTaiLieuCollection Select_ByListId(string _CId)
{
MauTaiLieuCollection List = new MauTaiLieuCollection();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("iList", _CId);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblMauTaiLieu_Select_SelectByIdList_hungpm", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static MauTaiLieuCollection Select_ByVBID(string DM_ID, string VB_ID)
{
MauTaiLieuCollection List = new MauTaiLieuCollection();
SqlParameter[] obj = new SqlParameter[2];
obj[0] = new SqlParameter("DM_ID", DM_ID);
obj[1] = new SqlParameter("VB_ID", VB_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblMauTaiLieu_Select_SelectAll_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}