private void btnQueryHistory_Click(object sender, EventArgs e) { UserType identity = CurrentUser.UserType; List <ResidentMission> missions = new List <ResidentMission>(); List <ResidentMission> historyMissions = new List <ResidentMission>(); switch (cmbQueryW.SelectedIndex) { case 0: // 全部 UserTypeJudge(CurrentUser, missions, historyMissions); MissionBindingSource.DataSource = historyMissions; break; case 1: // 根据编号查询 UserTypeJudge(CurrentUser, missions, historyMissions); List <ResidentMission> temp = new List <ResidentMission>(); var list = from ResidentMission s in historyMissions where s.ResidentMissionId == txtQuery.Text select s; temp = list.ToList(); MissionBindingSource.DataSource = temp; break; case 2: // 根据用户ID查询 UserTypeJudge(CurrentUser, missions, historyMissions); var id = from ResidentMission s in historyMissions where s.Resident.User.UserId == txtQuery.Text select s; temp = id.ToList(); MissionBindingSource.DataSource = ResidentMissionService.QueryByUserId(txtQuery.Text); break; case 3: // 根据日期查询 DateTime dt = Convert.ToDateTime(txtQuery.Text); UserTypeJudge(CurrentUser, missions, historyMissions); var date = from ResidentMission s in historyMissions where s.CreatedTime == dt select s; temp = date.ToList(); MissionBindingSource.DataSource = ResidentMissionService.QuerydByDate(dt); break; } MissionBindingSource.ResetBindings(true); }
private void QueryAll(User user) { TravelBindingSource.DataSource = ResidentMissionService.QueryByUserId(user.UserId); TravelBindingSource.ResetBindings(false); }