/// <summary>
/// 调用下层的新增课程的方法
/// </summary>
protected override void ExcuteSelf()
{
try
{
_Course.Skill = new List <Skill>();
foreach (Skill skill in _Skills)
{
_Course.Skill.Add(skill);
}
_Course.TrainFBResult = new TrainFBResult();
_Course.TrainFBResult.FBPaperItem = GetFBItem();
_Course.TrainFBResult.TrainEmployeeFBs = new List <TrainEmployeeFB>();
foreach (Account employee in _Employees)
{
TrainEmployeeFB employeeFb = new TrainEmployeeFB(null, string.Empty);
employeeFb.Trainee = employee;
_Course.TrainFBResult.TrainEmployeeFBs.Add(employeeFb);
}
_Course.Coordinator = _ItsCordinator;
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required))
{
_DalTrain.InsertTrainCourse(_Course);
ts.Complete();
}
new AddCourseSendMail(_Employees, _Course).Excute();
}
catch
{
BllUtility.ThrowException(BllExceptionConst._DbError);
}
}
/// <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);
}
private bool FindEndCourse(TrainEmployeeFB fb)
{
try
{
Course course = _ITrainFacade.GetTrainCourseByPKID(fb.CourseId);
if (course.Status == TrainStatusEnum.End)
{
return(true);
}
}
catch (Exception ae)
{
_ItsView.ErrorMessage = ae.Message;
}
return(false);
}
/// <summary>
/// 新增课程培训人员
/// </summary>
/// <param name="courseId"></param>
/// <param name="courseName"></param>
/// <param name="fb"></param>
private static void InsertCourseTrainee(int courseId, string courseName, TrainEmployeeFB fb)
{
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(_CourseName, SqlDbType.NVarChar, 200).Value = courseName;
sqlCommand.Parameters.Add(_TraineeID, SqlDbType.Int).Value = fb.Trainee.Id;
sqlCommand.Parameters.Add(_TraineeName, SqlDbType.NVarChar, 50).Value = fb.Trainee.Name;
sqlCommand.Parameters.Add(_FBTime, SqlDbType.DateTime).Value = fb.FBTime;
sqlCommand.Parameters.Add(_TrainFBAllScore, SqlDbType.Decimal).Value = fb.Score;
sqlCommand.Parameters.Add(_Suggestion, SqlDbType.Text).Value = fb.Remark;
sqlCommand.Parameters.Add(_TrainFBStatus, SqlDbType.Int).Value = 1; //反馈
sqlCommand.Parameters.Add(_CertificationName, SqlDbType.NVarChar, 50).Value = fb.CertificationName;
SqlHelper.ExecuteNonQueryReturnPKID("CourseTraineeInsert", sqlCommand, out pkid);
}
private void FillFeedBackEvent()
{
TrainEmployeeFB employeeFB = new TrainEmployeeFB(DateTime.Now, _ItsView.Comment);
employeeFB.CertificationName = _ItsView.CertificationName;
employeeFB.Trainee = _Trainee;
employeeFB.FBItem = _ItsView.FBItem;
try
{
_ITrainFacade.AddCourseFeedBack(_CourseId, employeeFB);
//_FeedBack.Excute();
_ItsView.returnLastPage = true;
}
catch (Exception ex)
{
_ItsView.ErrorMessage = ex.Message;
}
}
private List <TrainEmployeeFB> GetCourseTrainnee(int courseId)
{
List <TrainEmployeeFB> trainees = new List <TrainEmployeeFB>();
SqlCommand sqlCommmand = new SqlCommand();
sqlCommmand.Parameters.Add(_CourseID, SqlDbType.Int).Value = courseId;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetCourseTraineeByCourseID", sqlCommmand))
{
while (sdr.Read())
{
TrainEmployeeFB employeeFB;
if (sdr[_DBFBTime] == DBNull.Value)
{
employeeFB = new TrainEmployeeFB(null, sdr[_DBSuggestion].ToString());
}
else
{
employeeFB = new TrainEmployeeFB(Convert.ToDateTime(sdr[_DBFBTime]),
sdr[_DBSuggestion].ToString());
}
employeeFB.TrainEmployeeFBID = Convert.ToInt32(sdr[_DBPKID]);
//employeeFB.Trainee = _EmployeeDal.GetEmployeeByAccountID(Convert.ToInt32(sdr[_DBTraineeID]));
employeeFB.Trainee = new Account();
employeeFB.Trainee.Id = Convert.ToInt32(sdr[_DBTraineeID]);
employeeFB.Trainee.Name = sdr[_DBTraineeName].ToString();
employeeFB.Score = Convert.ToDecimal(sdr[_DBTrainFBAllScore]);
if (sdr[_DBCertificationName] != DBNull.Value)
{
employeeFB.CertificationName = sdr[_DBCertificationName].ToString();
}
trainees.Add(employeeFB);
}
}
return(trainees);
}
public List <Course> GetCourseTrainneeByCondition(int traineeID, int courseId, string courseName, string traineeName,
int status, DateTime?startTime, DateTime?endTime)
{
List <Course> courses = new List <Course>();
SqlCommand sqlCommmand = new SqlCommand();
sqlCommmand.Parameters.Add(_TraineeID, SqlDbType.Int).Value = traineeID;
sqlCommmand.Parameters.Add(_CourseID, SqlDbType.Int).Value = courseId;
sqlCommmand.Parameters.Add(_CourseName, SqlDbType.NVarChar, 200).Value = courseName;
sqlCommmand.Parameters.Add(_TraineeName, SqlDbType.NVarChar, 50).Value = traineeName;
sqlCommmand.Parameters.Add(_Status, SqlDbType.Int).Value = status;
if (startTime == null)
{
sqlCommmand.Parameters.Add(_StartTime, SqlDbType.DateTime).Value = DBNull.Value;
}
else
{
sqlCommmand.Parameters.Add(_StartTime, SqlDbType.DateTime).Value = startTime;
}
if (endTime == null)
{
sqlCommmand.Parameters.Add(_EndTime, SqlDbType.DateTime).Value = DBNull.Value;
}
else
{
sqlCommmand.Parameters.Add(_EndTime, SqlDbType.DateTime).Value = endTime;
}
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetCourseTraineeByCondition", sqlCommmand))
{
while (sdr.Read())
{
Course course = new Course();
course.CourseID = Convert.ToInt32(sdr[_DBCourseID]);
course.CourseName = sdr[_DBCourseName].ToString();
course.ExpectST = Convert.ToDateTime(sdr[_DBExpectST]);
course.ExpectET = Convert.ToDateTime(sdr[_DBExpectET]);
course.TrainFBResult = new TrainFBResult();
course.TrainFBResult.TrainEmployeeFBs = new List <TrainEmployeeFB>();
TrainEmployeeFB employeeFb;
if (sdr[_DBFBTime] != DBNull.Value)
{
employeeFb = new TrainEmployeeFB(Convert.ToDateTime(sdr[_DBFBTime]), sdr[_DBSuggestion].ToString());
}
else
{
employeeFb = new TrainEmployeeFB(null, sdr[_DBSuggestion].ToString());
}
//employeeFb.Trainee = _EmployeeDal.GetEmployeeByAccountID(Convert.ToInt32(sdr[_DBTraineeID]));
employeeFb.Trainee = new Account();
employeeFb.Trainee.Id = Convert.ToInt32(sdr[_DBTraineeID]);
employeeFb.Trainee.Name = sdr[_DBTraineeName].ToString();
employeeFb.Score = Convert.ToDecimal(sdr[_DBTrainFBAllScore]);
if (sdr[_DBCertificationName] != DBNull.Value)
{
employeeFb.CertificationName = sdr[_DBCertificationName].ToString();
}
course.TrainFBResult.TrainEmployeeFBs.Add(employeeFb);
courses.Add(course);
}
}
return(courses);
}
private bool FindEmployeeFB(TrainEmployeeFB fb)
{
return(fb.Trainee.Id.Equals(_EmployeeId));
}
public void AddCourseFeedBack(int courseId, TrainEmployeeFB employeeFB)
{
AddCourseFeedBack addCourseFeedBack = new AddCourseFeedBack(courseId, employeeFB);
addCourseFeedBack.Excute();
}
///<summary>
///AddTrainCourse的构造函数，专为测试提供
///</summary>
public AddCourseFeedBack(int courseId, TrainEmployeeFB employeeFB, ITrain iTrain)
{
_CourseId = courseId;
_TrainEmployeeFb = employeeFB;
_DalTrain = iTrain;
}
public AddCourseFeedBack(int courseId, TrainEmployeeFB employeeFB)
{
_CourseId = courseId;
_TrainEmployeeFb = employeeFB;
}
/// <summary>
/// 调用下层的新增课程的方法
/// </summary>
protected override void ExcuteSelf()
{
//如果反馈表更新了，就重新新增一个课程
if (_IsFeedBackPaperUpdate)
{
new DeleteTrainCourse(_Course.CourseID).Excute();
new AddTrainCourse(_Course, _Skills, _Employees, _LoginUser).Excute();
return;
}
try
{
_Course.Skill = new List <Skill>();
foreach (Skill skill in _Skills)
{
_Course.Skill.Add(skill);
}
_Course.TrainFBResult = new TrainFBResult();
_Course.TrainFBResult.TrainEmployeeFBs = new List <TrainEmployeeFB>();
TrainEmployeeFB employeeFb;
foreach (TrainEmployeeFB fb in GetFbResults())
{
foreach (Account employee in _Employees)
{
if (fb.Trainee.Id.Equals(employee.Id))
{
//如果该员工有信息，添加其信息
_Course.TrainFBResult.TrainEmployeeFBs.Add(fb);
_Employees.Remove(employee);
break;
}
}
}
//无信息，未起新建一条数据
if (_Employees.Count != 0)
{
foreach (Account employee in _Employees)
{
employeeFb = new TrainEmployeeFB(null, string.Empty);
employeeFb.Trainee = employee;
_Course.TrainFBResult.TrainEmployeeFBs.Add(employeeFb);
}
}
_Course.Coordinator = _ItsCordinator;
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required))
{
_DalTrain.UpdateTrainCourse(_Course);
ts.Complete();
}
if (_Course.Status == TrainStatusEnum.End)
{
List <Skill> skills = _Course.Skill;
List <TrainEmployeeFB> employeeFBs = _Course.TrainFBResult.TrainEmployeeFBs;
foreach (TrainEmployeeFB fb in employeeFBs)
{
if (fb.FBTime != null)
{
new FinishTrainCourse(_Course.CourseID).InsertEmployeeSkill(fb.Trainee.Id, skills);
}
}
}
}
catch
{
BllUtility.ThrowException(BllExceptionConst._DbError);
}
}
