//添加机房 public int AddRoom(RoomBean bean) { try { string selectSql = "SELECT * FROM rooms AS r WHERE r.ROOM_NAME='" + @bean.RoomName + "'"; parameter.ParameterName = "@bean.RoomName"; parameter.Value = bean.RoomName; reade = MySqlHelper.ExecuteReader(MySqlHelper.Conn, CommandType.Text, selectSql, parameter); if (reade.Read()) { return(HAS); } string dateTime = Convert.ToDateTime(DateTime.Now).ToString(DATE_MS_FORMAT); string sql = "INSERT INTO rooms (ROOM_NAME,FLOOR,BELONGS,PURPOSE,USERS_ID,CREATION_DATE) VALUES('" + @bean.RoomName + "','" + @bean.Floor + "','" + @bean.Belongs + "','" + @bean.Purpose + "'," + @Session.UserId + ",'" + @dateTime + "')"; MySqlParameter[] parameters = { new MySqlParameter("@bean.RoomName", bean.RoomName), new MySqlParameter("@bean.Floor", bean.Floor), new MySqlParameter("@bean.Belongs", bean.Belongs), new MySqlParameter("@bean.Purpose", bean.Purpose), new MySqlParameter("@Session.UserId", Session.UserId), new MySqlParameter("@dateTime", dateTime), }; MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, parameters); return(SUCCESS); } catch (Exception e) { e.GetBaseException(); return(SYSTEM_EXCEPTION); } }
private void Sava_Edit(object sender, RoutedEventArgs e) { if (this.roomName.Text.Equals("")) { MessageBox.Show("请输入机房名称!"); return; } RoomBean bean = new RoomBean(); RoomClass rc=new RoomClass(); bean.RoomName = this.roomName.Text; bean.Floor = this.floor.Text; bean.Purpose = this.purpose.Text; bean.Belongs = this.belongs.Text; bean.Id = (int)this.roomId.Content; int state=rc.saveEditRoom(bean); if (state == BaseRequest.SUCCESS) { MessageBox.Show("操作成功!"); this.edit_room.Visibility = Visibility.Hidden; RoomManagerBean.AddRoom.page.ShowPages(RoomManagerBean.AddRoom.roomDate, rc.queryRoomsList(), BaseRequest.PAGE_SIZE); } }
//编辑机房信息 public int saveEditRoom(RoomBean bean) { try { string sql = "UPDATE rooms AS r SET r.ROOM_NAME='" + @bean.RoomName + "',r.FLOOR='" + @bean.Floor + "',r.PURPOSE='" + @bean.Purpose + "',r.BELONGS='" + @bean.Belongs + "' WHERE r.ID=" + @bean.Id; MySqlParameter[] parameters = { new MySqlParameter("@bean.RoomName", bean.RoomName), new MySqlParameter("@bean.Floor", bean.Floor), new MySqlParameter("@bean.Purpose", bean.Purpose), new MySqlParameter("@bean.Belongs", bean.Belongs), new MySqlParameter("@bean.Id", bean.Id), }; MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, parameters); return(BaseRequest.SUCCESS); } catch (Exception e) { e.GetBaseException(); return(BaseRequest.SYSTEM_EXCEPTION); } }
private void Add_Rooms(object sender, RoutedEventArgs e) { RoomBean bean=new RoomBean(); if (this.roomName.Text.Equals("")) { MessageBox.Show("请输入机房名!"); return; } RoomClass rc = new RoomClass(); bean.RoomName = this.roomName.Text; if (!this.belongs.Text.Equals("")) bean.Belongs = this.belongs.Text; if (!this.purpose.Text.Equals("")) bean.Purpose = this.purpose.Text; if (!this.floor.Text.Equals("")) bean.Floor = this.floor.Text; int state=rc.AddRoom(bean); if (state == BaseRequest.HAS) MessageBox.Show("已存在该机房名!"); else if (state == BaseRequest.SUCCESS) { MessageBox.Show("操作成功!"); this.addRooms.Visibility = Visibility.Hidden; RoomManagerBean.AddRoom.page.ShowPages(RoomManagerBean.AddRoom.roomDate, rc.queryRoomsList(), BaseRequest.PAGE_SIZE); } else MessageBox.Show("系统异常,请连管理员!"); }