private void ItemSearching_Handler(object sender, EventArgs e) { ServerSwitchRecordSearchCondition con = new ServerSwitchRecordSearchCondition(); con.RecordDateTimeRange = new DateTimeRange(ucDateTimeInterval1.StartDateTime, ucDateTimeInterval1.EndDateTime); con.ParkID = this.comPark.SelectedParkID; GridView.Rows.Clear(); List <ServerSwitchRecord> items = (new ServerSwitchRecordBll(AppSettings.CurrentSetting.ParkConnect)).GetServerSwitchRecords(con).QueryObjects; foreach (ServerSwitchRecord item in items) { int row = this.GridView.Rows.Add(); ShowServerSwitchRecordOnRow(GridView.Rows[row], item); } }
protected override List <ServerSwitchRecord> GetingItems(ParkDataContext parking, SearchCondition search) { if (search is ServerSwitchRecordSearchCondition) { ServerSwitchRecordSearchCondition condition = search as ServerSwitchRecordSearchCondition; IQueryable <ServerSwitchRecord> result = parking.ServerSwitchRecord; if (condition.ParkID > 0) { result = result.Where(s => s.ParkID == condition.ParkID); } if (condition.RecordDateTimeRange != null) { result = result.Where(s => s.SwitchDateTime >= condition.RecordDateTimeRange.Begin); result = result.Where(s => s.SwitchDateTime <= condition.RecordDateTimeRange.End); } if (condition.SMSStatus.HasValue) { result = result.Where(s => s.SMSStatus == condition.SMSStatus.Value); } return(result.ToList()); } return(new List <ServerSwitchRecord>()); }