/// <summary>
/// 获取评审意见
/// </summary>
/// <param name="meetingId"></param>
/// <returns></returns>
public static List <mMeetingOpinion> GetMeetingOpinion(string meetingId)
{
List <mMeetingOpinion> list = new List <mMeetingOpinion>();
string sql = @"select p.Id,p.MeetingId,p.UserId,u.UserName,u.Autograph,
Isnull(m.OpinionAction,0) OpinionAction,m.OpinionMsg from m_MeetingPeople p
left join m_MeetingOpinion m on p.MeetingId=m.MeetingId and p.UserId=m.UserId
join m_User u on p.UserId=u.UserId where p.MeetingId=@meetingId;";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@meetingId", meetingId),
};
using (SqlDataReader reader = SQLHelper.GetReader(sql, paras))
{
mMeetingOpinion model = null;
while (reader.Read())
{
model = new mMeetingOpinion();
model.Id = Convert.ToInt32(reader["Id"]);
model.OpinionAction = Convert.ToInt32(reader["OpinionAction"]);
model.OpinionMsg = reader["OpinionMsg"].ToString();
model.Autograph = reader["Autograph"].ToString();
model.UserName = reader["UserName"].ToString();
list.Add(model);
}
}
return(list);
}
public static mMeetingOpinion GetMeetingOpinion(int userId, string meetingId)
{
string sql = "select * from m_MeetingOpinion where MeetingId=@meetingId and UserId=@userId";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@userId", userId),
new SqlParameter("@meetingId", meetingId)
};
mMeetingOpinion model = new mMeetingOpinion();
using (SqlDataReader reader = SQLHelper.GetReader(sql, paras))
{
if (reader.Read())
{
model.OpinionMsg = reader["OpinionMsg"].ToString();
model.Id = Convert.ToInt32(reader["Id"]);
}
}
return(model);
}
