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