public RequestPagingResult <DriverInfoModel> GetDrivers(PagingSearchCondition <DriverSearch> condition) { RequestPagingResult <DriverInfoModel> rsts = new RequestPagingResult <DriverInfoModel>(); try { using (ydvsEntities entities = new ydvsEntities()) { bool isCondition = condition == null || string.IsNullOrWhiteSpace(condition.SearchCondition.Card); var temp = entities.base_driver_info.Where(d => true); rsts.TotalCount = temp.Count(); if (!isCondition) { temp = temp.Where(d => isCondition || d.card.Contains(condition.SearchCondition.Card)); } rsts.ResultDatas = temp.Select(d => new DriverInfoModel { Id = d.id, Order = d.order, Card = d.card, Name = d.name, LocomotiveDepot = d.locomotive_depot, Team = d.team }).OrderBy(d => d.Order).ToList(); } return(rsts); } catch (Exception ex) { CommonLibrary.LogHelper.Log4Helper.Error(this.GetType(), "查找机车信息", ex); return(rsts); } }
public IHttpActionResult GetTrainProprietorships([FromBody] PagingSearchCondition <TrainProprietorshipSearch> condition) { //CommonLibrary.LogHelper.Log4Helper.Debug(this.GetType(), "机车配属段查询接口调用,参数:" + JsonConvert.SerializeObject(condition)); RequestPagingResult <TrainProprietorshipModel> rsts = this.DBAdapter.GetTrainProprietorships(condition); //CommonLibrary.LogHelper.Log4Helper.Debug(this.GetType(), "机车配属段查询结果:" + JsonConvert.SerializeObject(rsts)); return(Json <RequestPagingResult <TrainProprietorshipModel> >(rsts)); }
private void SetPageData(int pIndex) { try { this.data_panel_sp.Children.Clear(); int pageSize = 23; this.self_wait.Visibility = Visibility.Visible; string requestUrl = CommonLibrary.ReadConfigHelper.BaseUrl + WebApiExtensionUrl.GetTrainProprietorships_URL; PagingSearchCondition <TrainProprietorshipSearch> condition = new PagingSearchCondition <TrainProprietorshipSearch>(); condition.StartIndex = pIndex; condition.PageSize = pageSize; condition.SearchCondition = new TrainProprietorshipSearch { TrainShortName = this.condition_tb.Text }; Task <RequestPagingResult <TrainProprietorshipModel> > task = Task <RequestPagingResult <TrainProprietorshipModel> > .Run(() => { return(CommonLibrary.Factory.HttpRequestFactroy.HttpPostRequest <RequestPagingResult <TrainProprietorshipModel> >(requestUrl, condition)); }); task.GetAwaiter().OnCompleted(() => { RequestPagingResult <TrainProprietorshipModel> rst = task.Result; this.Dispatcher.Invoke(() => { TableItem itemControl = null; foreach (var item in rst.ResultDatas) { itemControl = new TableItem(); itemControl.ViewModel.ObjectCopyProperty(item); this.data_panel_sp.Children.Add(itemControl); } this.self_pagination.SetPageContent(pIndex, pageSize, rst.TotalCount); this.self_wait.Visibility = Visibility.Collapsed; }); }); } catch (Exception ex) { CommonLibrary.LogHelper.Log4Helper.Error(this.GetType(), "机车配属段功能,查询配属段信息", ex); } }
public RequestPagingResult <TrainProprietorshipModel> GetTrainProprietorships(PagingSearchCondition <TrainProprietorshipSearch> condition) { RequestPagingResult <TrainProprietorshipModel> rsts = new RequestPagingResult <TrainProprietorshipModel>(); try { rsts.Flag = true; using (ydvsEntities entities = new ydvsEntities()) { bool isCondition = condition == null || string.IsNullOrWhiteSpace(condition.SearchCondition.TrainShortName); var temp = entities.base_train_proprietorship.Where(d => true); if (!isCondition) { temp = temp.Where(d => isCondition || d.train_type.Contains(condition.SearchCondition.TrainShortName) || d.train_no.Contains(condition.SearchCondition.TrainShortName)); } rsts.TotalCount = temp.Count(); int startIndex = condition.StartIndex <= 0 ? 0 : (condition.StartIndex - 1); int pageSize = condition.PageSize <= 0 ? rsts.TotalCount : condition.PageSize; var temp2 = temp.Select(d => new TrainProprietorshipModel { Id = d.id, Order = d.order, TrainType = d.train_type, TrainNo = d.train_no, LocomotiveDepot = d.locomotive_depot, WorkShop = d.work_shop }).OrderBy(d => d.Order).Skip(startIndex * condition.PageSize); rsts.ResultDatas = pageSize == 0 ? temp2.ToList() : temp2.Take(pageSize).ToList(); } rsts.Msg = ""; return(rsts); } catch (Exception ex) { CommonLibrary.LogHelper.Log4Helper.Error(this.GetType(), "查找机车配属段信息", ex); rsts.Flag = false; rsts.Msg = ex.ToString(); return(rsts); } }
public RequestPagingResult <DriverInfoModel> GetDrivers(PagingSearchCondition <DriverSearch> condition) { RequestPagingResult <DriverInfoModel> rst = this.DBAdapter.GetDrivers(condition); return(rst); }