/// <summary> /// 将AssessCharacterType枚举转换为文字 /// </summary> /// <param name="assessCharacterType"></param> /// <returns></returns> public static string GetCharacterNameByType(AssessCharacterType assessCharacterType) { switch (assessCharacterType) { case AssessCharacterType.NormalForContract: return("合同期满考核"); case AssessCharacterType.Normal: return("合同期周年考核"); case AssessCharacterType.ProbationI: return("试用期I考核"); case AssessCharacterType.ProbationII: return("试用期II考核"); case AssessCharacterType.PracticeI: return("实习期I考核"); case AssessCharacterType.PracticeII: return("实习期II考核"); case AssessCharacterType.Abnormal: return("非常规考核"); case AssessCharacterType.Annual: return("年终考核"); default: return(""); } }
/// <summary> /// /// </summary> public static string GetCharacterNameByType(AssessCharacterType assessCharacterType) { switch (assessCharacterType) { case AssessCharacterType.Normal: return(BllUtility.GetResourceMessage(BllExceptionConst._CharacterNormal)); case AssessCharacterType.NormalForContract: return(BllUtility.GetResourceMessage(BllExceptionConst._CharacterNormalForContract)); case AssessCharacterType.ProbationI: return(BllUtility.GetResourceMessage(BllExceptionConst._CharacterProbationI)); case AssessCharacterType.ProbationII: return(BllUtility.GetResourceMessage(BllExceptionConst._CharacterProbationII)); case AssessCharacterType.PracticeI: return(BllUtility.GetResourceMessage(BllExceptionConst._CharacterPracticeI)); case AssessCharacterType.PracticeII: return(BllUtility.GetResourceMessage(BllExceptionConst._CharacterPracticeII)); case AssessCharacterType.Abnormal: return(BllUtility.GetResourceMessage(BllExceptionConst._CharacterAbnormal)); case AssessCharacterType.Annual: return(BllUtility.GetResourceMessage(BllExceptionConst._CharacterAnnual)); default: return(""); } }
public List <AssessActivity> GetContractAssessActivityByCondition(string employeeName, AssessCharacterType assessCharacterType, AssessStatus status, DateTime?hrSubmitTimeFrom, DateTime?hrSubmitTimeTo, int finishStatus, DateTime?scopeFrom, DateTime?scopeTo, int departmentID, Account loginuser, int power) { return(new GetAssessActivity().GetContractAssessActivityByCondition(employeeName, assessCharacterType, status, hrSubmitTimeFrom, hrSubmitTimeTo, finishStatus, scopeFrom, scopeTo, departmentID, loginuser, power)); }
/// <summary> /// 根据employeeName、assessCharacterType、status、HRSubmitTime的查找所有的assessActivity /// </summary> /// <param name="assessCharacterType"></param> /// <param name="status"></param> /// <param name="hrSubmitTimeFrom"></param> /// <param name="hrSubmitTimeTo"></param> /// <returns></returns> /// <param name="finishStatus"></param> /// <param name="scopeFrom"></param> /// <param name="scopeTo"></param> public List <AssessActivity> GetContractAssessActivityByCondition(AssessCharacterType assessCharacterType, AssessStatus status, DateTime? hrSubmitTimeFrom, DateTime?hrSubmitTimeTo, int finishStatus, DateTime?scopeFrom, DateTime?scopeTo) { List <AssessActivity> assessActivityList = new List <AssessActivity>(); SqlCommand cmd = new SqlCommand(); //cmd.Parameters.Add(_EmployeeName, SqlDbType.NVarChar).Value = employeeName; cmd.Parameters.Add(_AssessCharacter, SqlDbType.Int).Value = assessCharacterType; cmd.Parameters.Add(_AssessActivityStatus, SqlDbType.Int).Value = status; cmd.Parameters.Add(_FinishStatus, SqlDbType.Int).Value = finishStatus; if (hrSubmitTimeFrom.HasValue) { cmd.Parameters.Add(_HRSubmitTimeFrom, SqlDbType.DateTime).Value = hrSubmitTimeFrom.Value; } else { cmd.Parameters.Add(_HRSubmitTimeFrom, SqlDbType.DateTime).Value = DBNull.Value; } if (hrSubmitTimeTo.HasValue) { cmd.Parameters.Add(_HRSubmitTimeTo, SqlDbType.DateTime).Value = hrSubmitTimeTo.Value; } else { cmd.Parameters.Add(_HRSubmitTimeTo, SqlDbType.DateTime).Value = DBNull.Value; } if (scopeFrom.HasValue) { cmd.Parameters.Add(_ScopeFrom, SqlDbType.DateTime).Value = scopeFrom.Value; } else { cmd.Parameters.Add(_ScopeFrom, SqlDbType.DateTime).Value = DBNull.Value; } if (scopeTo.HasValue) { cmd.Parameters.Add(_ScopeTo, SqlDbType.DateTime).Value = scopeTo.Value; } else { cmd.Parameters.Add(_ScopeTo, SqlDbType.DateTime).Value = DBNull.Value; } using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetContractAssessActivityByCondition", cmd)) { while (sdr.Read()) { int assessActivityId = (int)sdr[_DbPKID]; assessActivityList.Add(GetAssessActivityById(assessActivityId)); } } return(assessActivityList); }
/// <summary> /// 通过EmployeeID查找员工正在参加的考评活动的数目 /// </summary> public int CountOpeningAssessActivityByAccountId(int accountId, AssessCharacterType assessCharacterType) { SqlCommand cmd = new SqlCommand(); cmd.Parameters.Add(_EmployeeID, SqlDbType.Int).Value = accountId; cmd.Parameters.Add(_AssessCharacter, SqlDbType.Int).Value = (int)assessCharacterType; using (SqlDataReader sdr = SqlHelper.ExecuteReader("CountOpeningAssessActivityByEmployeeID", cmd)) { sdr.Read(); return((int)sdr[_DbCounts]); } }
private void SetDefaultValueExceptConstructor() { _AssessActivityPaper = new AssessActivityPaper(ModelUtility.MakeDefaultString()); _PersonalExpectedFinish = ModelUtility.MakeDefaultTime(); _ManagerExpectedFinish = ModelUtility.MakeDefaultTime(); _PersonalGoal = ModelUtility.MakeDefaultString(); _HRConfirmerName = ModelUtility.MakeDefaultString(); _AssessCharacterType = AssessCharacterType.None; _ItsAssessStatus = new AssessStatus(); _AssessProposerName = ModelUtility.MakeDefaultString(); _EmployeeDept = ModelUtility.MakeDefaultString(); _Responsibility = ModelUtility.MakeDefaultString(); }
public void BindAssessActivity(object source, EventArgs e) { if (Validation()) { DateTime dttemp; DateTime?dtHRSubmitTimeFrom = null; DateTime?dtHRSubmitTimeTo = null; DateTime?dtScopeFrom = null; DateTime?dtScopeTo = null; dtHRSubmitTimeFrom = DateTime.TryParse(_View.HRSubmitTimeFrom, out dttemp) ? dttemp : dtHRSubmitTimeFrom; dtHRSubmitTimeTo = DateTime.TryParse(_View.HRSubmitTimeTo, out dttemp) ? dttemp : dtHRSubmitTimeTo; dtScopeFrom = DateTime.TryParse(_View.ScopeTimeFrom, out dttemp) ? dttemp : dtScopeFrom; dtScopeTo = DateTime.TryParse(_View.ScopeTimeTo, out dttemp) ? dttemp : dtScopeTo; try { AssessCharacterType assessCharacterType = (AssessCharacterType)Convert.ToInt32(_View.CharacterType); AssessStatus assessStatus = (AssessStatus)Convert.ToInt32(_View.StatusType); //_View.AssessActivitysToList = // InstanceFactory.AssessActivityFacade().GetAssessActivityByCondition(_View.EmployeeName, // assessCharacterType, // assessStatus, // dtHRSubmitTimeFrom, // dtHRSubmitTimeTo, // _View.FinishStatus, // dtScopeFrom, dtScopeTo, // _View.DepartmentID, LoginUser, // HrmisPowers.A705); _View.AssessActivitysToList = AssessActivityLogic.GetAssessActivityByCondition(_View.EmployeeName, assessCharacterType, assessStatus, dtHRSubmitTimeFrom, dtHRSubmitTimeTo, _View.FinishStatus, dtScopeFrom, dtScopeTo, _View.DepartmentID, LoginUser, HrmisPowers.A705, "", _View.pagerEntity); _View.Message = "<span class='font14b'>共查到 </span>" + "<span class='fontred'>" + _View.AssessActivitysToList.Count + "</span>" + "<span class='font14b'> 个绩效考核活动</span>"; } catch (ApplicationException ex) { _View.Message = "<span class='fontred'>" + ex.Message + "</span>"; } } }
public static List <AssessActivity> GetAssessActivityByCondition(string employeeName, AssessCharacterType assessCharacterType, AssessStatus status, DateTime?hrSubmitTimeFrom, DateTime?hrSubmitTimeTo, int finishStatus, DateTime?scopeFrom, DateTime?scopeTo, int departmentID, Account loginuser, int power, string assessCharacter, PagerEntity pagerEntity) { var assessActivitylist = AssessActiveityDA.GetAssessActivityByCondition(assessCharacterType, status, hrSubmitTimeFrom, hrSubmitTimeTo, finishStatus, scopeFrom, scopeTo, assessCharacter); var assessActivities = assessActivitylist.Select(AssessActivityEntity.Convert).ToList(); var ans = GetAssessActivityByEmployeeNameAndPower(assessActivities, employeeName, loginuser, power, departmentID); BindItemInfo(pagerEntity, ans); return(ans); }
/// <summary> /// 通过assessCharacterType查找员工选择的意向 /// </summary> public string GetIntentionByCharacter(AssessCharacterType assessCharacterType) { switch (assessCharacterType) { case AssessCharacterType.NormalForContract: return("续签/不再续签/调整工作岗位后续签"); case AssessCharacterType.ProbationI: return("继续试用/提前转正/转岗/培训"); case AssessCharacterType.ProbationII: return("按期转正/解除劳动合同"); case AssessCharacterType.PracticeI: return("继续实习,并签三方协议/不再实习"); case AssessCharacterType.PracticeII: return("签合同/不签合同"); default: return(string.Empty); } }
/// <summary> /// 构造考核类型数据字典 /// </summary> public static void AddCharacterValueAndNameIntoDictionary(Dictionary <string, string> dictionaryData, AssessCharacterType assessCharacterType) { dictionaryData.Add(((int)assessCharacterType).ToString(), GetCharacterNameByType(assessCharacterType)); }
/// <summary> /// 根据employeeName、assessCharacterType、status、HRSubmitTime的查找所有的assessActivity /// </summary> public List <Model.AssessActivity> GetAssessActivityByCondition(string employeeName, AssessCharacterType assessCharacterType, AssessStatus status, DateTime?hrSubmitTimeFrom, DateTime?hrSubmitTimeTo, int finishStatus, DateTime?scopeFrom, DateTime?scopeTo, int departmentID, Account loginuser, int power) { List <Model.AssessActivity> assessActivitylist = _AssessActivityDal.GetAssessActivityByCondition(assessCharacterType, status, hrSubmitTimeFrom, hrSubmitTimeTo, finishStatus, scopeFrom, scopeTo); return(GetAssessActivityByEmployeeNameAndPower(assessActivitylist, employeeName, loginuser, power, departmentID)); }
/// <summary> /// 移出列表中正在进行某种考评的员工 /// </summary> private static List <Account> RemoveAssessingAccount(List <Account> accounts, AssessCharacterType assessCharacterType) { if (accounts == null) { accounts = new List <Account>(); } for (int i = accounts.Count - 1; i >= 0; i--) { if (_AssessActivityDal.CountOpeningAssessActivityByAccountId(accounts[i].Id, assessCharacterType) > 0) { accounts.RemoveAt(i); } } return(accounts); }
public static List <AssessActivityEntity> GetAssessActivityByCondition(AssessCharacterType assessCharacterType, AssessStatus status, DateTime? hrSubmitTimeFrom, DateTime?hrSubmitTimeTo, int finishStatus, DateTime?scopeFrom, DateTime?scopeTo, string assessCharacter) { using (var dataOperator = new DataOperator(SqlHelper.HrmisConnectionString)) { dataOperator.CommandText = @"SELECT A.* FROM TAssessActivity A with(nolock) WHERE 1=1 and A.PKID in ( SELECT AssessActivityID FROM TAssessActivityPaper C with(nolock) WHERE 1=1 " ; if (hrSubmitTimeFrom != null) { dataOperator.CommandText += " and c.SubmitTime>=@HRSubmitTimeFrom"; dataOperator.SetParameter("@HRSubmitTimeFrom", hrSubmitTimeFrom.GetValueOrDefault().Date, SqlDbType.DateTime); } if (hrSubmitTimeTo != null) { dataOperator.CommandText += " and c.SubmitTime<@HRSubmitTimeTo"; dataOperator.SetParameter("@HRSubmitTimeTo", hrSubmitTimeTo.Value.AddDays(1).Date, SqlDbType.DateTime); } dataOperator.CommandText += " )"; if (!string.IsNullOrEmpty(assessCharacter)) { dataOperator.CommandText += " and A.AssessCharacter" + assessCharacter; } if ((int)assessCharacterType != -1) { dataOperator.CommandText += " AND A.AssessCharacter=@AssessCharacter"; dataOperator.SetParameter("@AssessCharacter", assessCharacterType, SqlDbType.Int); } if ((int)status != -1) { dataOperator.CommandText += " AND A.AssessStatus=@AssessStatus"; dataOperator.SetParameter("@AssessStatus", status, SqlDbType.Int); } if (finishStatus != -1) { if (finishStatus == 0) { dataOperator.CommandText += " and A.AssessStatus not in (6,7)"; } else { dataOperator.CommandText += " and A.AssessStatus in (6,7)"; } } if (scopeFrom != null) { dataOperator.CommandText += " AND A.ScopeFrom>=@ScopeFrom"; dataOperator.SetParameter("@ScopeFrom", scopeFrom.GetValueOrDefault().Date, SqlDbType.DateTime); } if (scopeTo != null) { dataOperator.CommandText += " AND A.ScopeTo<@ScopeTo"; dataOperator.SetParameter("@ScopeTo", scopeTo.Value.AddDays(1).Date, SqlDbType.DateTime); } dataOperator.CommandText += " ORDER BY A.PKID DESC "; return(dataOperator.ExecuteEntityList <AssessActivityEntity>()); } }