/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="routedEvent"></param>
private void BtConfirm_Click(object sender, RoutedEventArgs routedEvent)
{
try
{
string strText = "";
string tbRoom_name = TbRoom_Name.Text.Trim().ToString() == "" ? strText = "房台名称不能为空" : TbRoom_Name.Text.Trim().ToString();
string cbStatus = CbStatus.Text.Trim().ToString() == "" ? strText = "请选择状态" : CbStatus.Text.Trim().ToString();
string tbDescribe = TbDescribe.Text.Trim().ToString() == "" ? strText = "请输入房台描述" : TbDescribe.Text.Trim().ToString();
//string cbClass = CbClass.SelectedIndex.ToString() == "0" ? strText = "请选中类型" : CbClass.SelectedIndex.ToString();
Model.SYS_Class sYS_ = (CbClass.SelectedItem) as Model.SYS_Class;
int cbClass = sYS_.ID_Class;
int numberRoomStage = my.SYS_RoomStage.Count();
int c = Convert.ToInt32(cbClass);
int count = my.SYS_RoomStage.Where(p => p.MC_RoomStage.Trim().ToString() == tbRoom_name && p.State_RoomStage == cbStatus &&
p.Describe == tbDescribe && p.ID_Class == c).Count();
if (count > 0)
{
MessageBox.Show("已存在房台信息", "大海提示", MessageBoxButton.OKCancel, MessageBoxImage.Warning);
return;
}
else if (tbRoom_name != "" && cbStatus != "" && tbDescribe != "" && c > 0)
{
//修改
if (tupl != null)
{
strText = "房台修改成功";
Model.SYS_RoomStage r = my.SYS_RoomStage.Where(p => p.ID_RoomStage == Id_RoomStage).Single();
r.MC_RoomStage = tbRoom_name;
r.State_RoomStage = cbStatus;
r.Describe = tbDescribe;
r.ID_Class = type_room;
my.Entry(r).State = System.Data.Entity.EntityState.Modified;
if (my.SaveChanges() > 0)
{
MessageBoxResult result = MessageBox.Show(strText, "大海提示", MessageBoxButton.OKCancel, MessageBoxImage.Warning);
if (result == MessageBoxResult.OK)
{
View.Usercontrol.UC_TealTimeExecutive u = new Usercontrol.UC_TealTimeExecutive();
u.UserControl_Loaded(null, null);
this.Close();
}
}
}
//添加
else if (tupl == null)
{
strText = "房台添加成功";
SYS_RoomStage m = new SYS_RoomStage();
m.MC_RoomStage = tbRoom_name;
m.State_RoomStage = cbStatus;
m.Number_RoomStage = (numberRoomStage + 1).ToString();
m.Describe = tbDescribe;
m.ID_Class = type_room;
my.SYS_RoomStage.Add(m);
if (my.SaveChanges() > 0)
{
MessageBoxResult s = MessageBox.Show(strText, "大海提示", MessageBoxButton.OKCancel, MessageBoxImage.Warning);
// View.Usercontrol.UC_TealTimeExecutive u = new Usercontrol.UC_TealTimeExecutive();
if (s == MessageBoxResult.OK)
{
//调用委托
ChangC();
this.Close();
}
}
}
}
else
{
MessageBox.Show(strText, "大海提示", MessageBoxButton.OKCancel, MessageBoxImage.Warning);
}
}
catch (Exception e)
{
Debug.Write(e);
}
}
/// <summary>
/// 确定换房台
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtQuit_Click(object sender, RoutedEventArgs e)
{
// tuple = new Tuple<string, string, string, string, int>(tbRoom_name, cbStatus, tbDescribe, cbClass, ID_RoomStage,Num);
string tbRoom_name = tuples.Item6; //房号
int id = tuples.Item5; //id
string nowNum = TbRoomNum.Text.Trim().ToString();
if (!Tools.Tools.IsNum(nowNum))
{
MessageBox.Show("请输入数字", "大海提示", MessageBoxButton.OK, MessageBoxImage.Warning);
}
//赛选文本所对应的房台id
List <RoomStage> RS = //m.SYS_RoomStage.Where(f => f.Number_RoomStage == nowNum).Single();
(from tb in m.SYS_RoomStage
where tb.Number_RoomStage == nowNum
select new RoomStage
{
ID_RoomStage = tb.ID_RoomStage,
}).ToList();
int IDRoomStage = 0;
foreach (var item in RS)
{
IDRoomStage = item.ID_RoomStage;
}
//改变房台状态2
int SYSRS2;
Model.SYS_RoomStage rs = m.SYS_RoomStage.Where(l => l.ID_RoomStage == IDRoomStage).Single();
rs.State_RoomStage = "已用";
m.Entry(rs).State = System.Data.Entity.EntityState.Modified;
SYSRS2 = m.SaveChanges();
//改变消费表对应房台id
int CWC;
Model.CW_Consumption c = m.CW_Consumption.Where(m => m.ID_RoomStage == id).SingleOrDefault();
c.ID_RoomStage = Convert.ToInt32(nowNum);
m.Entry(c).State = System.Data.Entity.EntityState.Modified;
CWC = m.SaveChanges();
//改变房台状态1
int SYSRS1;
Model.SYS_RoomStage r = m.SYS_RoomStage.Where(l => l.ID_RoomStage == id).Single();
r.State_RoomStage = "未用";
SYSRS1 = m.SaveChanges();
m.Entry(r).State = System.Data.Entity.EntityState.Modified;
if (CWC > 0 && SYSRS1 > 0 && SYSRS2 > 0)
{
MessageBoxResult message = MessageBox.Show("房台转换成功", "大海提示", MessageBoxButton.OKCancel, MessageBoxImage.Warning);
if (message == MessageBoxResult.OK)
{
btq();
this.Close();
}
}
else
{
MessageBox.Show("房台转换失败", "大海提示", MessageBoxButton.OKCancel, MessageBoxImage.Warning);
}
}
