public static void addGuest(Guest guest) { SqlParameter[] pams = new SqlParameter[] { new SqlParameter ("@Id",guest.Id ), new SqlParameter ("@Name",guest.Name ), new SqlParameter ("@IdentityCardNumber",guest .IdentityCardNumber ), new SqlParameter ("@Sex", guest .Sex ), new SqlParameter ("@Address",guest .Address ), new SqlParameter ("@TelephoneNumber",guest .TelephoneNumber ), }; SqlHelper.ExecuteNonQuery(AddGuestDAL.sql, pams); }
private void btAddGuest_Click(object sender, RoutedEventArgs e) { Guest guest = new Guest(); guest.Id = Guid.NewGuid(); guest.Name = tbName.Text; if (rbMan .IsChecked==true&&rbWoman .IsChecked ==false ) { guest .Sex ="男"; } else if (rbMan.IsChecked ==false &&rbWoman .IsChecked ==true ) { guest .Sex ="女"; } else { MessageBox .Show ("请选择性别!"); } guest.TelephoneNumber = tbTelephoneNumber.Text; guest.Address = tbAddress.Text; guest.IdentityCardNumber = tbIdentityCardNumber.Text ; AddGuestBLL.addGuest(guest); CheckIn checkIn = new CheckIn(); checkIn.Id = Guid.NewGuid(); checkIn.RoomNumber = MainWondows.SelectRoomNumber; checkIn.GuestName = guest.Name; checkIn.Date = System.DateTime.Now; checkIn.IdentityCardNumber = guest.IdentityCardNumber; checkIn.Address = guest.Address; checkIn.TelephoneNumber = guest.TelephoneNumber; AddCheckInBLL.addCheckIn(checkIn); tbAddress.Text = ""; tbIdentityCardNumber.Text = ""; tbName.Text = ""; tbTelephoneNumber.Text = ""; NumberOfPeaple++; if (NumberOfPeaple ==1) { FirstGuestId = guest.Id; }; lbNumberOfPeaple.Content = NumberOfPeaple; }
private void Window_Loaded(object sender, RoutedEventArgs e) { Guest guest=new Guest (); guest.Id =AddGuestToRoom.FirstGuestId ; DataTable table=UseIdSelectGuestBLL.useIdSelectGuest (guest ); DataRow row=table .Rows[0]; lbBillNumber.Content = BillNumber=Guid.NewGuid(); lbRoomNumber.Content = MainWondows.SelectRoomNumber; lbNumberOfPeaple.Content = AddGuestToRoom.NumberOfPeaple; lbRoomRate.Content = MainWondows.RoomRate; User user = new User(); user.UserName = LoginWindows.UserName; DataTable userTable = UseUserNameSelectUserBLL .useUserNameSelectUser (user ); DataRow userRow = userTable.Rows[0]; lbWaiterName.Content = WaiterName = (string)userRow["Name"]; lbGuestName.Content = GuestName = (string)row["Name"]; lbDate.Content = System.DateTime.Now; }
public static void addGuest(Guest guest) { AddGuestDAL.addGuest(guest); }
public static DataTable useIdSelectGuest(Guest guest) { DataTable table = SqlHelper.ExecuteDataTable(sql, new SqlParameter("@Id", guest .Id)); return table; }
public static DataTable useIdSelectGuest(Guest guest) { return UseIdSelectGuestDAL.useIdSelectGuest(guest); }