///<summary> ///</summary> ///<param name="TraineeApplicationID"></param> ///<returns></returns> public TraineeApplication GetTraineeApplicationByTraineeApplicationID(int TraineeApplicationID) { TraineeApplication app = new TraineeApplication(); SqlCommand cmd = new SqlCommand(); cmd.Parameters.Add(_PKID, SqlDbType.Int).Value = TraineeApplicationID; using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetTrainApplicationByPKID", cmd)) { while (sdr.Read()) { app.PKID = TraineeApplicationID; app.CourseName = (sdr[_DBCourseName]).ToString(); app.Applicant = new Account(); app.Applicant.Id = Convert.ToInt32(sdr[_DBApplicationId]); app.TrainType = TrainScopeType.GetById(Convert.ToInt32(sdr[_DBTrainType])); app.Trainer = (sdr[_DBTrainer]).ToString(); app.Skills = (sdr[_DBSkills]).ToString(); app.StratTime = Convert.ToDateTime(sdr[_DBStratTime]); app.EndTime = Convert.ToDateTime(sdr[_DBEndTime]); app.TrainPlace = (sdr[_DBTrianPlace]).ToString(); app.TrainOrgnatiaon = (sdr[_DBTrainOrgnatiaon]).ToString(); app.TrainHour = Convert.ToInt32(sdr[_DBTrainHour]); app.TrainCost = Convert.ToInt32(sdr[_DBTrainCost]); app.EduSpuCost = HrmisUtility.ConvertToDecimal(sdr[_DbEduSpuCost]); app.HasCertifacation = (Convert.ToInt32(sdr[_DBHasCertification])).Equals(1); app.NextStep = new DiyStep(Convert.ToInt32(sdr[_DBNextStepIndex])); app.TraineeApplicationStatuss = TraineeApplicationStatus.FindTraineeApplicationStatus(Convert.ToInt32(sdr[_DBApplicationStatus])); app.TraineeApplicationDiyProcess = DiyProcessDal.ConvertToObject(sdr[_DbDiyProcess].ToString()); app.StudentList = GetAppTrainee(TraineeApplicationID); app.TraineeApplicationFlowList = GetApplicationFlows(TraineeApplicationID); } return(app); } }
public void SearchEvent(object sender, EventArgs e) { if (Validate()) { try { _ItsView.ErrorMessage = string.Empty; int scope = TrainScopeType.GetById(Convert.ToInt32(_ItsView.Scope)).Id; int status = TrainStatusType.GetById(Convert.ToInt32(_ItsView.Status)).Id; courses = _ITrainFacade.GetCourseByConditon(_ItsView.CourseName, _ItsView.Codinator, scope, status, _ItsView.Trainer, _ItsView.Trainee, _ItsView.Skill, _OutStartFrom, _OutStartTo, _OutEndFrom, _OutEndTo, _ExpCost, _ExpHour, _ActCost, _ActHour, _LoginUser); _ItsView.listView.Course = courses; _ItsView.ErrorMessage = "<span class='font14b'>共查到 " + "<span class='fontred'>" + courses.Count + "</span>" + "<span class='font14b'> 条记录</span>"; } catch (Exception ex) { _ItsView.TimeErrorMessage = "<span class='fontred'>" + ex.Message + "</span>"; } } }
public void SearchEvent(object sender, EventArgs e) { if (!Validate()) { } else { try { _ItsView.ErrorMessage = string.Empty; int scope = Convert.ToInt32(_ItsView.Scope); int status = Convert.ToInt32(_ItsView.SelectedStatus); List <TraineeApplication> applications = _ITrainFacade.GetTraineeApplicationByCondition(_ItsView.Trainer, _ItsView.Trainee, _ItsView.CourseName, _OutStartFrom, _OutStartTo, _ItsView.HasCertification, TrainScopeType.GetById(scope), TraineeApplicationStatus. FindTraineeApplicationStatus(status)); _ItsView.ApplicationSource = applications; _ItsView.ErrorMessage = "<span class='font14b'>共查到 " + "<span class='fontred'>" + applications.Count + "</span>" + "<span class='font14b'> 条记录</span>"; } catch (Exception ex) { _ItsView.ErrorMessage = "<span class='fontred'>" + ex.Message + "</span>"; } } }
public void CompleteTheObject(TraineeApplication theObjectToComplete) { if (theObjectToComplete != null) { theObjectToComplete.CourseName = _ItsView.CourseName; theObjectToComplete.TrainPlace = _ItsView.Place; theObjectToComplete.Applicant = _LoginUser; theObjectToComplete.EndTime = Convert.ToDateTime(_ItsView.EndTime); theObjectToComplete.Skills = _ItsView.Skills; theObjectToComplete.StratTime = Convert.ToDateTime(_ItsView.StartTime); theObjectToComplete.StudentList = _ItsView.EmployeeList; theObjectToComplete.TrainCost = Convert.ToDecimal(_ItsView.Cost); if (!string.IsNullOrEmpty(_ItsView.EduSpuCost)) { theObjectToComplete.EduSpuCost = Convert.ToDecimal(_ItsView.EduSpuCost); } theObjectToComplete.Trainer = _ItsView.Trainer; theObjectToComplete.TrainHour = Convert.ToDecimal(_ItsView.Hour); theObjectToComplete.TrainOrgnatiaon = _ItsView.Orgnation; theObjectToComplete.TrainPlace = _ItsView.Place; theObjectToComplete.TrainType = TrainScopeType.GetById(Convert.ToInt32(_ItsView.TrainScope)); theObjectToComplete.HasCertifacation = _ItsView.HasCertifaction; } }
/// <summary> /// ²éѯÅàѵÉêÇë /// </summary> /// <returns></returns> public List <TraineeApplication> GetTraineeApplicationByCondition( string traineeName, string studentName, string courseName, DateTime?traineeFrom, DateTime?traineeTo, int hasCertifacation, TrainScopeType trainScopeEnum, TraineeApplicationStatus statusEnum) { return(new GetTraineeApplication().GetTraineeApplicationByCondition( traineeName, studentName, courseName, traineeFrom, traineeTo, hasCertifacation, trainScopeEnum, statusEnum)); }
///<summary> ///</summary> ///<param name="traineeName"></param> ///<param name="courseName"></param> ///<param name="traineeFrom"></param> ///<param name="traineeTo"></param> ///<param name="hasCertifacation"></param> ///<param name="trainScopeEnum"></param> ///<param name="statusEnum"></param> ///<returns></returns> public List <TraineeApplication> GetTraineeApplicationByCondition(string traineeName, string courseName, DateTime?traineeFrom, DateTime?traineeTo, int hasCertifacation, TrainScopeType trainScopeEnum, TraineeApplicationStatus statusEnum) { SqlCommand cmd = new SqlCommand(); cmd.Parameters.Add(_CourseName, SqlDbType.NVarChar, 200).Value = courseName; cmd.Parameters.Add(_Trainer, SqlDbType.NVarChar, 50).Value = traineeName; cmd.Parameters.Add(_StratTime, SqlDbType.DateTime).Value = traineeFrom; cmd.Parameters.Add(_EndTime, SqlDbType.DateTime).Value = traineeTo; cmd.Parameters.Add(_TrainType, SqlDbType.Int).Value = trainScopeEnum.Id; cmd.Parameters.Add(_HasCertification, SqlDbType.Int).Value = hasCertifacation; cmd.Parameters.Add(_ApplicationStatus, SqlDbType.Int).Value = statusEnum.Id; using ( SqlDataReader sdr = SqlHelper.ExecuteReader("GetTrainApplicationByCondition", cmd)) { List <TraineeApplication> apps = new List <TraineeApplication>(); while (sdr.Read()) { TraineeApplication app = new TraineeApplication(); app.PKID = Convert.ToInt32(sdr[_DBPKID]); app.CourseName = (sdr[_DBCourseName]).ToString(); app.Applicant = new Account(); app.Applicant.Id = Convert.ToInt32(sdr[_DBApplicationId]); app.TrainType = TrainScopeType.GetById(Convert.ToInt32(sdr[_DBTrainType])); app.Trainer = (sdr[_DBTrainer]).ToString(); app.Skills = (sdr[_DBSkills]).ToString(); app.StratTime = Convert.ToDateTime(sdr[_DBStratTime]); app.EndTime = Convert.ToDateTime(sdr[_DBEndTime]); app.TrainPlace = (sdr[_DBTrianPlace]).ToString(); app.TrainOrgnatiaon = (sdr[_DBTrainOrgnatiaon]).ToString(); app.TrainHour = Convert.ToInt32(sdr[_DBTrainHour]); app.TrainCost = Convert.ToInt32(sdr[_DBTrainCost]); app.EduSpuCost = HrmisUtility.ConvertToDecimal(sdr[_DbEduSpuCost]); app.HasCertifacation = (Convert.ToInt32(sdr[_DBHasCertification])).Equals(1); app.NextStep = new DiyStep(Convert.ToInt32(sdr[_DBNextStepIndex])); app.TraineeApplicationStatuss = TraineeApplicationStatus.FindTraineeApplicationStatus(Convert.ToInt32(sdr[_DBApplicationStatus])); app.TraineeApplicationDiyProcess = DiyProcessDal.ConvertToObject(sdr[_DbDiyProcess].ToString()); apps.Add(app); } return(apps); } }
public TraineeApplication(string courseName, Account applicant, DateTime stratTime, DateTime endTime, string skills, string trainOrgnatiaon, string trainPlace, Decimal trainHour, Decimal trainCost, string trainer, TrainScopeType trainType, bool hasCertifacation) { _StudentList = new List <Account>(); _CourseName = courseName; _Applicant = applicant; _StratTime = stratTime; _EndTime = endTime; _Skills = skills; _TrainOrgnatiaon = trainOrgnatiaon; _TrainPlace = trainPlace; _TrainHour = trainHour; _TrainCost = trainCost; _Trainer = trainer; _TrainType = trainType; _HasCertifacation = hasCertifacation; }
/// <summary> /// »ñÈ¡´ýÉóºËµÄÅàѵÉêÇë /// </summary> /// <returns></returns> public List <TraineeApplication> GetConfimingTraineeApplications() { SqlCommand cmd = new SqlCommand(); using ( SqlDataReader sdr = SqlHelper.ExecuteReader("GetConfirmingTrainApplication", cmd)) { List <TraineeApplication> apps = new List <TraineeApplication>(); while (sdr.Read()) { TraineeApplication app = new TraineeApplication(); app.PKID = Convert.ToInt32(sdr[_DBPKID]); app.CourseName = (sdr[_DBCourseName]).ToString(); app.Applicant = new Account(); app.Applicant.Id = Convert.ToInt32(sdr[_DBApplicationId]); app.TrainType = TrainScopeType.GetById(Convert.ToInt32(sdr[_DBTrainType])); app.Trainer = (sdr[_DBTrainer]).ToString(); app.Skills = (sdr[_DBSkills]).ToString(); app.StratTime = Convert.ToDateTime(sdr[_DBStratTime]); app.EndTime = Convert.ToDateTime(sdr[_DBEndTime]); app.TrainPlace = (sdr[_DBTrianPlace]).ToString(); app.TrainOrgnatiaon = (sdr[_DBTrainOrgnatiaon]).ToString(); app.TrainHour = Convert.ToInt32(sdr[_DBTrainHour]); app.TrainCost = Convert.ToInt32(sdr[_DBTrainCost]); app.EduSpuCost = HrmisUtility.ConvertToDecimal(sdr[_DbEduSpuCost]); app.HasCertifacation = (Convert.ToInt32(sdr[_DBHasCertification])).Equals(1); app.NextStep = new DiyStep(Convert.ToInt32(sdr[_DBNextStepIndex])); app.TraineeApplicationStatuss = TraineeApplicationStatus.FindTraineeApplicationStatus(Convert.ToInt32(sdr[_DBApplicationStatus])); app.TraineeApplicationDiyProcess = DiyProcessDal.ConvertToObject(sdr[_DbDiyProcess].ToString()); if (app.TraineeApplicationDiyProcess != null) { app.CurrentStep = app.TraineeApplicationDiyProcess.FindStep(app.NextStep.DiyStepID); } apps.Add(app); } return(apps); } }
///<summary> ///</summary> ///<param name="traineeName"></param> ///<param name="studentName"></param> ///<param name="courseName"></param> ///<param name="traineeFrom"></param> ///<param name="traineeTo"></param> ///<param name="hasCertifacation"></param> ///<param name="trainScopeEnum"></param> ///<param name="statusEnum"></param> ///<returns></returns> public List <TraineeApplication> GetTraineeApplicationByCondition (string traineeName, string studentName, string courseName, DateTime?traineeFrom, DateTime?traineeTo, int hasCertifacation, TrainScopeType trainScopeEnum, TraineeApplicationStatus statusEnum) { List <TraineeApplication> returnApplication = new List <TraineeApplication>(); List <Account> traineeList = _IAccountBll.GetAccountByBaseCondition(studentName, -1, -1, null, false, null); if (traineeList.Count == 0) { return(returnApplication); } List <TraineeApplication> applications = _DalTraineeApplication.GetTraineeApplicationByCondition(traineeName, courseName, traineeFrom, traineeTo, hasCertifacation, trainScopeEnum, statusEnum); foreach (TraineeApplication application in applications) { TraineeApplication newapplication = GetTraineeApplicationByPKID(application.PKID); //查找课程中是否包含不被管理的培训人员 List <int> traineeListid = new List <int>(); foreach (Account account in traineeList) { traineeListid.Add(account.Id); } bool isFind = true; for (int i = 0; i < newapplication.StudentList.Count; i++) { if (traineeListid.Contains(newapplication.StudentList[i].Id)) { isFind = false; break; } } if (!isFind) { returnApplication.Add(newapplication); } } return(returnApplication); }