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); }