Пример #1
0
        private void Button_Click(object sender, RoutedEventArgs e)

        {
            User user = new User();
            user.Id = Guid.NewGuid();
            user.Name = tbName.Text;
            user.IdentityCardNumber = tbIdentityCardNumber.Text;
            if (rbMan.IsChecked == true && rbWoman.IsChecked == false)
            {
                user.Sex = "男";
            }
            else if (rbMan.IsChecked == false && rbWoman.IsChecked == true)
            {
                user.Sex = "女";
            }
            else
            {
                lbMessge.Content ="请选择性别!";
            }
            user.Address = tbAddress.Text;
            user.Duty = "服务员";
            user.UserName = tbUeserName.Text;
            user.Password = tbPassword.Text;

            AddUserBLL.addUser(user);
            UserRefresh(sender, e);
            tbName.Text = "";
            tbIdentityCardNumber.Text = "";
            tbAddress.Text = "";
            tbUeserName.Text = "";
            tbPassword.Text = "";


        }
Пример #2
0
        private void CheckOutBill_Loaded(object sender, RoutedEventArgs e)
        {
           
           DataTable checkInBill= UseRoomNumberSelectCheckInBillBLL.UseRoomNumberSelectCheckInBill(MainWondows.SelectRoomNumber);
           DataRow row = checkInBill.Rows[0];
           checkOutBill.Id = Guid .NewGuid ();
           lbBillNumber.Content = checkOutBill.BillNumber = (Guid)row["BillNumber"];
           lbRoomNumber .Content  = checkOutBill.RoomNumber = MainWondows.SelectRoomNumber;
           lbGuestName .Content = checkOutBill.GuestName = (string)row["GuestName"];
           lbNumberOfPeaple .Content = checkOutBill.NumberOfPeaple = (string)row["NumberOfPeaple"];
           lbRoomRate .Content = checkOutBill.RoomRate = MainWondows.RoomRate;
           lbConsumPionPaid .Content = checkOutBill.ConsumptionPaid = (decimal)row["AmountPaid"] - MainWondows.RoomRate;
           lbDate .Content = checkOutBill.Date = System.DateTime.Now;
            
            User user=new User ();
            user .UserName =LoginWindows .UserName ;
            DataTable usertable = UseUserNameSelectUserBLL.useUserNameSelectUser(user);
            DataRow userRow = usertable.Rows[0];
            lbWaiterName .Content =  checkOutBill.WaiterName =(string ) userRow["Name"];

            checkOutBill.CheckInBillTableId = (Guid)row["Id"];
          
           
           
        }
Пример #3
0
        public static List<User> loadUserData(string sql)
        {
            List<User> list = new List<User>();
            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql))
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        User user = new User();
                        user.Name  = reader.GetString(0);
                        user.IdentityCardNumber = reader.GetString(1);
                        user.Sex = reader.GetString(2);
                        user.Address = reader.GetString(3);
                        user.Duty = reader.GetString(4);
                        user.UserName = reader.GetString(5);
                        user.Password = reader.GetString(6);
                       
                        list.Add(user);
                    }
                }

            }
            return list;
        }
Пример #4
0
 public static void addUser(User user)
 {
     SqlParameter[] pams = new SqlParameter[]
    {
        new SqlParameter ("@Id",user.Id ),
        new SqlParameter ("@Name",user.Name ),
        new SqlParameter ("@IdentityCardNumber",user .IdentityCardNumber  ),
        new SqlParameter ("@Sex", user .Sex  ),            
        new SqlParameter ("@Address",user .Address  ),  
        new SqlParameter ("@Duty",user .Duty  ), 
        new SqlParameter ("@UserName",user .UserName  ),  
        new SqlParameter ("@Password",user .Password  ),
   };
     SqlHelper.ExecuteNonQuery(AddUserDAL.sql, pams);
 }
Пример #5
0
        /// <summary>
        /// 用户登陆
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btSuer_Click(object sender, RoutedEventArgs e)
        {
          
            User user = new User();
            if (tbxUserName.Text == "" || pwbPassword.Password == "")
            {
                lbReminder.Content = "用户名或密码不能为空,请输入!";
            }
            else
            {
                user.UserName = tbxUserName.Text;
                user.Password = pwbPassword.Password;


                DataTable table = LoginBll.Login(user);

                if (table.Rows.Count <= 0)
                {
                    lbReminder.Content = "用户名不存在,请查证后再输入!";
                    return;
                }
                if (table.Rows.Count > 1)
                {
                    lbReminder.Content = "有多个用户存在,请联系管理员!";
                    return;
                }
                DataRow row = table.Rows[0];
                string dataUserPasswod = (string)row["Password"];
                if (dataUserPasswod != user.Password)
                {
                    lbReminder.Content = "密码错误,请查证后再输入!";
                }
                else
                {
                    UserName = user .UserName ;
                    MainWondows   mainWindows = new MainWondows();

                    DataTable userTable = UseUserNameSelectUserBLL.useUserNameSelectUser(user);
                    DataRow userRow = userTable.Rows[0];
                    WaiterName  = (string)userRow["Name"];
                   
                    mainWindows.Show();
                    LoginWindow.Close();
                }
            }
        }
Пример #6
0
        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;
           
        }
Пример #7
0
 /// <summary>
 /// 用户验证
 /// </summary>
 /// <param name="sql"></param>
 /// <param name="User"></param>
 /// <returns></returns>
 public static DataTable Longin(User user )
 {
     DataTable table = SqlHelper.ExecuteDataTable(sql, new SqlParameter("@UserName", user.UserName));
     return table;
 }
Пример #8
0
 /// <summary>
 /// 验证登陆
 /// </summary>
 /// <param name="User"></param>
 public static DataTable Login(User user)
 {
   return   LoginDAL.Longin(user );
 }
Пример #9
0
 private void UserDataRefresh(object sender, RoutedEventArgs e)
 {
     User user = new User();
     user.UserName = LoginWindows.UserName;
     DataTable userTable = UseUserNameSelectUserBLL.useUserNameSelectUser(user);
     DataRow row = userTable.Rows[0];
     if ((string)row["Duty"] == "管理员")
     { dgUserData.ItemsSource = LoadUserDataBLL.loadUserData(); }
    
 }
Пример #10
0
      public static void  addUser(User user)
      {
          AddUserDAL.addUser(user);

      }
Пример #11
0
 public static DataTable useUserNameSelectUser(User user)
 {
     return UseUserNameSelectUserDAL.useUserNameSelectUser(user);
 }