using SchedulingSystem.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 { /// /// XGSSQJDWindow.xaml 的交互逻辑 /// public partial class XGSSQJDWindow : Window { public XGSSQJDWindow(int ssqidid) { InitializeComponent(); qjdid = ssqidid; } SurgerySchedulingEntities myModel = new SurgerySchedulingEntities(); int qjdid = 0; Cus_Ssqjdb ssqjdlb = new Cus_Ssqjdb(); private void Window_Loaded(object sender, RoutedEventArgs e) { sfqy.SelectedIndex = 0; //List listsfqy = new List(); //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; ssqjdlb = (from tbssqjd in myModel.SYS_SSQKLXB where tbssqjd.ID == qjdid select new Cus_Ssqjdb { ID = tbssqjd.ID, SSQJD = tbssqjd.QKLX, QJSJID = tbssqjd.QJSCID, }).FirstOrDefault(); ssqjd.Text = ssqjdlb.SSQJD; qjsj.Text = ssqjdlb.QJSJ.ToString(); List listsfqy = new List(); 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 = ssqjdlb.SFQY == true ? 0 : 1; List listqjsc = new List(); listqjsc.Add(new ComboBoxBinding() { ID = 0, Name = "0.5小时" }); listqjsc.Add(new ComboBoxBinding() { ID = 1, Name = "1小时" }); listqjsc.Add(new ComboBoxBinding() { ID = 2, Name = "1.5小时" }); listqjsc.Add(new ComboBoxBinding() { ID = 3, Name = "2小时" }); qjsj.ItemsSource = listqjsc; qjsj.SelectedValuePath = "ID"; qjsj.DisplayMemberPath = "Name"; qjsj.SelectedValue = ssqjdlb.QJSJID; } private void btn_bc_Click(object sender, RoutedEventArgs e) { if (ssqjd.Text == null || ssqjd.Text == string.Empty) { MessageBox.Show("请填写手术清洁度"); return; } if (qjsj.SelectedValue == null ) { MessageBox.Show("请选择清洁时间"); return; } if (ssqjd.Text != ssqjdlb.SSQJD) { var listssqjd = (from tbssqjd in myModel.SYS_SSQKLXB where tbssqjd.QKLX == ssqjd.Text select new { tbssqjd }).ToList(); if (listssqjd.Count > 0) { MessageBox.Show("清洁度不能重复"); return; } } SYS_SSQKLXB ssqjdb = new SYS_SSQKLXB(); ssqjdb.ID = qjdid; ssqjdb.QKLX = ssqjd.Text; //ssqjdb.QJSJID =Convert.ToInt32(qjsj.SelectedValue); //ssqjdb.QJSJ = Convert.ToDecimal(qjsj.Text.Replace("小时","")); //ssqjdb.SFQY = sfqy.SelectedValue.ToString() == "0"; try { myModel.Entry(ssqjdb).State = System.Data.Entity.EntityState.Modified; myModel.SaveChanges(); MessageBox.Show("修改成功"); this.Close(); } catch (Exception) { MessageBox.Show("修改失败"); } } } }