/// <summary> /// 保存 /// </summary> public void Save() { string _name = String.Empty; if (!Integrity()) { return; } if (base_names == "Bt_the_guest_book") { _name = "预定"; //修改房台状态 SYS_RoomStage sr = m.SYS_RoomStage.Where(c => c.ID_RoomStage == ID_RoomStage).SingleOrDefault(); sr.State_RoomStage = "预定"; sr.ID_Guest = ID_Guest; sr.ID_room_type = int.Parse(ck_tag); m.Entry(sr).State = System.Data.Entity.EntityState.Modified; //添加预定信息 YW_Subscribe sb = new YW_Subscribe(); sb.ID_Guest = ID_Guest; sb.ID_VIP = ID_VIP; sb.ID_AgreementUser = ID_AgreementUser; sb.Number_Subscribe = Tb_Deposit_receipt_no.Text.Trim().ToString(); sb.Time_Predict = DateTime.Parse(Dp_the_date_of_arrival.Text.Trim()); sb.Time_Leave = DateTime.Parse(Dp_departure_time.Text.Trim()); sb.Number_People = int.Parse(Tb_number_of_people.Text.Trim()); sb.Money_Pledge = decimal.Parse(Tb_The_first_deposit.Text.Trim()); sb.State_Secrecy = true; sb.Remark = Tb_note.Text.Trim(); sb.Type_CheckIn = ck_tag; string _ID_houseID = string.Empty; foreach (var item in right) { _ID_houseID += item.ID_RoomStage + ","; } sb.HouseStageID = _ID_houseID; m.YW_Subscribe.Add(sb); m.SaveChanges(); int _IDsub = m.YW_Subscribe.Where(c => c.Number_Subscribe == sb.Number_Subscribe && c.State_Secrecy == true).Single().ID_Subscribe; //添加账单信息 预定押金的 CW_Bill cb = new CW_Bill(); cb.Price = decimal.Parse(Tb_The_first_deposit.Text.Trim()); cb.SuOp_ID = _IDsub; cb.Number_Bill = Tb_Deposit_receipt_no.Text.Trim(); cb.State_Bill = "未结账"; m.CW_Bill.Add(cb); m.SaveChanges(); int _IDbill = m.CW_Bill.Where(c => c.Number_Bill == cb.Number_Bill).Single().ID_Bill; //添加消费记录 CW_Consumption cp = new CW_Consumption(); cp.ID_Bill = _IDbill; cp.ID_RoomStage = ID_RoomStage; cp.ID_ProjectDetail = 0; cp.Prict = decimal.Parse(Tb_The_first_deposit.Text.Trim()); cp.Discount = 1; cp.Effective = true; m.CW_Consumption.Add(cp); } //房台登记 if (base_names == "Bt_The_guest_registration") { _name = "登记"; SYS_RoomStage sr = m.SYS_RoomStage.Where(c => c.ID_RoomStage == ID_RoomStage).SingleOrDefault(); //有预定的情况 if (sr.State_RoomStage.Trim() == "未用") { //添加账单信息 预定押金的 CW_Bill cb = new CW_Bill(); cb.Price = decimal.Parse(Tb_The_first_deposit.Text.Trim()); cb.SuOp_ID = 0; cb.Number_Bill = Tb_Deposit_receipt_no.Text.Trim(); cb.State_Bill = "未结账"; m.CW_Bill.Add(cb); m.SaveChanges(); int _IDbill = m.CW_Bill.Where(c => c.Number_Bill == cb.Number_Bill).Single().ID_Bill; //添加消费记录 CW_Consumption cp = new CW_Consumption(); cp.ID_Bill = _IDbill; cp.ID_RoomStage = ID_RoomStage; cp.ID_ProjectDetail = 0; cp.Prict = decimal.Parse(Tb_The_first_deposit.Text.Trim()); cp.Discount = 1; cp.Effective = true; m.CW_Consumption.Add(cp); } //修改房台状态 sr.State_RoomStage = "已用"; sr.ID_Guest = ID_Guest; sr.ID_room_type = int.Parse(ck_tag); m.Entry(sr).State = System.Data.Entity.EntityState.Modified; YW_OpenStage os = new YW_OpenStage(); os.ID_VIP = ID_VIP; os.ID_AgreementUser = m.AG_AgreementUser.Where(c => c.MC_AgreementUser == Cb_bargaining_unit_l.Text.Trim()).Single().ID_AgreementUser; os.Number_OpenStage = Tb_Deposit_receipt_no.Text.Trim().ToString(); os.Time_Predict = DateTime.Parse(Dp_the_date_of_arrival.Text.Trim()); os.Time_Leave = DateTime.Parse(Dp_departure_time.Text.Trim()); os.Number_People = int.Parse(Tb_number_of_people.Text.Trim()); os.Money_Pledge = decimal.Parse(Tb_The_first_deposit.Text.Trim()); os.State_Secrecy = true; os.Remark = Tb_note.Text.Trim(); os.Type_CheckIn = ck_tag; os.Content_Message = Tb_note.Text.Trim(); string _ID_houseID = string.Empty; foreach (var item in right) { _ID_houseID += item.ID_RoomStage + ","; } os.HouseStageID = _ID_houseID; m.YW_OpenStage.Add(os); } //客人续住 if (base_names == "Bt_guest_delay") { _name = "续住登记"; YW_OpenStage os = m.YW_OpenStage.Where(c => c.Number_OpenStage.Trim() == Tb_Deposit_receipt_no.Text.Trim()).SingleOrDefault(); os.Time_Leave = Dp_departure_time.SelectedDate.Value; m.Entry(os).State = System.Data.Entity.EntityState.Modified; } if (m.SaveChanges() > 0) { MessageBoxResult result = MessageBox.Show("房台" + _name + "成功", "大海提示", MessageBoxButton.OK, MessageBoxImage.Warning); if (result == MessageBoxResult.OK) { this.Close(); refresh(); } } }
/// <summary> /// 人民币结账 /// </summary> private void RMB_settlement() { try { if (!Tools.Tools.IsInteger(Tb_balance.Text)) { MessageBox.Show("请输入正确的数据类型", "大海提示", MessageBoxButton.OK, MessageBoxImage.Warning); return; } //钱够的情况 if (Tb_balance.Text != string.Empty) { //添加消费记录 CW_PayRecord c = new CW_PayRecord(); c.ID_Guest = ID_Guest; c.ID_Bill = ID_Bill; c.Price_Pay = decimal.Parse(Tb_guests_pay.Text.Trim()); c.Time_Pay = DateTime.Now.Date; c.PoP = Cb_payment_method.IsEnabled is false ?"人民币": Cb_payment_method.Text.Trim().ToString(); var co = m.CW_ConsumeDetail.Where(cc => cc.ID_Consumption == ID_Consumption && cc.State_ComsumeDetail == true).ToList(); foreach (var item in co) { //修改该消费记录状态 CW_ConsumeDetail cd = m.CW_ConsumeDetail.Where(cc => cc.ID_ComsumeDetail == item.ID_ComsumeDetail && cc.State_ComsumeDetail == true).SingleOrDefault(); cd.State_ComsumeDetail = false; m.Entry(cd).State = System.Data.Entity.EntityState.Modified; } //注销本次消费 CW_Consumption cp = m.CW_Consumption.Where(cc => cc.ID_Consumption == ID_Consumption && cc.Effective == true).Single(); cp.Effective = false; m.Entry(cp).State = System.Data.Entity.EntityState.Modified; CW_Bill cb = m.CW_Bill.Where(cc => cc.ID_Bill == ID_Bill && cc.State_Bill == null).Single(); cb.Time_PayBill = DateTime.Parse(Tb_The_check_time.Text.Trim()); cb.Remark = Tb_comment.Text.Trim().ToString(); cb.Price = decimal.Parse(Tb_guests_pay.Text.Trim()); cb.State_Bill = "已结账"; m.Entry(cb).State = System.Data.Entity.EntityState.Modified; SYS_RoomStage sr = m.SYS_RoomStage.Where(cc => cc.ID_RoomStage == ID_RoomStage && cc.ID_Guest == ID_Guest).Single(); sr.ID_Guest = null; sr.State_RoomStage = "未用"; m.Entry(sr).State = System.Data.Entity.EntityState.Modified; if (m.SaveChanges() > 0) { MessageBox.Show("结账成功", "大海提示", MessageBoxButton.OK, MessageBoxImage.Warning); } } else //当钱不够时 if (Tb_to_pay_the_balance.Text != string.Empty) { //添加消费记录 CW_PayRecord c = new CW_PayRecord(); c.ID_Guest = ID_Guest; c.ID_Bill = ID_Bill; c.Price_Pay = decimal.Parse(Tb_guests_pay.Text.Trim()); c.Time_Pay = DateTime.Now.Date; c.PoP = Cb_payment_method.IsEnabled is false ? "人民币" : Cb_payment_method.Text.Trim().ToString(); m.SaveChanges(); //修改本次消费 CW_Consumption cp = m.CW_Consumption.Where(cc => cc.ID_Consumption == ID_Consumption && cc.Effective == true).Single(); cp.Prict = decimal.Parse(Tb_to_pay_the_balance.Text.Trim()); m.Entry(cp).State = System.Data.Entity.EntityState.Modified; CW_Bill cb = m.CW_Bill.Where(cc => cc.ID_Bill == ID_Bill && cc.State_Bill == null).Single(); cb.Time_PayBill = DateTime.Parse(Tb_The_check_time.Text.Trim()); cb.Remark = Tb_comment.Text.Trim().ToString(); cb.Price = decimal.Parse(Tb_guests_pay.Text.Trim()); m.Entry(cb).State = System.Data.Entity.EntityState.Modified; if (m.SaveChanges() > 0) { MessageBox.Show("部分结账成功", "大海提示", MessageBoxButton.OK, MessageBoxImage.Warning); } } } catch (Exception e) { WPF_MvvMTest.Tools.Common_means.error_log(e); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Save_Click(object sender, RoutedEventArgs e) { if (TbOddNumbers.Text == "" || TbOddNumbers.Text == null && TbDevelopmentTime.Text == "" || TbDevelopmentTime.Text == null && TbPopulation.Text == "" || TbPopulation.Text == null && TbDiscount.Text == "" || TbDiscount.Text == null && TbRemark.Text == "" || TbRemark.Text == null) { MessageBox.Show("你大爷的,漏数据了", "大海提示", MessageBoxButton.OK, MessageBoxImage.Asterisk); return; } 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; //账单表 // string Mun = STATIC_cache.ScBill_id; //CW_Bill_id int YYid = 0; try { YYid = m.CW_Bill.Where(p => p.SuOp_ID == (m.YW_Subscribe.Where(S => S.ID_VIP == m.VIP_Table.Where(V => V.Accounts == zhanghao).FirstOrDefault().ID_VIP).FirstOrDefault().ID_Subscribe)).FirstOrDefault().SuOp_ID; } catch (Exception) { } if (YYid > 0) { CW_Bill cB = m.CW_Bill.Where(p => p.SuOp_ID == YYid).Single(); cB.Time_PayBill = null; cB.Remark = "该怎么形容你最贴切"; cB.Price = 0; cB.State_Bill = "正在消费"; m.Entry(cB).State = System.Data.Entity.EntityState.Modified; m.SaveChanges(); } else { CW_Bill cW_Bill = new CW_Bill(); cW_Bill.Time_PayBill = null; cW_Bill.Remark = "该怎么形容你最贴切"; cW_Bill.Price = 0; cW_Bill.State_Bill = "正在消费"; m.CW_Bill.Add(cW_Bill); m.SaveChanges(); } int cbid = m.CW_Bill.Where(p => p.SuOp_ID == YYid).Single().ID_Bill; //支付记录表录入 CW_PayRecord cP = new CW_PayRecord(); cP.ID_Guest = krid; cP.Price_Pay = 0; cP.Time_Pay = null; cP.PoP = ""; cP.State = false; cP.ID_Bill = cbid; m.CW_PayRecord.Add(cP); m.SaveChanges(); /**********/ //根据会员 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; try { int os = m.YW_OpenStage.Where(m => m.ID_VIP == vip_id && m.State_Message == true).SingleOrDefault().ID_OpenStage; } catch (Exception) { 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(); } /************/ //开台id int ktid = m.YW_OpenStage.Where(p => p.ID_VIP == (m.VIP_Table.Where(v => v.ID_Guest == krid).FirstOrDefault().ID_VIP)).SingleOrDefault().ID_OpenStage; //开台房台id string ktftid = m.YW_OpenStage.Where(p => p.ID_OpenStage == ktid).Single().HouseStageID; //分割数组 List <string> vs = ktftid.Split(',').ToList(); for (int i = 0; i < vs.Count(); i++) { if (vs[i] == "") { vs.Remove(vs[i]); break; } int ftid = Convert.ToInt32(vs[i]); //消费表 CW_Consumption cC = new CW_Consumption(); cC.ID_Bill = cbid; cC.ID_RoomStage = ftid; cC.Discount = Convert.ToDecimal(TbDiscount.Text) == 0 ? throw new NullReferenceException() : Convert.ToDecimal(TbDiscount.Text); cC.Time_Consumption = DateTime.Now.ToLocalTime(); m.CW_Consumption.Add(cC); //修改房台状态 SYS_RoomStage Rs = m.SYS_RoomStage.Where(m => m.ID_RoomStage == ftid).SingleOrDefault(); Rs.State_RoomStage = "已用"; } if (m.SaveChanges() > 0) { MessageBoxResult m = MessageBox.Show("开台成功!", "大海提示", MessageBoxButton.OK, MessageBoxImage.Asterisk); if (m == MessageBoxResult.OK) { this.Close(); Resh(); } } }
/// <summary> /// 人民币结账 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtRMBSettlement_Click(object sender, RoutedEventArgs e) { //假如钱不够 decimal ljxf = Convert.ToDecimal(TbTheCumulative.Text); decimal bkzf = Convert.ToDecimal(TbFodingTime.Text); if (bkzf < ljxf) { MessageBox.Show("你的钱不够哦,不要想着吃霸王餐哦", "大海提示", MessageBoxButton.OK, MessageBoxImage.Asterisk); return; } //客人账号信息 string krzh = TbGuestAccount.Text.Trim().ToString(); List <SYS_RoomStage> rS = m.SYS_RoomStage.Where(l => l.ID_Guest == m.VIP_Table.Where(k => k.Accounts == krzh).FirstOrDefault().ID_Grade).ToList(); int rs_id = rS[0].ID_RoomStage; foreach (var item in rS) { //房台id int ftid = item.ID_RoomStage; List <CW_Bill> CWb = m.CW_Bill.Where(p => p.ID_Bill == (m.CW_Consumption.Where(o => o.ID_RoomStage == ftid).FirstOrDefault().ID_Bill)).ToList(); foreach (var cW in CWb) { DateTime dtNow = DateTime.Now; //添加支付记录 CW_PayRecord cWpr = new CW_PayRecord(); cWpr.ID_Bill = cW.ID_Bill; cWpr.ID_Guest = rs_id; cWpr.Price_Pay = Convert.ToDecimal(TbTheCumulative.Text); cWpr.Time_Pay = dtNow; cWpr.PoP = "现金支付"; cWpr.State = true;//已支付 m.CW_PayRecord.Add(cWpr); m.SaveChanges(); int cwprid = m.CW_PayRecord.Where(p => p.ID_Bill == cW.ID_Bill && p.ID_Guest == rs_id && p.State == false).ToList()[0].ID_PayRecord; //账单 CW_Bill cwB = m.CW_Bill.Where(p => p.ID_Bill == cW.ID_Bill).SingleOrDefault(); cwB.Price = Convert.ToDecimal(TbTheCumulative.Text); cwB.State_Bill = "已结账"; cwB.Time_PayBill = dtNow; m.Entry(cwB).State = System.Data.Entity.EntityState.Modified; m.SaveChanges(); //消费记录明细 List <CW_ConsumeDetail> cwCD = m.CW_ConsumeDetail.Where(p => p.ID_Consumption == (m.CW_Consumption.Where(c => c.ID_RoomStage == ftid).FirstOrDefault().ID_Consumption)).ToList(); foreach (var cW_Cme in cwCD) { CW_ConsumeDetail cW_Consume = m.CW_ConsumeDetail.Where(p => p.ID_Consumption == cW_Cme.ID_Consumption).FirstOrDefault(); cW_Consume.State_ComsumeDetail = false; cW_Consume.ID_PayRecord = cwprid; m.Entry(cW_Consume).State = System.Data.Entity.EntityState.Modified; m.SaveChanges(); } } //修改房台状态 SYS_RoomStage sysRs = m.SYS_RoomStage.Where(p => p.ID_RoomStage == item.ID_RoomStage).SingleOrDefault(); sysRs.ID_Guest = null; sysRs.State_RoomStage = "未用"; m.Entry(sysRs).State = System.Data.Entity.EntityState.Modified; m.SaveChanges(); if (CWb.Count > 0) { MessageBoxResult mb = MessageBox.Show("结账成功", "大海提示", MessageBoxButton.OK, MessageBoxImage.Asterisk); if (mb == MessageBoxResult.OK) { this.Close(); } } } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtPreserve_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(TbAccounts.Text.ToString()) || string.IsNullOrEmpty(TbRoomTable.Text.ToString())|| string.IsNullOrEmpty(TbRoomTableName.Text.ToString()) || string.IsNullOrEmpty(TbOddNumbers.Text.ToString())|| string.IsNullOrEmpty(TbDevelopmentTime.Text.ToString()) || string.IsNullOrEmpty(TbPopulation.Text.ToString())|| string.IsNullOrEmpty(TbDiscount.Text.ToString())|| string.IsNullOrEmpty(TbRemark.Text.ToString())) { MessageBox.Show("请将信息填写完整", "大海提示",MessageBoxButton.OKCancel,MessageBoxImage.Asterisk); return; } //预定单号 string odd = TbOddNumbers.Text.ToString(); YW_Subscribe YWS = m.YW_Subscribe.Where(p => p.Number_Subscribe == odd).SingleOrDefault(); YWS.Time_Predict = Convert.ToDateTime(TbDevelopmentTime.Text.Trim()); YWS.Number_People = Convert.ToInt32(TbPopulation.Text); YWS.Remark = TbRemark.Text.Trim(); m.Entry(YWS).State = System.Data.Entity.EntityState.Modified; m.SaveChanges(); //折扣 //生成账单 int yddid = m.YW_Subscribe.Where(p => p.Number_Subscribe == odd).SingleOrDefault().ID_Subscribe;//预订单id string Mun = "ZD000" + m.CW_Bill.Count() + 1;//账单号 CW_Bill Cb = new CW_Bill(); Cb.SuOp_ID = yddid;//预订单id Cb.Number_Bill = Mun; Cb.Remark = "预定";//备注 Cb.State_Bill = "预定";//状态 m.CW_Bill.Add(Cb); m.SaveChanges(); //保存数据 // STATIC_cache.ScBill_id = Mun; //预订单房台id string ftid = m.YW_Subscribe.Where(p => p.Number_Subscribe == odd).SingleOrDefault().HouseStageID; List<string> vs = ftid.Split(',').ToList(); //生成消费单方法 int mSc=0; foreach (var item in vs) { if (item != "") { CW_Consumption Cc = new CW_Consumption(); //房台id Cc.ID_RoomStage = Convert.ToInt32(item); //账单id Cc.ID_Bill = m.CW_Bill.Where(p => p.SuOp_ID == yddid).SingleOrDefault().ID_Bill; Cc.Effective = true; //折扣、TbDiscount Cc.Discount = Convert.ToDecimal(TbDiscount.Text); m.CW_Consumption.Add(Cc); mSc= m.SaveChanges(); } else { break; } } if (mSc >0) { MessageBoxResult messageBoxResult = MessageBox.Show("保存成功", "大海提示", MessageBoxButton.OKCancel, MessageBoxImage.Asterisk); if (messageBoxResult ==MessageBoxResult.OK) { this.Close(); Resh(); } } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Bt_save_Click(object sender, RoutedEventArgs e) { //代码还有整合得空间,算了懒得去搞~ if (Cb_Founding_account.Text.Equals(string.Empty) && Tb_Founding_account.Equals(string.Empty) || Tb_Room_table.Text.Equals(string.Empty) || Tb_Room_table_name.Text.Equals(string.Empty) || Tb_odd.Text.Equals(string.Empty) || Tb_Founding_time.Text.Equals(string.Empty) || Tb_number_of_people.Text.Equals(string.Empty) || Tb_discount.Text.Equals(string.Empty) || Tb_account.Text.Equals(string.Empty) || Tb_postscript.Text.Equals(string.Empty)) { MessageBox.Show("请将信息填写完整", "大海提示", MessageBoxButton.OK, MessageBoxImage.Warning); return; } string hsid = string.Empty; //未定状态 if (Cb_Founding_account.IsVisible) { int?Guest = m.SYS_Guest.Where(c => c.MC_Guest.Trim() == Cb_Founding_account.Text).SingleOrDefault().ID_AgreementUser; foreach (var item in RightOc) { hsid += item.ID_RoomStage + ","; //账单表 CW_Bill b = new CW_Bill(); //b.ID_Bill = c.ID_Consumption; b.Number_Bill = Tb_odd.Text.Trim(); m.CW_Bill.Add(b); m.SaveChanges(); //消费表 CW_Consumption c = new CW_Consumption(); c.ID_RoomStage = item.ID_RoomStage; /// c.ID_Bill = b.ID_Bill; //c.ID_Bill = m.CW_Bill.AsEnumerable().Last().ID_Bill;//查询表格中最后一条数据 c.ID_Bill = m.CW_Bill.Where(t => t.Number_Bill == Tb_odd.Text.Trim() && t.State_Bill == null).Single().ID_Bill; c.Discount = Convert.ToDecimal(Tb_discount.Text.Trim()); c.Effective = true; m.CW_Consumption.Add(c); m.SaveChanges(); //房台 SYS_RoomStage r = m.SYS_RoomStage.Where(d => d.ID_RoomStage == item.ID_RoomStage).FirstOrDefault(); r.State_RoomStage = "已用"; r.ID_Guest = item.ID_Guest; m.Entry(r).State = System.Data.Entity.EntityState.Modified; m.SaveChanges(); } ; var ID_VIP = m.VIP_Table.Where(c => c.Accounts == Tb_account.Text.Trim()).FirstOrDefault().ID_VIP; //预约 YW_OpenStage o = new YW_OpenStage(); o.Number_People = int.Parse(Tb_number_of_people.Text.Trim());//人数 o.Number_OpenStage = Tb_odd.Text.Trim(); o.ID_VIP = ID_VIP; o.State_Secrecy = true; o.Remark = Tb_postscript.Text.Trim(); o.Type_CheckIn = "餐饮"; o.Content_Message = string.Empty; if (!Guest.Equals(null)) { o.ID_AgreementUser = (int)Guest; } o.HouseStageID = hsid; o.Time_Predict = Convert.ToDateTime(Tb_Founding_time.Text.Trim()); m.YW_OpenStage.Add(o); if (m.SaveChanges() > 0) { MessageBox.Show("开台成功", "大海提示", MessageBoxButton.OK, MessageBoxImage.Warning); Close(); return; } } //预定状态 if (Tb_Founding_account.IsVisible) { foreach (var item in RightOc) { //查看该房台是否存在消费但 var date = m.CW_Consumption.Where(c => c.ID_RoomStage == item.ID_RoomStage && c.Effective == true).FirstOrDefault(); if (date.Equals(null)) { CW_Bill b = new CW_Bill(); // b.ID_Bill = c.ID_Consumption; b.Number_Bill = Tb_odd.Text.Trim(); m.CW_Bill.Add(b); m.SaveChanges(); CW_Consumption c = new CW_Consumption(); c.ID_RoomStage = item.ID_RoomStage; c.Discount = Convert.ToDecimal(Tb_discount.Text.Trim()); c.ID_Bill = m.CW_Bill.Where(t => t.Number_Bill == Tb_odd.Text.Trim() && t.State_Bill == null).Single().ID_Bill; c.Effective = true; m.CW_Consumption.Add(c); m.SaveChanges(); } //修改房台信息 SYS_RoomStage r = m.SYS_RoomStage.Where(c => c.ID_RoomStage == item.ID_RoomStage && c.State_RoomStage.Trim() == "预定").SingleOrDefault(); r.ID_Guest = null; r.State_RoomStage = "已用"; m.Entry(r).State = System.Data.Entity.EntityState.Modified; } var ID_VIP = m.VIP_Table.Where(c => c.Accounts == Tb_account.Text.Trim()).FirstOrDefault().ID_VIP; //修改预定信息 YW_Subscribe w = m.YW_Subscribe.Where(c => c.ID_VIP == ID_VIP && c.State_Secrecy == true).SingleOrDefault(); w.State_Secrecy = false; m.Entry(w).State = System.Data.Entity.EntityState.Modified; m.SaveChanges(); YW_OpenStage o = new YW_OpenStage(); o.Number_People = int.Parse(Tb_number_of_people.Text.Trim());//人数 o.Number_OpenStage = Tb_odd.Text.Trim(); o.ID_VIP = ID_VIP; o.State_Secrecy = true; o.Remark = Tb_postscript.Text.Trim(); o.HouseStageID = hsid; o.Time_Predict = Convert.ToDateTime(Tb_Founding_time.Text.Trim()); o.Type_CheckIn = "餐饮"; o.Content_Message = string.Empty; m.YW_OpenStage.Add(o); if (m.SaveChanges() > 0) { MessageBox.Show("开台成功", "大海提示", MessageBoxButton.OK, MessageBoxImage.Warning); Close(); return; } } }