public List <NewsCategoryInfo> UpdataSorting(int fatherid, int sorting)
{
List <NewsCategoryInfo> infos = new List <NewsCategoryInfo>();
IDataReader reader = db.UpdataSorting(fatherid, sorting, lidValue).CreateDataReader();
while (reader.Read())
{
infos.Add(NewsCategoryInfo.Populate(reader));
}
return(infos);
}
public NewsCategoryInfo getAllById(int id)
{
NewsCategoryInfo info = new NewsCategoryInfo();
IDataReader reader = db.GetDataById(id).CreateDataReader();
while (reader.Read())
{
info = NewsCategoryInfo.Populate(reader);
}
return(info);
}
/// <summary>
/// 取出所有Father與Lid符合的資料,並以Sort排序
/// </summary>
/// <param name="fatherId"></param>
/// <param name="lidvalue"></param>
/// <returns></returns>
public List <NewsCategoryInfo> GetDataByFatherIdAndLidOrderSorting(int fatherId, int lidvalue)
{
List <NewsCategoryInfo> infos = new List <NewsCategoryInfo>();
IDataReader reader = db.GetDataByFatherIdAndLidOrderSorting(fatherId, lidvalue).CreateDataReader();
while (reader.Read())
{
infos.Add(NewsCategoryInfo.Populate(reader));
}
return(infos);
}
public List <NewsCategoryInfo> getAll()
{
List <NewsCategoryInfo> infos = new List <NewsCategoryInfo>();
IDataReader reader = db.GetData().CreateDataReader();
while (reader.Read())
{
infos.Add(NewsCategoryInfo.Populate(reader));
}
return(infos);
}
public int GetDataByFatherIdAndLidOrderSortDESC(int fatherId, int lidvalue)
{
NewsCategoryInfo info = new NewsCategoryInfo();
IDataReader reader = db.GetDataByFatherIdAndLidOrderSortDESC(fatherId, lidvalue).CreateDataReader();
if (reader.Read())
{
info = NewsCategoryInfo.Populate(reader);
return(info.nc_sorting + 1);
}
return(1);
}