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