private static List <EmployeeSkill> GetEmployeeSkills(int accountID, string skillName, int skillTypeID,
SkillLevelEnum skillLevel)
{
List <EmployeeSkill> skills = new List <EmployeeSkill>();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_AccountID, SqlDbType.Int).Value = accountID;
cmd.Parameters.Add(_SkillName, SqlDbType.NVarChar, 100).Value = skillName;
cmd.Parameters.Add(_SkillID, SqlDbType.Int).Value = skillTypeID;
cmd.Parameters.Add(_SkillRank, SqlDbType.Int).Value = skillLevel;
using (
SqlDataReader sdr =
SqlHelper.ExecuteReader("GetEmployeeSkillByAccountID", cmd))
{
while (sdr.Read())
{
SkillType type = new SkillType(Convert.ToInt32(sdr[_DBSkillTypeId]), sdr[_DBSkillTypeName].ToString());
Skill skill = new Skill(Convert.ToInt32(sdr[_DBSkillID]), sdr[_DBSkillName].ToString(), type);
EmployeeSkill employeeSkill =
new EmployeeSkill(skill, (SkillLevelEnum)(sdr[_DBSkillRank]));
employeeSkill.EmpSkillID = Convert.ToInt32(sdr[_DBPKID]);
employeeSkill.Score = Convert.ToDecimal(sdr[_DbScore]);
employeeSkill.Remark = sdr[_DbRemark].ToString();
skills.Add(employeeSkill);
}
}
return(skills);
}
public Employee GetEmployeeSkillByAccountID(int accountID, string skillName, int skillTypeID,
SkillLevelEnum skillLevel)
{
Employee employee = _EmployeeDal.GetEmployeeBasicInfoByAccountID(accountID);
employee.EmployeeSkills = GetEmployeeSkills(accountID, skillName, skillTypeID,
skillLevel);
return(employee);
}
/// <summary>
/// 将SkillLevelEnum枚举转换为文字
/// </summary>
public static string GetLevelNameByType(SkillLevelEnum level)
{
switch (level)
{
case SkillLevelEnum.Trained:
return("已培训过");
case SkillLevelEnum.Intermediate:
return("中级");
case SkillLevelEnum.Advanced:
return("高级");
case SkillLevelEnum.MasteR:
return("精通");
case SkillLevelEnum.Expert:
return("专家");
default:
return("");
}
}
/// <summary>
/// 员工技能构造函数
/// </summary>
/// <param name="skill"></param>
/// <param name="skillLevel"></param>
public EmployeeSkill(Skill skill, SkillLevelEnum skillLevel)
{
_EmpSkillID = GetHashCode();
_Skill = skill;
_SkillLevel = skillLevel;
}
/// <summary>
/// 根据员工帐号ID获得员工技能列表
/// </summary>
/// <param name="accountid"></param>
/// <param name="skillName"></param>
/// <param name="skillTypeID"></param>
/// <param name="skillLevel"></param>
/// <returns></returns>
public Employee GetEmployeeSkillByAccountID(int accountid, string skillName, int skillTypeID,
SkillLevelEnum skillLevel)
{
return(_DalEmployeeSkill.GetEmployeeSkillByAccountID(accountid, skillName, skillTypeID, skillLevel));
}
