public IEnumerable <Dictionary> QueryUpperList(DictionaryCondition condition)
{
string code = string.Empty;
if (condition.ParentCode == "root")
{
code = "root";
}
else
{
var dic = _db.Dictionary.Where(c => c.Code == condition.ParentCode).Take(1).ToList();
if (dic.Count > 0)
{
code = dic[0].ParentCode;
}
}
condition.PageIndex = 1;
condition.ParentCode = code;
var list = QueryList(condition);
return(list);
}
public int Delete(DictionaryCondition dic)
{
var sql = string.Format("DELETE FROM [dbo].[Dictionary] WHERE ID IN('{0}')", dic.Ids);
var result = _db.Database.ExecuteSqlCommand(sql);
return(result);
//var dic = _db.Dictionary.Find(id);
//_db.Dictionary.RemoveRange()
//_db.SaveChanges();
}
public dynamic QueryList(DictionaryCondition condition)
{
//从多少页开始取数据
var skipSize = condition.PageSize * (condition.PageIndex - 1);
var list = _db.Dictionary
.Where(d => d.ParentCode == condition.ParentCode);
var result = list.OrderBy(c => c.Sequence)
.Skip(skipSize)
.Take(condition.PageSize).ToList();
//int totalCount = 0;
//var result = Dictionary.Bll.Search(d => d.ParentCode == condition.ParentCode, c => c.Sequence, condition.PageIndex,
// condition.PageSize, out totalCount).ToList();
return(result);
}
