/// <summary>
/// 页面加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Window_Loaded(object sender, RoutedEventArgs e)
{
var cMmTbAccounts = m.SYS_Guest.ToList();
TbAccounts.ItemsSource = cMmTbAccounts;
TbAccounts.DisplayMemberPath = "MC_Guest";
TbAccounts.SelectedValuePath = "ID_Guest";
//生成并回填单号
TbOddNumbers.Text = "KT00" + (m.YW_OpenStage.Count() + 1).ToString();
////房台号
TbRoomTable.Text = tbRoomTable;
////房台名
TbRoomTableName.Text = rS[0].MC_RoomStage.Trim() == null ? tbRoomTable : rS[0].MC_RoomStage.Trim();
//存在预订单时
if (预定或开台 == "预定")
{
////回填客户数据
int roon_id = rSts[0].ID_RoomStage;
TbAccounts.Text = m.SYS_Guest.Where(p => p.ID_Guest == (m.SYS_RoomStage.Where(r =>
r.ID_RoomStage == roon_id).FirstOrDefault().ID_Guest)).SingleOrDefault().MC_Guest;
////房台名
TbRoomTableName.Text = (rS[0].MC_RoomStage.Trim() + rS[0].Number_RoomStage.Trim()) == null ?
tbRoomTableName : rS[0].MC_RoomStage.Trim() + rS[0].Number_RoomStage.Trim();
////开始时间
TbDevelopmentTime.Text = DateTime.Now.ToLongDateString();
int yyd_id = m.YW_Subscribe.Where(s => s.ID_Guest == (m.VIP_Table.Where
(v => v.ID_Guest == (m.SYS_RoomStage.Where(r => r.ID_RoomStage == roon_id)
.FirstOrDefault().ID_Guest)).FirstOrDefault().ID_Guest)).FirstOrDefault().ID_Subscribe;
////嵌套右边表格
View.Windows.W_UC.W_RoomTableDataGridRight w_RoomTableDataGridRight = new W_UC.W_RoomTableDataGridRight(yyd_id, 0, 0);
w_RoomTableDataGridRight.RetM += new ReuntMessage(ReceiveRight);//定义委托
heeh.Content = w_RoomTableDataGridRight;
heeh.IsSelected = true;
//嵌套左边的表格
View.Windows.W_UC.W_RoomTableDastaGridLeft w_RoomTableDataGridLeft = new W_UC.W_RoomTableDastaGridLeft(rSts);
w_RoomTableDataGridLeft.ReuntLeft += new GetGridMessage(ReceiveLeft);//定义委托
kexuanfangtai.Content = w_RoomTableDataGridLeft;
kexuanfangtai.IsSelected = true;
}
//没有预订单时
else
{
////嵌套右边表格
View.Windows.W_UC.W_RoomTableDataGridRight w_RoomTableDataGridRight = new W_UC.W_RoomTableDataGridRight(0, 0, 0);
w_RoomTableDataGridRight.RetM += new ReuntMessage(ReceiveRight);//定义委托
heeh.Content = w_RoomTableDataGridRight;
heeh.IsSelected = true;
View.Windows.W_UC.W_RoomTableDastaGridLeft w_RoomTableDataGridLeft = new W_UC.W_RoomTableDastaGridLeft(null);
w_RoomTableDataGridLeft.ReuntLeft += new GetGridMessage(ReceiveLeft);//定义委托
kexuanfangtai.Content = w_RoomTableDataGridLeft;
kexuanfangtai.IsSelected = true;
}
/*
*
*
* 开台消费：
* 主页选择房台号后，跳转到开台
* 根据账号查询出顾客的信息，并向预约单询问顾客是否存在预订单
* 如果存在，根据顾客预定的房台 开台消费
* 如果不存在，直接开台消费
*
*/
#region MyRegion
// TbAccounts.Text = zhanghao;
////房台号
////开台单号
//TbOddNumbers.Text = "KT000" + m.YW_OpenStage.Count() + 1;
////开始时间
//TbDevelopmentTime.Text = DateTime.Now.ToLongDateString();
//会员id
//int vip_id = m.VIP_Table.Where(p => p.Accounts == zhanghao).SingleOrDefault().ID_VIP;
////客人id
//int krid = m.VIP_Table.Where(p => p.ID_VIP == vip_id).SingleOrDefault().ID_Guest;
////查看预约表中是否存在对应会员
//int Sub = m.YW_Subscribe.Where(p => p.ID_VIP == vip_id).Count();
////如果存在预约单
//if (Sub > 0)
//{
// int Yydid = m.YW_Subscribe.Where(p => p.ID_VIP == vip_id).SingleOrDefault().ID_Subscribe;
// //如果存在直接从预约房id 开台
// string RoomID = m.YW_Subscribe.Where(p => p.ID_VIP == vip_id).SingleOrDefault().HouseStageID;
// int keid = m.YW_Subscribe.Where(p => p.ID_VIP == vip_id).SingleOrDefault().ID_Guest;
// //开台表
// YW_OpenStage oS = new YW_OpenStage();
// oS.ID_VIP = vip_id;
// //oS.Number_People = Convert.ToInt32(TbPopulation.Text);
// oS.Remark = TbRemark.Text.ToString();
// oS.HouseStageID = RoomID.Trim();
// oS.Type_CheckIn = "足浴";
// oS.Remark = "鬼知道你备注什么";
// oS.Content_Message = "谁设计的奇葩";
// oS.Time_Predict = DateTime.Now;
// oS.GuestID = keid;
// m.YW_OpenStage.Add(oS);
// m.SaveChanges();
// List<RoomStage> rooms = rS;
// rooms.Clear();
// List<string> vs = RoomID.Split(',').ToList();
// for (int i = 0; i < vs.Count; i++)
// {
// int vsid =0;
// if (vs[i] == "")
// {
// vs.Remove(vs[i]);
// }
// else
// {
// try
// {
// vsid = Convert.ToInt32(vs[i]);
// }
// catch (Exception)
// {
// continue;
// }
// //改变房台状态
// SYS_RoomStage sRs = m.SYS_RoomStage.Where(p => p.ID_RoomStage == vsid).SingleOrDefault();
// sRs.ID_Guest = krid;
// sRs.State_RoomStage = "已用";
// m.Entry(sRs).State = System.Data.Entity.EntityState.Modified;
// m.SaveChanges();
// rooms.AddRange(from tb in m.SYS_RoomStage
// where tb.ID_RoomStage == vsid
// select new RoomStage
// {
// Number_RoomStage = tb.Number_RoomStage,
// MC_RoomStage = tb.MC_RoomStage,
// State_RoomStage = tb.State_RoomStage,
// Describe = tb.Describe,
// JionSign = tb.JionSign,
// });
// }
// }
// //嵌套右边表格
// View.Windows.W_UC.W_RoomTableDataGridRight w_RoomTableDataGridRight = new W_UC.W_RoomTableDataGridRight(Yydid,0);
// w_RoomTableDataGridRight.RetM += new ReuntMessage(ReceiveRight);//定义委托
// heeh.Content = w_RoomTableDataGridRight;
// heeh.IsSelected = true;
// //嵌套左边的表格
// View.Windows.W_UC.W_RoomTableDastaGridLeft w_RoomTableDataGridLeft = new W_UC.W_RoomTableDastaGridLeft(rooms);
// w_RoomTableDataGridLeft.ReuntLeft += new GetGridMessage(ReceiveLeft);//定义委托
// kexuanfangtai.Content = w_RoomTableDataGridLeft;
// kexuanfangtai.IsSelected = true;
// //删除预定信息
// //YW_Subscribe ySu = m.YW_Subscribe.Where(p => p.ID_VIP == vip_id).SingleOrDefault();
// //m.YW_Subscribe.Remove(ySu);
// //m.SaveChanges();
//}
////当你没有预定时
//else
//{
// //根据会员 id 找到客人id
// int Guest_id = m.SYS_Guest.Where(p => p.ID_Guest ==
// (m.VIP_Table.Where(v => v.ID_VIP == vip_id).FirstOrDefault().ID_Guest)).SingleOrDefault().ID_Guest;
// //房台状态
// int id_Rs = rS[0].ID_RoomStage;
// SYS_RoomStage Sr = m.SYS_RoomStage.Where(p => p.ID_RoomStage == id_Rs).Single();
// Sr.ID_Guest = krid;
// Sr.State_RoomStage = "已用";
// m.Entry(Sr).State = System.Data.Entity.EntityState.Modified;
// m.SaveChanges();
// //新增开台表
// YW_OpenStage oS = new YW_OpenStage();
// oS.ID_VIP = vip_id;
// //oS.Number_People = Convert.ToInt32(TbPopulation.Text);
// // oS.Remark = TbRemark.Text.ToString();
// oS.GuestID = Guest_id;
// oS.Type_CheckIn = "足浴";
// oS.Remark = "鬼知道你备注什么";
// oS.Content_Message = "谁设计的奇葩";
// oS.HouseStageID = rS[0].ID_RoomStage + ",";
// oS.Time_Predict = DateTime.Now;
// oS.Time_Leave = DateTime.Now;
// m.YW_OpenStage.Add(oS);
// m.SaveChanges();
// //
// int os_id = m.YW_OpenStage.Where(p => p.ID_VIP == vip_id).SingleOrDefault().ID_OpenStage;
// //嵌套右边表格
// View.Windows.W_UC.W_RoomTableDataGridRight w_RoomTableDataGridRight = new W_UC.W_RoomTableDataGridRight(0, os_id);
// w_RoomTableDataGridRight.RetM += new ReuntMessage(ReceiveRight);//定义委托
// heeh.Content = w_RoomTableDataGridRight;
// heeh.IsSelected = true;
// //嵌套左边的表格
// View.Windows.W_UC.W_RoomTableDastaGridLeft w_RoomTableDataGridLeft = new W_UC.W_RoomTableDastaGridLeft(rSts);
// w_RoomTableDataGridLeft.ReuntLeft += new GetGridMessage(ReceiveLeft);//定义委托
// kexuanfangtai.Content = w_RoomTableDataGridLeft;
// kexuanfangtai.IsSelected = true;
//}
//刷新父页面
// Resh();
#endregion
}
/// <summary>
/// 移除按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Remove_Click(object sender, RoutedEventArgs e)
{
//目标数据
string ycft = (m.YW_OpenStage.Where(p => p.ID_VIP == (m.VIP_Table.Where(q => q.Accounts.Trim().ToString()
== zhanghao).FirstOrDefault().ID_VIP)).Single().HouseStageID);
if (RsRight == null || RsRight.Count == 0)
{
RsRight = STATIC_cache.StaticRoomStages;
}
//预定房台.Except(RsRight[0].ID_RoomStage);
//分割字符
List <string> vs = ycft.Split(',').ToList();
List <string> s = vs;
//移出房台id
string RRIDR = RsRight[0].ID_RoomStage.ToString();
for (int i = 0; i < vs.Count; i++)
{
if (vs[i] == "")
{
vs.RemoveAt(i);
break;
}
if (vs[i] == RRIDR)
{
vs.RemoveAt(i);
break;
}
}
//剩下的房台id
string ycftid = "";
foreach (var item in vs)
{
if (item == "")
{
break;
}
else
{
ycftid += item + ",";
}
}
//目标订单id
int ktid = m.YW_OpenStage.Where(p => p.ID_VIP ==
(m.VIP_Table.Where(o => o.Accounts.Trim() == zhanghao.Trim()).FirstOrDefault().ID_VIP)).Single().ID_OpenStage;
YW_OpenStage Yos = m.YW_OpenStage.Where(p => p.ID_OpenStage == ktid).Single();
Yos.HouseStageID = ycftid;
m.Entry(Yos).State = System.Data.Entity.EntityState.Modified;
m.SaveChanges();
int Id_RoomStage = RsRight[0].ID_RoomStage;
SYS_RoomStage RS = m.SYS_RoomStage.Where(p => p.ID_RoomStage == Id_RoomStage).Single();
RS.ID_Guest = null;
RS.State_RoomStage = "未用";
m.Entry(RS).State = System.Data.Entity.EntityState.Modified;
//获取已修改的房台数据
List <RoomStage> rooms = (from tb in m.SYS_RoomStage
where tb.ID_RoomStage == Id_RoomStage
select new RoomStage
{
ID_RoomStage = tb.ID_RoomStage,
Number_RoomStage = tb.Number_RoomStage, //房号
MC_RoomStage = tb.MC_RoomStage,
//State_RoomStage = tb.State_RoomStage == "已用" ? "" : "否"
}).ToList();
if (m.SaveChanges() > 0)
{
//右边表格刷新
View.Windows.W_UC.W_RoomTableDataGridRight w_RoomTableDataGridRight = new W_UC.W_RoomTableDataGridRight(0, RsRight[0].ID_RoomStage, 0);
heeh.Content = null;
heeh.Content = w_RoomTableDataGridRight;
w_RoomTableDataGridRight.UserControl_Loaded(null, null);
//左边表格刷新
View.Windows.W_UC.W_RoomTableDastaGridLeft w_RoomTableDataGridLeft = new W_UC.W_RoomTableDastaGridLeft(rooms);
kexuanfangtai.Content = null;
kexuanfangtai.Content = w_RoomTableDataGridLeft;
w_RoomTableDataGridLeft.UserControl_Loaded(null, null);
}
RsRight.Clear();
}
/// <summary>
/// 页面加载事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
///
private void Window_Loaded(object sender, RoutedEventArgs e)
{
TbRoomTable.Text = tbRoomTable;
TbRoomTableName.Text = tbRoomTableName;
//账号下拉框
// TbAccounts
var cMmTbAccounts = m.SYS_Guest.ToList();
TbAccounts.ItemsSource = cMmTbAccounts;
TbAccounts.DisplayMemberPath = "MC_Guest";
TbAccounts.SelectedValuePath = "ID_Guest";
#region
// 预定单号
// TbOddNumbers.Text = DateTime.Now.ToFileTimeUtc().ToString();
//int Tb = m.YW_Subscribe.Count() + 1;
//string count;
//count = "YD00" + Tb;
//TbOddNumbers.Text = count;
//////客人帐号
//TbAccounts.Text = zhanghao;
//////房台号
//TbRoomTable.Text = roomStages[0].Number_RoomStage.Trim() == null ? tbRoomTable : roomStages[0].Number_RoomStage.Trim();
//////房台名
//TbRoomTableName.Text = (roomStages[0].MC_RoomStage.Trim() + roomStages[0].Number_RoomStage.Trim()) == null ?
//tbRoomTableName : roomStages[0].MC_RoomStage.Trim() + roomStages[0].Number_RoomStage.Trim();
////根据帐号查询预定表
//int ID_Guest_VIP = m.VIP_Table.Where(p => p.Accounts.Trim() == zhanghao.Trim()).Single().ID_Guest;
//int ID_Guest_YW = m.YW_Subscribe.Where(p => p.ID_Guest == ID_Guest_VIP).Count();
//////表格加载前添加预定表
//if (ID_Guest_YW <= 0)
//{
// YW_Subscribe y = new YW_Subscribe();
// y.ID_Guest = m.VIP_Table.Where(p => p.Accounts.Trim() == zhanghao).Single().ID_Guest;//客人id
// y.ID_VIP = m.VIP_Table.Where(p => p.Accounts.Trim() == zhanghao).Single().ID_VIP;//vipid
// y.HouseStageID = roomStages[0].ID_RoomStage.ToString() + ",";//客房id
// y.Number_Subscribe = TbOddNumbers.Text.Trim();//预约单号
// y.Remark = "我是黑大帅";
// y.Type_CheckIn = "足浴";
// m.YW_Subscribe.Add(y);
// m.SaveChanges();
//}
//else
//{
// //查询已存在的预约单id
// Yydid = m.YW_Subscribe.Where(p => p.ID_Guest == ID_Guest_VIP && p.Number_Subscribe == TbOddNumbers.Text.Trim()).FirstOrDefault().ID_Subscribe;
//}
////查询新增的id
//Yydid = m.YW_Subscribe.Where(p => p.ID_Guest == ID_Guest_VIP && p.Number_Subscribe == TbOddNumbers.Text.Trim()).Single().ID_Subscribe;
//////修改房台状态
/////
////客人id
//int keid = m.YW_Subscribe.Where(p => p.ID_Subscribe == Yydid).SingleOrDefault().ID_Guest;
//ID_RoomStage = roomStages[0].ID_RoomStage;
//SYS_RoomStage r = m.SYS_RoomStage.Where(p => p.ID_RoomStage == ID_RoomStage).Single();
//r.State_RoomStage = "预定";
//m.SaveChanges();
//获取id 右边获取数据用
//ID_Guest = m.VIP_Table.Where(o => o.Accounts.Trim() == zhanghao).Single().ID_Guest;//顾客id
//string YWid = m.YW_Subscribe.Where(p => p.ID_Guest == ID_Guest).Single().HouseStageID;//预订单客户id
#endregion
//嵌套右边表格
View.Windows.W_UC.W_RoomTableDataGridRight w_RoomTableDataGridRight = new W_UC.W_RoomTableDataGridRight(0,0,0);
w_RoomTableDataGridRight.RetM +=new ReuntMessage(ReceiveRight);//定义委托
heeh.Content = w_RoomTableDataGridRight;
heeh.IsSelected = true;
//嵌套左边的表格
View.Windows.W_UC.W_RoomTableDastaGridLeft w_RoomTableDataGridLeft = new W_UC.W_RoomTableDastaGridLeft(roomStages);
w_RoomTableDataGridLeft.ReuntLeft += new GetGridMessage(ReceiveLeft);//定义委托
kexuanfangtai.Content = w_RoomTableDataGridLeft;
kexuanfangtai.IsSelected = true;
}
/// <summary>
/// 添加按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtAdd_Click(object sender, RoutedEventArgs e)
{
//获取选中行
if (RsLeft == null || RsLeft.Count == 0)
{
RsLeft = STATIC_cache.StaticRoomStages;
//STATIC_cache.StaticRoomStages.Clear();
}
if (RsLeft == null || RsLeft.Count == 0)
{
MessageBox.Show("请选择需要添加的房台", "大海提示", MessageBoxButton.OK, MessageBoxImage.Asterisk);
return;
}
string tbAccounts = TbAccounts.Text.Trim();
if (string.IsNullOrEmpty(tbAccounts))
{
MessageBox.Show("请选择客人信息", "大海提示", MessageBoxButton.OK, MessageBoxImage.Asterisk);
return;
}
else
{
//获取账号信息
zhanghao = m.VIP_Table.Where(p => p.ID_Guest == (m.SYS_Guest.Where(g => g.MC_Guest == tbAccounts).FirstOrDefault().ID_Guest)).FirstOrDefault().Accounts;
}
//会员id
vip_id = m.VIP_Table.Where(p => p.Accounts == zhanghao).SingleOrDefault().ID_VIP;
//客人id
int krid = m.VIP_Table.Where(p => p.ID_VIP == vip_id).SingleOrDefault().ID_Guest;
////查看预约表中是否存在对应会员 p.State_Secrecy ==true 标志是否有效
int Sub = m.YW_Subscribe.Where(p => p.ID_VIP == vip_id && p.State_Secrecy == true).Count();
int Os_id = 0;
int id_;
int isOp = 0;
List <RoomStage> _Rooms = rS;
// 查询开台表信息
var id = (from tv in m.VIP_Table
join to in m.YW_OpenStage on tv.ID_VIP equals to.ID_VIP
where tv.Accounts.Trim() == zhanghao && to.State_Message == true
select new
{
tv.ID_VIP,
}).SingleOrDefault();
if (id != null)
{
id_ = id.ID_VIP;
isOp = m.YW_OpenStage.Where(l => l.ID_VIP == id_ && l.State_Message == true).FirstOrDefault().ID_OpenStage;
}
//预约表中有对应的数据数据
if (Sub > 0)
{
string Sub_room_id = m.YW_Subscribe.Where(p => p.ID_VIP == vip_id && p.State_Secrecy == true).FirstOrDefault().HouseStageID;
//开台表
YW_OpenStage oS = new YW_OpenStage();
oS.ID_VIP = vip_id;
//oS.Number_People = Convert.ToInt32(TbPopulation.Text);
oS.Remark = TbRemark.Text.ToString();
oS.HouseStageID = Sub_room_id.Trim();
oS.Type_CheckIn = "足浴";
oS.Remark = "鬼知道你备注什么";
oS.Content_Message = "谁设计的奇葩";
oS.Time_Predict = DateTime.Now;
oS.State_Message = true;
oS.GuestID = krid;
m.YW_OpenStage.Add(oS);
m.SaveChanges();
//查询新增的开台表id
Os_id = m.YW_OpenStage.Where(p => p.ID_VIP == vip_id && p.State_Message == true).FirstOrDefault().ID_OpenStage;
//改变预定表数据的有效性
YW_Subscribe yws = m.YW_Subscribe.Where(p => p.ID_VIP == vip_id && p.State_Secrecy == true).SingleOrDefault();
yws.State_Secrecy = false;
m.Entry(yws).State = System.Data.Entity.EntityState.Modified;
m.SaveChanges();
//改变房台状态
_Rooms.Clear();
List <string> vs = Sub_room_id.Split(',').ToList();
for (int i = 0; i < vs.Count; i++)
{
int vsid = 0;
if (vs[i] == "")
{
vs.Remove(vs[i]);
}
else
{
try
{
vsid = Convert.ToInt32(vs[i]);
}
catch (Exception)
{
continue;
}
}
// 改变房台状态
SYS_RoomStage sRs = m.SYS_RoomStage.Where(p => p.ID_RoomStage == vsid).SingleOrDefault();
sRs.ID_Guest = krid;
sRs.State_RoomStage = "已用";
m.Entry(sRs).State = System.Data.Entity.EntityState.Modified;
m.SaveChanges();
_Rooms.AddRange(from tb in m.SYS_RoomStage
where tb.ID_RoomStage == vsid
select new RoomStage
{
Number_RoomStage = tb.Number_RoomStage,
MC_RoomStage = tb.MC_RoomStage,
State_RoomStage = tb.State_RoomStage,
Describe = tb.Describe,
JionSign = (int)tb.JionSign,
});
}
}
//如果开台表已存在开台表就只做修改
else if (isOp > 0)
{
YW_OpenStage os = m.YW_OpenStage.Where(p => p.ID_OpenStage == isOp).SingleOrDefault();
os.HouseStageID = os.HouseStageID + RsLeft[0].ID_RoomStage + ",";
m.Entry(os).State = System.Data.Entity.EntityState.Modified;
m.SaveChanges();
int room_id = RsLeft[0].ID_RoomStage;
SYS_RoomStage rs = m.SYS_RoomStage.Where(p => p.ID_RoomStage == room_id).SingleOrDefault();
rs.State_RoomStage = "已用";
rs.ID_Guest = krid;
m.Entry(rs).State = System.Data.Entity.EntityState.Modified;
m.SaveChanges();
Os_id = isOp;
}
//假如没有就直接新增
else if (Sub == 0)
{
//根据会员 id 找到客人id
int Guest_id = m.SYS_Guest.Where(p => p.ID_Guest ==
(m.VIP_Table.Where(v => v.ID_VIP == vip_id).FirstOrDefault().ID_Guest)).SingleOrDefault().ID_Guest;
//房台状态
int id_Rs = rS[0].ID_RoomStage;
SYS_RoomStage Sr = m.SYS_RoomStage.Where(p => p.ID_RoomStage == id_Rs).Single();
Sr.ID_Guest = krid;
Sr.State_RoomStage = "已用";
m.Entry(Sr).State = System.Data.Entity.EntityState.Modified;
m.SaveChanges();
//新增开台表
YW_OpenStage oS = new YW_OpenStage();
oS.ID_VIP = vip_id;
oS.Number_People = 0;
oS.Remark = TbRemark.Text.ToString();
oS.GuestID = Guest_id;
oS.Type_CheckIn = "足浴";
oS.Remark = "鬼知道你备注什么";
oS.Content_Message = "谁设计的奇葩";
oS.State_Message = true;
oS.HouseStageID = rS[0].ID_RoomStage + ",";
oS.Time_Predict = DateTime.Now;
oS.Time_Leave = DateTime.Now;
m.YW_OpenStage.Add(oS);
m.SaveChanges();
Os_id = m.YW_OpenStage.Where(p => p.ID_VIP == vip_id && p.State_Message == true).FirstOrDefault().ID_OpenStage;
}
//嵌套右边表格
View.Windows.W_UC.W_RoomTableDataGridRight w_RoomTableDataGridRight = new W_UC.W_RoomTableDataGridRight(0, 0, Os_id);
w_RoomTableDataGridRight.RetM += new ReuntMessage(ReceiveRight);//定义委托
heeh.Content = w_RoomTableDataGridRight;
heeh.IsSelected = true;
//嵌套左边的表格
View.Windows.W_UC.W_RoomTableDastaGridLeft w_RoomTableDataGridLeft = new W_UC.W_RoomTableDastaGridLeft(_Rooms);
w_RoomTableDataGridLeft.ReuntLeft += new GetGridMessage(ReceiveLeft);//定义委托
kexuanfangtai.Content = w_RoomTableDataGridLeft;
kexuanfangtai.IsSelected = true;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtAdd_Click(object sender, RoutedEventArgs e)
{
// 预约单号
//获取选中行
if (RsLeft ==null ||RsLeft.Count ==0)
{
RsLeft = STATIC_cache.StaticRoomStages;
//STATIC_cache.StaticRoomStages.Clear();
}
if (string.IsNullOrEmpty(zhanghao))//客户帐号
{
MessageBox.Show("请选中客户信息","大海提示",MessageBoxButton.OK,MessageBoxImage.Asterisk);
return;
}
var id = (from tv in m.VIP_Table
join ty in m.YW_Subscribe on tv.ID_Guest equals ty.ID_Guest
where tv.Accounts.Trim() == zhanghao.Trim() select new
{
ty.ID_Guest,
ty.ID_Subscribe
}).SingleOrDefault();
//没有对应的预约单就添加
if (id ==null)
{
string count = "YYD0" + (m.YW_Subscribe.ToList().Count + 1);//获取 预约单条数
EntityVo.STATIC_cache.Number_Subscribe = count;
TbOddNumbers.Text = count.Trim();
YW_Subscribe s = new YW_Subscribe();
s.ID_Guest = m.VIP_Table.Where(p => p.Accounts.Trim() == zhanghao).Single().ID_Guest;//客人id
s.ID_VIP = m.VIP_Table.Where(p => p.Accounts.Trim() == zhanghao).Single().ID_VIP;//vipid
s.HouseStageID = "";//房台id
s.Number_Subscribe = count;//单号
s.Remark = "我是黑大帅";
s.Type_CheckIn = "足浴";
m.YW_Subscribe.Add(s);
s.State_Secrecy = true;
m.SaveChanges();
}
id = (from tv in m.VIP_Table
join ty in m.YW_Subscribe on tv.ID_Guest equals ty.ID_Guest
where tv.Accounts.Trim() == zhanghao.Trim()
select new
{
ty.ID_Guest,
ty.ID_Subscribe
}).SingleOrDefault();
//roomStage.ID_RoomStage;
// dgdt.ItemsSource[roomStage.ID_RoomStage].
//id.ID_Subscribe
///不知道为啥会报错
try
{
int id_sbb = id.ID_Subscribe;
}
catch (Exception)
{
return;
}
string strHouseStageID = m.YW_Subscribe.Where(p => p.ID_Subscribe == id.ID_Subscribe).SingleOrDefault().HouseStageID;
if (RsLeft[0].ID_RoomStage.ToString().Trim() == strHouseStageID)
{
strHouseStageID = null;
}
YW_Subscribe y = m.YW_Subscribe.Where(p => p.ID_Subscribe == id.ID_Subscribe).SingleOrDefault();
y.HouseStageID = strHouseStageID + RsLeft[0].ID_RoomStage.ToString().Trim() + ",";
m.Entry(y).State = System.Data.Entity.EntityState.Modified;
m.SaveChanges();
int getIDR = RsLeft[0].ID_RoomStage;
int krid= m.YW_Subscribe.Where(p => p.ID_Subscribe == id.ID_Subscribe).SingleOrDefault().ID_Guest;
SYS_RoomStage o = m.SYS_RoomStage.Where(p => p.ID_RoomStage == getIDR).SingleOrDefault();
o.ID_Guest = krid;
o.State_RoomStage = "预定";
//获取已修改的房台数据
List<RoomStage> rooms = (from tb in m.SYS_RoomStage where tb.ID_RoomStage == getIDR
select new RoomStage
{
ID_RoomStage = tb.ID_RoomStage,
Number_RoomStage = tb.Number_RoomStage,//房号
MC_RoomStage = tb.MC_RoomStage,
//State_RoomStage = tb.State_RoomStage == "已用" ? "" : "否"
}).ToList() ;
if (m.SaveChanges()>0)
{
MessageBoxResult messageBoxResult = MessageBox.Show("添加成功！","大海提示",MessageBoxButton.OK,MessageBoxImage.Asterisk);
if (messageBoxResult ==MessageBoxResult.OK)
{
// YYid
Yydid = m.YW_Subscribe.Where(p => p.Number_Subscribe.Trim() == EntityVo.STATIC_cache.Number_Subscribe.Trim()).SingleOrDefault().ID_Subscribe;
//右边表格刷新 EntityVo.STATIC_cache.Number_Subscribe
View.Windows.W_UC.W_RoomTableDataGridRight w_RoomTableDataGridRight = new W_UC.W_RoomTableDataGridRight(Yydid,0,0);
heeh.Content = null;
heeh.Content = w_RoomTableDataGridRight;
w_RoomTableDataGridRight.UserControl_Loaded(null, null);
//左边表格刷新
View.Windows.W_UC.W_RoomTableDastaGridLeft w_RoomTableDataGridLeft = new W_UC.W_RoomTableDastaGridLeft(rooms);
kexuanfangtai.Content = null;
kexuanfangtai.Content = w_RoomTableDataGridLeft;
w_RoomTableDataGridLeft.UserControl_Loaded(null,null);
}
}
RsLeft.Clear();
}
