public canshulei fenye2(Cansh ji)
{
Expression <Func <human_file, bool> > expr = n => GetCondition(n, ji);
canshulei cs = new canshulei();
List <human_fileModel> li = new List <human_fileModel>();
int rows = 0;
var data = db.Set <human_file>().OrderBy(e => e.id).Where(expr.Compile()).ToList();
rows = data.Count();//获取总行数
List <human_file> list = data.Skip((ji.dqy - 1) * ji.rl)
.Take(ji.rl)
.ToList();
foreach (human_file item in list)
{
human_fileModel mo = new human_fileModel();
mo.id = item.id;
mo.human_name = item.human_name;
mo.human_id = item.human_id;
mo.human_sex = item.human_sex;
mo.first_kind_name = item.first_kind_name;
mo.second_kind_name = item.second_kind_name;
mo.third_kind_name = item.third_kind_name;
mo.hunma_major_name = item.hunma_major_name;
mo.human_major_kind_name = item.human_major_kind_name;
li.Add(mo);
}
cs.li = li;
cs.MyProperty = rows;
cs.zys = (rows % ji.rl == 0 ? rows / ji.rl : rows % ji.rl + 1);
return(cs);
}
private bool GetCondition(human_file fb, Cansh ji)
{
bool boolResult = true;
if (!ji.first_kind_id.Equals("查询全部"))
{
boolResult &= fb.first_kind_id.Equals(ji.first_kind_id);
}
if (!ji.second_kind_id.Equals("查询全部"))
{
boolResult &= fb.second_kind_id.Equals(ji.second_kind_id);
}
if (!ji.third_kind_id.Equals("查询全部"))
{
boolResult &= fb.third_kind_id.Equals(ji.third_kind_id);
}
if (!ji.human_major_kind_id.Equals("查询全部"))
{
boolResult &= fb.human_major_kind_id.Equals(ji.human_major_kind_id);
}
if (!ji.hunma_major_name.Equals("查询全部"))
{
boolResult &= fb.human_major_id.Equals(ji.hunma_major_name);
}
boolResult &= fb.regist_time >= ji.utilBeanstartDate;
boolResult &= fb.regist_time <= ji.utilBeandatePropertyName;
boolResult &= fb.human_file_status == ji.human_file_status;
return(boolResult);
}
public canshulei fenye2(Cansh ji)
{
return(st1.fenye2(ji));
}
