using SchedulingSystem.EntityClass;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows;
namespace SchedulingSystemClient.InsertWindow
{
///
/// XZSBWindow.xaml 的交互逻辑
///
public partial class XZSBWindow : Window
{
public XZSBWindow()
{
InitializeComponent();
}
SurgerySchedulingEntities myModel = new SurgerySchedulingEntities();
private void Window_Loaded(object sender, RoutedEventArgs e)
{
List listsblx = new List();
listsblx = (from tbsblxb in myModel.SYS_SBLXB
select new ComboBoxBinding
{
ID = tbsblxb.ID,
Name = tbsblxb.Name,
}).ToList();
sblx.ItemsSource = listsblx;
sblx.SelectedValuePath = "ID";
sblx.DisplayMemberPath = "Name";
List listsss = new List();
listsss = (from tbsssb in myModel.SYS_SSSB
select new ComboBoxBinding
{
ID = tbsssb.ID,
Name = tbsssb.SSSMC,
}).ToList();
sss.ItemsSource = listsss;
sss.SelectedValuePath = "ID";
sss.DisplayMemberPath = "Name";
List listsbdj = new List();
listsbdj = (from tbsbdj in myModel.SYS_SBDJB
select new ComboBoxBinding
{
ID = tbsbdj.ID,
Name = tbsbdj.Name,
}).ToList();
sbdj.ItemsSource = listsbdj;
sbdj.SelectedValuePath = "ID";
sbdj.DisplayMemberPath = "Name";
}
private void btn_bc_Click(object sender, RoutedEventArgs e)
{
if (sbbm.Text == string.Empty)
{
MessageBox.Show("请填写设备编码");
return;
}
if (sbmc.Text == string.Empty)
{
MessageBox.Show("请填写设备名称");
return;
}
if (sss.SelectedValue == null)
{
MessageBox.Show("请选择手术室");
return;
}
if (sblx.SelectedValue == null)
{
MessageBox.Show("请选择设备类型");
return;
}
if (sbdj.SelectedValue == null)
{
MessageBox.Show("请选择设备等级");
return;
}
decimal jg;
try
{
if (sbjg.Text!=string.Empty)
{
jg = Convert.ToDecimal(sbjg.Text);
}
else
{
jg = 0;
}
}
catch (Exception )
{
MessageBox.Show("设备价格格式不正确");
return;
}
int sssid = Convert.ToInt32(sss.SelectedValue);
int sblxid = Convert.ToInt32(sblx.SelectedValue);
int sbjdid = Convert.ToInt32(sbdj.SelectedValue);
Bus_SBB sbb = new Bus_SBB();
sbb.SBBM = sbbm.Text.Trim();
sbb.SBDJ = sbjdid;
sbb.SBJG = jg;
sbb.SBLX = sblxid;
sbb.SBMC = sbmc.Text.Trim();
sbb.SSSID = sssid;
try
{
myModel.Bus_SBB.Add(sbb);
myModel.SaveChanges();
MessageBox.Show("新增成功");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}