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