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