public PagedModel<School> FindByCriteria(SchoolCriteria c)
{
PagedModel<School> m = new PagedModel<School>();
var r = this.Repository.FindByCriteria(c);
if(!String.IsNullOrEmpty(c.sortname)){
if(c.sortname.ToLower().Equals("id")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Id);
}else{
r = r.OrderByDescending(o=>o.Id);
}
}
if(c.sortname.ToLower().Equals("name")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Name);
}else{
r = r.OrderByDescending(o=>o.Name);
}
}
if(c.sortname.ToLower().Equals("districtid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.DistrictId);
}else{
r = r.OrderByDescending(o=>o.DistrictId);
}
}
if(c.sortname.ToLower().Equals("issold")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.IsSold);
}else{
r = r.OrderByDescending(o=>o.IsSold);
}
}
if(c.sortname.ToLower().Equals("type")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Type);
}else{
r = r.OrderByDescending(o=>o.Type);
}
}
if(c.sortname.ToLower().Equals("levels")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Levels);
}else{
r = r.OrderByDescending(o=>o.Levels);
}
}
if(c.sortname.ToLower().Equals("devby")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.DevBy);
}else{
r = r.OrderByDescending(o=>o.DevBy);
}
}
if(c.sortname.ToLower().Equals("devdate")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.DevDate);
}else{
r = r.OrderByDescending(o=>o.DevDate);
}
}
if(c.sortname.ToLower().Equals("important")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Important);
}else{
r = r.OrderByDescending(o=>o.Important);
}
}
if(c.sortname.ToLower().Equals("equipments")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Equipments);
}else{
r = r.OrderByDescending(o=>o.Equipments);
}
}
if(c.sortname.ToLower().Equals("daojishipai")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.DaoJiShiPai);
}else{
r = r.OrderByDescending(o=>o.DaoJiShiPai);
}
}
if(c.sortname.ToLower().Equals("jiaoshibiaoyu")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.JiaoShiBiaoYu);
}else{
r = r.OrderByDescending(o=>o.JiaoShiBiaoYu);
}
}
if(c.sortname.ToLower().Equals("shushibiaoyu")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.ShuShiBiaoYu);
}else{
r = r.OrderByDescending(o=>o.ShuShiBiaoYu);
}
}
if(c.sortname.ToLower().Equals("shitangbiaoyu")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.ShiTangBiaoYu);
}else{
r = r.OrderByDescending(o=>o.ShiTangBiaoYu);
}
}
if(c.sortname.ToLower().Equals("loutibiaoyu")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.LouTiBiaoYu);
}else{
r = r.OrderByDescending(o=>o.LouTiBiaoYu);
}
}
if(c.sortname.ToLower().Equals("butiao")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.BuTiao);
}else{
r = r.OrderByDescending(o=>o.BuTiao);
}
}
if(c.sortname.ToLower().Equals("address")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Address);
}else{
r = r.OrderByDescending(o=>o.Address);
}
}
if(c.sortname.ToLower().Equals("highclassqty")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.HighClassQty);
}else{
r = r.OrderByDescending(o=>o.HighClassQty);
}
}
if(c.sortname.ToLower().Equals("highstudentqty")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.HighStudentQty);
}else{
r = r.OrderByDescending(o=>o.HighStudentQty);
}
}
if(c.sortname.ToLower().Equals("lowclassqty")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.LowClassQty);
}else{
r = r.OrderByDescending(o=>o.LowClassQty);
}
}
if(c.sortname.ToLower().Equals("lowstudentqty")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.LowStudentQty);
}else{
r = r.OrderByDescending(o=>o.LowStudentQty);
}
}
if(c.sortname.ToLower().Equals("remark")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Remark);
}else{
r = r.OrderByDescending(o=>o.Remark);
}
}
if(c.sortname.ToLower().Equals("oldoahuwaiid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.OldOaHuWaiId);
}else{
r = r.OrderByDescending(o=>o.OldOaHuWaiId);
}
}
}
m.RecordCount = r.Count();
if (c.pagesize.HasValue) {
int page = c.page ?? 1;
int pageCount = m.RecordCount / c.pagesize.Value;
if (m.RecordCount % c.pagesize.Value > 0) {
pageCount++;
}
int skip = (page - 1) * c.pagesize.Value;
if (skip > 0) {
r = r.Skip(skip);
}
r = r.Take(c.pagesize.Value);
}
m.Data = r.ToList();
return m;
}
public ActionResult GetData(SchoolCriteria c)
{
var m = new LigerGridModel();
this.BeforeGetData(c);
var r = this.Service.FindByCriteria(c);
this.AfterGetData(m, c, r);
m.Total = r.RecordCount;
r.Data.ForEach(o => {
this.AddRowToGridModel(m, o);
});
this.AfterBuildGridModel(m, c, r);
return this.Json(m, JsonRequestBehavior.AllowGet);
}
partial void AfterGetData(LigerGridModel gm, SchoolCriteria c, PagedModel<School> pm);
partial void BeforeGetData(SchoolCriteria c);
partial void AfterBuildGridModel(LigerGridModel gm, SchoolCriteria c, PagedModel<School> pm);
