/// <summary> /// 顾客登记 /// </summary> /// <param name="guest"></param> /// <returns></returns> public static bool AddGuest(GuestInsert guest) { string sql = "Insert GuestRecord(IdentityID,GuestName,RoomID,ResideID,ResideDate,Deposit) Values(@IdCard,@Name,@RoomId,(Select ResideId From ResideState Where ResideName = '未结账'),@ResideDate,@Deposit)"; SqlParameter [] paras = { new SqlParameter("@IdCard", guest.IdentityId), new SqlParameter("@Name", guest.GuestName), new SqlParameter("@RoomId", guest.RoomId), new SqlParameter("@ResideDate", guest.ResideDate), new SqlParameter("@Deposit", guest.Deposit) }; try { if (!SqlHelper.Execute(sql, paras)) { return(false); } //更新房间入住人数 RoomService.UpdateRoomGuestNum(guest.RoomId); return(true); } catch (Exception) { throw; } }
/// <summary> /// 顾客入住 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOk_Click(object sender, EventArgs e) { if (!CheckIsNull()) { return; } //创建顾客对象 GuestInsert guest = new GuestInsert( this.txtIdentityID.Text.Trim(), this.txtGuestName.Text.Trim(), Convert.ToInt32(this.cboRooms.SelectedValue), this.dtpReside.Value, Convert.ToDecimal(this.txtDeposit.Text.Trim()) ); //登记 try { if (GuestRecordBLL.AddGuest(guest)) { MessageBox.Show("登记成功!", "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information); Recovery(); this.txtIdentityID.Focus(); } else { MessageBox.Show("登记失败。", "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("顾客登记出现异常\n" + ex.Message, "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// 顾客登记 /// </summary> /// <param name="guest"></param> /// <returns></returns> public static bool AddGuest(GuestInsert guest) { try { return(GuestRecordService.AddGuest(guest)); } catch (Exception) { throw; } }