public IList <LogDefinition> QueryByParam1(QueryByParam1In param) { param.BeginDateTime = param.BeginDateTime.Date; param.EndDateTime = param.EndDateTime.AddDays(1); using (var dal = new BaseDal()) { var list = from o in dal.Log where ((o.UpdateDateTime >= param.BeginDateTime) && (o.UpdateDateTime < param.EndDateTime)) select o; param.Total = list.Count(); list = from o in list orderby o.UpdateDateTime select o; list = list.Skip((param.Page - 1) * param.Rows).Take(param.Rows); return((list).ToList()); } }
public IList <GranariesDefinition> QueryByParam1(QueryByParam1In param) { //param.BeginDateTime = param.BeginDateTime.Date; //param.EndDateTime = param.EndDateTime.AddDays(1); using (var dal = new BaseDal()) { var list = from o in dal.Granaries where (true)select o; param.Total = list.Count(); list = from o in list orderby o.GranariesName select o; list = list.Skip((param.Page - 1) * param.Rows).Take(param.Rows); return((list).ToList()); } }