public List <EvalStudent> GetStudentsByBatchs(string batch, string direction, string projectName)
{
string sql = @"select * from (
select s.StudentNo,m.Name as mName,year(b.CheckInTime) as bYear,
s.Name,s.Mobile,s.[Address],s.EducationBackground as GraduateSchool ,p.Name as pName,isnull(p.periodType,1) as periodType,
(select RealName from Member me where me.Id = p.PeopleManagerId) as PEM,
(select RealName from Member me where me.Id = p.ProjectManagerId) as PRM,
p.Classroom,b.Name as bName from Student s
left join ProjectDepartment p on s.ProjectDepartmentId = p.Id
left join Batch b on p.BatchId = b.Id
left join Major m on p.MajorId = m.Id
) t where t.bName = @bName";
if (!string.IsNullOrEmpty(direction))
{
sql += " and t.mName = @mName";
}
if (!string.IsNullOrEmpty(projectName))
{
sql += " and t.pName = @pName";
}
EvalStudent stu = new EvalStudent();
stu.bName = batch;
stu.mName = direction;
stu.pName = projectName;
List <EvalStudent> result = DapperDBHelper.Instance.ExcuteQuery <EvalStudent>(sql, stu).OrderBy(r => r.Name).ToList();
return(result);
}
public DeluxeJsonResult AddEvalPoint(StudentTagsModel model)
{
HPITMemberInfo currentUser = DeluxeUser.CurrentMember;
string stuNo = "";
if (currentUser.FullName != "学生" && currentUser.FullName != "项目组组长" && currentUser.FullName != "技术主管" && currentUser.FullName != "项目主管" && currentUser.FullName != "人事主管")
{
return(new DeluxeJsonResult(new { data = "只能学生进行技术评估", status = 403 }));
}
List <EvalStudent> matchList = EvaluteDal.Instance.GetMatchStudent(currentUser.RealName, "");
StudentEval studentEval = new StudentEval();
if (matchList.Count == 1)
{
EvalStudent match = matchList.FirstOrDefault();
stuNo = match.StudentNo;
studentEval.PEM = match.PEM;
studentEval.PRM = match.PRM;
}
foreach (var stag in model.tags)
{
stag.StudentName = currentUser.RealName;
stag.StudentNo = stuNo;
}
studentEval.StudentName = currentUser.RealName;
studentEval.StudentNo = stuNo;
studentEval.Direction = model.positionName;
studentEval.CreateTime = DateTime.Now;
studentEval.Score = model.tags.Sum(r => r.SelfPoint);
var result = StudentDal.Instance.AddStudentTags(stuNo, model.tags, studentEval);
return(new DeluxeJsonResult(new { data = result, status = 200 }));
}
public DeluxeJsonResult StartStudentNewSurvey(string stuNo)
{
AbstractFormModel <SurveyModel> result = SurveyDal.Instance.StartNewSurvey();
result.Form.Type = (int)SurveyType.Student;
HPITMemberInfo currentUser = DeluxeUser.CurrentMember;
result.CurrentRole = DeluxeUser.CurrentMember;
if (currentUser.FullName == "项目组组长" || currentUser.FullName == "技术主管" || currentUser.FullName == "项目主管" || currentUser.FullName == "人事主管")
{
result.CurrentRole.FullName = "学生";
}
//根据学生编号创建新的
List <EvalStudent> matchList = EvaluteDal.Instance.GetMatchStudent(currentUser.RealName, "");
if (matchList.Count == 1)
{
EvalStudent match = matchList.FirstOrDefault();
result.Form.ProjectName = match.pName;
result.Form.StudentNo = match.StudentNo;
result.Form.StuName = match.Name;
result.Form.Phone = match.Mobile;
result.Form.Direction = match.mName;
result.Form.Year = match.bYear;
result.Form.School = match.GraduateSchool;
result.Form.Batch = match.bName;
result.Form.PRM = match.PRM;
result.Form.PEM = match.PEM;
}
return(new DeluxeJsonResult(result));
}
public void OnAuthentication(AuthenticationContext filterContext)
{
//如果action 和 controller的添加的特性里面包含匿名的，则直接过滤掉。
if (filterContext.ActionDescriptor.IsDefined(typeof(AllowAnonymousAttribute), inherit: true) ||
filterContext.ActionDescriptor.ControllerDescriptor.IsDefined(typeof(AllowAnonymousAttribute), inherit: true))
{
return;
}
//获取请求上下问的context
var Url = new UrlHelper(filterContext.RequestContext);
//获取登录的url
var urlstr = Url.Action("Index", "Login");
//filterContext.Result = new RedirectResult(urlstr); //指定返回重定向登录界面
//HttpCookie cokie = filterContext.HttpContext.Request.Cookies.Get("Login");
//获取cookie 的名字
string cookieName = FormsAuthentication.FormsCookieName;
//当前context 里面取cookie
HttpCookie authCookie = filterContext.HttpContext.Request.Cookies[cookieName];
//cookie为空 返回登录页面
if (authCookie == null)
{
filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary
{
{ "controller", "Login" },
{ "action", "Index" },
{ "returnUrl", filterContext.HttpContext.Request.RawUrl }
});
}
else
{
//定义票据
FormsAuthenticationTicket authTicket = null;
try
{
//解密cookie的票据信息
authTicket = FormsAuthentication.Decrypt(authCookie.Value);
}
catch (Exception ex)
{
LogHelper.Default.WriteError(ex.Message);
}
if (authTicket != null)
{
//反序列化json 放到当前用户信息
DeluxeUser.CurrentMember = JsonConvert.DeserializeObject <HPITMemberInfo>(authTicket.UserData);
EvalStudent match = EvaluteDal.Instance.GetMatchStudent(DeluxeUser.CurrentMember.RealName);
//查询当前用户 如果是学生的话 培训周期period(1,2,3,4) , 学号
if (match != null)
{
DeluxeUser.CurrentMember.Period = match.periodType;
DeluxeUser.CurrentMember.StuNo = match.StudentNo;
DeluxeUser.CurrentMember.ProjectName = match.pName;
}
LogHelper.Default.WriteInfo(DeluxeUser.CurrentMember.RealName + "登录了系统" + filterContext.ActionDescriptor.ActionName + "--" + filterContext.ActionDescriptor.ControllerDescriptor.ControllerName);
}
}
}
public DeluxeJsonResult Save(SurveyModel model)
{
List <EvalStudent> matchList = EvaluteDal.Instance.GetMatchStudent(model.StuName, "");
if (matchList.Count == 1)
{
EvalStudent match = matchList.FirstOrDefault();
model.PRM = !string.IsNullOrEmpty(model.PRM) ? model.PRM: match.PRM;
model.PEM = !string.IsNullOrEmpty(model.PEM) ? model.PEM : match.PEM;
}
var result = SurveyDal.Instance.Create(model);
return(new DeluxeJsonResult(result));
}
public List <string> GetProjectNames()
{
string sql = @"select * from (
select s.StudentNo,m.Name as mName,year(b.CheckInTime) as bYear,
s.Name,s.Mobile,s.[Address],s.EducationBackground as GraduateSchool ,p.Name as pName,
(select RealName from Member me where me.Id = p.PeopleManagerId) as PEM,
(select RealName from Member me where me.Id = p.ProjectManagerId) as PRM,
p.Classroom,b.Name as bName from Student s
left join ProjectDepartment p on s.ProjectDepartmentId = p.Id
left join Batch b on p.BatchId = b.Id
left join Major m on p.MajorId = m.Id
) t";
EvalStudent stu = new EvalStudent();
List <EvalStudent> result = DapperDBHelper.Instance.ExcuteQuery <EvalStudent>(sql, stu).ToList();
List <string> data = result.Where(r => !string.IsNullOrEmpty(r.pName)).Select(r => r.pName).Distinct().ToList();
return(data);
}
public List <EvalStudent> GetMatchStudentByNo(string StudentNo)
{
string sql = @"select * from (
select s.StudentNo,m.Name as mName,year(b.CheckInTime) as bYear,
s.Name,s.Mobile,s.[Address],s.GraduateSchool,p.Name as pName,
(select RealName from Member me where me.Id = p.PeopleManagerId) as PEM,
(select RealName from Member me where me.Id = p.ProjectManagerId) as PRM,
p.Classroom,b.Name as bName from Student s
left join ProjectDepartment p on s.ProjectDepartmentId = p.Id
left join Batch b on p.BatchId = b.Id
left join Major m on p.MajorId = m.Id ) t where StudentNo=@StudentNo";
EvalStudent stu = new EvalStudent();
stu.StudentNo = StudentNo;
List <EvalStudent> result = DapperDBHelper.Instance.ExcuteQuery <EvalStudent>(sql, stu).ToList();
return(result);
}
public EvalStudent GetMatchStudent(string name, string classNo = "")
{
string sql = @"select * from (
select s.StudentNo,m.Name as mName,year(b.CheckInTime) as bYear,
s.Name,s.Mobile,s.[Address],s.EducationBackground as GraduateSchool ,p.Name as pName,isnull(p.periodType,1) as periodType,
(select RealName from Member me where me.Id = p.PeopleManagerId) as PEM,
(select RealName from Member me where me.Id = p.ProjectManagerId) as PRM,
p.Classroom,b.Name as bName from Student s
left join ProjectDepartment p on s.ProjectDepartmentId = p.Id
left join Batch b on p.BatchId = b.Id
left join Major m on p.MajorId = m.Id
) t where Name=@Name or pName=@ClassName";
EvalStudent stu = new EvalStudent();
stu.Name = name;
stu.ClassName = classNo;
EvalStudent result = DapperDBHelper.Instance.ExcuteQuery <EvalStudent>(sql, stu).ToList().FirstOrDefault();
return(result);
}
