public List <ArticleCategoryInfo> UpdataSorting(int fatherid, int sorting)
{
List <ArticleCategoryInfo> infos = new List <ArticleCategoryInfo>();
IDataReader reader = db.UpdataSorting(fatherid, sorting, lidValue).CreateDataReader();
while (reader.Read())
{
infos.Add(ArticleCategoryInfo.Populate(reader));
}
return(infos);
}
public ArticleCategoryInfo getAllById(int id)
{
ArticleCategoryInfo info = new ArticleCategoryInfo();
IDataReader reader = db.GetDataByAcId(id).CreateDataReader();
if (reader.Read())
{
info = ArticleCategoryInfo.Populate(reader);
}
return(info);
}
public List <ArticleCategoryInfo> GetDataByFatherIdAndLidOrderSorting(int fatherId, int lidvalue)
{
List <ArticleCategoryInfo> infos = new List <ArticleCategoryInfo>();
IDataReader reader = db.GetDataByFatherIdAndLidOrderSorting(fatherId, lidvalue).CreateDataReader();
while (reader.Read())
{
infos.Add(ArticleCategoryInfo.Populate(reader));
}
return(infos);
}
public List <ArticleCategoryInfo> getAll()
{
List <ArticleCategoryInfo> infos = new List <ArticleCategoryInfo>();
IDataReader reader = db.GetData().CreateDataReader();
while (reader.Read())
{
infos.Add(ArticleCategoryInfo.Populate(reader));
}
return(infos);
}
public int GetDataByFatherIdAndLidOrderSortDESC(int fatherId, int lidvalue)
{
ArticleCategoryInfo info = new ArticleCategoryInfo();
IDataReader reader = db.GetDataByFatherIdAndLidOrderSortDESC(fatherId, lidvalue).CreateDataReader();
if (reader.Read())
{
info = ArticleCategoryInfo.Populate(reader);
return(info.ac_sorting + 1);
}
return(1);
}