/// <summary>
/// 显示某个员工反馈项
/// </summary>
/// <param name="courseId"></param>
/// <param name="employeeId"></param>
/// <returns></returns>
public List <TraineeFBItem> GetTraineeFBItems(int courseId, int employeeId)
{
_EmployeeId = employeeId;
Course temp = GetTrainCourseByPKID(courseId);
TrainEmployeeFB employeeFb = temp.TrainFBResult.TrainEmployeeFBs.Find(FindEmployeeFB);
if (employeeFb.FBItem.Count == 0 || employeeFb.FBItem == null)
{
foreach (FBPaperItem item in temp.TrainFBResult.FBPaperItem)
{
TraineeFBItem traineeItem = new TraineeFBItem();
traineeItem.FBPaperItemId = item.FBPaperItemId;
traineeItem.FBQuestion = item.FBQuestion;
traineeItem.FBQueItems = item.FBQueItems;
traineeItem.Worths = item.Worths;
employeeFb.FBItem.Add(traineeItem);
}
}
else
{
foreach (FBPaperItem item in temp.TrainFBResult.FBPaperItem)
{
foreach (TraineeFBItem traineeItem in employeeFb.FBItem)
{
if (traineeItem.FBPaperItemId == item.FBPaperItemId)
{
traineeItem.FBQuestion = item.FBQuestion;
traineeItem.FBQueItems = item.FBQueItems;
traineeItem.Worths = item.Worths;
}
}
}
}
return(employeeFb.FBItem);
}
/// <summary>
/// 新增课程培训人员反馈
/// </summary>
/// <param name="courseId"></param>
/// <param name="item"></param>
/// <param name="account"></param>
private static void InsertCourseFBResult(int courseId, TraineeFBItem item, Account account)
{
int pkid;
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Parameters.Add(_PKID, SqlDbType.Int).Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(_CourseID, SqlDbType.Int).Value = courseId;
sqlCommand.Parameters.Add(_CourseFBID, SqlDbType.Int).Value = item.FBPaperItemId;
sqlCommand.Parameters.Add(_TraineeID, SqlDbType.Int).Value = account.Id;
sqlCommand.Parameters.Add(_TraineeName, SqlDbType.NVarChar, 50).Value = account.Name;
sqlCommand.Parameters.Add(_TraineeScore, SqlDbType.Int).Value = item.Grade;
SqlHelper.ExecuteNonQueryReturnPKID("CourseFBResultInsert", sqlCommand, out pkid);
}
private static List <TraineeFBItem> GetEmployeeFBItem(int trainneeId, int courseId)
{
List <TraineeFBItem> fbItems = new List <TraineeFBItem>();
SqlCommand sqlCommmand = new SqlCommand();
sqlCommmand.Parameters.Add(_CourseID, SqlDbType.Int).Value = courseId;
sqlCommmand.Parameters.Add(_TraineeID, SqlDbType.Int).Value = trainneeId;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetCourseFBResultByCourseIDAndTraineeID", sqlCommmand))
{
while (sdr.Read())
{
TraineeFBItem item = new TraineeFBItem();
item.Grade = Convert.ToInt32(sdr[_DBTraineeScore]);
item.FBPaperItemId = Convert.ToInt32(sdr[_DBCourseFBID]);
fbItems.Add(item);
}
}
return(fbItems);
}
