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