private void Save_Edit(object sender, RoutedEventArgs e) { ComboBoxItem status = (ComboBoxItem)this.status.SelectedItem; UserBean bean = new UserBean(); QueryUser query = new QueryUser(); query.Account = UserManagerBean.AddUser.queryAccount.Text; query.UserName = UserManagerBean.AddUser.queryName.Text; bean.Id = int.Parse(this.userId.Content.ToString()); bean.UserName = this.userName.Text; bean.Phone = this.userPhone.Text; bean.Status = int.Parse(status.Tag.ToString()); bean.Type = this.userType.SelectedIndex; Users user = new Users(); int state = user.saveUserEdit(bean); if (state == BaseRequest.SUCCESS) { JXMessageBox.Show(Window.GetWindow(this), "编辑用信息保存成功!", MsgImage.Success); this.Close(); UserManagerBean.AddUser.page.ShowPages(UserManagerBean.AddUser.userData, user.getUsersList(query), BaseRequest.PAGE_SIZE); } else if (state == BaseRequest.SYSTEM_EXCEPTION) { JXMessageBox.Show(Window.GetWindow(this), "系统异常,请联系管理员!", MsgImage.Error); } else { JXMessageBox.Show(Window.GetWindow(this), "未知错误", MsgImage.Error); } }
private void Submit_AddUser(object sender, RoutedEventArgs e) { if (ValidateUtil.CheckFolderName(this.account.Text) == false) { JXMessageBox.Show(Window.GetWindow(this), "请填写帐号!", MsgImage.Error); return; } if (ValidateUtil.CheckFolderName(this.userName.Text) == false) { JXMessageBox.Show(Window.GetWindow(this), "请填写用户姓名!", MsgImage.Error); return; } if (ValidateUtil.CheckPasswordStrength(this.password.Password) == false) { JXMessageBox.Show(Window.GetWindow(this), "请输入6位以上的密码长度!", MsgImage.Error); return; } if (!this.password.Password.Equals(this.password2.Password)) { JXMessageBox.Show(Window.GetWindow(this), "输入密码不一致,请重新输入!", MsgImage.Error); return; } Users u = new Users(); UserBean bean = new UserBean(); QueryUser query = new QueryUser(); query.Account = UserManagerBean.AddUser.queryAccount.Text; query.UserName = UserManagerBean.AddUser.queryName.Text; bean.Account = this.account.Text; bean.UserName = this.userName.Text; bean.Password = this.password.Password; bean.Status = 0; bean.CreateId = Session.UserId; bean.CreateTime = Convert.ToDateTime(DateTime.Now); bean.Phone = this.phone.Text; ComboBoxItem type = (ComboBoxItem)this.userType.SelectedItem; bean.Type = int.Parse(type.Tag.ToString()); int state = u.registUser(bean); Window targe = Window.GetWindow(this); if (state == BaseRequest.HAS) { JXMessageBox.Show(Window.GetWindow(this), "该账号已被使用!", MsgImage.Error); } else if (state==BaseRequest.SUCCESS) { JXMessageBox.Show(Window.GetWindow(this), "新增用户成功!", MsgImage.Error); UserManagerBean.AddUser.page.ShowPages(UserManagerBean.AddUser.userData, u.getUsersList(query), BaseRequest.PAGE_SIZE); this.Close(); } else { JXMessageBox.Show(Window.GetWindow(this), "系统异常,请联系管理员!", MsgImage.Error); } }
//用户分页列表 public DataSet getUsersList(QueryUser query) { try { //int count = (BaseRequest.PAGE_CURRENT - 1) * BaseRequest.PAGE_SIZE; string sql = "SELECT u.ID,u.ACCOUNT,u.USER_NAME,u.TYPE,u.STATUS,us.USER_NAME as NAME,u.LOGIN_TIME," + "u.PHONE FROM users AS u LEFT JOIN users AS us ON u.CREATE_ID=us.ID where u.ACCOUNT like '%" + @query.Account + "%' and u.USER_NAME like '%" + query.UserName + "%' ORDER BY u.CREATE_TIME DESC"; //string sqlAppend = SqlApend.returnSqlStr(sql,SqlApend.SqlMap); DataSet set = MySqlHelper.GetDataSet(MySqlHelper.Conn, CommandType.Text, sql); return set; } catch (Exception e) { e.GetBaseException(); } return null; }
private void QueryUser(object sender, RoutedEventArgs e) { QueryUser query = new QueryUser(); query.Account = this.queryAccount.Text; query.UserName = this.queryName.Text; Users user = new Users(); DataSet set=user.getUsersList(query); this.page.ShowPages(this.userData,set, BaseRequest.PAGE_SIZE); }
private void DazzleTabControl_SelectionChanged(object sender, SelectionChangedEventArgs e) { DazzleTabItem item = ((sender as DazzleTabControl).SelectedItem as DazzleTabItem); if (item != null) { //MessageBox.Show(item.ToString()); if (item.Name.Equals("User_Manager")) { Users u = new Users(); QueryUser query = new QueryUser(); query.Account = UserManagerBean.AddUser.queryAccount.Text; query.UserName = UserManagerBean.AddUser.queryName.Text; DataSet set = u.getUsersList(query); UserManagerBean.AddUser.page.ShowPages(UserManagerBean.AddUser.userData, set, BaseRequest.PAGE_SIZE); AddGrid(UserManagerBean.AddUser); } } }
//private void _UserManager(object sender, System.Windows.Input.MouseButtonEventArgs e) //{ // //UserManagerBean.AddUser // Users u = new Users(); // QueryUser query = new QueryUser(); // query.Account = UserManagerBean.AddUser.queryAccount.Text; // query.UserName = UserManagerBean.AddUser.queryName.Text; // DataSet set = u.getUsersList(query); // UserManagerBean.AddUser.page.ShowPages(UserManagerBean.AddUser.userData, set, BaseRequest.PAGE_SIZE); // AddGrid(UserManagerBean.AddUser); //} private void User_Manager_KeyDown(object sender, KeyEventArgs e) { //UserManagerBean.AddUser Users u = new Users(); QueryUser query = new QueryUser(); query.Account = UserManagerBean.AddUser.queryAccount.Text; query.UserName = UserManagerBean.AddUser.queryName.Text; DataSet set = u.getUsersList(query); UserManagerBean.AddUser.page.ShowPages(UserManagerBean.AddUser.userData, set, BaseRequest.PAGE_SIZE); AddGrid(UserManagerBean.AddUser); }
//设备管理功能选择 private void Choice(object sender, RoutedEventArgs e) { TreeViewItem assets = ((sender as TreeView).SelectedItem as TreeViewItem); //MessageBox.Show(assets.Uid.ToString()); string assetsName = assets.Uid.ToString(); if (assetsName == null || "".Equals(assetsName)) { roomGrid.Children.Clear(); } if (roomGrid.Children != null) roomGrid.Children.Clear(); // ================================================================================== if (assetsName.Equals("Elist")) { EquipmentList equipment = RoomManagerBean.EquipmentList; RoomClass rc = new RoomClass(); EquipmentBean bean = new EquipmentBean(); DataSet equipmentSet = rc.queryEquipmentList(bean); DataSet typeSet = rc.queryType(); ComboBox box = RoomManagerBean.EquipmentList.type; if (box.HasItems) box.Items.Clear(); ComboBoxItem boxItem = new ComboBoxItem(); boxItem.Content = "请选择..."; boxItem.Tag = ""; boxItem.IsSelected = true; box.Items.Add(boxItem); //RoomManagerBean.DeviceClass.selectType.SelectedValuePath = ""; if (typeSet.Tables.Count > 0) { DataRowCollection drc = typeSet.Tables[0].Rows; for (int i = 0; i < drc.Count; i++) { DataRow dr = drc[i]; int typeId = (int)dr["ID"]; string typeName = dr["TYPE_NAME"].ToString(); ComboBoxItem boxItems = new ComboBoxItem(); boxItems.Content = typeName; boxItems.Tag = typeId; box.Items.Add(boxItems); //MessageBox.Show("typeId=" + typeId + " typeName=" + boxItems.Tag); } //MessageBox.Show("===" + equipmentSet.Tables.Count); RoomManagerBean.EquipmentList.page.ShowPages(RoomManagerBean.EquipmentList.equipment, equipmentSet, BaseRequest.PAGE_SIZE); roomGrid.Children.Add(equipment); equipment.SetValue(Grid.RowProperty, 0); equipment.SetValue(Grid.ColumnProperty, 0); } } else if (assetsName.Equals("Report")) { Statement statement = RoomManagerBean.Statement; roomGrid.Children.Add(statement); statement.SetValue(Grid.RowProperty, 0); statement.SetValue(Grid.ColumnProperty, 0); } else if (assetsName.Equals("Inventory")) { RoomClass rc = new RoomClass(); DataSet stockSet = rc.queryInventory(); RoomManagerBean.DeviceList.page.ShowPages(RoomManagerBean.DeviceList.stock, stockSet, BaseRequest.PAGE_SIZE); DeviceList deviceList = RoomManagerBean.DeviceList; roomGrid.Children.Add(deviceList); deviceList.SetValue(Grid.RowProperty, 0); deviceList.SetValue(Grid.ColumnProperty, 0); } else if (assetsName.Equals("Category")) { DeviceClass deviceClass = RoomManagerBean.DeviceClass; RoomClass room = new RoomClass(); QueryUser query = new QueryUser(); //query.Account = UserManagerBean.AddUser.queryAccount.Text; //query.UserName = UserManagerBean.AddUser.queryName.Text; DataSet set = room.queryType(); RoomManagerBean.DeviceClass.page.ShowPages(RoomManagerBean.DeviceClass.deviceData, set, BaseRequest.PAGE_SIZE); roomGrid.Children.Add(deviceClass); deviceClass.SetValue(Grid.RowProperty, 0); deviceClass.SetValue(Grid.ColumnProperty, 0); } else if (assetsName.Equals("HistoryEquipment")) { HistoryEquipment he = RoomManagerBean.HistoryEquipment; RoomClass rc = new RoomClass(); DataSet set = rc.queryHistoryEquipment(); he.page.ShowPages(he.historyEquipment, set, BaseRequest.PAGE_SIZE); roomGrid.Children.Add(he); he.SetValue(Grid.RowProperty, 0); he.SetValue(Grid.ColumnProperty, 0); } }