WPF中DatePiker值绑定以及精简查询

1.WPF中DatePiker值绑定

Xaml中值绑定使用Text

在ViewModel中使用strMinDate 转为DateTime.如下：

public string strMinDate
{
get { return this.GetProperty(() => strMinDate); }
set { this.SetProperty(() => strMinDate, value);
MinDateTime = Convert.ToDateTime(value);
}
}

public string strMaxDate
{
get { return this.GetProperty(() => strMaxDate); }
set { this.SetProperty(() => strMaxDate, value);
MaxDateTime = Convert.ToDateTime(value);
}
}

private DateTime? _minDateTime;
///

/// 起始时间 ///

public DateTime? MinDateTime
{
get { return _minDateTime; }
set
{
_minDateTime = value;
this.RaisePropertyChanged(() => MinDateTime);
}
}
private DateTime? _maxDateTime;
///

/// 结束时间 ///

public DateTime? MaxDateTime
{
get { return _maxDateTime; }
set
{
_maxDateTime = value;
this.RaisePropertyChanged(() => MaxDateTime);
}
}

2. Linq精简查询

public void Search()
{
DateTime tMin = _minDateTime == null ? DateTime.MinValue : _minDateTime.Value.Date;
DateTime tMax = _maxDateTime == null ? DateTime.MaxValue : _maxDateTime.Value.Date.AddDays(1);
IQueryable IResults = _databaseContext.SampleResults.Where(x => x.Sample.ArriveDateTime < tMax && x.Sample.ArriveDateTime >= tMin && x.Sample.Barcode.Contains(Barcode)).Include(p=>p.Sample).Include(p=>p.Sample.Test).Include(p=>p.Sample.Patient);
this.Results = new ObservableCollection(IResults);
}

3. 原代码：

Xaml:

1 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 ¨C21C 26 27 28 31 ¨C33C 52 53 54 55

 ViewModel:

//------------------------------------------摘要------------------------------------------
// 产品名称：结果列表
// 文 件 名：ResultListViewModel
// 文件说明：
// 机器名称：EIBJDE0153
// 作　　者：zhengping.pan
// 创建日期：2018-08-04 10:44:09
//----------------------------------------------------------------------------------------

using System;
using System.Linq;
using System.Data.Entity;
using DevExpress.Mvvm.DataAnnotations;
using DevExpress.Mvvm;
using System.Collections.ObjectModel;
using EUROFluoAnalyzer.Data.Table;
using EUROFluoAnalyzer.Data;
using EUROFluoAnalyzer.Result.Views;

namespace EUROFluoAnalyzer.Result.ViewModels
{
[POCOViewModel]
public class ResultListViewModel : ViewModelBase
{
#region 属性
public string Barcode
{
get { return this.GetProperty(() => Barcode); }
set { this.SetProperty(() => Barcode, value); }
}

public string strMinDate
{
get { return this.GetProperty(() => strMinDate); }
set { this.SetProperty(() => strMinDate, value);
MinDateTime = Convert.ToDateTime(value);
}
}

public string strMaxDate
{
get { return this.GetProperty(() => strMaxDate); }
set { this.SetProperty(() => strMaxDate, value);
MaxDateTime = Convert.ToDateTime(value);
}
}

private DateTime? _minDateTime;
///

/// 起始时间 ///

public DateTime? MinDateTime
{
get { return _minDateTime; }
set
{
_minDateTime = value;
this.RaisePropertyChanged(() => MinDateTime);
}
}
private DateTime? _maxDateTime;
///

/// 结束时间 ///

public DateTime? MaxDateTime
{
get { return _maxDateTime; }
set
{
_maxDateTime = value;
this.RaisePropertyChanged(() => MaxDateTime);
}
}

public ObservableCollection Results
{
get { return GetProperty(() => Results); }
set { SetProperty(() => Results, value); }
}

public SampleResult SelectedResult
{
get { return this.GetProperty(() => SelectedResult); }
set { this.SetProperty(() => SelectedResult, value); }
}

private EuroLabContext _databaseContext;
#endregion

public ResultListViewModel()
{
Barcode = string.Empty;
strMaxDate = DateTime.Now.Date.ToString("yyyy-MM-dd");
strMinDate = new DateTime(DateTime.Now.Year,1,1).ToString("yyyy-MM-dd");
this._databaseContext = new EuroLabContext();
}

public void Search()
{
DateTime tMin = _minDateTime == null ? DateTime.MinValue : _minDateTime.Value.Date;
DateTime tMax = _maxDateTime == null ? DateTime.MaxValue : _maxDateTime.Value.Date.AddDays(1);
IQueryable IResults = _databaseContext.SampleResults.Where(x => x.Sample.ArriveDateTime < tMax && x.Sample.ArriveDateTime >= tMin && x.Sample.Barcode.Contains(Barcode)).Include(p=>p.Sample).Include(p=>p.Sample.Test).Include(p=>p.Sample.Patient);
this.Results = new ObservableCollection(IResults);
}

public void Detail()
{
if (this.SelectedResult != null)
{
IQueryable IResults = _databaseContext.SampleResults.Where(x => x.Sample_ID == SelectedResult.Sample.ID && x.Sample.Protocol_ID == SelectedResult.Sample.Protocol_ID).Include(p => p.Sample).Include(p => p.Sample.Test).Include(p => p.Sample.Patient);
ResultDetailView detailWindow = new ResultDetailView();
(detailWindow.DataContext as ResultDetailViewModel).SelectedResult = this.SelectedResult;
(detailWindow.DataContext as ResultDetailViewModel).Results = new ObservableCollection(IResults);
detailWindow.ShowDialog();
}
}

}
}