public ViewApproveUserSurvey GetApproveUserSurvey(int userSurveyId)
{
var selectSql = @"SELECT usy.UserSurveyId, u.Realname,u.UserId,si.SurveyTitle,d.LevelPath AS DeptName,p.PostName,si.StartTime,si.EndTime,usy.ApproveFlag,usy.ApproveReason,usy.ApproveTime
FROM Cde_UserSurvey usy
LEFT JOIN Cde_SurveyInfo si ON usy.SurveyId=si.SurveyId
LEFT JOIN Sys_Users u ON usy.UserId=u.UserId
LEFT JOIN Sys_Department d ON u.DeptId=d.DeptId
LEFT JOIN Sys_Posts p ON u.PostId=p.PostId
WHERE usy.UserSurveyId=" + userSurveyId;
var sendUsers = _dataAccess.GetList <Cde_SurveySendUsers>("Cde_SurveySendUsers.UserSurveyId=" + userSurveyId);
var model = _dataAccess.FetchListBySql <ViewApproveUserSurvey>(selectSql).FirstOrDefault();
if (model == null)
{
model = new ViewApproveUserSurvey();
}
model.SendUsers.AddRange(sendUsers);
return(model);
}
public ActionResult ApproveUserSurveyDetail(int userSurveyId)
{
ViewApproveUserSurvey model = _userSurveyManager.GetApproveUserSurvey(userSurveyId);
return(View(model));
}