shoushupaiban/SchedulingSystemClient/UpdateWindow/XGMZYSWindow.xaml.cs

using SchedulingSystem.EntityClass;
using SchedulingSystemClient.EntityClass;
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.Shapes;

namespace SchedulingSystemClient.UpdateWindow
{
    /// <summary>
    /// XGMZYSWindow.xaml 的交互逻辑
    /// </summary>
    public partial class XGMZYSWindow : Window
    {
        public XGMZYSWindow(Cus_MZYS row)
        {
            InitializeComponent();
            mzysrow = row;
        }
        Cus_MZYS mzysrow = new Cus_MZYS();
        SurgerySchedulingEntities myModel = new SurgerySchedulingEntities();
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            List<ComboBoxBinding> listsfqy = new List<ComboBoxBinding>();
            listsfqy.Add(new ComboBoxBinding() { ID = 0, Name = "是" });
            listsfqy.Add(new ComboBoxBinding() { ID = 1, Name = "否" });
            sfqy.ItemsSource = listsfqy;
            sfqy.SelectedValuePath = "ID";
            sfqy.DisplayMemberPath = "Name";
            sfqy.SelectedIndex = 0;

            List<ComboBoxBinding> listyszc = new List<ComboBoxBinding>();
            listyszc = (from tbssjb in myModel.SYS_YSZCB
                        select new ComboBoxBinding
                        {
                            ID = tbssjb.ID,
                            Name = tbssjb.Name,
                        }).ToList();
            yszc.ItemsSource = listyszc;
            yszc.SelectedValuePath = "ID";
            yszc.DisplayMemberPath = "Name";
            List<ComboBoxBinding> listsslb1 = new List<ComboBoxBinding>();
            listsslb1 = (from tbsslx in myModel.SYS_SSLXB
                         select new ComboBoxBinding
                         {
                             ID = tbsslx.ID,
                             Name = tbsslx.SSLX,
                         }).ToList();
            scss1.ItemsSource = listsslb1;
            scss1.SelectedValuePath = "ID";
            scss1.DisplayMemberPath = "Name";
            List<ComboBoxBinding> listsslb2 = new List<ComboBoxBinding>();
            listsslb2 = (from tbsslx in myModel.SYS_SSLXB
                         select new ComboBoxBinding
                         {
                             ID = tbsslx.ID,
                             Name = tbsslx.SSLX,
                         }).ToList();
            scss2.ItemsSource = listsslb2;
            scss2.SelectedValuePath = "ID";
            scss2.DisplayMemberPath = "Name";
            List<ComboBoxBinding> listsslb3 = new List<ComboBoxBinding>();
            listsslb3 = (from tbsslx in myModel.SYS_SSLXB
                         select new ComboBoxBinding
                         {
                             ID = tbsslx.ID,
                             Name = tbsslx.SSLX,
                         }).ToList();
            scss3.ItemsSource = listsslb3;
            scss3.SelectedValuePath = "ID";
            scss3.DisplayMemberPath = "Name";
            sfqy.SelectedValue = mzysrow.strSFQY == "是" ? 0 : 1;
            if (mzysrow.SCSS1 !=null)
            {
                scss1.SelectedValue = mzysrow.SCSS1;
            }
            else
            {
                scss1.SelectedValue = null;
            }
            if (mzysrow.SCSS2 != null)
            {
                scss2.SelectedValue = mzysrow.SCSS2;
            }
            else
            {
                scss2.SelectedValue = null;
            }
            if (mzysrow.SCSS3 != null)
            {
                scss3.SelectedValue = mzysrow.SCSS3;
            }
            else
            {
                scss3.SelectedValue = null;
            }
            yszc.SelectedValue = mzysrow.YSZC;
            ysxm.Text = mzysrow.YSXM;
            ysgh.Text = mzysrow.YSGH;

            //List<ComboBoxBinding> listsfqy = new List<ComboBoxBinding>();
            //listsfqy.Add(new ComboBoxBinding() { ID = 0, Name = "是" });
            //listsfqy.Add(new ComboBoxBinding() { ID = 1, Name = "否" });
            //sfqy.ItemsSource = listsfqy;
            //sfqy.SelectedValuePath = "ID";
            //sfqy.DisplayMemberPath = "Name";
            //List<ComboBoxBinding> listyszc = new List<ComboBoxBinding>();
            //listyszc = (from tbssjb in myModel.SYS_YSZCB
            //            select new ComboBoxBinding
            //            {
            //                ID = tbssjb.ID,
            //                Name = tbssjb.Name,
            //            }).ToList();
            //yszc.ItemsSource = listyszc;
            //yszc.SelectedValuePath = "ID";
            //yszc.DisplayMemberPath = "Name";
            //List<ComboBoxBinding> listsss = new List<ComboBoxBinding>();
            //listsss = (from tbssjb in myModel.SYS_SSSB
            //           select new ComboBoxBinding
            //           {
            //               ID = tbssjb.ID,
            //               Name = tbssjb.SSSMC,
            //           }).ToList();
            //sss.ItemsSource = listsss;
            //sss.SelectedValuePath = "ID";
            //sss.DisplayMemberPath = "Name";

        }

        private void btn_bc_Click(object sender, RoutedEventArgs e)
        {
            if (ysxm.Text == string.Empty)
            {
                MessageBox.Show("请填写医生姓名");
                return;
            }
            if (ysgh.Text == string.Empty)
            {
                MessageBox.Show("请填写医生姓名");
                return;
            }
            if (yszc.SelectedValue == null)
            {
                MessageBox.Show("请选择职称");
                return;
            }
            if (scss1.SelectedValue == null)
            {
                MessageBox.Show("请选择擅长手术室");
                return;
            }
            
            if (scss2.SelectedValue == null)
            {
            }
            try
            {
                if (ysgh.Text != mzysrow.YSGH || ysxm.Text!=mzysrow.YSXM)
                {
                    var listmzys = (from ybmzys in myModel.SYS_MZYSB
                                    where ybmzys.YSBM == ysgh.Text && ybmzys.YSMC == ysxm.Text
                                    select new { ybmzys }).ToList();
                    if (listmzys.Count > 0)
                    {
                        MessageBox.Show("医生姓名和编码重复！");
                        return;
                    }
                }
                SYS_MZYSB mzys = new SYS_MZYSB();
                mzys.ID = mzysrow.ID;
                mzys.SFQY = sfqy.SelectedValue.ToString() == "0" ? true : false;
                mzys.SCSS1 = Convert.ToInt32(scss1.SelectedValue);
                if (scss2.SelectedValue==null)
                {
                    mzys.SCSS2 = null;
                }
                else
                {
                    mzys.SCSS2 = Convert.ToInt32(scss2.SelectedValue);
                }
                if (scss3.SelectedValue == null)
                {
                    mzys.SCSS3 = null;
                }
                else
                {
                    mzys.SCSS3 = Convert.ToInt32(scss3.SelectedValue);
                }
                mzys.YSBM = ysgh.Text;
                mzys.YSMC = ysxm.Text;
                mzys.YSZCID = Convert.ToInt32(yszc.SelectedValue);
                myModel.Entry(mzys).State = System.Data.Entity.EntityState.Modified;
                myModel.SaveChanges();
                MessageBox.Show("修改成功");
                this.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("修改失败"+ex.ToString());
            }
        }
    }
}