Beispiel #1
0
        public static TinCollection SelectTopTen()
        {
            TinCollection List = new TinCollection();

            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTin_Select_SelectTopTen_linhnx"))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Beispiel #2
0
        public static TinCollection SelectTopThongBao(int top)
        {
            TinCollection List = new TinCollection();

            SqlParameter[] obj = new SqlParameter[1];
            obj[0] = new SqlParameter("top", top);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssTin_Select_SelectTopThongBao_linhnx", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Beispiel #3
0
        public static TinCollection SelectByDanhMucNew(string DM_ID, int Top)
        {
            TinCollection List = new TinCollection();

            SqlParameter[] obj = new SqlParameter[3];
            obj[0] = new SqlParameter("DM_ID", DM_ID);
            obj[1] = new SqlParameter("Top", Top);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTin_Select_SelectByDanhMucNewID_linhnx", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Beispiel #4
0
        public static TinCollection SelectByDanhMuc(string DM_Ma, int Top, SqlConnection con)
        {
            var list = new TinCollection();
            var obj  = new SqlParameter[2];

            obj[0] = new SqlParameter("DM_Ma", DM_Ma);
            obj[1] = new SqlParameter("Top", Top);
            using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblTin_Select_SelectByDanhMuc_linhnx", obj))
            {
                while (rd.Read())
                {
                    list.Add(getFromReader(rd));
                }
            }
            return(list);
        }
Beispiel #5
0
        public static TinCollection byLoaiDanhMuc(int top, string dm_id)
        {
            TinCollection List = new TinCollection();

            SqlParameter[] obj = new SqlParameter[2];
            obj[0] = new SqlParameter("top", top);
            obj[1] = new SqlParameter("dm_id", dm_id);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblRssTin_Select_byLoaiDanhMuc_linhnx", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Beispiel #6
0
        public static TinCollection SelectTop(int Top, string _lang)
        {
            TinCollection List = new TinCollection();

            SqlParameter[] obj = new SqlParameter[2];
            obj[0] = new SqlParameter("Top", Top);
            obj[1] = new SqlParameter("Lang", _lang);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTin_Select_SelectTop_linhnx", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Beispiel #7
0
        public static TinCollection GetTinbyMaDanhMucHomeKhac(int top, string DM_Ma, string Lang, SqlConnection cnn)
        {
            TinCollection List = new TinCollection();

            SqlParameter[] obj = new SqlParameter[3];
            obj[0] = new SqlParameter("top", top);
            obj[1] = new SqlParameter("DM_Ma", DM_Ma);
            obj[2] = new SqlParameter("Lang", Lang);
            using (IDataReader rd = SqlHelper.ExecuteReader(cnn, CommandType.StoredProcedure, "sp_tblRssTin_Select_byDanhMucHomeKhac_hampv", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Beispiel #8
0
        public static TinCollection lienQuan(int Top, string Id, int dmId, string Lang)
        {
            TinCollection List = new TinCollection();

            SqlParameter[] obj = new SqlParameter[4];
            obj[0] = new SqlParameter("Top", Top);
            obj[1] = new SqlParameter("Id", Id);
            obj[2] = new SqlParameter("DM_ID", dmId);
            obj[3] = new SqlParameter("TIN_Lang", Lang);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTin_Select_lienQuan_linhnx", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
Beispiel #9
0
        public static TinCollection SelectLienQuan(string ID, int Top, SqlConnection con)
        {
            var list = new TinCollection();
            var obj  = new SqlParameter[2];

            if (!string.IsNullOrEmpty(ID))
            {
                obj[0] = new SqlParameter("ID", ID);
            }
            else
            {
                obj[0] = new SqlParameter("ID", DBNull.Value);
            }
            obj[1] = new SqlParameter("Top", Top);
            using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblTin_Select_SelectLienQuan_linhnx", obj))
            {
                while (rd.Read())
                {
                    list.Add(getFromReader(rd));
                }
            }
            return(list);
        }