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