public IEnumerable <UserModel> GetUsers(int searchType, string userId, string userName, string status, int deptCode, string sex, string nation, bool?hasEmail) { try { var item = (from u in _db.SP_SYS_USER_LIST(searchType, userId, userName, deptCode, sex == "" ? null : sex, nation == "" ? null : nation, hasEmail) select new UserModel { LoginID = u.Code, Name = u.LocalName, Email = u.Email, OrganizeName = u.OrganizationName, PlantName = u.PlantName, DeptName = u.DeptName, SectionName = u.SectName, StatusName = u.NAME, DeptFullName = u.DeptFullName, DeptId = u.DeptId, CostCenter = u.Costcenter, HandPhoneNumber = u.HandPhoneNumber, PhoneNumber = u.PhoneNumber }).ToList(); return(item); } catch (Exception ex) { LogHelper.Error("UserRepository: GetUsers: " + ex.Message + " Exception: " + ex.InnerException.Message); return(null); } }