private void frmRoomEdit_Load(object sender, EventArgs e)
{
InitDeviceCount();
if (this.Tag.ToString() == "添加")
{
if (roomInfo == null)
{
roomInfo = new TbRoominfo();
}
this.Text = "添加房间设备信息";
}
else if (this.Tag.ToString() == "修改")
{
this.Text = "修改房间设备信息";
LoadRoomInfo();
//tbName.Text = strName;
//tbWsd2.Text = strWsd2;
//tbFire2.Text = strFire2;
//tbWsd1.Text = strWsd1;
//tbFire1.Text = strFire1;
//tbRelayAddr.Text = strRelay;
//tbAirAddr.Text = strAir;
//cbbAirFactory.Text = strFactory;
//tbAirAddr2.Text = strAir2;
//cbbAirFactory2.Text = strFactory2;
//chbCSJ.Checked = IsExistCsj;
//chbJRQ.Checked = IsExistJrq;
//chbXF.Checked = IsExistXf;
}
}
private void LoadAndUpShow()
{
//string strSql = "select ID,RoomName,IsSingle,WsdAddr1,WsdAddr2,FireAddr1,FireAddr2,RelayAddr,AirAddr,AirFactory,AirAddr2,AirFactory2,IsExistCsj,IsExistJrq,IsExistXf from tb_RoomInfo ";
//gridControl1.DataSource = datalogic.GetDataTable(strSql);
listRoomInfo = TbRoominfo.FindAll("", "Id ASC", "", 0, 0);
gridControl1.DataSource = listRoomInfo;
}
private void LoadRoomDeviceInfo(int roomid)
{
TbRoominfo roominfo = TbRoominfo.Find("ID=" + roomid);
if (roominfo != null)
{//查找到对应的房间
//温湿度
if (roominfo.WSDCount > 0)
{
gcWSD1.Visible = roominfo.WSDCount > 0 ? true : false;
gcWSD2.Visible = roominfo.WSDCount >= 2 ? true : false;
}
else
{
gcWSD1.Visible = gcWSD2.Visible = false;
}
//烟感
if (roominfo.YGCount > 0)
{
pnlYG.Visible = true;
}
else
{
pnlYG.Visible = false;
}
//控制设备
gbCSJ.Visible = roominfo.IsExistCsj == DeviceUsing.启用.ToString() ? true : false;
gbJRQ.Visible = roominfo.IsExistJrq == DeviceUsing.启用.ToString() ? true : false;
gbXF.Visible = roominfo.IsExistXf == DeviceUsing.启用.ToString() ? true : false;
//空调
if (roominfo.KTCount > 0)
{
gbKT.Visible = true;
}
else
{
gbKT.Visible = false;
}
}
}
private void sbtnAlter_Click(object sender, EventArgs e)
{
int[] rows = gridView1.GetSelectedRows(); //选中多行
if (rows.Length > 0)
{
int ID = Convert.ToInt16(gridView1.GetRowCellDisplayText(rows[0], "ID"));
TbRoominfo roomInfo = listRoomInfo.Find(p => p.ID == ID);
if (roomInfo != null)
{
frmRoomEdit frm = new frmRoomEdit(roomInfo);
frm.Tag = "修改";
frm.ShowDialog(this);
frm.Dispose();
LoadAndUpShow();
}
//frm.Tag = "修改";
//frm.strID = gridView1.GetRowCellDisplayText(rows[0], "ID").ToString();
//frm.strName = gridView1.GetRowCellDisplayText(rows[0], "RoomName").ToString();
//frm.strWsd1 = gridView1.GetRowCellDisplayText(rows[0], "WsdAddr1").ToString();
//frm.strFire1 = gridView1.GetRowCellDisplayText(rows[0], "FireAddr1").ToString();
//frm.strRelay = gridView1.GetRowCellDisplayText(rows[0], "RelayAddr").ToString();
//frm.strWsd2 = gridView1.GetRowCellDisplayText(rows[0], "WsdAddr2").ToString();
//frm.strFire2 = gridView1.GetRowCellDisplayText(rows[0], "FireAddr2").ToString();
//frm.strAir = gridView1.GetRowCellDisplayText(rows[0], "AirAddr").ToString();
//frm.strFactory = gridView1.GetRowCellDisplayText(rows[0], "AirFactory").ToString();
//frm.strAir2 = gridView1.GetRowCellDisplayText(rows[0], "AirAddr2").ToString();
//frm.strFactory2 = gridView1.GetRowCellDisplayText(rows[0], "AirFactory2").ToString();
//frm.IsExistCsj = gridView1.GetRowCellDisplayText(rows[0], "IsExistCsj").ToString() == DeviceUsing.启用.ToString() ? true : false;
//frm.IsExistJrq = gridView1.GetRowCellDisplayText(rows[0], "IsExistJrq").ToString() == DeviceUsing.启用.ToString() ? true : false;
//frm.IsExistXf = gridView1.GetRowCellDisplayText(rows[0], "IsExistXf").ToString() == DeviceUsing.启用.ToString() ? true : false;
//frm.ShowDialog(this);
//frm.Dispose();
//LoadAndUpShow();
}
else
{
MessageUtil.ShowTips("无选中的房间");
}
}
private void LoadRoomName()
{
//string strSql = "select RoomName from tb_RoomInfo ";
//DataTable dt = datalogic.GetDataTable(strSql);
IList <TbRoominfo> list = TbRoominfo.FindAll("", "ID ASC", "", 0, 0);
this.cbbRoomName.SelectedIndexChanged -= new System.EventHandler(this.cbbRoomName_SelectedIndexChanged);
try
{
if (list != null && list.Count > 0)
{
cbbRoomName.DataSource = list;
cbbRoomName.DisplayMember = "RoomName";
cbbRoomName.ValueMember = "ID";
}
this.cbbRoomName.SelectedIndexChanged += new System.EventHandler(this.cbbRoomName_SelectedIndexChanged);
if (cbbRoomName.Items.Count > 0)
{
cbbRoomName.SelectedIndex = 0;
LoadRoomDeviceInfo(Convert.ToInt16(cbbRoomName.SelectedValue));
}
//foreach (DataRow dr in dt.Rows)
//{
// string strName = dr["RoomName"].ToString();
// cbbRoomName.Items.Add(strName);
//}
//if (cbbRoomName.Items.Count > 0)
// cbbRoomName.SelectedIndex = 0;
}
catch (Exception ex)
{
if (frmMain.blDebug)
{
MessageUtil.ShowTips(ex.Message);
}
}
}
/// <summary>
/// 加载房间设备 一个房间对应的温湿度、烟感、空调控制器地址等
/// </summary>
public void LoadRooms()
{
clsEnvirControl.listRoom.Clear();
//string strSql = "select ID,RoomName,WsdAddr1,WsdAddr2,FireAddr1,FireAddr2,RelayAddr,AirAddr,AirFactory,AirAddr2,AirFactory2 from tb_RoomInfo ";
//DataTable dtRoom = datalogic.GetDataTable(strSql);
IList <TbRoominfo> list = TbRoominfo.FindAll("", "ID ASC", "", 0, 0);
if (list != null && list.Count > 0)
{
foreach (TbRoominfo roominfo in list)
{
try
{
int iWsd1 = 0;
int iWsd2 = 0;
int iAir1 = 0;
int iAir2 = 0;
int iRelay = 0;
RoomClass room = new RoomClass(roominfo.RoomName);
room.YGCount = roominfo.YGCount;
room.WSDCount = roominfo.WSDCount;
room.KTCount = roominfo.KTCount;
room.IsExistCSJ = roominfo.IsExistCsj == DeviceUsing.启用.ToString() ? true : false;
room.IsExistJDQ = roominfo.IsExistRealy == DeviceUsing.启用.ToString() ? true : false;
room.IsExistJRQ = roominfo.IsExistJrq == DeviceUsing.启用.ToString() ? true : false;
room.IsExistXF = roominfo.IsExistXf == DeviceUsing.启用.ToString() ? true : false;
//温湿度
if (!string.IsNullOrEmpty(roominfo.WsdAddr1))
{
iWsd1 = Convert.ToInt32(roominfo.WsdAddr1);
}
if (!string.IsNullOrEmpty(roominfo.WsdAddr2))
{
iWsd2 = Convert.ToInt32(roominfo.WsdAddr2);
}
if (roominfo.WSDCount > 0)
{
if (iWsd1 != 0)
{
clsWsd wsd = new clsWsd(iWsd1);
room.listWsd.Add(wsd);
}
if (iWsd2 != 0)
{
clsWsd wsd = new clsWsd(iWsd2);
room.listWsd.Add(wsd);
}
}
//烟感
if (!string.IsNullOrEmpty(roominfo.FireAddr1))
{
clsFire fire = new clsFire(roominfo.FireAddr1);
room.listFire.Add(fire);
}
if (!string.IsNullOrEmpty(roominfo.FireAddr2))
{
clsFire fire = new clsFire(roominfo.FireAddr2);
room.listFire.Add(fire);
}
//空调控制器
if (roominfo.KTCount >= 2)
{//2个空调
if (!string.IsNullOrEmpty(roominfo.AirAddr))
{
iAir1 = Convert.ToInt32(roominfo.AirAddr);
}
if (!string.IsNullOrEmpty(roominfo.AirAddr2))
{
iAir2 = Convert.ToInt32(roominfo.AirAddr2);
}
if (iAir1 != 0)
{
AirFactoryType airType = AirFactoryType.大金;
if (roominfo.AirFactory != "大金")
{
airType = AirFactoryType.其他;
}
clsAir air = new clsAir(iAir1, airType);
room.listAir.Add(air);
}
if (iAir2 != 0)
{
AirFactoryType airType = AirFactoryType.大金;
if (roominfo.AirFactory2 != "大金")
{
airType = AirFactoryType.其他;
}
clsAir air = new clsAir(iAir2, airType);
room.listAir.Add(air);
}
}
else
{
if (!string.IsNullOrEmpty(roominfo.AirAddr))
{
iAir1 = Convert.ToInt32(roominfo.AirAddr);
}
if (iAir1 != 0)
{
AirFactoryType airType = AirFactoryType.大金;
if (roominfo.AirFactory != "大金")
{
airType = AirFactoryType.其他;
}
clsAir air = new clsAir(iAir1, airType);
room.listAir.Add(air);
}
}
//继电器板
if (!string.IsNullOrEmpty(roominfo.RelayAddr))
{
iRelay = Convert.ToInt32(roominfo.RelayAddr);
}
if (iRelay != 0)
{
room.roomRelay = new clsRelay(iRelay);
}
clsEnvirControl.listRoom.Add(room);
}
catch (Exception ex)
{
if (frmMain.blDebug)
{
MessageUtil.ShowTips(ex.Message);
}
}
}
RoomClass roomrelay = clsEnvirControl.listRoom.Find(p => p.roomRelay != null);
foreach (RoomClass room in clsEnvirControl.listRoom)
{
if (room.roomRelay == null)
{
room.roomRelay = roomrelay.roomRelay;
}
}
}
}
public frmRoomEdit(TbRoominfo _roomInfo)
{
InitializeComponent();
roomInfo = _roomInfo;
}
private void sbtnOk_Click(object sender, EventArgs e)
{
#region 输入 判断
if (string.IsNullOrEmpty(tbName.Text.Trim()))
{
MessageUtil.ShowTips("房间名称不能为空！");
return;
}
if (cmbWSD.Text == "1" || cmbWSD.Text == "2")
{
if (string.IsNullOrEmpty(tbWsd1.Text.Trim()))
{
MessageUtil.ShowTips("请输入1#温湿度地址！");
return;
}
}
if (cmbWSD.Text == "2")
{
if (string.IsNullOrEmpty(tbWsd2.Text.Trim()))
{
MessageUtil.ShowTips("请输入2#温湿度地址！");
return;
}
}
if (cmbYG.Text == "1" || cmbYG.Text == "2")
{
if (string.IsNullOrEmpty(tbFire1.Text.Trim()))
{
MessageUtil.ShowTips("请输入1#烟感地址！");
return;
}
}
if (cmbYG.Text == "2")
{
if (string.IsNullOrEmpty(tbFire2.Text.Trim()))
{
MessageUtil.ShowTips("请输入2#烟感地址！");
return;
}
}
if (chbJDQ.Checked)
{
if (string.IsNullOrEmpty(tbRelayAddr.Text.Trim()))
{
MessageUtil.ShowTips("请输入控制板地址！");
return;
}
}
if (cmbKT.Text == "1" || cmbKT.Text == "2")
{
if (string.IsNullOrEmpty(tbAirAddr.Text.Trim()))
{
MessageUtil.ShowTips("请输入1#空调控制器地址！");
return;
}
}
if (cmbKT.Text == "1" || cmbKT.Text == "2")
{
if (string.IsNullOrEmpty(cbbAirFactory.Text))
{
MessageUtil.ShowTips("请选择1#空调厂家！");
return;
}
}
if (cmbKT.Text == "2")
{
if (string.IsNullOrEmpty(tbAirAddr2.Text.Trim()))
{
MessageUtil.ShowTips("请输入2#空调控制器地址！");
return;
}
}
if (cmbKT.Text == "2")
{
if (string.IsNullOrEmpty(cbbAirFactory2.Text))
{
MessageUtil.ShowTips("请选择2#空调厂家！");
return;
}
}
if (strFire1.Length < 2)
{
strFire1 = "0" + strFire1;
}
if (strFire2.Length < 2)
{
strFire2 = "0" + strFire2;
}
roomInfo.RoomName = tbName.Text.Trim();
roomInfo.WsdAddr1 = tbWsd1.Text.Trim();
roomInfo.FireAddr1 = tbFire1.Text.Trim();
roomInfo.WsdAddr2 = tbWsd2.Text.Trim();
roomInfo.FireAddr2 = tbFire2.Text.Trim();
roomInfo.RelayAddr = tbRelayAddr.Text.Trim();
roomInfo.AirAddr = tbAirAddr.Text.Trim();
roomInfo.AirFactory = cbbAirFactory.Text;
roomInfo.AirAddr2 = tbAirAddr2.Text.Trim();
roomInfo.AirFactory2 = cbbAirFactory2.Text;
roomInfo.IsExistCsj = chbCSJ.Checked ? DeviceUsing.启用.ToString() : DeviceUsing.未启用.ToString();
roomInfo.IsExistJrq = chbJRQ.Checked ? DeviceUsing.启用.ToString() : DeviceUsing.未启用.ToString();
roomInfo.IsExistXf = chbXF.Checked ? DeviceUsing.启用.ToString() : DeviceUsing.未启用.ToString();
roomInfo.IsExistRealy = chbJDQ.Checked ? DeviceUsing.启用.ToString() : DeviceUsing.未启用.ToString();
roomInfo.YGCount = Convert.ToInt16(cmbYG.Text);
roomInfo.WSDCount = Convert.ToInt16(cmbWSD.Text);
roomInfo.KTCount = Convert.ToInt16(cmbKT.Text);
#endregion
if (this.Text == "添加房间设备信息")//tb_RoomInfo ID,RoomName,IsSingle,WsdAddr1,WsdAddr2,FireAddr1,FireAddr2,RelayAddr
{
//string strSql = "insert into tb_RoomInfo (RoomName,WsdAddr1,WsdAddr2,FireAddr1,FireAddr2,RelayAddr,AirAddr,AirFactory"+
// ",AirAddr2,AirFactory2)" +
//"values ('" + strName + "','" + strWsd1 + "','" + strWsd2 + "','" + strFire1 + "','" + strFire2 + "','" + strRelay + "'"+
// ",'" + strAir + "','" + strFactory + "','" + strAir2 + "','" + strFactory2 + "')";
//datalogic.SqlComNonQuery(strSql);
int count = TbRoominfo.Insert(roomInfo);
if (count > 0)
{
MessageUtil.ShowTips("添加房间设备信息成功！");
}
else
{
MessageUtil.ShowWarning("添加房间设备信息失败！");
}
}
else if (this.Text == "修改房间设备信息")
{
//string strSql = "update tb_RoomInfo set RoomName='" + strName + "',WsdAddr1='" + strWsd1 + "',AirAddr='" + strAir + "'," +
// "WsdAddr2='" + strWsd2 + "' ,FireAddr1='" + strFire1 + "',FireAddr2='" + strFire2 + "',RelayAddr='" + strRelay + "' " +
// ",AirFactory='" + strFactory + "',AirAddr2='" + strAir2 + "',AirFactory2='" + strFactory2 + "' "+
// "where ID='" + strID + "' ";
//datalogic.SqlComNonQuery(strSql);
int count = TbRoominfo.Update(roomInfo);
if (count > 0)
{
MessageUtil.ShowTips("修改房间设备信息成功！");
}
else
{
MessageUtil.ShowWarning("区域设备没有数据更新！");
}
}
this.Close();
}
