Пример #1
0
        public static VanBanDiCollection SelectTTSo()
        {
            VanBanDiCollection List = new VanBanDiCollection();

            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBanDi_Select_TTSo_linhnx"))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Пример #2
0
        public static VanBanDiCollection GetVanBanChuaPhatHanh(string sort, int numRow, string UserName)
        {
            VanBanDiCollection List = new VanBanDiCollection();

            SqlParameter[] obj = new SqlParameter[3];
            obj[0] = new SqlParameter("Sort", sort);
            obj[1] = new SqlParameter("Top", numRow);
            obj[2] = new SqlParameter("Username", UserName);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBanDi_Select_Desktop_hungpm", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }