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