using SchedulingSystem.EntityClass;
using SchedulingSystemClient.EntityClass;
using SchedulingSystemClient.InsertWindow;
using SchedulingSystemClient.UpdateWindow;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace SchedulingSystemClient
{
    /// <summary>
    /// SBGLWindow.xaml 的交互逻辑
    /// </summary>
    public partial class SBGLWindow : UserControl
    {
        public SBGLWindow()
        {
            InitializeComponent();
        }
        SurgerySchedulingEntities myModel = new SurgerySchedulingEntities();
        Cus_SBB selectedRow = new Cus_SBB();
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_sx_Click(object sender, RoutedEventArgs e)
        {
            var list = (from tbsbb in myModel.Bus_SBB
                        join tbsblx in myModel.SYS_SBLXB on tbsbb.SBLX equals tbsblx.ID
                        join tbsssb in myModel.SYS_SSSB on tbsbb.SSSID equals tbsssb.ID
                        join tbsbdj in myModel.SYS_SBDJB on tbsbb.SBDJ equals tbsbdj.ID
                        select new Cus_SBB
                        {
                            ID = tbsbb.ID,
                            SBBM = tbsbb.SBBM,
                            SBDJ = tbsbb.SBDJ,
                            SBJG = tbsbb.SBJG,
                            SBLX = tbsbb.SBLX,
                            SBMC = tbsbb.SBMC,
                            SSSID = tbsbb.ID,
                            SSSMC = tbsssb.SSSMC,
                            strSBDJ = tbsbdj.Name,
                            strSBLX = tbsblx.Name,
                        }).ToList();
            sbgldata.ItemsSource = list;
        }
        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_tj_Click(object sender, RoutedEventArgs e)
        {
            XZSBWindow window = new XZSBWindow();
            window.ShowDialog();
        }

        private void btn_sc_Click(object sender, RoutedEventArgs e)
        {

        }

        private void btn_xg_Click(object sender, RoutedEventArgs e)
        {
            if (selectedRow.ID==0)
            {
                MessageBox.Show("请选择要修改的内容");
                return;
            }
            else
            {
                XGSBWindow window = new XGSBWindow(selectedRow);
                window.ShowDialog();
            }
        }

        private void sbgldata_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            selectedRow = sbgldata.SelectedItem as Cus_SBB;
        }
        private void UserControl_Loaded(object sender, RoutedEventArgs e)
        {
            List<ComboBoxBinding> listsblx = new List<ComboBoxBinding>();
            listsblx = (from tbsblxb in myModel.SYS_SBLXB
                        select new ComboBoxBinding
                        {
                            ID = tbsblxb.ID,
                            Name = tbsblxb.Name,
                        }).ToList();
            listsblx.Add(new ComboBoxBinding() { ID = 0, Name = "全部" });
            sblx.ItemsSource = listsblx.OrderBy(a => a.ID);
            sblx.SelectedValuePath = "ID";
            sblx.DisplayMemberPath = "Name";
            List<ComboBoxBinding> listsss = new List<ComboBoxBinding>();
            listsss = (from tbsssb in myModel.SYS_SSSB
                       select new ComboBoxBinding
                       {
                           ID = tbsssb.ID,
                           Name = tbsssb.SSSMC,
                       }).ToList();
            listsss.Add(new ComboBoxBinding() { ID = 0, Name = "全部" });
            sss.ItemsSource = listsss.OrderBy(a => a.ID);
            sss.SelectedValuePath = "ID";
            sss.DisplayMemberPath = "Name";
            List<ComboBoxBinding> listsbdj = new List<ComboBoxBinding>();
            listsbdj = (from tbsbdj in myModel.SYS_SBDJB
                        select new ComboBoxBinding
                        {
                            ID = tbsbdj.ID,
                            Name = tbsbdj.Name,
                        }).ToList();
            listsbdj.Add(new ComboBoxBinding() { ID = 0, Name = "全部" });
            sbdj.ItemsSource = listsbdj.OrderBy(a => a.ID);
            sbdj.SelectedValuePath = "ID";
            sbdj.DisplayMemberPath = "Name";

            sblx.SelectedIndex = 0;
            sss.SelectedIndex = 0;
            sbdj.SelectedIndex = 0;

        }
    }
}