private List <Maticsoft.Model.SMT_CONTROLLER_INFO> GetCtrls(List <decimal> ctrIds)
{
Maticsoft.BLL.SMT_CONTROLLER_INFO ctrlBll = new Maticsoft.BLL.SMT_CONTROLLER_INFO();
var models = ctrlBll.GetModelList("ID in (" + string.Join(",", ctrIds.ToArray()) + ")");
return(models);
}
public static Maticsoft.Model.SMT_CONTROLLER_INFO AddController(Controller ctrlr)
{
Maticsoft.Model.SMT_CONTROLLER_INFO info = UpdateDBControllerIp(ctrlr);//如果存在则更新
if (info != null)
{
info.DOOR_INFOS = DoorDataHelper.GetDoors();
return(info);
}
info = ToInfo(ctrlr);
Maticsoft.BLL.SMT_CONTROLLER_INFO bll = new Maticsoft.BLL.SMT_CONTROLLER_INFO();
decimal ctrlId = bll.Add(info);
info.ID = ctrlId;
int count = 1;
int dir = 1;
switch (ctrlr.doorType)
{
case ControllerDoorType.OneDoorTwoDirections:
count = 1;
dir = 2;
break;
case ControllerDoorType.TwoDoorsTwoDirections:
count = 2;
dir = 2;
break;
case ControllerDoorType.FourDoorsOneDirection:
count = 4;
dir = 1;
break;
default:
break;
}
Maticsoft.BLL.SMT_DOOR_INFO doorBll = new Maticsoft.BLL.SMT_DOOR_INFO();
info.DOOR_INFOS = new List <Maticsoft.Model.SMT_DOOR_INFO>();
for (int i = 0; i < count; i++)
{
Maticsoft.Model.SMT_DOOR_INFO doorInfo = new Maticsoft.Model.SMT_DOOR_INFO();
doorInfo.CTRL_DELAY_TIME = 3;
doorInfo.CTRL_DOOR_INDEX = i + 1;
doorInfo.CTRL_ID = ctrlId;
doorInfo.CTRL_STYLE = 0;
doorInfo.DOOR_NAME = "门_" + ctrlId + "_" + (i + 1);
doorInfo.DOOR_DESC = doorInfo.DOOR_NAME;
doorInfo.AREA_ID = -1;
doorInfo.AREA_NAME = "";
doorInfo.ID = -1;
doorInfo.IS_ATTENDANCE1 = false;
doorInfo.IS_ATTENDANCE2 = false;
doorInfo.IS_ENABLE = true;
doorInfo.IS_ENTER1 = true;
doorInfo.IS_ENTER2 = dir == 1;
doorInfo.ID = doorBll.Add(doorInfo);
info.DOOR_INFOS.Add(doorInfo);
}
return(info);
}
public static List <Maticsoft.Model.SMT_CONTROLLER_INFO> GetList(string strWhere, bool withAreaAndDoors = false)
{
Maticsoft.BLL.SMT_CONTROLLER_INFO bll = new Maticsoft.BLL.SMT_CONTROLLER_INFO();
if (withAreaAndDoors)
{
return(bll.GetModelListWithAreaDoor(strWhere));
}
return(bll.GetModelList(strWhere));
}
public static Maticsoft.Model.SMT_CONTROLLER_INFO UpdateDBControllerIp(Controller ctrlr)
{
Maticsoft.BLL.SMT_CONTROLLER_INFO bll = new Maticsoft.BLL.SMT_CONTROLLER_INFO();
List <Maticsoft.Model.SMT_CONTROLLER_INFO> models = bll.GetModelList("SN_NO='" + ctrlr.sn + "'");
if (models.Count > 0)
{
models[0].IP = ctrlr.ip;
models[0].MASK = ctrlr.mask;
models[0].GATEWAY = ctrlr.gateway;
bll.Update(models[0]);
return(models[0]);
}
return(null);
}
private void tsmiRecordButton_Click(object sender, EventArgs e)
{
DataGridViewRow row = GetSelectRow();
if (row == null)
{
WinInfoHelper.ShowInfoWindow(this, "未有选择控制器！");
return;
}
Maticsoft.Model.SMT_CONTROLLER_INFO ctrlInfo = (Maticsoft.Model.SMT_CONTROLLER_INFO)row.Tag;
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
IAccessCore access = new WGAccess();
var c = ControllerHelper.ToController(ctrlInfo);
bool ret = access.SetRecordButtonRecords(c, !ctrlInfo.ENABLE_BUTTON_RECORD);
if (!ret)
{
WinInfoHelper.ShowInfoWindow(this, "设置按钮记录状态失败！");
}
else
{
Maticsoft.BLL.SMT_CONTROLLER_INFO ctrlBll = new Maticsoft.BLL.SMT_CONTROLLER_INFO();
ctrlInfo.ENABLE_BUTTON_RECORD = !ctrlInfo.ENABLE_BUTTON_RECORD;
ctrlBll.Update(ctrlInfo);
}
}
catch (System.Exception ex)
{
log.Error("设置按钮记录状态异常：", ex);
WinInfoHelper.ShowInfoWindow(this, "设置按钮记录状态异常：" + ex.Message);
}
});
waiting.Show(this);
}
private void DoLoadCtrlr()
{
try
{
log.Info("加载控制器...");
Maticsoft.BLL.SMT_CONTROLLER_INFO bll = new Maticsoft.BLL.SMT_CONTROLLER_INFO();
List <Maticsoft.Model.SMT_CONTROLLER_INFO> ctrls = bll.GetModelList("1=1");
if (ctrls.Count > 0)
{
log.Info("控制器个数:" + ctrls.Count);
List <Controller> ctls = new List <Controller>();
foreach (Maticsoft.Model.SMT_CONTROLLER_INFO item in ctrls)
{
Controller ctl = new Controller();
ctl.id = item.ID;
ctl.sn = item.SN_NO;
ctl.ip = item.IP;
ctl.port = item.PORT == null ? 60000 : (int)item.PORT;
if (ctl.port <= 0 || ctl.port > 65535)
{
ctl.port = 60000;
}
ctl.mac = item.MAC;
ctl.mask = item.MASK;
ctl.model = item.CTRLR_MODEL;
ctl.gateway = item.GATEWAY;
ctls.Add(ctl);
}
_controllers = ctls;
}
}
catch (Exception ex)
{
log.Error("加载控制器异常：", ex);
}
}
private void LoadDatas()
{
CtrlWaiting waiting = new CtrlWaiting(() =>
{
List <decimal> ids = new List <decimal>();
List <Maticsoft.Model.SMT_CONTROLLER_INFO> ctrlModels = null;
try
{
Maticsoft.BLL.SMT_CONTROLLER_INFO ctrlBll = new Maticsoft.BLL.SMT_CONTROLLER_INFO();
ctrlModels = ctrlBll.GetModelList("CTRLR_TYPE=" + (int)ControllerDoorType.Elevator);
this.Invoke(new Action(() =>
{
foreach (var item in ctrlModels)
{
ComboBoxItem cbi = new ComboBoxItem(item.NAME, item.NAME);
cbi.Tag = item;
cbCtrler.Items.Add(cbi);
ids.Add(item.ID);
}
if (ctrlModels.Count > 0)
{
cbCtrler.SelectedIndex = 0;
}
}));
}
catch (System.Exception ex)
{
log.Error("加载电梯控制器错误！", ex);
WinInfoHelper.ShowInfoWindow(this, "加载电梯控制器错误：" + ex.Message);
}
if (ids.Count == 0)
{
return;
}
try
{
Maticsoft.BLL.SMT_DOOR_INFO doorBll = new Maticsoft.BLL.SMT_DOOR_INFO();
var doors = doorBll.GetModelList("CTRL_ID in (" + string.Join(",", ids.ToArray()) + ")");
this.Invoke(new Action(() =>
{
foreach (var item in doors)
{
var ctrl = ctrlModels.Find(m => m.ID == item.CTRL_ID);
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(dgvData,
ctrl.ID,
ctrl.NAME,
(int)item.CTRL_DOOR_INDEX,
item.DOOR_NAME,
"删除"
);
row.Tag = item;
dgvData.Rows.Add(row);
}
}));
}
catch (Exception ex)
{
log.Error("加载电梯控制器门错误！", ex);
WinInfoHelper.ShowInfoWindow(this, "加载电梯控制器门错误：" + ex.Message);
}
});
waiting.Show(this);
}
private void btnApplyState_Click(object sender, EventArgs e)
{
List <decimal> ids = GetCtrlIds();
bool isAllowVisitor = cbIsAllowVisitor.Checked;
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
List <decimal> visitorIds = new List <decimal>();
foreach (var item in _doors)
{
if (item.IS_ALLOW_VISITOR != isAllowVisitor)
{
visitorIds.Add(item.ID);
}
}
if (visitorIds.Count > 0)
{
Maticsoft.DBUtility.DbHelperSQL.Query("update SMT_DOOR_INFO set IS_ALLOW_VISITOR=" + (isAllowVisitor ? 1 : 0) + " where ID in (" + string.Join(",", visitorIds.ToArray()) + ")");
WinInfoHelper.ShowInfoWindow(this.Parent, "更新访客状态正常！");
foreach (var item in _doors)
{
item.IS_ALLOW_VISITOR = isAllowVisitor;
}
}
Maticsoft.BLL.SMT_CONTROLLER_INFO ctrlBLL = new Maticsoft.BLL.SMT_CONTROLLER_INFO();
var ctrls = ctrlBLL.GetModelList("ID in (" + string.Join(",", ids) + ")");
DoorControlStyle style = DoorControlStyle.Online;
if (rbOnline.Checked)
{
style = DoorControlStyle.Online;
}
else if (rbAlwaysOpen.Checked)
{
style = DoorControlStyle.AlwaysOpen;
}
else if (rbAlwaysClose.Checked)
{
style = DoorControlStyle.AlwaysClose;
}
List <ManualResetEvent> resetEvents = new List <ManualResetEvent>();
foreach (var item in ctrls)
{
var doors = _doors.FindAll(m => m.CTRL_ID == item.ID);
if (doors.Count == 0)
{
continue;
}
ManualResetEvent evt = new ManualResetEvent(false);
resetEvents.Add(evt);
ThreadPool.QueueUserWorkItem(new WaitCallback((o) =>
{
try
{
var c = ControllerHelper.ToController(item);
IAccessCore acc = new WGAccess();
foreach (var d in doors)
{
if (d.CTRL_DOOR_INDEX == null)
{
continue;
}
string temp = "在线";
switch (style)
{
case DoorControlStyle.Online:
temp = "在线";
break;
case DoorControlStyle.AlwaysOpen:
temp = "常开";
break;
case DoorControlStyle.AlwaysClose:
temp = "常关";
break;
default:
break;
}
bool ret = acc.SetDoorControlStyle(c, (int)d.CTRL_DOOR_INDEX, style, iDelayTime.Value);
if (!ret)
{
this.Invoke(new Action(() =>
{
if (_dgvX != null)
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(_dgvX, DateTime.Now, d.DOOR_NAME, "设置门禁失败！控制器IP=" + item.IP + ",SN=" + item.SN_NO + ",门禁：" + d.DOOR_NAME);
_dgvX.Rows.Insert(0, row);
row.Selected = true;
}
}));
WinInfoHelper.ShowInfoWindow(this.Parent, "设置门禁失败！控制器IP=" + item.IP + ",SN=" + item.SN_NO + ",门禁：" + d.DOOR_NAME);
continue;
}
else
{
Maticsoft.BLL.SMT_DOOR_INFO doorBll = new Maticsoft.BLL.SMT_DOOR_INFO();
d.CTRL_DELAY_TIME = iDelayTime.Value;
d.CTRL_STYLE = (int)style;
doorBll.Update(d);
IsChanged = true;
this.Invoke(new Action(() =>
{
if (_dgvX != null)
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(_dgvX, DateTime.Now, d.DOOR_NAME, "设置门禁：" + d.DOOR_NAME + " " + temp + "状态,时间" + iDelayTime.Value + "秒成功！");
_dgvX.Rows.Insert(0, row);
row.Selected = true;
}
}));
WinInfoHelper.ShowInfoWindow(this.Parent, "设置门禁：" + d.DOOR_NAME + " " + temp + "状态,时间" + iDelayTime.Value + "秒成功！");
}
}
}
catch (Exception ex)
{
log.Error("设置门禁发生异常：", ex);
this.Invoke(new Action(() =>
{
if (_dgvX != null)
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(_dgvX, DateTime.Now, "", "设置门禁发生异常！控制器IP=" + item.IP + ",SN=" + item.SN_NO + ",异常信息：" + ex.Message);
_dgvX.Rows.Insert(0, row);
row.Selected = true;
}
}));
WinInfoHelper.ShowInfoWindow(this.Parent, "设置门禁发生异常！控制器IP=" + item.IP + ",SN=" + item.SN_NO + ",异常信息：" + ex.Message);
}
finally
{
evt.Set();
}
}));
}
foreach (var item in resetEvents)
{
item.WaitOne(15000);
}
}
catch (Exception ex)
{
log.Error("设置门禁发生异常1：", ex);
WinInfoHelper.ShowInfoWindow(this.Parent, "设置门禁发生异常!");
}
finally
{
this.Invoke(new Action(() =>
{
this.Close();
}));
}
});
waiting.Show(this);
}
private void DoSave(bool upload)
{
try
{
if (!CheckInput())
{
return;
}
Maticsoft.Model.SMT_CONTROLLER_INFO ctrlInfo = new Maticsoft.Model.SMT_CONTROLLER_INFO();
if (_ctrlr != null)
{
ctrlInfo.MAC = _ctrlr.MAC;
ctrlInfo.ID = _ctrlr.ID;
ctrlInfo.MASK = _ctrlr.MASK;
ctrlInfo.ORG_ID = _ctrlr.ORG_ID;
ctrlInfo.ORDER_VALUE = _ctrlr.ORDER_VALUE;
ctrlInfo.CTRLR_MODEL = _ctrlr.CTRLR_MODEL;
ctrlInfo.DRIVER_DATE = _ctrlr.DRIVER_DATE;
ctrlInfo.DRIVER_VERSION = _ctrlr.DRIVER_VERSION;
ctrlInfo.GATEWAY = _ctrlr.GATEWAY;
}
else
{
ctrlInfo.ID = -1;
}
ctrlInfo.SN_NO = tbCtrlrSn.Text.Trim();
ctrlInfo.IS_ENABLE = cbCtrlrEnable.Checked;
string name = tbCtrlName.Text.Trim();
if (name == "")
{
name = ctrlInfo.SN_NO;
}
ctrlInfo.NAME = name;
ctrlInfo.IP = ipCtrlr.Value;
ctrlInfo.PORT = iiPort.Value;
ctrlInfo.CTRLR_DESC = tbDesc.Text.Trim();
ctrlInfo.CTRLR_TYPE = (int)_lastType;
ctrlInfo.AREA_ID = -1;
if (cboTreeArea.SelectedNode != null && cboTreeArea.SelectedNode.Tag is Maticsoft.Model.SMT_CONTROLLER_ZONE)
{
var area = cboTreeArea.SelectedNode.Tag as Maticsoft.Model.SMT_CONTROLLER_ZONE;
ctrlInfo.AREA_ID = area.ID;
ctrlInfo.AREA_NAME = area.ZONE_NAME;
}
List <DoorNameAttriData> doorNameDatas = doorNameAttriGroup.GetDatas();
List <DoorReaderAttriData> doorReaderDatas = doorReaderAttriGroup.GetDatas();
List <Maticsoft.Model.SMT_DOOR_INFO> doors = new List <Maticsoft.Model.SMT_DOOR_INFO>();
foreach (var item in doorNameDatas)
{
Maticsoft.Model.SMT_DOOR_INFO door = new Maticsoft.Model.SMT_DOOR_INFO();
door.CTRL_ID = ctrlInfo.ID;
door.CTRL_DELAY_TIME = item.doorSecond;
door.CTRL_DOOR_INDEX = item.doorNo;
door.CTRL_STYLE = item.doorCtrlType;
door.IS_ALLOW_VISITOR = item.visitor;
if (_ctrlr != null)
{
var old = _ctrlr.DOOR_INFOS.Find(m => m.CTRL_DOOR_INDEX == item.doorNo);
if (old != null)
{
door.ID = old.ID;
door.DOOR_DESC = old.DOOR_DESC;
}
}
else
{
door.ID = -1;
door.DOOR_DESC = "";
}
door.DOOR_NAME = item.doorName;
DoorReaderAttriData reader1 = doorReaderDatas.Find(m => m.doorNo == item.doorNo && m.isEnter1);
DoorReaderAttriData reader2 = doorReaderDatas.Find(m => m.doorNo == item.doorNo && !m.isEnter1);
door.IS_ATTENDANCE1 = reader1 == null ? false : reader1.isAttend;
door.IS_ATTENDANCE2 = reader2 == null ? false : reader2.isAttend;
door.IS_ENABLE = item.doorEnable;
door.IS_ENTER1 = reader1 == null ? false : reader1.isEnter;
door.IS_ENTER2 = reader2 == null ? false : reader2.isEnter;
doors.Add(door);
}
CtrlWaiting ctrlWaiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_CONTROLLER_INFO ctrlBll = new Maticsoft.BLL.SMT_CONTROLLER_INFO();
var exists = ctrlBll.GetModelList("SN_NO='" + ctrlInfo.SN_NO + "'");
if (ctrlInfo.ID != -1)
{
if (exists.Count > 0)
{
if (exists[0].ID != ctrlInfo.ID)
{
WinInfoHelper.ShowInfoWindow(this, "已存在控制器序列号：" + ctrlInfo.SN_NO);
return;
}
}
ctrlBll.Update(ctrlInfo);
ctrlInfo.DOOR_INFOS = _ctrlr.DOOR_INFOS;
_ctrlr = ctrlInfo;
}
else
{
if (exists.Count > 0)
{
WinInfoHelper.ShowInfoWindow(this, "已存在控制器序列号：" + ctrlInfo.SN_NO);
return;
}
ctrlInfo.ID = ctrlBll.Add(ctrlInfo);
_ctrlr = ctrlInfo;
}
if (_lastType != ControllerDoorType.Elevator)//非电梯控制器
{
Maticsoft.BLL.SMT_DOOR_INFO doorBll = new Maticsoft.BLL.SMT_DOOR_INFO();
foreach (var item in doors)
{
var edoors = doorBll.GetModelList("CTRL_ID=" + ctrlInfo.ID + " and " + " CTRL_DOOR_INDEX=" + item.CTRL_DOOR_INDEX);
if (edoors.Count > 0)
{
item.ID = edoors[0].ID;
doorBll.Update(item);
}
else
{
item.CTRL_ID = ctrlInfo.ID;
item.ID = doorBll.Add(item);
}
}
_ctrlr.DOOR_INFOS = doors;
if (upload)
{
string errMsg = null;
if (UploadPrivate.UploadByCtrlr(_ctrlr, out errMsg, doors, true))
{
if (errMsg != "")
{
WinInfoHelper.ShowInfoWindow(this, "设置控制器" + (_ctrlr.IS_ENABLE ? "启用" : "禁用") + "异常：" + errMsg);
return;
}
}
else
{
WinInfoHelper.ShowInfoWindow(this, "设置控制器" + (_ctrlr.IS_ENABLE ? "启用" : "禁用") + "异常：" + errMsg);
return;
}
Controller c = ControllerHelper.ToController(_ctrlr);
//设置门控制方式
foreach (var item in doors)
{
using (IAccessCore access = new WGAccess())
{
bool ret = access.SetDoorControlStyle(c, (int)item.CTRL_DOOR_INDEX, (DoorControlStyle)item.CTRL_STYLE, item.CTRL_DELAY_TIME);
if (!ret)
{
WinInfoHelper.ShowInfoWindow(this, "上传门控制方式失败！");
return;
}
}
}
}
}
this.Invoke(new Action(() =>
{
this.DialogResult = DialogResult.OK;
this.Close();
}));
}
catch (Exception ex)
{
log.Error("保存异常：" + ex.Message, ex);
WinInfoHelper.ShowInfoWindow(this, "保存异常：" + ex.Message);
}
});
ctrlWaiting.Show(this);
}
catch (Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "保存异常：" + ex.Message);
log.Error("保存异常：" + ex.Message, ex);
}
}
private void DoDelete(DataGridViewRow row)
{
if (MessageBox.Show("确定删除该控制器？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
CtrlWaiting ctrlWaiting = new CtrlWaiting("正在删除中...", () =>
{
try
{
Maticsoft.Model.SMT_CONTROLLER_INFO ctrlr = (Maticsoft.Model.SMT_CONTROLLER_INFO)row.Tag;
DialogResult dr = DialogResult.No;
this.Invoke(new Action(() =>
{
dr = MessageBox.Show("是否清除该控制器权限？", "提示", MessageBoxButtons.YesNo);
}));
if (dr == DialogResult.Yes)
{
Controller c = ControllerHelper.ToController(ctrlr);
using (IAccessCore ac = new WGAccess())
{
try
{
bool ret = ac.ClearAuthority(c);
if (!ret)
{
this.Invoke(new Action(() =>
{
dr = MessageBox.Show("清除控制器权限失败（控制器可能离线），是否继续删除控制器？", "提示", MessageBoxButtons.YesNo);
}));
if (dr == DialogResult.No)
{
return;
}
}
}
catch (Exception ex)
{
log.Error("清除控制器权限失败（控制器可能离线）(删除控制器)：", ex);
this.Invoke(new Action(() =>
{
dr = MessageBox.Show("清除控制器权限失败（控制器可能离线），是否继续删除控制器？", "提示", MessageBoxButtons.YesNo);
}));
if (dr == DialogResult.No)
{
return;
}
}
}
}
Maticsoft.BLL.SMT_CONTROLLER_INFO ctrlBll = new Maticsoft.BLL.SMT_CONTROLLER_INFO();
ctrlBll.Delete(ctrlr.ID);
//置门关联控制器为空
Maticsoft.DBUtility.DbHelperSQL.ExecuteSql("update SMT_DOOR_INFO set CTRL_ID=-1,CTRL_DOOR_INDEX=0 where CTRL_ID=" + ctrlr.ID);
SmtLog.Info("设备", "控制器删除：" + ctrlr.IP + "," + ctrlr.NAME);
this.Invoke(new Action(() =>
{
dgvCtrlr.Rows.Remove(row);
}));
}
catch (System.Exception ex)
{
log.Error("删除控制器异常：", ex);
WinInfoHelper.ShowInfoWindow(this, "删除失败：" + ex.Message);
}
});
ctrlWaiting.Show(this);
}
}
