//添加机房
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("系统异常，请连管理员!");
}
