using SchedulingSystem;
using SchedulingSystem.EntityClass;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Media;
namespace SchedulingSystemClient
{
///
/// GZWHWindow.xaml 的交互逻辑
///
public partial class GZWHWindow : UserControl
{
public GZWHWindow()
{
InitializeComponent();
}
SurgerySchedulingEntities myModel = new SurgerySchedulingEntities();
string type = string.Empty;
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
type = "手术级别";
btnsslx.IsEnabled = false;
btnbrvip.IsEnabled = true;
btnysbip.IsEnabled = true;
btnssqjd.IsEnabled = true;
btnqtcs.IsEnabled = true;
sslxgrid.Visibility = Visibility.Visible;
brvipgrid.Visibility = Visibility.Collapsed;
ysvipgrid.Visibility = Visibility.Collapsed;
ssqjdgrid.Visibility = Visibility.Collapsed;
qtcsgrid.Visibility = Visibility.Collapsed;
ShuaXin();
}
Color color = (Color)ColorConverter.ConvertFromString("#315DDA");
private void btnsslx_Click(object sender, RoutedEventArgs e)
{
type = "手术级别";
btnsslx.IsEnabled = false;
btnbrvip.IsEnabled = true;
btnysbip.IsEnabled = true;
btnssqjd.IsEnabled = true;
btnqtcs.IsEnabled = true;
sslxgrid.Visibility = Visibility.Visible;
brvipgrid.Visibility = Visibility.Collapsed;
ysvipgrid.Visibility = Visibility.Collapsed;
ssqjdgrid.Visibility = Visibility.Collapsed;
qtcsgrid.Visibility = Visibility.Collapsed;
ShuaXin();
}
private void btnbrvip_Click(object sender, RoutedEventArgs e)
{
type = "患者VIP";
btnsslx.IsEnabled = true;
btnbrvip.IsEnabled = false;
btnysbip.IsEnabled = true;
btnssqjd.IsEnabled = true;
btnqtcs.IsEnabled = true;
sslxgrid.Visibility = Visibility.Collapsed;
brvipgrid.Visibility = Visibility.Visible;
ysvipgrid.Visibility = Visibility.Collapsed;
ssqjdgrid.Visibility = Visibility.Collapsed;
qtcsgrid.Visibility = Visibility.Collapsed;
ShuaXin();
}
private void btnysbip_Click(object sender, RoutedEventArgs e)
{
type = "医生VIP";
btnsslx.IsEnabled = true;
btnbrvip.IsEnabled = true;
btnysbip.IsEnabled = false;
btnssqjd.IsEnabled = true;
btnqtcs.IsEnabled = true;
sslxgrid.Visibility = Visibility.Collapsed;
brvipgrid.Visibility = Visibility.Collapsed;
ysvipgrid.Visibility = Visibility.Visible;
ssqjdgrid.Visibility = Visibility.Collapsed;
qtcsgrid.Visibility = Visibility.Collapsed;
ShuaXin();
}
private void btnssqjd_Click(object sender, RoutedEventArgs e)
{
type = "切口类型";
btnsslx.IsEnabled = true;
btnbrvip.IsEnabled = true;
btnysbip.IsEnabled = true;
btnssqjd.IsEnabled = false;
btnqtcs.IsEnabled = true;
sslxgrid.Visibility = Visibility.Collapsed;
brvipgrid.Visibility = Visibility.Collapsed;
ysvipgrid.Visibility = Visibility.Collapsed;
ssqjdgrid.Visibility = Visibility.Visible;
qtcsgrid.Visibility = Visibility.Collapsed;
ShuaXin();
}
List listqtcsb = new List();
private void btnqtcs_Click(object sender, RoutedEventArgs e)
{
type = "其他参数";
btnsslx.IsEnabled = true;
btnbrvip.IsEnabled = true;
btnysbip.IsEnabled = true;
btnssqjd.IsEnabled = true;
btnqtcs.IsEnabled = false;
sslxgrid.Visibility = Visibility.Collapsed;
brvipgrid.Visibility = Visibility.Collapsed;
ysvipgrid.Visibility = Visibility.Collapsed;
ssqjdgrid.Visibility = Visibility.Collapsed;
qtcsgrid.Visibility = Visibility.Visible;
listqtcsb = (from tbqtcsb in myModel.Bus_SJCSB
select new Cus_Qtcs
{
ID = tbqtcsb.ID,
MTPBSCID = tbqtcsb.MTPBSCID,
MTPBSC = tbqtcsb.MTPBSC,
PBKSSJID = tbqtcsb.PBKSSJID,
PBKSSJ = tbqtcsb.PBKSSJ,
SSMXSQZ = tbqtcsb.SSMXSQZ,
ZHXGSJID = tbqtcsb.ZHXGSJID,
ZHXGSJ = tbqtcsb.ZHXGSJ,
XXSC = tbqtcsb.XXSC,
strXXSC = tbqtcsb.STRXXSC,
XXSJ = tbqtcsb.XXSJ,
strXXSJ = tbqtcsb.STRXXSJ,
XGSJ = tbqtcsb.XGSJ,
XGR = tbqtcsb.XGR
}).ToList();
List listpbkssj = new List();
listpbkssj.Add(new ComboBoxBinding() { ID = 0, Name = "请选择" });
listpbkssj.Add(new ComboBoxBinding() { ID = 1, Name = "07:00:00" });
listpbkssj.Add(new ComboBoxBinding() { ID = 2, Name = "07:30:00" });
listpbkssj.Add(new ComboBoxBinding() { ID = 3, Name = "08:00:00" });
listpbkssj.Add(new ComboBoxBinding() { ID = 4, Name = "08:30:00" });
listpbkssj.Add(new ComboBoxBinding() { ID = 5, Name = "09:00:00" });
listpbkssj.Add(new ComboBoxBinding() { ID = 6, Name = "09:30:00" });
listpbkssj.Add(new ComboBoxBinding() { ID = 7, Name = "10:00:00" });
listpbkssj.Add(new ComboBoxBinding() { ID = 8, Name = "10:30:00" });
listpbkssj.Add(new ComboBoxBinding() { ID = 9, Name = "11:00:00" });
listpbkssj.Add(new ComboBoxBinding() { ID = 10, Name = "11:30:00" });
listpbkssj.Add(new ComboBoxBinding() { ID = 11, Name = "12:00:00" });
List listmtpbsc = new List();
listmtpbsc.Add(new ComboBoxBinding() { ID = 0, Name = "请选择" });
listmtpbsc.Add(new ComboBoxBinding() { ID = 1, Name = "4小时" });
listmtpbsc.Add(new ComboBoxBinding() { ID = 2, Name = "5小时" });
listmtpbsc.Add(new ComboBoxBinding() { ID = 3, Name = "6小时" });
listmtpbsc.Add(new ComboBoxBinding() { ID = 4, Name = "7小时" });
listmtpbsc.Add(new ComboBoxBinding() { ID = 5, Name = "8小时" });
listmtpbsc.Add(new ComboBoxBinding() { ID = 6, Name = "9小时" });
listmtpbsc.Add(new ComboBoxBinding() { ID = 7, Name = "10小时" });
listmtpbsc.Add(new ComboBoxBinding() { ID = 8, Name = "11小时" });
listmtpbsc.Add(new ComboBoxBinding() { ID = 9, Name = "12小时" });
List listssxsqz = new List();
listssxsqz.Add(new ComboBoxBinding() { ID = 0, Name = "0" });
listssxsqz.Add(new ComboBoxBinding() { ID = 1, Name = "1" });
listssxsqz.Add(new ComboBoxBinding() { ID = 2, Name = "2" });
listssxsqz.Add(new ComboBoxBinding() { ID = 3, Name = "3" });
listssxsqz.Add(new ComboBoxBinding() { ID = 4, Name = "4" });
listssxsqz.Add(new ComboBoxBinding() { ID = 5, Name = "5" });
listssxsqz.Add(new ComboBoxBinding() { ID = 6, Name = "6" });
listssxsqz.Add(new ComboBoxBinding() { ID = 7, Name = "7" });
listssxsqz.Add(new ComboBoxBinding() { ID = 8, Name = "8" });
listssxsqz.Add(new ComboBoxBinding() { ID = 9, Name = "9" });
listssxsqz.Add(new ComboBoxBinding() { ID = 10, Name = "10" });
List listzhxgsj = new List();
listzhxgsj.Add(new ComboBoxBinding() { ID = 0, Name = "1天内" });
listzhxgsj.Add(new ComboBoxBinding() { ID = 1, Name = "2天内" });
listzhxgsj.Add(new ComboBoxBinding() { ID = 2, Name = "3天内" });
//listzhxgsj.Add(new ComboBoxBinding() { ID = 3, Name = "24小时" });
//listzhxgsj.Add(new ComboBoxBinding() { ID = 4, Name = "36小时" });
//listzhxgsj.Add(new ComboBoxBinding() { ID = 5, Name = "48小时" });
List listxxsj = new List();
listxxsj.Add(new ComboBoxBinding() { ID = 0, Name = "不休息" });
listxxsj.Add(new ComboBoxBinding() { ID = 1, Name = "11:00:00" });
listxxsj.Add(new ComboBoxBinding() { ID = 2, Name = "11:30:00" });
listxxsj.Add(new ComboBoxBinding() { ID = 3, Name = "12:00:00" });
listxxsj.Add(new ComboBoxBinding() { ID = 4, Name = "12:30:00" });
listxxsj.Add(new ComboBoxBinding() { ID = 5, Name = "13:00:00" });
listxxsj.Add(new ComboBoxBinding() { ID = 6, Name = "13:30:00" });
listxxsj.Add(new ComboBoxBinding() { ID = 7, Name = "14:00:00" });
List listxxsc = new List();
listxxsc.Add(new ComboBoxBinding() { ID = 0, Name = "0" });
listxxsc.Add(new ComboBoxBinding() { ID = 1, Name = "0.5小时" });
listxxsc.Add(new ComboBoxBinding() { ID = 2, Name = "1小时" });
listxxsc.Add(new ComboBoxBinding() { ID = 3, Name = "1.5小时" });
listxxsc.Add(new ComboBoxBinding() { ID = 4, Name = "2小时" });
listxxsc.Add(new ComboBoxBinding() { ID = 5, Name = "2.5小时" });
listxxsc.Add(new ComboBoxBinding() { ID = 6, Name = "3小时" });
pbkssj.ItemsSource = listpbkssj;
pbkssj.SelectedValuePath = "ID";
pbkssj.DisplayMemberPath = "Name";
pbkssj.SelectedValue = listqtcsb.Single().PBKSSJID;
mtpbsc.ItemsSource = listmtpbsc;
mtpbsc.SelectedValuePath = "ID";
mtpbsc.DisplayMemberPath = "Name";
mtpbsc.SelectedValue = listqtcsb.Single().MTPBSCID;
ssmxsqz.ItemsSource = listssxsqz;
ssmxsqz.SelectedValuePath = "ID";
ssmxsqz.DisplayMemberPath = "Name";
ssmxsqz.SelectedValue = listqtcsb.Single().SSMXSQZ;
zhxgsj.ItemsSource = listzhxgsj;
zhxgsj.SelectedValuePath = "ID";
zhxgsj.DisplayMemberPath = "Name";
zhxgsj.SelectedValue = listqtcsb.Single().ZHXGSJID;
xxsj.ItemsSource = listxxsj;
xxsj.SelectedValuePath = "ID";
xxsj.DisplayMemberPath = "Name";
xxsj.SelectedValue = listqtcsb.Single().XXSJ;
xxsc.ItemsSource = listxxsc;
xxsc.SelectedValuePath = "ID";
xxsc.DisplayMemberPath = "Name";
xxsc.Text = listqtcsb.Single().strXXSC;
if (xxsj.SelectedValue!=null)
{
if (Convert.ToInt32(xxsj.SelectedValue) == 0)
{
xxsc.SelectedValue = 0;
xxsc.IsEditable = false;
}
else
{
xxsc.IsEditable = true;
}
}
}
int sslxqzid = 0;
int brvipqzid = 0;
int ysvipqzid = 0;
int ssqjdqzid = 0;
private void sslxdata_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
sslxqzid = 0;
Cus_SslxQz selectedRow = sslxdata.SelectedItem as Cus_SslxQz;
if (selectedRow != null)
{
sslxqzid = selectedRow.ID;
ssjbrow = selectedRow;
}
}
private void brvipdata_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
brvipqzid = 0;
Cus_BrvipQz selectedRow = brvipdata.SelectedItem as Cus_BrvipQz;
if (selectedRow != null)
{
brvipqzid = selectedRow.ID;
}
}
private void ysvipdata_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
ysvipqzid = 0;
Cus_YsvipQz selectedRow = ysvipdata.SelectedItem as Cus_YsvipQz;
if (selectedRow != null)
{
ysvipqzid = selectedRow.ID;
}
}
private void ssqjddata_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
ssqjdqzid = 0;
Cus_SsqjdQz selectedRow = ssqjddata.SelectedItem as Cus_SsqjdQz;
if (selectedRow != null)
{
ssqjdqzid = selectedRow.ID;
qklxrow = selectedRow;
}
}
private void btn_bccs_Click(object sender, RoutedEventArgs e)
{
if (pbkssj.SelectedIndex == 0)
{
MessageBox.Show("请选择开始时间");
return;
}
if (mtpbsc.SelectedIndex == 0)
{
MessageBox.Show("请选择排班时长");
return;
}
if (xxsj.SelectedValue == null)
{
MessageBox.Show("请选择休息时间");
return;
}
if (xxsc.SelectedValue == null)
{
MessageBox.Show("请选择休息时长");
return;
}
Bus_SJCSB stcsb = new Bus_SJCSB();
stcsb.ID = listqtcsb.Single().ID;
stcsb.MTPBSCID = Convert.ToInt32(mtpbsc.SelectedValue);
stcsb.MTPBSC = mtpbsc.Text;
stcsb.PBKSSJID = Convert.ToInt32(pbkssj.SelectedValue);
stcsb.PBKSSJ = pbkssj.Text;
stcsb.SSMXSQZ = Convert.ToInt32(ssmxsqz.SelectedValue);
stcsb.ZHXGSJID = Convert.ToInt32(zhxgsj.SelectedValue);
stcsb.XXSJ = Convert.ToInt32(xxsj.SelectedValue);
stcsb.STRXXSJ = xxsj.Text;
stcsb.XXSC = Convert.ToDecimal(xxsc.Text.Replace("小时", ""));
stcsb.STRXXSC = xxsc.Text;
stcsb.ZHXGSJ = zhxgsj.Text;
stcsb.XGSJ = DateTime.Now;
try
{
myModel.Entry(stcsb).State = System.Data.Entity.EntityState.Modified;
myModel.SaveChanges();
MessageBox.Show("保存成功");
myModel.Entry(stcsb).State = System.Data.Entity.EntityState.Detached;
}
catch (Exception ex)
{
MessageBox.Show("保存失败" + ex.ToString());
}
}
private void btn_xz_Click(object sender, RoutedEventArgs e)
{
if (type == "患者VIP")
{
XZGZBRVIPWindow window = new XZGZBRVIPWindow();
window.ShowDialog();
}
if (type == "医生VIP")
{
XZGZYSVIPWindow window = new XZGZYSVIPWindow();
window.ShowDialog();
}
ShuaXin();
}
private void btn_xg_Click(object sender, RoutedEventArgs e)
{
if (type == "手术级别")
{
if (sslxqzid != 0)
{
XGGZSSLXWindow window = new XGGZSSLXWindow(ssjbrow);
window.ShowDialog();
}
else
{
MessageBox.Show("请选择需要修改的信息");
}
}
if (type == "患者VIP")
{
if (brvipqzid != 0)
{
XGGZBRVIPWindow window = new XGGZBRVIPWindow(brvipqzid);
window.ShowDialog();
}
else
{
MessageBox.Show("请选择需要修改的信息");
}
}
if (type == "医生VIP")
{
if (ysvipqzid != 0)
{
XGGZYSVIPWindow window = new XGGZYSVIPWindow(ysvipqzid);
window.ShowDialog();
}
else
{
MessageBox.Show("请选择需要修改的信息");
}
}
if (type == "切口类型")
{
if (ssqjdqzid != 0)
{
XGGZSSQJDWindow window = new XGGZSSQJDWindow(qklxrow);
window.ShowDialog();
}
else
{
MessageBox.Show("请选择需要修改的信息");
}
}
ShuaXin();
}
private void btn_sc_Click(object sender, RoutedEventArgs e)
{
if (type == "患者VIP")
{
if (brvipqzid != 0)
{
MessageBoxResult dr = MessageBox.Show("确定要删除吗？", "提示", MessageBoxButton.OKCancel, MessageBoxImage.Question);
if (dr == MessageBoxResult.OK)
{
var listsbrvipqz = (from tbbrvipqz in myModel.SYS_HZVIPB
where tbbrvipqz.ID == brvipqzid
select new
{
tbbrvipqz,
}).Single();
try
{
myModel.SYS_HZVIPB.Remove(listsbrvipqz.tbbrvipqz);
myModel.SaveChanges();
MessageBox.Show("删除成功");
}
catch (Exception)
{
MessageBox.Show("删除失败");
}
}
}
else
{
MessageBox.Show("请选择需要删除的内容");
}
}
if (type == "医生VIP")
{
if (ysvipqzid != 0)
{
MessageBoxResult dr = MessageBox.Show("确定要删除吗？", "提示", MessageBoxButton.OKCancel, MessageBoxImage.Question);
if (dr == MessageBoxResult.OK)
{
var listsysvipqz = (from tbysvipqz in myModel.SYS_YSVIPB
where tbysvipqz.ID == ysvipqzid
select new
{
tbysvipqz,
}).Single();
try
{
myModel.SYS_YSVIPB.Remove(listsysvipqz.tbysvipqz);
myModel.SaveChanges();
MessageBox.Show("删除成功");
}
catch (Exception)
{
MessageBox.Show("删除失败");
}
}
}
else
{
MessageBox.Show("请选择需要删除的内容");
}
}
ShuaXin();
}
private void btn_sx_Click(object sender, RoutedEventArgs e)
{
ShuaXin();
}
private void ShuaXin()
{
if (type == "手术级别")
{
var listsslx = (from tbsslx in myModel.SYS_SSDJB
select new Cus_SslxQz
{
ID = tbsslx.ID,
SSLX = tbsslx.SSDJ,
LXMS = tbsslx.DJMS,
QZ = tbsslx.QZ
}).ToList().OrderBy(a => a.ID);
sslxdata.ItemsSource = listsslx;
}
if (type == "患者VIP")
{
var listbrvip = (from tbbrvip in myModel.SYS_HZVIPB
select new Cus_BrvipQz
{
ID = tbbrvip.ID,
BRXM = tbbrvip.HZXM,
ZLKH = tbbrvip.ZLKH,
QZ = tbbrvip.QZ
}).ToList().OrderByDescending(a => a.QZ);
brvipdata.ItemsSource = listbrvip;
}
if (type == "医生VIP")
{
var listysvip = (from tbysvip in myModel.SYS_YSVIPB
select new Cus_YsvipQz
{
ID = tbysvip.ID,
YSXM = tbysvip.YSXM,
YSBM = tbysvip.YSBM,
QZ = tbysvip.QZ
}).ToList().OrderByDescending(a => a.QZ);
ysvipdata.ItemsSource = listysvip;
}
if (type == "切口类型")
{
var listssqjd = (from tbssqjd in myModel.SYS_SSQKLXB
join tbsb in myModel.SYS_SSSCB on tbssqjd.QJSCID equals tbsb.ID
select new Cus_SsqjdQz
{
ID = tbssqjd.ID,
SSQJD = tbssqjd.QKLX,
LXMS = tbssqjd.LXMS,
QJSCID = tbsb.ID,
QJSC = tbsb.NAME,
QZ = tbssqjd.QZ
}).ToList().OrderBy(a => a.ID);
ssqjddata.ItemsSource = listssqjd;
}
}
Cus_SslxQz ssjbrow = new Cus_SslxQz();
Cus_SsqjdQz qklxrow = new Cus_SsqjdQz();
private void xxsj_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (xxsj.SelectedValue!=null)
{
if (Convert.ToInt32(xxsj.SelectedValue) == 0)
{
xxsc.SelectedValue = 0;
}
}
}
private void xxsc_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (xxsj.SelectedValue !=null)
{
if (Convert.ToInt32(xxsj.SelectedValue) == 0)
{
xxsc.SelectedValue = 0;
}
}
}
}
}