/// <summary> /// 条件查询 /// </summary> /// <param name="parmList"></param> /// <returns></returns> public List <StudentDTO> GetConditionStu(int page, int pagesize, string sortName, List <Expression <Func <StudentDTO, bool> > > parmList, ref int count) { var query = (from c in ObjEntity.Student join d in ObjEntity.Grade on c.s_GradeID equals d.GradeID select new StudentDTO() { s_id = c.s_id, s_name = c.s_name, s_address = c.s_address, s_sex = c.s_sex, s_age = c.s_age, s_createDate = c.s_createDate, s_loginName = c.s_loginName, s_passWord = c.s_passWord, s_phone = c.s_phone, s_remark = c.s_remark, s_status = c.s_status, SexName = c.s_sex == 0 ? "男" : "女", StatusName = c.s_status == 1 ? "启用" : "禁用", GradeName = d.GradeName }); if (parmList != null) { foreach (var parm in parmList) { query = query.Where(parm); } } //返回总条数 count = query.FutureCount(); query = SortTools.SortingAndPaging <StudentDTO>(query, sortName, page, pagesize); return(query.ToList()); }
private void StartBtn_Click(object sender, EventArgs e) { N = 0; SortTools sort = new SortTools(); states = sort.GetSortStates(20, (SortTools.IncrementsType)Type.SelectedIndex); Refresh(); NextBtn.Enabled = true; }
/// <summary> /// 分页获取数据 /// </summary> /// <param name="page">页码</param> /// <param name="pageSize">煤业显示条数</param> /// <param name="order">排序字段</param> /// <param name="sort">排序方式 1.正序 2.倒序</param> /// <returns></returns> public List <TEntity> GetDataByPage(int page, int pageSize, List <Expression <Func <TEntity, bool> > > parmList, string Sort, ref int count) { IQueryable <TEntity> query = dbSet; if (parmList != null) { foreach (var parm in parmList) { query = query.Where(parm); } } count = query.FutureCount(); query = SortTools.SortingAndPaging <TEntity>(query, Sort, page, pageSize, true); List <TEntity> queryList = query.ToList(); return(queryList); }
public static List <double> Sort(List <double> inputList) { List <double> sortingList = new List <double>(inputList); while (!SortTools.CheckSort(sortingList)) { for (var i = 0; i < sortingList.Count - 1; i++) { if (sortingList[i] > sortingList[i + 1]) { var temperory = sortingList[i]; sortingList[i] = sortingList[i + 1]; sortingList[i + 1] = temperory; } } } return(sortingList); }
public void TestMethod1() { int[] testArray = { 1, 2, 3, 4, 5 }; Assert.IsTrue(SortTools.IsSorted(Sorts.InsertionSort(new int[] { 5, 4, 3, 2, 1 }))); }