private void Repair_Click(object sender, RoutedEventArgs e)
{
EquipmentClass _Eclass = new EquipmentClass();
var a = this.repairGrid.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
MsgResult r =JXMessageBox.Show(this, "您需要对此设备进修报修？", "提示", MsgButton.Yes_No_Cancel, MsgImage.Question);
if (r == MsgResult.OK)
{
int state = _Eclass.repairEquipment(_Eid);
if (state == BaseRequest.SUCCESS)
{
DataSet _Repair_Set = _Eclass.getWorkEquipment();
this.page.ShowPages(this.repairGrid, _Repair_Set, BaseRequest.PAGE_SIZE);
JXMessageBox.Show(this, "申请报修成功", MsgImage.Success);
RepairEquipment repair = DeviceMigrationsFactory.RepairEquipment;
DataSet repairSet = _Eclass.getRepairEquipment();
repair.page.ShowPages(repair.repair_Grid, repairSet, BaseRequest.PAGE_SIZE);
}
else
{
JXMessageBox.Show(this, "操作失败!系统异常，请联系管理员!", MsgImage.Error);
}
}
}
private void Move_Click(object sender, RoutedEventArgs e)
{
EquipmentClass _Eclass = new EquipmentClass();
var a = this.MoveGrid.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
MsgResult r = JXMessageBox.Show(this, "您需要对此设备迁移？", "提示", MsgButton.Yes_No_Cancel, MsgImage.Warning);
//MessageBox.Show(r.ToString());
if (r == MsgResult.OK)
{
int state = _Eclass.moveEquipment(_Eid);
if (state == BaseRequest.SUCCESS)
{
DataSet _Repair_Set = _Eclass.getWorkEquipment();
this.page.ShowPages(this.MoveGrid, _Repair_Set, BaseRequest.PAGE_SIZE);
JXMessageBox.Show(this, "申请迁移成功", MsgImage.Success);
DeviceMove move = DeviceMigrationsFactory.DeviceMove;
DataSet moveSet=_Eclass.getMoveEquipment();
move.page.ShowPages(move.removeGrid, moveSet, BaseRequest.PAGE_SIZE);
}
else
{
JXMessageBox.Show(this, "操作失败!系统异常，请联系管理员!", MsgImage.Error);
}
}
}
private void RpairCom_Click(object sender, RoutedEventArgs e)
{
EquipmentClass _Eclass = new EquipmentClass();
var a = this.repair_Grid.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
MsgResult r = JXMessageBox.Show(this, "您需要对此设备申请入库？", "提示", MsgButton.Yes_No_Cancel, MsgImage.Exclamation);
//MessageBox.Show(r.ToString());
if (r == MsgResult.OK)
{
int state = _Eclass.repairEquipmentComing(_Eid);
if (state == BaseRequest.SUCCESS)
{
DataSet set = _Eclass.getRepairEquipmentList();
this.page.ShowPages(this.repair_Grid, set, BaseRequest.PAGE_SIZE);
JXMessageBox.Show(this, "申请出库成功", MsgImage.Success);
NewEquipment newEquipment = DeviceMigrationsFactory.NewEquipment;
DataSet deliverySet = _Eclass.comingEquipment();
newEquipment.page.ShowPages(newEquipment.comingGrild, deliverySet, BaseRequest.PAGE_SIZE);
}
else
{
JXMessageBox.Show(this, "操作失败!系统异常，请联系管理员!", MsgImage.Error);
}
}
}
private void SaveEdit_Click(object sender, RoutedEventArgs e)
{
ComboBoxItem type = (ComboBoxItem)this.Etype.SelectedItem;
if (this.Ename.Text.Equals(""))
{
JXMessageBox.Show(this, "设备名称不准为空!", MsgImage.Error);
return;
}
if (type.Tag.ToString().Equals(""))
{
JXMessageBox.Show(this, "非法操作!", MsgImage.Error);
return;
}
RoomClass rc = new RoomClass();
int state = rc.updateEquipmentInformation(int.Parse(this.ID.Content.ToString()), this.Ename.Text,
int.Parse(type.Tag.ToString()));
if (state == BaseRequest.SUCCESS)
{
Room roomBean = RoomManagerBean.Room;
EquipmentClass ec = new EquipmentClass();
DataSet set = ec.getEquipmentInformationByRoom(int.Parse(roomBean.roomId.Text));
roomBean.page.ShowPages(roomBean.roomEquipment, set, BaseRequest.PAGE_SIZE);
JXMessageBox.Show(this, "编辑信息已保存.", MsgImage.Success);
this.Close();
}
else
{
JXMessageBox.Show(this, "保存失败！", MsgImage.Error);
}
}
private void Save_Edit(object sender, RoutedEventArgs e)
{
if (this.Ename.Equals(""))
{
JXMessageBox.Show(this,"设备名称不能为空!",MsgImage.Error);
return;
}
int _Eid = int.Parse(this.ID.Content.ToString());
string name = this.Ename.Text;
ComboBoxItem roomItem = (ComboBoxItem)this.roomBox.SelectedItem;
int roomId = (int)roomItem.Tag;
EquipmentClass _Edit = new EquipmentClass();
int state = _Edit.saveEditEquipment(_Eid, name, roomId);
if (state == BaseRequest.SUCCESS)
{
EquipmentClass equitment = new EquipmentClass();
DataSet set = equitment.comingEquipment();
NewEquipment equipments = DeviceMigrationsFactory.NewEquipment;
DeviceMigrationsFactory.NewEquipment.page.ShowPages(DeviceMigrationsFactory.NewEquipment.comingGrild, set, BaseRequest.PAGE_SIZE);
JXMessageBox.Show(this, "编辑成功!", MsgImage.Success);
this.Close();
}
else
{
JXMessageBox.Show(this, "错误，请检查您是否正确操作!", MsgImage.Error);
}
}
private void Delivery_Click(object sender, RoutedEventArgs e)
{
EquipmentClass _Eclass = new EquipmentClass();
var a = this.deliveryGrid.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
MsgResult r = JXMessageBox.Show(this, "您需要对此设备迁移？", "提示", MsgButton.Yes_No_Cancel, MsgImage.Exclamation);
//MessageBox.Show(r.ToString());
if (r == MsgResult.OK)
{
int state = _Eclass.outRoomEquipment(_Eid);
if (state == BaseRequest.SUCCESS)
{
DataSet _OutSet = _Eclass.getWorkEquipment();
this.page.ShowPages(this.deliveryGrid, _OutSet, BaseRequest.PAGE_SIZE);
JXMessageBox.Show(this, "申请出库成功", MsgImage.Success);
EquipmentDelivery delivery = DeviceMigrationsFactory.EquipmentDelivery;
DataSet deliverySet = _Eclass.getDeliverEquipment();
delivery.page.ShowPages(delivery.outGird, deliverySet, BaseRequest.PAGE_SIZE);
}
else
{
JXMessageBox.Show(this, "操作失败!系统异常，请联系管理员!", MsgImage.Error);
}
}
}
private void Scrapping_Click(object sender, RoutedEventArgs e)
{
EquipmentClass _Eclass = new EquipmentClass();
var a = this.scrappingGrid.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
MsgResult r = JXMessageBox.Show(this, "您需要对此设备进修报修？", "提示", MsgButton.Yes_No_Cancel, MsgImage.Question);
if (r == MsgResult.OK)
{
int state = _Eclass.scrapEquipment(_Eid);
if (state == BaseRequest.SUCCESS)
{
DataSet _Scrapping_Set = _Eclass.getWorkEquipment();
this.page.ShowPages(this.scrappingGrid, _Scrapping_Set, BaseRequest.PAGE_SIZE);
JXMessageBox.Show(this, "申请报废成功", MsgImage.Success);
EquipmentScrapping scrapping = DeviceMigrationsFactory.EquipmentScrapping;
DataSet scrappingSet = _Eclass.getScrappingEquipment();
scrapping.page.ShowPages(scrapping.scrapGrid, scrappingSet, BaseRequest.PAGE_SIZE);
}
else
{
JXMessageBox.Show(this, "操作失败!系统异常，请联系管理员!", MsgImage.Error);
}
}
}
private void Out_Click(object sender, RoutedEventArgs e)
{
EquipmentClass _Eclass = new EquipmentClass();
DataSet _OutSet = _Eclass.getWorkEquipment();
TakeDelivery td = new TakeDelivery();
td.page.ShowPages(td.deliveryGrid, _OutSet, BaseRequest.PAGE_SIZE);
//this.apply_repair.Children.Add(tr);//.Add(_Repair);
//JXMessageBox.Show(Window.GetWindow(this)
td.Owner = Window.GetWindow(this);
td.ShowDialog();
}
private void Submit_Add(object sender, RoutedEventArgs e)
{
DeviceBean bean = new DeviceBean();
EquipmentClass equipClass = new EquipmentClass();
bean.Id = int.Parse(this.ID.Content.ToString());
ComboBoxItem typeItem = (ComboBoxItem)this.typeBox.SelectedItem;
ComboBoxItem roomItem = (ComboBoxItem)this.roomBox.SelectedItem;
if (typeItem.Tag.ToString().Equals(""))
{
MessageBox.Show("请选择设备类别!");
return;
}
if (this.equipName.Text.Equals("") || this.equipName.Text == null)
{
MessageBox.Show("请输入设备名称!");
return;
}
if (roomItem.Tag.ToString().Equals(""))
{
MessageBox.Show("请选择设备所属机房!");
return;
}
int state = 0;
this.add.IsEnabled = false;
bean.Name = this.equipName.Text;
bean.RoomId = (int)roomItem.Tag;
bean.Type = (int)typeItem.Tag;
bean.Id = int.Parse(this.ID.Content.ToString());
bean.EPCCode = this.numberStr.Text;
state = equipClass.addEquipment(bean, this);
this.add.IsEnabled = true;
if (state == BaseRequest.SUCCESS)
{
//EquipmentClass equitment = new EquipmentClass();
//DataSet set = equitment.comingEquipment();
//NewEquipment equipments = DeviceMigrationsFactory.NewEquipment;
//DeviceMigrationsFactory.NewEquipment.page.ShowPages(DeviceMigrationsFactory.NewEquipment.comingGrild, set, BaseRequest.PAGE_SIZE);
//JXMessageBox.Show(Window.GetWindow(this), "已成功录入设备信息!", MsgImage.Success);
//Close_Add(DeviceMigrationsFactory.AddEquipment, new RoutedEventArgs());
}
else
{
JXMessageBox.Show(Window.GetWindow(this), "未知错误，请联系管理员!", MsgImage.Error);
}
}
//出库
private void Device_Out(object sender, RoutedEventArgs e)
{
if (moveGrid.Children != null) moveGrid.Children.Clear();
EquipmentDelivery _Delivery = DeviceMigrationsFactory.EquipmentDelivery;
EquipmentClass _Eclass = new EquipmentClass();
//DataSet _OutSet=_Eclass.getWorkEquipment();
DataSet _OutSet = _Eclass.getDeliverEquipment();
_Delivery.page.ShowPages(_Delivery.outGird, _OutSet, BaseRequest.PAGE_SIZE);
moveGrid.Children.Add(_Delivery);
_Delivery.SetValue(Grid.RowProperty, 0);
_Delivery.SetValue(Grid.ColumnProperty, 0);
}
//新设备录入
private void Device_Incoming(object sender, RoutedEventArgs e)
{
EquipmentClass equitment= new EquipmentClass();
DataSet set = equitment.comingEquipment();
if (moveGrid.Children != null) moveGrid.Children.Clear();
NewEquipment equipments = DeviceMigrationsFactory.NewEquipment;
equipments.MyEvent += new ClickEventHandler(form2_MyEvent);
DeviceMigrationsFactory.NewEquipment.page.ShowPages(DeviceMigrationsFactory.NewEquipment.comingGrild, set, BaseRequest.PAGE_SIZE);
moveGrid.Children.Add(equipments);
equipments.SetValue(Grid.RowProperty, 0);
equipments.SetValue(Grid.ColumnProperty, 0);
}
//设备迁移
private void Device_Move(object sender, RoutedEventArgs e)
{
if (moveGrid.Children != null) moveGrid.Children.Clear();
DeviceMove deviceMove = DeviceMigrationsFactory.DeviceMove;
EquipmentClass _Eclass = new EquipmentClass();
//DataSet _RemoveSet = _Eclass.getWorkEquipment();
DataSet _RemoveSet = _Eclass.getMoveEquipment();
deviceMove.page.ShowPages(deviceMove.removeGrid, _RemoveSet, BaseRequest.PAGE_SIZE);
moveGrid.Children.Add(deviceMove);
deviceMove.SetValue(Grid.RowProperty, 0);
deviceMove.SetValue(Grid.ColumnProperty, 0);
}
//机房选择
private void SelectRoom(object sender, RoutedEventArgs e)
{
TreeViewItem roomId = ((sender as TreeView).SelectedItem as TreeViewItem);
string id = roomId.Uid.ToString();
if (roomGrid.Children != null) roomGrid.Children.Clear();
if ("roomName".Equals(id))
{
AddRoom addRoom = RoomManagerBean.AddRoom;
RoomClass room = new RoomClass();
QueryUser query = new QueryUser();
//query.Account = UserManagerBean.AddUser.queryAccount.Text;
//query.UserName = UserManagerBean.AddUser.queryName.Text;
DataSet set = room.queryRoomsList();
RoomManagerBean.AddRoom.page.ShowPages(RoomManagerBean.AddRoom.roomDate, set, BaseRequest.PAGE_SIZE);
roomGrid.Children.Add(addRoom);
addRoom.SetValue(Grid.RowProperty, 0);
addRoom.SetValue(Grid.ColumnProperty, 0);
}
else if (id.Equals("EquipmentInfo")) { }
else if (id.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 (id.Equals("Report"))
{
Statement statement = RoomManagerBean.Statement;
roomGrid.Children.Add(statement);
statement.SetValue(Grid.RowProperty, 0);
statement.SetValue(Grid.ColumnProperty, 0);
}
else if (id.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 (id.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 (id.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);
}
else
{
Room roomBean = RoomManagerBean.Room;
EquipmentClass ec = new EquipmentClass();
roomBean.roomId.Text = id;
DataSet set = ec.getEquipmentInformationByRoom(int.Parse(id));
roomBean.page.ShowPages(roomBean.roomEquipment, set, BaseRequest.PAGE_SIZE);
roomBean.roomName.Content = roomId.Header.ToString();
roomGrid.Children.Add(roomBean);
roomBean.SetValue(Grid.RowProperty, 0);
roomBean.SetValue(Grid.ColumnProperty, 0);
}
}
private void Repair_Equipment(object sender, RoutedEventArgs e)
{
EquipmentClass ec = new EquipmentClass();
DataSet set = ec.getRepairEquipmentList();
TakeRepairComing tr = new TakeRepairComing();
tr.page.ShowPages(tr.repair_Grid, set, BaseRequest.PAGE_SIZE);
//this.apply_repair.Children.Add(tr);//.Add(_Repair);
//JXMessageBox.Show(Window.GetWindow(this)
tr.Owner = Window.GetWindow(this);
tr.ShowDialog();
}
//编辑新添加设备
private void Edit_Click(object sender, RoutedEventArgs e)
{
EditEquipments edit = new EditEquipments();
var a = this.comingGrild.SelectedItem;
var b = a as DataRowView;
int _Eid = Convert.ToInt32(b.Row[0]);
EquipmentClass _Eclass = new EquipmentClass();
RoomClass room = new RoomClass();
MySqlDataReader reader = _Eclass.editNewEquipment(_Eid);
ComboBox rooms = edit.roomBox;
ComboBoxItem roomItem = new ComboBoxItem();
if (reader.Read())
{
edit.ID.Content = reader["ID"];
edit.numberStr.Text = reader["NUMBER"].ToString();
edit.Ename.Text = reader["NAME"].ToString();
edit.Etype.Content = reader["TYPE_NAME"];
roomItem.Content = reader["ROOM_NAME"];
roomItem.Tag = reader["RID"];
roomItem.IsSelected = true;
rooms.Items.Add(roomItem);
edit.UserName.Content = reader["USER_NAME"];
edit.CreateTime.Content = Convert.ToDateTime(reader["STORAGE_TIME"]).ToString(BaseRequest.DATE_TIME_FORMAT);
}
MySqlDataReader roomReader = room.queryRoomsName();
while (roomReader.Read())
{
if (!reader["RID"].ToString().Equals(roomReader["ID"].ToString()))
{
roomItem = new ComboBoxItem();
roomItem.Content = roomReader["ROOM_NAME"];
roomItem.Tag = roomReader["ID"];
rooms.Items.Add(roomItem);
}
}
edit.Owner = Window.GetWindow(this);
edit.ShowDialog();
}
//报修设备申请
private void Device_Repair(object sender, RoutedEventArgs e)
{
if (moveGrid.Children != null) moveGrid.Children.Clear();
RepairEquipment _RepairEquipment = DeviceMigrationsFactory.RepairEquipment;
EquipmentClass _Eclass = new EquipmentClass();
//Equipments _Repair = DeviceMigrationsFactory.Equipments;
//EquipmentClass _Eclass = new EquipmentClass();
// DataSet _OutSet = _Eclass.getWorkEquipment();
DataSet _OutSet = _Eclass.getRepairEquipment();
_RepairEquipment.page.ShowPages(_RepairEquipment.repair_Grid, _OutSet, BaseRequest.PAGE_SIZE);
moveGrid.Children.Add(_RepairEquipment);
_RepairEquipment.SetValue(Grid.RowProperty, 0);
_RepairEquipment.SetValue(Grid.ColumnProperty, 0);
}
//报废申请
private void Device_Mains(object sender, RoutedEventArgs e)
{
if (moveGrid.Children != null) moveGrid.Children.Clear();
EquipmentScrapping _Scrap = DeviceMigrationsFactory.EquipmentScrapping;
EquipmentClass _Eclass = new EquipmentClass();
//DataSet _Scrap_Set = _Eclass.getWorkEquipment();
DataSet _Scrap_Set = _Eclass.getScrappingEquipment();
_Scrap.page.ShowPages(_Scrap.scrapGrid, _Scrap_Set, BaseRequest.PAGE_SIZE);
moveGrid.Children.Add(_Scrap);
_Scrap.SetValue(Grid.RowProperty, 0);
_Scrap.SetValue(Grid.ColumnProperty, 0);
}
private void Add_ReaderAndWrite(object sender, RoutedEventArgs e)
{
AddReaderWrider rw = new AddReaderWrider();
EquipmentClass ec = new EquipmentClass();
RoomClass rc = new RoomClass();
MySqlDataReader roomReader = rc.queryRoomsName();
ComboBox rooms = rw.roomBox;
ComboBoxItem roomItem = new ComboBoxItem();
roomItem.Content = "请选择...";
roomItem.Tag = "";
roomItem.IsSelected = true;
rooms.Items.Add(roomItem);
while (roomReader.Read())
{
roomItem = new ComboBoxItem();
roomItem.Content = roomReader["ROOM_NAME"];
roomItem.Tag = roomReader["ID"];
rooms.Items.Add(roomItem);
}
MySqlDataReader reader = ec.getWriderMaxId();
if (reader.Read())
{
if ("".Equals(reader["ID"].ToString()) || reader["ID"] == null)
{
int _Ecode = 100000;
rw.number.Text = "100000";
rw.numberStr.Text = ReaderAndWriterConnection.getEPCCode(_Ecode);
}
else
{
rw.number.Text = reader["ID"].ToString();
rw.numberStr.Text = ReaderAndWriterConnection.getEPCCode(int.Parse(reader["ID"].ToString()));
}
}
rw.Owner = Window.GetWindow(this);
rw.ShowDialog();
}
private void Submit_Add_Click(object sender, RoutedEventArgs e)
{
ComboBoxItem antennaNum = (ComboBoxItem)this.antennaNum.SelectedItem;
ComboBoxItem typeItem = (ComboBoxItem)this.type.SelectedItem;
ComboBoxItem room = (ComboBoxItem)this.roomBox.SelectedItem;
if (this.number.Text.Equals(""))
{
JXMessageBox.Show(Window.GetWindow(this), "非法操作！", MsgImage.Error);
return;
}
if (this.name.Text.Equals(""))
{
JXMessageBox.Show(Window.GetWindow(this), "请输入读写器名称！", MsgImage.Error);
return;
}
if (this.ip.Text.Equals(""))
{
JXMessageBox.Show(Window.GetWindow(this), "请输入读写器IP！", MsgImage.Error);
return;
}
if (this.port.Text.Equals(""))
{
JXMessageBox.Show(Window.GetWindow(this), "请输入读写器端口！", MsgImage.Error);
return;
}
if ("".Equals(antennaNum.Tag.ToString()))
{
JXMessageBox.Show(Window.GetWindow(this), "请选择读写器支持天线数目！", MsgImage.Error);
return;
}
if ("".Equals(typeItem.Tag.ToString()))
{
JXMessageBox.Show(Window.GetWindow(this), "请选择读写器的类别！", MsgImage.Error);
return;
}
if (this.time.Text.Equals(""))
{
JXMessageBox.Show(Window.GetWindow(this), "请填写读写器扫描时间间隔！", MsgImage.Error);
return;
}
if (room.Tag.ToString().Equals(""))
{
JXMessageBox.Show(Window.GetWindow(this), "请选择所在机房！", MsgImage.Error);
return;
}
WriterReaderBean bean = new WriterReaderBean();
bean.Id = int.Parse(this.number.Text.ToString());
bean.Number = int.Parse(this.number.Text.ToString());
bean.Name = this.name.Text;
bean.Ip = this.ip.Text;
bean.Port = int.Parse(this.port.Text);
bean.AntennaSum = int.Parse(antennaNum.Tag.ToString());
bean.Type = int.Parse(typeItem.Tag.ToString());
bean.SweepTime = int.Parse(this.time.Text);
bean.RoomId = int.Parse(room.Tag.ToString());
bean.EpcCode = this.numberStr.Text;
EquipmentClass ec = new EquipmentClass();
int state = ec.insertWriterReader(bean,this);
if (state == BaseRequest.SUCCESS)
{
EquipmentClass equitment = new EquipmentClass();
DataSet set = equitment.comingEquipment();
NewEquipment equipments = DeviceMigrationsFactory.NewEquipment;
DeviceMigrationsFactory.NewEquipment.page.ShowPages(DeviceMigrationsFactory.NewEquipment.comingGrild, set, BaseRequest.PAGE_SIZE);
JXMessageBox.Show(Window.GetWindow(this), "已成功录入读写器信息!", MsgImage.Success);
this.Close();
}
else
{
JXMessageBox.Show(Window.GetWindow(this), "未知错误，请联系管理员!", MsgImage.Error);
}
}
//录入设备
private void Add_NewEquipment(object sender, RoutedEventArgs e)
{
AddEquipment add = new AddEquipment(); ;
EquipmentClass equip = new EquipmentClass();
RoomClass room = new RoomClass();
MySqlDataReader roomReader = room.queryRoomsName();
MySqlDataReader typeReader = room.getTypeList();
MySqlDataReader reader = equip.getMaxId();
if (reader.Read())
{
// ReaderAndWriterConnection EpcNumber = new ReaderAndWriterConnection();
int i = 1;
if (reader["ID"].ToString().Equals("") || reader["ID"] == null)
{
add.ID.Content = i;
add.numberStr.Text = ReaderAndWriterConnection.getEPCCode(i);
}
else
{
add.ID.Content = reader["ID"];
add.numberStr.Text = ReaderAndWriterConnection.getEPCCode(int.Parse(reader["ID"].ToString()));
}
}
ComboBox rooms = add.roomBox;
ComboBoxItem check = new ComboBoxItem();
check.Content = "请选择...";
check.Tag = "";
check.IsSelected = true;
rooms.Items.Add(check);
while (roomReader.Read())
{
check = new ComboBoxItem();
check.Content = roomReader["ROOM_NAME"];
check.Tag = roomReader["ID"];
rooms.Items.Add(check);
}
ComboBox types = add.typeBox;
ComboBoxItem checkType = new ComboBoxItem();
checkType.Content = "请选择...";
checkType.Tag = "";
checkType.IsSelected = true;
types.Items.Add(checkType);
while (typeReader.Read())
{
if (int.Parse(typeReader["ID"].ToString()) == 4)
{
continue;
}
else
{
ComboBoxItem TypeItems = new ComboBoxItem();
TypeItems.Content = typeReader["TYPE_NAME"];
TypeItems.Tag = typeReader["ID"];
types.Items.Add(TypeItems);
}
}
add.Owner = Window.GetWindow(this);
add.ShowDialog();
}
