public List <StudentEval> GetPageData(SearchModel <StudentEval> search, out int count) { GetPageListParameter <StudentEval, string> parameter = new GetPageListParameter <StudentEval, string>(); parameter.isAsc = true; parameter.orderByLambda = t => t.StudentNo; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; parameter.whereLambda = t => !string.IsNullOrEmpty(t.StudentNo); //查询数据 if (!string.IsNullOrEmpty(search.Entity.PEM)) { Expression <Func <StudentEval, bool> > Where = item => item.PEM == search.Entity.PEM; parameter.whereLambda = ExpressionExt.ReBuildExpression <StudentEval>(parameter.whereLambda, Where); } if (!string.IsNullOrEmpty(search.Entity.PRM)) { Expression <Func <StudentEval, bool> > Where = item => item.PRM == search.Entity.PRM; parameter.whereLambda = ExpressionExt.ReBuildExpression <StudentEval>(parameter.whereLambda, Where); } DBBaseService baseService = new DBBaseService(SurveyContext.Instance); List <StudentEval> list = baseService.GetSimplePagedData <StudentEval, string>(parameter, out count); return(list); }
/// <summary> /// 分页查询,代码 /// </summary> /// <param name="search"></param> /// <param name="count"></param> /// <returns></returns> public List <SurveyModel> GetPageData(SearchModel <SurveyModel> search, out int count) { GetPageListParameter <SurveyModel, int> parameter = new GetPageListParameter <SurveyModel, int>(); parameter.isAsc = true; parameter.orderByLambda = t => t.SurveyID; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; if (search.RoleName == "学生" || search.RoleName == "项目组组长" || search.RoleName == "技术主管" || search.RoleName == "项目主管" || search.RoleName == "人事主管") { Expression <Func <SurveyModel, bool> > lambda0 = item => item.Status != 1; Expression <Func <SurveyModel, bool> > lambda1 = item => item.StuName == search.UserName; //合并表达式 parameter.whereLambda = ExpressionExt.ReBuildExpression <SurveyModel>(lambda0, lambda1); } else if (search.RoleName == "人事经理") { Expression <Func <SurveyModel, bool> > lambda0 = item => item.Status != 1; Expression <Func <SurveyModel, bool> > lambda1 = item => item.PEM == search.UserName && (item.AuditName == item.PEM || string.IsNullOrEmpty(item.AuditName) || item.AuditStatus == 3); //合并表达式 parameter.whereLambda = ExpressionExt.ReBuildExpression <SurveyModel>(lambda0, lambda1); } else if (search.RoleName == "项目经理") { Expression <Func <SurveyModel, bool> > lambda0 = item => item.Status != 1; Expression <Func <SurveyModel, bool> > lambda1 = item => item.PRM == search.UserName; //合并表达式 parameter.whereLambda = ExpressionExt.ReBuildExpression <SurveyModel>(lambda0, lambda1); } else { Expression <Func <SurveyModel, bool> > lambda0 = item => item.Status != 1; Expression <Func <SurveyModel, bool> > lambda1 = item => item.AuditName == search.UserName || item.AuditStatus == 3; //合并表达式 parameter.whereLambda = ExpressionExt.ReBuildExpression <SurveyModel>(lambda0, lambda1); } if (!string.IsNullOrEmpty(search.Entity.Batch)) { Expression <Func <SurveyModel, bool> > batchWhere = item => item.Batch == search.Entity.Batch; parameter.whereLambda = ExpressionExt.ReBuildExpression <SurveyModel>(parameter.whereLambda, batchWhere); } if (!string.IsNullOrEmpty(search.Entity.ProjectName)) { Expression <Func <SurveyModel, bool> > projectNameWhere = item => item.ProjectName == search.Entity.ProjectName; parameter.whereLambda = ExpressionExt.ReBuildExpression <SurveyModel>(parameter.whereLambda, projectNameWhere); } if (!string.IsNullOrEmpty(search.Entity.Direction)) { Expression <Func <SurveyModel, bool> > directionWhere = item => item.Direction == search.Entity.Direction; parameter.whereLambda = ExpressionExt.ReBuildExpression <SurveyModel>(parameter.whereLambda, directionWhere); } //查询数据 DBBaseService baseService = new DBBaseService(SurveyContext.Instance); List <SurveyModel> list = baseService.GetSimplePagedData <SurveyModel, int>(parameter, out count); return(list); }
/// <summary> /// 分页查询的方法 /// </summary> /// <param name="search"></param> /// <param name="count"></param> /// <returns></returns> public object GetPageData(SearchModel <Dictionary> search, out int count) { GetPageListParameter <Dictionary, int> parameter = new GetPageListParameter <Dictionary, int>(); parameter.isAsc = true; parameter.orderByLambda = t => t.ID; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; parameter.whereLambda = t => t.ID != 0; DBBaseService baseService = new DBBaseService(SurveyContext.Instance); List <Dictionary> list = baseService.GetSimplePagedData <Dictionary, int>(parameter, out count); return(list); }
public object GetPageData(SearchModel <Task> search, out int count) { GetPageListParameter <Task, int> parameter = new GetPageListParameter <Task, int>(); parameter.isAsc = true; parameter.orderByLambda = t => t.TaskID; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; parameter.whereLambda = t => t.TaskID != 0; DateLoginTask indsentes = new DateLoginTask(); DBBaseService baseService = new DBBaseService(indsentes); List <Task> list = baseService.GetSimplePagedData <Task, int>(parameter, out count); return(list); }
/// <summary> /// 分页 /// </summary> /// <param name="search"></param> /// <param name="count"></param> /// <returns></returns> public object GetPageData(SearchModel <trashtype> search, out int count) { GetPageListParameter <trashtype, int> parameter = new GetPageListParameter <trashtype, int>(); parameter.isAsc = true; parameter.orderByLambda = t => t.typeId; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; parameter.whereLambda = t => t.typeId != 0; Model1 Instance = new Model1(); DBBaseService baseService = new DBBaseService(Instance); List <trashtype> list = baseService.GetSimplePagedData <trashtype, int>(parameter, out count); return(list); }
/// <summary> /// 分页 /// </summary> /// <param name="model"></param> /// <param name="count"></param> /// <returns></returns> public object GetpaheData(SearchModel <BookInfo> model, out int count) { GetPageListParameter <BookInfo, int> parameter = new GetPageListParameter <BookInfo, int>(); parameter.isAsc = true; parameter.orderByLambda = a => a.BookID; parameter.pageIndex = model.PageIndex; parameter.pageSize = model.PageSize; parameter.whereLambda = a => a.BookID != 0; Model1 Instance = new Model1(); DBBaseService baseService = new DBBaseService(Instance); List <BookInfo> list = baseService.GetSimplePagedData <BookInfo, int>(parameter, out count); return(list); }
public object GetPageData(SearchModel <Login_Info> search, out int count) { GetPageListParameter <Login_Info, int> par = new GetPageListParameter <Login_Info, int>(); par.isAsc = true; par.orderByLambda = t => t.UserId; par.pageIndex = search.PageIndex; par.pageSize = search.PageSize; par.whereLambda = t => t.UserId != 0; user_model Instance = new user_model(); DBBaseService baseService = new DBBaseService(Instance); List <Login_Info> list = baseService.GetSimplePagedData <Login_Info, int>(par, out count); return(list); }
public object GetPageData(SearchModel <StuInfo> search, out int count) { GetPageListParameter <StuInfo, int> parameter = new GetPageListParameter <StuInfo, int>(); parameter.isAsc = true; parameter.orderByLambda = t => t.StuID; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; parameter.whereLambda = t => t.StuID != 0; XITDataModel1 indsentes = new XITDataModel1(); DBBaseService baseService = new DBBaseService(indsentes); List <StuInfo> list = baseService.GetSimplePagedData <StuInfo, int>(parameter, out count); return(list); }
public List <PayRequest> GetPageData(SearchModel <PayRequest> search, out int count) { GetPageListParameter <PayRequest, string> parameter = new GetPageListParameter <PayRequest, string>(); parameter.isAsc = true; parameter.orderByLambda = t => t.DormNo; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; parameter.whereLambda = t => !string.IsNullOrEmpty(t.PID); //查询数据 DBBaseService baseService = new DBBaseService(FlatContext.Instance); List <PayRequest> list = baseService.GetSimplePagedData <PayRequest, string>(parameter, out count); foreach (var request in list) { request.StatusStr = EnumDescriptionAttribute.GetDescription((PayRequestStatus)request.Status); request.RealPayMoney = request.Payment.Sum(r => r.PayMoney); } return(list); }
public List <Dorm> GetPageData(SearchModel <Dorm> search, out int count) { GetPageListParameter <Dorm, string> parameter = new GetPageListParameter <Dorm, string>(); parameter.isAsc = true; parameter.orderByLambda = t => t.DormNo; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; parameter.whereLambda = t => t.Status > -1; //查询数据 DBBaseService baseService = new DBBaseService(FlatContext.Instance); List <Dorm> list = baseService.GetSimplePagedData <Dorm, string>(parameter, out count); foreach (var dorm in list) { dorm.SizeStr = EnumDescriptionAttribute.GetDescription((DormSize)dorm.DormSize); dorm.StatusStr = EnumDescriptionAttribute.GetDescription((DormStatus)dorm.Status); dorm.TypeStr = EnumDescriptionAttribute.GetDescription((DormType)dorm.DormType); dorm.DormJsonStr = JsonConvert.SerializeObject(dorm); } return(list); }
public object GetPageData(SearchModel <PositionExt> search, out int count) { GetPageListParameter <PositionExt, int> parameter = new GetPageListParameter <PositionExt, int>(); parameter.isAsc = true; //parameter.orderByLambda = t => t.PositionID; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; //parameter.whereLambda = t => t.PositionID > 0; DBBaseService baseService = new DBBaseService(SurveyContext.Instance); string sqlwhere = " where 1=1 "; string sql = @"SELECT p.*,c.CompanyName ,c.CompanyType FROM dbo.[Position] p left join dbo.[SurveyModel] s on p.SurveyID = s.SurveyID left join dbo.[Company] c on c.CompanyID = s.CompanyID"; if (!string.IsNullOrEmpty(search.Entity.PositionType)) { sqlwhere += string.Format(" and PositionType='{0}'", search.Entity.PositionType); } if (!string.IsNullOrEmpty(search.Entity.Source)) { sqlwhere += string.Format(" and Source ='{0}'", search.Entity.Source); } sql = string.Format("{0}{1}", sql, sqlwhere); List <PositionExt> list = baseService.GetSqlPagedData <PositionExt, int>(sql, parameter, out count); foreach (PositionExt position in list) { //查询对应职位的标签。 position.Tags = this.GetTagsByPositionID(position.PositionID); if (position.Tags.Count > 0) { position.TagsJsonStr = JsonConvert.SerializeObject(position.Tags.Select(r => r.TagName).ToList()); } } return(list); }
public object GetPageData(SearchModel <SkillTag> search, out int count) { GetPageListParameter <SkillTag, string> parameter = new GetPageListParameter <SkillTag, string>(); parameter.isAsc = true; parameter.orderByLambda = t => t.TagID; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; parameter.whereLambda = t => t.TagID != ""; if (!string.IsNullOrEmpty(search.Entity.Direction)) { Expression <Func <SkillTag, bool> > Where = item => item.Direction == search.Entity.Direction; parameter.whereLambda = ExpressionExt.ReBuildExpression <SkillTag>(parameter.whereLambda, Where); } if (!string.IsNullOrEmpty(search.Entity.TagType)) { Expression <Func <SkillTag, bool> > Where = item => item.TagType == search.Entity.TagType; parameter.whereLambda = ExpressionExt.ReBuildExpression <SkillTag>(parameter.whereLambda, Where); } DBBaseService baseService = new DBBaseService(SurveyContext.Instance); List <SkillTag> list = baseService.GetSimplePagedData <SkillTag, string>(parameter, out count); return(list); }
public object GetMatchPageData(SearchModel <PositionMatchModel> search, out int count) { GetPageListParameter <PositionMatchModel, int> parameter = new GetPageListParameter <PositionMatchModel, int>(); parameter.isAsc = true; //parameter.orderByLambda = t => t.PositionID; parameter.pageIndex = search.PageIndex; parameter.pageSize = search.PageSize; //parameter.whereLambda = t => t.PositionID > 0; DBBaseService baseService = new DBBaseService(SurveyContext.Instance); string sql = @"select * from (SELECT ISNULL(aj.AvageMoney,0) as AvageMoney,tt.Skills,(select count(*) from dbo.SkillTags st where st.PositionID = p.PositionID) skillCount,aj.StartTime,p.*,c.CompanyName,c.City,c.CompanyType FROM dbo.ActiveJobs aj left join dbo.[Position] p on aj.PositionID = p.PositionID left join (select st.PositionID,Skills = ( stuff( (select ',' + TagName from SkillTags tst left join SkillTag t on tst.TagID=t.TagID where PositionID = st.PositionID order by t.TagName for xml path('')), 1,1,'') ) from SkillTags as st group by st.PositionID) tt on tt.PositionID = p.PositionID left join dbo.[SurveyModel] s on p.SurveyID = s.SurveyID left join dbo.[Company] c on c.CompanyID = s.CompanyID) t"; string sqlWhere = " where 1=1 "; int skillcount = 0; string studentTagStr = ""; List <string> tags = new List <string>(); if (search.Entity.Point > 0) { var matchs = context.StudentTags.Where(r => r.StudentName == search.UserName && r.TeacherPoint > search.Entity.Point).ToList(); skillcount = matchs.Count(); tags = matchs.OrderBy(r => r.SkillTag.TagName).Select(r => r.SkillTag.TagName).ToList(); studentTagStr = string.Join(",", tags); } int totalSkillNeed = 0; float realSkillNeed = 0; if (search.Entity.Percent >= 0 && skillcount > 0) { //默认70 if (search.Entity.Percent == 0) { search.Entity.Percent = 70; } totalSkillNeed = skillcount * 100 / search.Entity.Percent; realSkillNeed = skillcount * (((float)search.Entity.Percent) / 100); sqlWhere += " and skillCount <=" + totalSkillNeed; } if (!string.IsNullOrEmpty(search.Entity.City)) { sqlWhere += string.Format(" and t.City ='{0}'", search.Entity.City); } if (search.Entity.Salary > 0) { sqlWhere += " and t.AvageMoney <=" + search.Entity.Salary; } List <PositionExt> list = new List <PositionExt>(); count = 0; if (!string.IsNullOrEmpty(studentTagStr)) { List <string> realNeedTags = tags.Take((int)realSkillNeed).ToList(); string realNeedSkillStr = string.Join(",", realNeedTags); sqlWhere += string.Format(" and t.Skills like '%{0}%'", realNeedSkillStr); sql = string.Format("{0}{1}", sql, sqlWhere); list = baseService.GetSqlPagedData <PositionExt, PositionMatchModel, int>(sql, parameter, out count); } //标签的匹配度 精确匹配度,判断匹配的数量 //foreach (PositionExt position in list) //{ // //查询对应职位的标签。 // position.Tags = this.GetTagsByPositionID(position.PositionID); // if (position.Tags.Count > 0) // { // position.TagsJsonStr = JsonConvert.SerializeObject(position.Tags.Select(r => r.TagName).ToList()); // } //} return(list); }