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