using SchedulingSystem.EntityClass;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows;

namespace SchedulingSystemClient.InsertWindow
{
    /// <summary>
    /// XZSSXXWindow.xaml 的交互逻辑
    /// </summary>
    public partial class XZSSXXWindow : Window
    {
        SurgerySchedulingEntities myModel = new SurgerySchedulingEntities();
        public XZSSXXWindow()
        {
            InitializeComponent();
        }
        List<ComboBoxBinding> listsssc = new List<ComboBoxBinding>();
        List<ComboBoxBinding> listssjb = new List<ComboBoxBinding>();
        List<ComboBoxBinding> listssqjd = new List<ComboBoxBinding>();
        List<ComboBoxBinding> listmzys = new List<ComboBoxBinding>();
        List<ComboBoxBinding> listxhhs = new List<ComboBoxBinding>();
        List<ComboBoxBinding> listsslb = new List<ComboBoxBinding>();
        List<ComboBoxBinding> listcyss = new List<ComboBoxBinding>();


        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            listcyss.Add(new ComboBoxBinding() { ID = 0, Name = "是" });
            listcyss.Add(new ComboBoxBinding() { ID = 1, Name = "否" });
            listsssc = (from tbsssc in myModel.SYS_SSSCB
                        select new ComboBoxBinding
                        {
                            ID = tbsssc.ID,
                            Name = tbsssc.NAME,
                        }).ToList();
            listssjb = (from tbssjb in myModel.SYS_SSDJB
                        select new ComboBoxBinding
                        {
                            ID = tbssjb.ID,
                            Name = tbssjb.SSDJ,
                        }).ToList();
            listssqjd = (from tbssqjd in myModel.SYS_SSQKLXB
                        select new ComboBoxBinding
                        {
                            ID = tbssqjd.ID,
                            Name = tbssqjd.QKLX,
                        }).ToList();
            listmzys = (from tbmzyszc in myModel.SYS_YSZCB
                         select new ComboBoxBinding
                         {
                             ID = tbmzyszc.ID,
                             Name = tbmzyszc.Name,
                         }).ToList();
            listxhhs = (from tbxhhxzc in myModel.SYS_HSZCB
                         select new ComboBoxBinding
                         {
                             ID = tbxhhxzc.ID,
                             Name = tbxhhxzc.Name,
                         }).ToList();
            listsslb = (from tbxxlb in myModel.SYS_SSLXB
                        select new ComboBoxBinding
                        {
                            ID = tbxxlb.ID,
                            Name = tbxxlb.SSLX,
                        }).ToList();
            yjsssc.ItemsSource = listsssc;
            yjsssc.SelectedValuePath = "ID";
            yjsssc.DisplayMemberPath = "Name";
            ssjb.ItemsSource = listssjb;
            ssjb.SelectedValuePath = "ID";
            ssjb.DisplayMemberPath = "Name";
            ssqjd.ItemsSource = listssqjd;
            ssqjd.SelectedValuePath = "ID";
            ssqjd.DisplayMemberPath = "Name";
            mzyszc.ItemsSource = listmzys;
            mzyszc.SelectedValuePath = "ID";
            mzyszc.DisplayMemberPath = "Name";
            xhhszc.ItemsSource = listxhhs;
            xhhszc.SelectedValuePath = "ID";
            xhhszc.DisplayMemberPath = "Name";
            sslb.ItemsSource = listsslb;
            sslb.SelectedValuePath = "ID";
            sslb.DisplayMemberPath = "Name";
            cyss.ItemsSource = listcyss;
            cyss.SelectedValuePath = "ID";
            cyss.DisplayMemberPath = "Name";
            cyss.SelectedIndex = 0;
        }

        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_bc_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                string strssbm = ssbm.Text;
                string strssmc = ssmc.Text;
                string strpyszm = pyszm.Text;
                int? intyjsssc;
                int? intssjb;
                int? intssqjd;
                int? intmzyszc;
                int? intxhhszc;
                int? intsslb;
                bool? sfcy;

                if (strssbm == string.Empty || strssbm == null)
                {
                    MessageBox.Show("请填写手术编码");
                    return;
                }
                if (strssmc == string.Empty || strssmc == null)
                {
                    MessageBox.Show("请填写手术名称");
                    return;
                }
                if (sslb.SelectedValue == null)
                {
                    intsslb = null;
                    MessageBox.Show("请选择手术类别");
                    return;
                }
                else
                {
                    intsslb = Convert.ToInt32(sslb.SelectedValue);
                }
                if (yjsssc.SelectedValue == null)
                {
                    intyjsssc = null;
                }
                else
                {
                    intyjsssc = Convert.ToInt32(yjsssc.SelectedValue);
                }
                if (ssjb.SelectedValue == null)
                {
                    intssjb = null;
                }
                else
                {
                    intssjb = Convert.ToInt32(ssjb.SelectedValue);
                }
                if (ssqjd.SelectedValue == null)
                {
                    intssqjd = null;
                }
                else
                {
                    intssqjd = Convert.ToInt32(ssqjd.SelectedValue);
                }
                if (mzyszc.SelectedValue == null)
                {
                    intmzyszc = null;
                }
                else
                {
                    intmzyszc = Convert.ToInt32(mzyszc.SelectedValue);
                }
                if (xhhszc.SelectedValue == null)
                {
                    intxhhszc = null;
                }
                else
                {
                    intxhhszc = Convert.ToInt32(xhhszc.SelectedValue);
                }

                sfcy = Convert.ToInt32(sslb.SelectedValue)==0?true:false;

                var listssxx = (from tbssxxb in myModel.SYS_SSXXB
                                where tbssxxb.SSBM == strssbm && tbssxxb.SSMC == strssmc
                                select new
                                {
                                    tbssxxb
                                }).ToList();
                if (listssxx.Count > 0)
                {
                    MessageBox.Show("手术编码和名称已存在");
                    return;
                }
                SYS_SSXXB ssxxb = new SYS_SSXXB();
                ssxxb.SSBM = strssbm;
                ssxxb.SSMC = strssbm;
                ssxxb.PYSZM = strpyszm;
                ssxxb.SSSCID = intyjsssc;
                ssxxb.SSDJID = intssjb;
                ssxxb.SSQKLXID = intssqjd;
                ssxxb.MZYSZCID = intmzyszc;
                ssxxb.HSZCID = intxhhszc;
                ssxxb.SSLX = intsslb;
                ssxxb.CJSS = sfcy;
                ssxxb.IsICD = false;
                myModel.SYS_SSXXB.Add(ssxxb);
                myModel.SaveChanges();
                MessageBox.Show("保存成功");
                this.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
    }
}