/// <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(); }