public static BanHang_PhienLamViecCollection SelectAll()
{
var List = new BanHang_PhienLamViecCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_PhienLamViec_Select_SelectAll_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static BanHang_PhienLamViecCollection SelectByCqId(string CqId)
{
var List = new BanHang_PhienLamViecCollection();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("CqId", CqId);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_PhienLamViec_Select_SelectByCqId_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static BanHang_PhienLamViecCollection SelectByNgay(string Ngay, string Username)
{
var List = new BanHang_PhienLamViecCollection();
var obj = new SqlParameter[2];
obj[0] = new SqlParameter("Ngay", Ngay);
obj[1] = new SqlParameter("Username", Username);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_PhienLamViec_Select_SelectByNgay_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
