public List <U_Employee> GetEmployeesByDept(string dept) { SqlParameter[] parms = { new SqlParameter("@Type", SqlDbType.Int), new SqlParameter("@DeptId", SqlDbType.VarChar, 100) }; parms[0].Value = (int)EnmEmpType.Employee; parms[1].Value = SqlTypeConverter.DBNullStringChecker(dept); var entities = new List <U_Employee>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_U_Employee_Repository_GetEmployeesByDept, parms)) { while (rdr.Read()) { var entity = new U_Employee(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["EmpNo"]); entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]); entity.EngName = SqlTypeConverter.DBNullStringHandler(rdr["EngName"]); entity.UsedName = SqlTypeConverter.DBNullStringHandler(rdr["UsedName"]); entity.Sex = SqlTypeConverter.DBNullEnmSexHandler(rdr["Sex"]); entity.DeptId = SqlTypeConverter.DBNullStringHandler(rdr["DeptId"]); entity.DeptName = SqlTypeConverter.DBNullStringHandler(rdr["DeptName"]); entity.DutyId = SqlTypeConverter.DBNullStringHandler(rdr["DutyId"]); entity.DutyName = SqlTypeConverter.DBNullStringHandler(rdr["DutyName"]); entity.ICardId = SqlTypeConverter.DBNullStringHandler(rdr["ICardId"]); entity.Birthday = SqlTypeConverter.DBNullDateTimeHandler(rdr["Birthday"]); entity.Degree = SqlTypeConverter.DBNullEnmDegreeHandler(rdr["Degree"]); entity.Marriage = SqlTypeConverter.DBNullEnmMarriageHandler(rdr["Marriage"]); entity.Nation = SqlTypeConverter.DBNullStringHandler(rdr["Nation"]); entity.Provinces = SqlTypeConverter.DBNullStringHandler(rdr["Provinces"]); entity.Native = SqlTypeConverter.DBNullStringHandler(rdr["Native"]); entity.Address = SqlTypeConverter.DBNullStringHandler(rdr["Address"]); entity.PostalCode = SqlTypeConverter.DBNullStringHandler(rdr["PostalCode"]); entity.AddrPhone = SqlTypeConverter.DBNullStringHandler(rdr["AddrPhone"]); entity.WorkPhone = SqlTypeConverter.DBNullStringHandler(rdr["WorkPhone"]); entity.MobilePhone = SqlTypeConverter.DBNullStringHandler(rdr["MobilePhone"]); entity.Email = SqlTypeConverter.DBNullStringHandler(rdr["Email"]); entity.Photo = SqlTypeConverter.DBNullBytesHandler(rdr["Photo"]); entity.IsLeft = SqlTypeConverter.DBNullBooleanHandler(rdr["Leaving"]); entity.EntryTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["EntryTime"]); entity.RetireTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["RetireTime"]); entity.IsFormal = SqlTypeConverter.DBNullBooleanHandler(rdr["IsFormal"]); entity.Remarks = SqlTypeConverter.DBNullStringHandler(rdr["Remarks"]); entity.CardId = SqlTypeConverter.DBNullStringHandler(rdr["CardId"]); entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]); entities.Add(entity); } } return(entities); }