shoushupaiban/SchedulingSystemClient/PBRZWindow.xaml.cs

using SchedulingSystemClient.EntityClass;
using System;
using System.Linq;
using System.Windows;
using System.Windows.Controls;

namespace SchedulingSystemClient
{
    /// <summary>
    /// PBRZWindow.xaml 的交互逻辑
    /// </summary>
    public partial class PBRZWindow : UserControl
    {
        public PBRZWindow()
        {
            InitializeComponent();
        }
        SurgerySchedulingEntities myModel = new SurgerySchedulingEntities();
        private void UserControl_Loaded(object sender, RoutedEventArgs e)
        {
            kssj.Text = DateTime.Now.AddDays(-6).ToString();
            jssj.Text = DateTime.Now.ToString();
            ChaXun();
        }
        private void btn_cx_Click(object sender, RoutedEventArgs e)
        {
            ChaXun();
        }
        private void ChaXun()
        {
            DateTime ks = Convert.ToDateTime(kssj.SelectedDate).Date;
            DateTime js = Convert.ToDateTime(jssj.SelectedDate).AddDays(1).Date.AddSeconds(-1);
            var listpbrz = (from tbpbrzb in myModel.Bus_PBRZB
                            join tbuser in myModel.SYS_YHB on tbpbrzb.CZRYID equals tbuser.ID
                            join tbczlx in myModel.SYS_CZLXB on tbpbrzb.CZLX equals tbczlx.ID
                            //join tbpbzt in myModel.SYS_PBZTB on tbpbrzb.PBZT equals tbpbzt.ID
                            where tbpbrzb.CZSJ >= ks && tbpbrzb.CZSJ <= js
                            select new Cus_PBRZ
                            {
                                ID = tbpbrzb.ID,
                                CZLX = tbczlx.Name,
                                CZLXID = tbczlx.ID,
                                CZRGH = tbuser.GH,
                                CZRXM = tbuser.YHM,
                                CZSJ = tbpbrzb.CZSJ,
                                //PBID = tbpbrzb.SSID,
                                //PBZT = tbpbzt.Name,
                                //PBZTID = tbpbzt.ID,
                                ZCRID = tbuser.ID,
                                SQDH = tbpbrzb.SQDH
                            }).OrderBy(a => a.CZSJ).ToList();

            pbrzdata.ItemsSource = listpbrz;
        }
    }
}