private void Equipment_Details(object sender, RoutedEventArgs e)
{
RoomClass rc = new RoomClass();
var a = this.equipment.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
int _TypeId = Convert.ToInt32(b.Row[1]);
MySqlDataReader reader;
if (_TypeId == 4)//如果设备类型等于4，则为读写器
{
reader = rc.getWriteAndReaderInformation(_Eid);
if (reader.Read())
{
WriteAndReaderInfo war = new WriteAndReaderInfo();
war.number.Text = reader["NUMBER"].ToString();
war.Ename.Text = reader["NAME"].ToString();
war.Etype.Text = reader["TYPE_NAME"].ToString();
war.room.Text = reader["ROOM_NAME"].ToString();
war.ip.Text = reader["IP"].ToString();
war.port.Text = reader["PORT"].ToString();
war.antenenSum.Text = reader["ANTENNA_SUM"].ToString();
if (int.Parse(reader["TYPE"].ToString()) == 0)
{
war.type.Text = "门禁读写器";
}
else
{
war.type.Text = "室内读写器";
}
war.sweepTime.Text = reader["SWEEP_TIME"].ToString() + " 秒";
war.userName.Text = reader["USER_NAME"].ToString();
war.createTime.Text = reader["CREATE_TIME"].ToString();
war.Owner = Window.GetWindow(this);
war.ShowDialog();
}
}
else
{
reader = rc.getEquipmentInfo(_Eid);
if (reader.Read())
{
EquipmentsDetails ed = new EquipmentsDetails();
ed.number.Text = reader["NUMBER"].ToString();
ed.Ename.Text = reader["NAME"].ToString();
ed.Etype.Text = reader["TYPE_NAME"].ToString();
int status = int.Parse(reader["WORK_STATUS"].ToString());
if (status == 1)
{
ed.status.Text = "入库中";
}
else if (status == 0)
{
ed.status.Text = "正常使用";
}
else if (status == 15)
{
ed.status.Text = "保修中";
}
ed.room.Text = reader["ROOM_NAME"].ToString();
if (int.Parse(reader["POWER_SOURCE"].ToString()) == 0)
{
ed.powerSource.Text = "开";
//ed.powerSource.Foreground = Brush.TransformProperty;
}
else
{
ed.powerSource.Text = "关";
}
ed.userName.Text = reader["USER_NAME"].ToString();
ed.time.Text = reader["STORAGE_TIME"].ToString();
ed.Owner = Window.GetWindow(this);
ed.ShowDialog();
}
}
}
//编辑设备信息
private void Edit_Click(object sender, RoutedEventArgs e)
{
RoomClass rc = new RoomClass();
var a = this.roomEquipment.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
int _TypeId = Convert.ToInt32(b.Row[1]);
MySqlDataReader reader;
if (_TypeId == 4)
{
reader = rc.getWriteAndReaderInformation(_Eid);
if (reader.Read())
{
EditWriteAndReader ear = new EditWriteAndReader();
ear.ID.Content = reader["READER_WRITER_ID"];
ear.numberStr.Text = reader["NUMBER"].ToString();
ear.Ename.Text = reader["NAME"].ToString();
ear.Etype.Text = reader["TYPE_NAME"].ToString();
ear.room.Text = reader["ROOM_NAME"].ToString();
ear.ip.Text = reader["IP"].ToString();
ear.port.Text = reader["PORT"].ToString();
ear.antenenSum.Text = reader["ANTENNA_SUM"].ToString();
if (int.Parse(reader["TYPE"].ToString()) == 0)
{
ear.type.SelectedIndex = 0;
}
else
{
ear.type.SelectedIndex = 1;
}
ear.sweepTime.Text = reader["SWEEP_TIME"].ToString();
ear.userName.Text = reader["USER_NAME"].ToString();
ear.createTime.Text = reader["CREATE_TIME"].ToString();
ear.Owner = Window.GetWindow(this);
ear.ShowDialog();
}
}
else
{
reader = rc.getEquipmentInfo(_Eid);
if (reader.Read())
{
EditEquipment ed = new EditEquipment();
ed.ID.Content = reader["ID"];
ed.numberStr.Text = reader["NUMBER"].ToString();
ed.Ename.Text = reader["NAME"].ToString();
//ed.Etype.Text = reader["TYPE_NAME"].ToString();
int status = int.Parse(reader["WORK_STATUS"].ToString());
if (status == 1)
{
ed.status.Text = "入库中";
}
else if (status == 0)
{
ed.status.Text = "正常使用";
}
else if (status == 15)
{
ed.status.Text = "保修中";
}
ed.room.Text = reader["ROOM_NAME"].ToString();
if (int.Parse(reader["POWER_SOURCE"].ToString()) == 0)
{
ed.powerSource.Text = "开";
//ed.powerSource.Foreground = Brush.TransformProperty;
}
else
{
ed.powerSource.Text = "关";
}
ed.userName.Text = reader["USER_NAME"].ToString();
ed.time.Text = reader["STORAGE_TIME"].ToString();
reader = rc.getTypeList();
ComboBox types = ed.Etype;
ComboBoxItem TypeItems;
while (reader.Read())
{
if (int.Parse(reader["ID"].ToString()) != 4)
{
TypeItems = new ComboBoxItem();
TypeItems.Content = reader["TYPE_NAME"];
TypeItems.Tag = reader["ID"];
if (int.Parse(reader["ID"].ToString()) == _TypeId)
{
TypeItems.IsSelected = true;
}
types.Items.Add(TypeItems);
}
}
ed.Owner = Window.GetWindow(this);
ed.ShowDialog();
}
}
}
private void Equipment_Details(object sender, RoutedEventArgs e)
{
RoomClass rc = new RoomClass();
var a = this.equipment.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
int _TypeId = Convert.ToInt32(b.Row[1]);
MySqlDataReader reader;
if (_TypeId == 4)//如果设备类型等于4，则为读写器
{
reader = rc.getWriteAndReaderInformation(_Eid);
if (reader.Read())
{
WriteAndReaderInfo war = new WriteAndReaderInfo();
war.number.Text =reader["NUMBER"].ToString();
war.Ename.Text = reader["NAME"].ToString();
war.Etype.Text = reader["TYPE_NAME"].ToString();
war.room.Text = reader["ROOM_NAME"].ToString();
war.ip.Text = reader["IP"].ToString();
war.port.Text = reader["PORT"].ToString();
war.antenenSum.Text = reader["ANTENNA_SUM"].ToString();
if (int.Parse(reader["TYPE"].ToString()) == 0)
{
war.type.Text = "门禁读写器";
}
else
{
war.type.Text = "室内读写器";
}
war.sweepTime.Text = reader["SWEEP_TIME"].ToString() + " 秒";
war.userName.Text = reader["USER_NAME"].ToString();
war.createTime.Text = reader["CREATE_TIME"].ToString();
war.Owner = Window.GetWindow(this);
war.ShowDialog();
}
}
else
{
reader = rc.getEquipmentInfo(_Eid);
if (reader.Read())
{
EquipmentsDetails ed = new EquipmentsDetails();
ed.number.Text = reader["NUMBER"].ToString();
ed.Ename.Text = reader["NAME"].ToString();
ed.Etype.Text = reader["TYPE_NAME"].ToString();
int status = int.Parse(reader["WORK_STATUS"].ToString());
if (status == 1)
{
ed.status.Text = "入库中";
}
else if (status == 0)
{
ed.status.Text = "正常使用";
}
else if (status == 15)
{
ed.status.Text = "保修中";
}
ed.room.Text = reader["ROOM_NAME"].ToString();
if (int.Parse(reader["POWER_SOURCE"].ToString()) == 0)
{
ed.powerSource.Text = "开";
//ed.powerSource.Foreground = Brush.TransformProperty;
}
else
{
ed.powerSource.Text = "关";
}
ed.userName.Text = reader["USER_NAME"].ToString();
ed.time.Text = reader["STORAGE_TIME"].ToString();
ed.Owner = Window.GetWindow(this);
ed.ShowDialog();
}
}
}
//编辑设备信息
private void Edit_Click(object sender, RoutedEventArgs e)
{
RoomClass rc=new RoomClass();
var a = this.roomEquipment.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
int _TypeId = Convert.ToInt32(b.Row[1]);
MySqlDataReader reader;
if (_TypeId == 4)
{
reader = rc.getWriteAndReaderInformation(_Eid);
if (reader.Read())
{
EditWriteAndReader ear = new EditWriteAndReader();
ear.ID.Content = reader["READER_WRITER_ID"];
ear.numberStr.Text =reader["NUMBER"].ToString();
ear.Ename.Text = reader["NAME"].ToString();
ear.Etype.Text = reader["TYPE_NAME"].ToString();
ear.room.Text = reader["ROOM_NAME"].ToString();
ear.ip.Text = reader["IP"].ToString();
ear.port.Text = reader["PORT"].ToString();
ear.antenenSum.Text = reader["ANTENNA_SUM"].ToString();
if (int.Parse(reader["TYPE"].ToString()) == 0)
{
ear.type.SelectedIndex = 0;
}
else
{
ear.type.SelectedIndex = 1;
}
ear.sweepTime.Text = reader["SWEEP_TIME"].ToString();
ear.userName.Text = reader["USER_NAME"].ToString();
ear.createTime.Text = reader["CREATE_TIME"].ToString();
ear.Owner = Window.GetWindow(this);
ear.ShowDialog();
}
}
else
{
reader = rc.getEquipmentInfo(_Eid);
if (reader.Read())
{
EditEquipment ed = new EditEquipment();
ed.ID.Content = reader["ID"];
ed.numberStr.Text = reader["NUMBER"].ToString();
ed.Ename.Text = reader["NAME"].ToString();
//ed.Etype.Text = reader["TYPE_NAME"].ToString();
int status = int.Parse(reader["WORK_STATUS"].ToString());
if (status == 1)
{
ed.status.Text = "入库中";
}
else if (status == 0)
{
ed.status.Text = "正常使用";
}
else if (status == 15)
{
ed.status.Text = "保修中";
}
ed.room.Text = reader["ROOM_NAME"].ToString();
if (int.Parse(reader["POWER_SOURCE"].ToString()) == 0)
{
ed.powerSource.Text = "开";
//ed.powerSource.Foreground = Brush.TransformProperty;
}
else
{
ed.powerSource.Text = "关";
}
ed.userName.Text = reader["USER_NAME"].ToString();
ed.time.Text = reader["STORAGE_TIME"].ToString();
reader = rc.getTypeList();
ComboBox types = ed.Etype;
ComboBoxItem TypeItems;
while (reader.Read())
{
if (int.Parse(reader["ID"].ToString()) != 4)
{
TypeItems = new ComboBoxItem();
TypeItems.Content = reader["TYPE_NAME"];
TypeItems.Tag = reader["ID"];
if (int.Parse(reader["ID"].ToString()) == _TypeId)
TypeItems.IsSelected = true;
types.Items.Add(TypeItems);
}
}
ed.Owner = Window.GetWindow(this);
ed.ShowDialog();
}
}
}