public void Add(History model) { using (var db = new DataContext()) { db.Histories.Add(model); db.SaveChanges(); } }
public List<History> GetList(string clientId, int pageIndex, int pageSize, out int pageCount) { using (var db = new DataContext()) { var query = db.Histories.AsQueryable(); if (!string.IsNullOrEmpty(clientId)) { query = query.Where(e => e.ClientId == clientId); } var recordCount = query.Count(); pageCount = recordCount / 20; if (recordCount % 20 > 0) pageCount++; return query.OrderByDescending(e => e.ID).Skip(pageIndex * pageSize - pageSize).Take(pageSize).ToList(); } }