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