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