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