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