private void ApproveEvent(TraineeApplicationStatus status)
{
if (new TrainApplicationUtilityPresenter(_ItsView, _LoginUser).EduSpuCostValidate())
{
try
{
TraineeApplication application =
_ITrainFacade.GetTraineeApplicationByPkid(Convert.ToInt32(_ItsView.TrainApplicationID));
if (string.IsNullOrEmpty(_ItsView.EduSpuCost))
{
application.EduSpuCost = null;
}
else
{
application.EduSpuCost = Convert.ToDecimal(_ItsView.EduSpuCost);
}
_ITrainFacade.UpdateTraineeApplicationDal(application);
_ITrainFacade.ApproveTraineeApplicationWhole(_LoginUser, Convert.ToInt32(_ItsView.TrainApplicationID),
status,
_ItsView.ApproveRemark);
_CompleteEvent();
}
catch (ApplicationException ae)
{
_ItsView.Message = ae.Message;
}
}
}
///<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="loginUser"></param>
///<param name="TraineeApplication"></param>
///<param name="traineeApplicationStatus"></param>
public void ApproveTraineeApplication(Account loginUser, TraineeApplication TraineeApplication,
TraineeApplicationStatus traineeApplicationStatus)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_PKID, SqlDbType.Int).Value = TraineeApplication.PKID;
cmd.Parameters.Add(_ApplicationStatus, SqlDbType.Int).Value = traineeApplicationStatus.Id;
cmd.Parameters.Add(_NextStepIndex, SqlDbType.Int).Value = TraineeApplication.NextStep.DiyStepID;
SqlHelper.ExecuteNonQuery("UpdateTrainAppStatusByTrainAppID", cmd);
//Ïà¹ØÁ÷³Ì
//DeleteTraineeApplicationFlow(TraineeApplication.PKID);
if (TraineeApplication.TraineeApplicationFlowList != null)
{
foreach (TraineeApplicationFlow flow in TraineeApplication.TraineeApplicationFlowList)
{
flow.TraineeApplicationFlowID = InsertTraineeApplicationFlow(flow, TraineeApplication.PKID);
}
}
}
catch
{
throw new ApplicationException(_DbError);
}
}
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>";
}
}
}
///<summary>
///</summary>
///<param name="loginUser"></param>
///<param name="TraineeApplicationID"></param>
///<param name="status"></param>
///<param name="remark"></param>
public ApproveTraineeApplication(Account loginUser, int TraineeApplicationID,
TraineeApplicationStatus status, string remark)
{
_TraineeApplicationID = TraineeApplicationID;
_LoginUser = loginUser;
_Status = status;
_Remark = remark;
}
/// <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="loginUser"></param>
///<param name="TraineeApplicationID"></param>
///<param name="iTraineeApplicationMock"></param>
///<param name="iEmployeeDiyProcessMock"></param>
///<param name="status"></param>
///<param name="remark"></param>
public ApproveTraineeApplication(Account loginUser, int TraineeApplicationID,
ITraineeApplication iTraineeApplicationMock, IEmployeeDiyProcessDal iEmployeeDiyProcessMock,
TraineeApplicationStatus status, string remark)
{
_DalTraineeApplication = iTraineeApplicationMock;
_DalEmployeeDiyProcess = iEmployeeDiyProcessMock;
_TraineeApplicationID = TraineeApplicationID;
_LoginUser = loginUser;
_Status = status;
_Remark = remark;
}
protected void Page_Load(object sender, EventArgs e)
{
int AccountID = Convert.ToInt32(SecurityUtil.DECDecrypt(Request.QueryString["accountId"]));
int TraineeApplicationID = Convert.ToInt32(SecurityUtil.DECDecrypt(Request.QueryString["Id"]));
TraineeApplication traineeApplication = _ITraineeApplicationFacade.GetTraineeApplicationByPkid(TraineeApplicationID);
if (TraineeApplicationStatus.CanApproveStatus(traineeApplication.TraineeApplicationStatuss))
{
_ITraineeApplicationFacade.ApproveTraineeApplicationWhole
(new Account(AccountID, "", ""), TraineeApplicationID, TraineeApplicationStatus.ApprovePass, "邮件通过");
}
else
{
lblMessage.Text = "该申请已经审核完毕，无法再次审核";
}
}
///<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);
}
}
///<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);
}
/// <summary>
///
/// </summary>
/// <param name="trainAppID"></param>
/// <returns></returns>
public List <TraineeApplicationFlow> GetApplicationFlows(int trainAppID)
{
SqlCommand cmd = new SqlCommand();
List <TraineeApplicationFlow> flows = new List <TraineeApplicationFlow>();
cmd.Parameters.Add(_TrainAppID, SqlDbType.Int).Value = trainAppID;
using (
SqlDataReader sdr =
SqlHelper.ExecuteReader("GetTrainAppFlowByTrainAppID", cmd))
{
while (sdr.Read())
{
TraineeApplicationFlow flow =
new TraineeApplicationFlow(new Account(Convert.ToInt32(sdr[_DBOperatorID]), string.Empty, string.Empty),
Convert.ToDateTime(sdr[_DBOperationTime]),
TraineeApplicationStatus.FindTraineeApplicationStatus(
Convert.ToInt32(sdr[_DBOperation])));
flow.Remark = sdr[_DBRemark].ToString();
flow.TraineeApplicationFlowID = Convert.ToInt32(sdr[_DBPKID]);
flows.Add(flow);
}
return(flows);
}
}
public void ApproveTraineeApplicationWhole(Account loginUser, int TraineeApplicationID,
TraineeApplicationStatus status, string remark)
{
new ApproveTraineeApplication(loginUser, TraineeApplicationID, status, remark).Excute();
}
public void ConfirmLeaveRequestEvent(object source, EventArgs e)
{
if (CheckValidate())
{
try
{
_ITrainFacade.ApproveTraineeApplicationWhole(LoginUser, Convert.ToInt32(_View.OperationView.TrainApplicationID), TraineeApplicationStatus.FindTraineeApplicationStatus(Convert.ToInt32(_View.OperationView.Status)), _View.OperationView.Remark);
}
catch (ApplicationException ae)
{
_View.OperationView.ResultMessage = ae.Message;
}
}
else
{
_View.ResultMessage = string.Empty;
_ShowUpdatePanel();
}
_CompleteEvent();
}
