/// <summary> /// 添加监控管理的设备 /// </summary> /// <param name="devid">请求的客户端</param> /// <param name="ispatrol">是否持续巡检</param> private void addDevice(string devid, bool ispatrol) { //设备已经监控,则不再增加设备信息 DeviceBase[] devices = this.devlist.ToArray(); for (int i = 0; i < devices.Length; i++) { if (devid == devices[i].DevID) { return; } } //增加设备监控 Estar.Common.Tools.NameObjectList ps = new Estar.Common.Tools.NameObjectList(); ps["设备ID"] = devid; DataTable tab = this.query.getTable("设备通讯参数", ps); if (null == tab || tab.Rows.Count < 1) { return; } DataRow dr = tab.Rows[0]; string dvtype = Convert.ToString(dr["通讯协议"]); if (string.IsNullOrEmpty(dvtype) || DBNull.Value == dr["站址"]) { return; } int station = Convert.ToInt32(dr["站址"]); CommiTarget target = this.getTarget(dr); CommiManager commimgr = CommiManager.GlobalManager; DeviceBase device = null; switch (dvtype) { case "门禁": device = new DeviceDoor(); target.setProtocol(Protocol.PTLDoor); break; case "消费": device = new DeviceEatery(); target.setProtocol(Protocol.PTLEatery); break; default: return; } device.IsPatrol = ispatrol; device.SetDevice(commimgr, target, devid, station); this.devlist.Add(device); device.RecordHandle += new EventHandler <DvRecordEventArgs>(device_RecordHandle); device.SignalHandle += new EventHandler <DvSignalEventArgs>(device_SignalHandle); device.AlarmHandle += new EventHandler <DvAlarmEventArgs>(device_AlarmHandle); device.StartGather(); }
/// <summary> /// 添加监控管理的设备 /// </summary> /// <param name="devid">请求的客户端</param> /// <param name="ispatrol">是否持续巡检</param> private DeviceBase addDevice(string devid, bool ispatrol) { //增加设备监控 Estar.Common.Tools.NameObjectList ps = new Estar.Common.Tools.NameObjectList(); ps["设备ID"] = devid; DataTable tab = this.query.getTable("设备通讯参数", ps); if (null == tab || tab.Rows.Count < 1) { return(null); } DataRow dr = tab.Rows[0]; string dvtype = Convert.ToString(dr["通讯协议"]); if (string.IsNullOrEmpty(dvtype) || DBNull.Value == dr["站址"]) { return(null); } int station = Convert.ToInt32(dr["站址"]); CommiTarget target = this.getTarget(dr); CommiManager commimgr = CommiManager.GlobalManager; DeviceBase device = null; switch (dvtype) { case "门禁": device = new DeviceDoor(); target.setProtocol(Protocol.PTLDoor); break; case "消费": device = new DeviceEatery(); target.setProtocol(Protocol.PTLEatery); break; default: return(null); } device.IsPatrol = ispatrol; device.dtBeat = DateTime.Now; device.SetDevice(commimgr, target, devid, station); this.devlist.Add(device); device.StartGather(); return(device); }
/// <summary> /// 对目标通讯启动心跳,已经有则不会重复 /// </summary> /// <param name="mgr">通讯管理器</param> /// <param name="target">通讯目标</param> public static void OpenHeaderBeat(CommiManager mgr, CommiTarget target) { if (null == mgr || null == target) { return; } target.setProtocol(CmdFileTrans.PTL); mgr.SendCommand(target, CmdHeaderBeat); }
/// <summary> /// 搜索网络内支持UDP通讯的设备信息,设备信息使用tag格式数据 /// </summary> /// <returns>返回tag格式数据信息</returns> public static string[] SearchUDPnet() { IPEndPoint srv = new IPEndPoint(IPAddress.Broadcast, initport); CommiTarget target = new CommiTarget(srv, CommiType.UDP); target.setProtocol(ptlZnet); DateTime dtStart = DateTime.Now; CommandBase cmd = new CommandBase(false); cmd.TimeSendInv = new TimeSpan(0, 0, 50); cmd.TimeOut = new TimeSpan(0, 0, 2); cmd.TimeFailLimit = new TimeSpan(0, 0, 5); cmd.TimeLimit = new TimeSpan(0, 0, 20); cmd.IsResposeHandle = isRpsZnet; cmd.setCommand(initcmd, true); cmd.ResponseHandle += new EventHandler <ResponseEventArgs>(cmd_ResponseHandle); CommiManager.GlobalManager.SendCommand(target, cmd); //广播搜索,有多个设备返回信息,直到超时停止接收 List <string> infolist = cmd.Tag as List <string>; while (cmd.EventWh.WaitOne(cmd.TimeLimit, false) && DateTime.Now - dtStart < cmd.TimeLimit) { infolist = cmd.Tag as List <string>; if (null == infolist || infolist.Count < 1) { continue; } string[] infos = infolist.ToArray(); bool iscomplete = true; for (int i = 0; i < infos.Length; i++) { if (!string.IsNullOrEmpty(basefun.valtag(infos[i], "工作端口"))) { continue; } iscomplete = false; break; } if (iscomplete) { break; } } cmd.TimeSendInv = new TimeSpan(0, 0, -10); CommiManager.GlobalManager.RemoveCommand(target, cmd); //返回搜索结果 infolist = cmd.Tag as List <string>; cmd.Tag = null; if (null == infolist || infolist.Count < 1) { return(new string[0]); } return(infolist.ToArray()); }
/// <summary> /// 从服务器中获得图片 /// </summary> /// <param name="savePath">图片保存相对路径</param> /// <param name="pl">显示图片的容器</param> public void getPic_Server(string filepath, Panel pl) { if (string.IsNullOrEmpty(filepath)) { return; } int port = 2010; string ipsrv = "127.0.0.1"; string sport = DataAccRes.AppSettings("Granity文件服务"); string conn = DataAccRes.DefaultDataConnInfo.Value; if (!string.IsNullOrEmpty(sport)) { try { port = Convert.ToInt32(sport); } catch { return; } } Regex regIP = new Regex(@"server=([\w.\(\)]*)(;|\\)"); if (regIP.IsMatch(conn)) { Match mt = regIP.Match(conn); if (mt.Groups.Count > 1) { ipsrv = mt.Groups[1].Value.ToLower(); } if ("(local)" == ipsrv || "127.0.0.1" == ipsrv) { ipsrv = Dns.GetHostName(); } ipsrv = Dns.GetHostAddresses(ipsrv)[0].ToString(); } CommiTarget target = new CommiTarget(ipsrv, port, CommiType.TCP); target.setProtocol(CmdFileTrans.PTL); CmdFileTrans cmd = new CmdFileTrans(false); cmd.GetFile(filepath); CommiManager.GlobalManager.SendCommand(target, cmd); if (cmd.EventWh.WaitOne(new TimeSpan(0, 0, 15), false)) { byte[] data = cmd.FileContext; if (data.Length < 1) { return; } MemoryStream stream = new MemoryStream(data); pl.BackgroundImage = Image.FromStream(stream); } }
/// <summary> /// 获取数据行的设备目标位置参数 /// 记录包含字段【访问方式】(TCP/UDP/SerialPort)、【端口】(60000/COM1)、【地址】(192.168.1.146) /// </summary> /// <param name="dr">数据记录</param> /// <returns></returns> private CommiTarget getTarget(DataRow dr) { if (null == dr) { return(null); } CommiTarget target = new CommiTarget(); CommiType commiType = CommiType.UDP; int typecommi = 0; if (dr["通讯类别"].ToString() == "485") { typecommi = 1; } else if (dr["通讯类别"].ToString() == @"TCP\IP") { typecommi = 2; } else { typecommi = 3; } if (DBNull.Value != dr["通讯类别"]) { //int typecommi = Convert.ToInt16(dr["通讯类别"]); if (1 == typecommi) { commiType = CommiType.SerialPort; } if (2 == typecommi) { commiType = CommiType.TCP; } } if (CommiType.SerialPort == commiType) { string portname = "COM" + Convert.ToString(dr["端口"]); target.SetProtocolParam(portname, 19200); } else { string addr = Convert.ToString(dr["站址"]); int port = Convert.ToInt16(dr["端口"]); target.SetProtocolParam(addr, port, commiType); } target.setProtocol(Protocol.PTLPark); return(target); }
/// <summary> /// 火警联动 /// </summary> /// <param name="sender">门禁设备</param> /// <param name="e">报警事件</param> void device_AlarmHandle(object sender, DvAlarmEventArgs e) { DeviceDoor door = sender as DeviceDoor; if (null == door || null == e || string.IsNullOrEmpty(e.TagAlarm)) { return; } string fire = basefun.valtag(e.TagAlarm, "火警"); if ("1" != fire) { return; } NameObjectList ps = new NameObjectList(); ps["设备ID"] = door.DevID; DataTable tab = this.query.getTable("同组设备", ps); CommiManager commimgr = CommiManager.GlobalManager; for (int i = 0; i < tab.Rows.Count; i++) { DataRow dr = tab.Rows[i]; string dvid = Convert.ToString(dr["ID"]); string dvtype = Convert.ToString(dr["通讯协议"]); if (string.IsNullOrEmpty(dvtype) || DBNull.Value == dr["站址"]) { return; } int station = Convert.ToInt32(dr["站址"]); CommiTarget target = this.getTarget(dr); if (null == target) { return; } target.setProtocol(Protocol.PTLDoor); door = new DeviceDoor(); door.SetDevice(commimgr, target, dvid, station); door.FireOpenDoor(); } }
/// <summary> /// 设置RF通讯端口,波特率,站址,被动只接收数据 /// </summary> /// <param name="port">RF射频串口</param> /// <param name="baudRate">波特率</param> /// <returns>能够打开端口则成功,端口占用或参数非法则失败</returns> public bool setRfTarget(string port, int baudRate) { CommiManager mgr = CommiManager.GlobalManager; if (null != this.rftar && this.rftar.PortName == port) { mgr.SendCommand(this.rftar, this.cmdRFID); return(true); } if (null != this.rftar) { mgr.RemoveCommand(this.rftar); } this.rftar = null; try { CommiTarget tar = new CommiTarget(port, baudRate); Protocol ptl = new Protocol(); ptl.FrameHeader = new byte[] { 0x02 }; ptl.FrameFoot = new byte[] { 0x03, 0x0A, 0x0D }; ptl.TotalBytes = 13; tar.setProtocol(ptl); if (!mgr.TestConnect(tar)) { return(false); } this.rftar = tar; } catch { return(false); } //命令只接收数据 this.cmdRFID.ResetState(); byte[] request = new byte[] { 0x02, 0x00, 0x00, 0x03, 0x0A, 0x0D }; this.cmdRFID.setCommand(request); mgr.SendCommand(this.rftar, this.cmdRFID); return(true); }
/// <summary> /// 搜索网络内支持UDP通讯的设备信息,设备信息使用tag格式数据 /// </summary> /// <returns>返回tag格式数据信息</returns> public static string[] SearchUDPDoor() { IPEndPoint srv = new IPEndPoint(IPAddress.Broadcast, searport); CommiTarget target = new CommiTarget(srv, CommiType.UDP); target.setProtocol(Protocol.PTLDoor); DateTime dtStart = DateTime.Now; CommandBase cmd = new CommandBase(false); cmd.TimeSendInv = new TimeSpan(0, 0, 50); cmd.TimeOut = new TimeSpan(0, 0, 2); cmd.TimeFailLimit = new TimeSpan(0, 0, 5); cmd.TimeLimit = new TimeSpan(0, 0, 20); cmd.IsResposeHandle = isRpsDoor; cmd.setCommand(searcmd, true); cmd.ResponseHandle += new EventHandler <ResponseEventArgs>(cmd_RpsDoorHandle); CommiManager.GlobalManager.SendCommand(target, cmd); //广播搜索,有多个设备返回信息,直到超时停止接收 List <string> infolist = cmd.Tag as List <string>; while (cmd.EventWh.WaitOne(cmd.TimeLimit, false) && DateTime.Now - dtStart < cmd.TimeLimit) { cmd.EventWh.Reset(); } cmd.TimeSendInv = new TimeSpan(0, 0, -10); CommiManager.GlobalManager.RemoveCommand(target, cmd); //返回搜索结果 infolist = cmd.Tag as List <string>; cmd.Tag = null; if (null == infolist || infolist.Count < 1) { return(new string[0]); } return(infolist.ToArray()); }
/// <summary> /// 获取数据行的设备目标位置参数 /// 记录包含字段【访问方式】(TCP/UDP/SerialPort)、【端口】(60000/COM1)、【地址】(192.168.1.146) /// </summary> /// <param name="dr">数据记录</param> /// <returns></returns> private CommiTarget getTarget(string[] devps) { string[] cols = { "通讯类别", "串口", "波特率", "数据位", "停止位", "IP地址", "端口", "站址", "控制器", "名称" }; if (null == devps || devps.Length < 7) { return(null); } CommiTarget target = new CommiTarget(); target.setProtocol(Protocol.PTLDoor); CommiType commiType = CommiType.UDP; string stype = Convert.ToString(devps[0]); switch (stype) { case "TCP/IP(局域网)": commiType = CommiType.TCP; break; case "UDP/IP(局域网)": commiType = CommiType.UDP; break; default: commiType = CommiType.SerialPort; break; } try { if (CommiType.SerialPort == commiType) { string portname = Convert.ToString(devps[1]); int baudRate = Convert.ToInt16(devps[2]); int dataBits = Convert.ToInt16(devps[3]); decimal s = Convert.ToDecimal(devps[4]); StopBits sb = StopBits.None; if (1 == s) { sb = StopBits.One; } else if (2 == s) { sb = StopBits.Two; } else if (1 < s && s < 2) { sb = StopBits.OnePointFive; } target.SetProtocolParam(portname, baudRate, Parity.None, dataBits, sb); } else { string addr = Convert.ToString(devps[5]); int port = Convert.ToInt32(devps[6]); target.SetProtocolParam(addr, port, commiType); } } catch (Exception ex) { return(null); } return(target); }
/// <summary> /// 添加监控管理的设备 /// </summary> /// <param name="devid">请求的客户端</param> /// <param name="ispatrol">是否持续巡检</param> private DeviceBase addDevice(string devid, bool ispatrol) { //增加设备监控 NameObjectList ps = new NameObjectList(); ps["设备ID"] = devid; DataTable tab = this.query.getTable("设备通讯参数", ps); if (null == tab || tab.Rows.Count < 1) { return(null); } DataRow dr = tab.Rows[0]; if (!tab.Columns.Contains("通讯协议")) { string msg = ""; foreach (object obj in dr.ItemArray) { msg += Convert.ToString(obj) + " "; } Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff") + " 设备通讯参数值:" + msg); myLog.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff") + " 设备通讯参数值:" + msg); return(null); } string dvtype = Convert.ToString(dr["通讯协议"]); if (string.IsNullOrEmpty(dvtype) || DBNull.Value == dr["站址"]) { return(null); } int station = Convert.ToInt32(dr["站址"]); CommiTarget target = this.getTarget(dr); if (null == target) { return(null); } CommiManager commimgr = CommiManager.GlobalManager; DeviceBase device = null; switch (dvtype) { case "门禁": Debug.WriteLine("门禁"); string ctrltype = Convert.ToString(dr["控制器类型"]); if ("进出口" == ctrltype || "出入口" == ctrltype) { device = new DeviceChannel(); } else { device = new DeviceDoor(); } target.setProtocol(Protocol.PTLDoor); device.AlarmHandle += new EventHandler <DvAlarmEventArgs>(device_AlarmHandle); break; case "消费": device = new DeviceEatery(); target.setProtocol(Protocol.PTLEatery); break; default: return(null); } device.RecordHandle += new EventHandler <DvRecordEventArgs>(device_RecordHandle); Monitor.Enter(devlist); this.devlist.Add(device); Monitor.PulseAll(devlist); Monitor.Exit(devlist); device.IsPatrol = ispatrol; device.dtBeat = DateTime.Now; device.SetDevice(commimgr, target, devid, station); device.StartGather(); Debug.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff") + " 启动:" + Convert.ToString(station) + " 设备ID:" + devid); myLog.WriteLine(DateTime.Now.ToString("HH:mm:ss.fff") + " 启动:" + Convert.ToString(station) + " 设备ID:" + devid); return(device); }
/// <summary> /// 设置发行器 /// </summary> /// <param name="target">发行器地址</param> /// <param name="stationNum">发行器站址</param> /// <param name="isCardIC">是否IC卡</param> /// <returns>是否成功设置发行器</returns> public bool SetTarget(CommiTarget target, int stationNum, bool isCardIC) { //重新设置则保持当前状态 if (null != target && stationNum > 0 && stationNum < 255 && null != this.targetwr) { if (this.addrst == Convert.ToString(stationNum) && this.isCardIC == isCardIC && ((null != target.SrvEndPoint && null != this.targetwr.SrvEndPoint && this.targetwr.SrvEndPoint.Port == target.SrvEndPoint.Port && this.targetwr.SrvEndPoint.Address.ToString() == target.SrvEndPoint.Address.ToString()) || (this.targetwr.PortName == target.PortName && this.targetwr.BaudRate == target.BaudRate))) { if (!string.IsNullOrEmpty(this.cardid) || 0 == this.stateChecking) { return(true); } this.reChecking(1); return(true); } } this.TimeSendInv = new TimeSpan(24, 0, 0); this.stateChecking = 0; this.cardid = ""; this.cardserno = ""; this.cardnum = ""; string tagdata = "@设备地址=" + this.addrst; //原发行器脱机 string[,] cmds = { { "卡务中心", "脱机" }, { "卡务中心", "蜂鸣" } }; if (null != this.targetwr && !string.IsNullOrEmpty(this.addrst)) { for (int i = 0; i < cmds.GetLength(0); i++) { this.setCommand(cmds[i, 0], cmds[i, 1], tagdata); this.ResetState(); this.commiMgr.SendCommand(this.targetwr, this); this.EventWh.WaitOne(this.waitTime, false); } this.commiMgr.RemoveCommand(this.targetwr, this); } //置发行器脱机并蜂鸣提示 this.isCardIC = isCardIC; this.targetwr = null; this.addrst = "3"; if (null == target || stationNum < 1 || stationNum > 255) { return(false); } this.targetwr = target; this.addrst = Convert.ToString(stationNum); target.setProtocol(Protocol.PTLCard); tagdata = "@设备地址=" + this.addrst; cmds = new string[, ] { { "卡务中心", "联机" }, { "卡务中心", "防冲突" } }; if (!isCardIC) { cmds = new string[, ] { { "卡务中心", "读卡" } } } ; for (int i = 0; i < cmds.GetLength(0); i++) { this.setCommand(cmds[i, 0], cmds[i, 1], tagdata); this.ResetState(); this.commiMgr.SendCommand(this.targetwr, this); if (!this.EventWh.WaitOne(this.waitTime, false)) { return(false); } } this.tmIDcache.Change(Timeout.Infinite, Timeout.Infinite); this.TimeSendInv = new TimeSpan(3000000); this.stateChecking = isCardIC ? 2 : 1; return(true); }
/// <summary> /// 接收广播反馈,需要多次交互获取完整信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private static void cmd_ResponseHandle(object sender, ResponseEventArgs e) { if (null == sender || !(sender is CommandBase) || null == e || !e.Success || null == e.Response || e.Response.Length < 1) { return; } CommandBase cmd = sender as CommandBase; string rsl = CommandBase.Parse(cmd.ResponseData, true); //检查功能码:搜索功能,获取网络信息,获取详细信息 string codesearch = "A1FD000922"; string codedetailA = "A114010200"; string codedetailB = "A114010202"; string code = parseFunCode(rsl); string addr = parseAddrMac(rsl); if (codesearch != code && codedetailA != code && codedetailB != code) { return; } //格式参数:普通/物理地址/IP地址/文本/数字 string[] formatinit = { "功能码,10,4;", "物理地址,4,6", "IP地址,17,4;", "", "" }; string[] formatdtlA = { "功能码,10,4;", "物理地址,4,6", "IP地址,47,4;子网掩码,51,4;网关IP,55,4;DNS服务器,59,4;", "设备名称,15,16;密码,31,5;", "网页端口,71,1;命令端口,72,2;" }; string[] formatdtlB = { "功能码,10,4;", "物理地址,4,6", "", "", "工作方式,15,1;工作端口,16,2;超时断开时间,18,3;心跳时间,21,1;波特率,26,3;数据位,29,1;停止位,30,1;校验位,31,1;" }; formatdtlB[4] += "分包长度,32,3;帧间隔,35,2;目标端口1,47,2;目标端口2,49,2;目标端口3,51,2;目标端口4,53,2;目标端口5,55,2;目标端口6,57,2;目标端口7,59,2;目标端口8,61,2;"; //读取信息列表 List <string> infolist = new List <string>(); if (null == cmd.Tag) { cmd.Tag = infolist; } int index = -1; infolist = cmd.Tag as List <string>; for (int i = 0; i < infolist.Count; i++) { if (addr != basefun.valtag(infolist[i], "物理地址")) { continue; } index = i; break; } string info = ""; if (index > -1) { info = infolist[index]; } if (codesearch == code) { info = parseDetail(rsl, info, formatinit[0], formatinit[1], formatinit[2], formatinit[3], formatinit[4], false); } else if (codedetailA == code) { info = parseDetail(rsl, info, formatdtlA[0], formatdtlA[1], formatdtlA[2], formatdtlA[3], formatdtlA[4], false); } else if (codedetailB == code) { info = parseDetail(rsl, info, formatdtlB[0], formatdtlB[1], formatdtlB[2], formatdtlB[3], formatdtlB[4], false); } if (index > -1) { infolist[index] = info; } else { infolist.Add(info); } //最后一步获取详细信息后结束 if (codedetailB == code) { return; } //再获取网络信息,最后获取详细信息 IPEndPoint srv = new IPEndPoint(IPAddress.Broadcast, infoport); CommiTarget target = new CommiTarget(srv, CommiType.UDP); target.setProtocol(ptlZnet); string strcmd = string.Format(infocmd, addr.Replace("-", " "), codesearch == code ? "A114000200" : "A114000202"); CommandBase cmdNext = new CommandBase(); //使用相同的同步事件,可动态检测UDP搜索反馈结果 cmdNext.EventWh = cmd.EventWh; cmdNext.Tag = cmd.Tag; cmdNext.ResponseHandle += new EventHandler <ResponseEventArgs>(cmd_ResponseHandle); cmdNext.IsResposeHandle = isResponseCmd; cmdNext.setCommand(strcmd, true); CommiManager.GlobalManager.SendCommand(target, cmdNext); }
/// <summary> /// 采集记录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btPick_Click(object sender, EventArgs e) { if (null == this.target || string.IsNullOrEmpty(this.deviceID) || string.IsNullOrEmpty(this.deviceName)) { return; } string tpl = "停车场", cmd = "收集下一条记录"; if (this.rdbRetry.Checked) { cmd = "收集当前记录"; } CmdProtocol cmdP = new CmdProtocol(this.deviceID, false); string tagdata = "@设备地址=" + this.deviceID; cmdP.setCommand(tpl, cmd, tagdata); cmdP.TimeLimit = new TimeSpan(0, 10, 0); cmdP.TimeFailLimit = new TimeSpan(0, 10, 0); cmdP.TimeSendInv = new TimeSpan(0, 10, 0); target.setProtocol(Protocol.PTLPark); this.gdRecord.Rows.Clear(); DataGridViewColumnCollection cols = this.gdRecord.Columns; string msg = ""; while (string.IsNullOrEmpty(msg)) { cmdP.ResetState(); CommiManager.GlobalManager.SendCommand(this.target, cmdP); if (!cmdP.EventWh.WaitOne(2000, false)) { msg = "通讯失败,请检查设备连接或通讯参数后重试!"; } string tag = cmdP.ResponseFormat; if (string.IsNullOrEmpty(msg) && string.IsNullOrEmpty(tag)) { msg = "采集完成!"; } if (!string.IsNullOrEmpty(msg)) { continue; } //采集加入数据 object[] data = new object[cols.Count]; for (int i = 0; i < cols.Count; i++) { if ("车牌号码" == cols[i].Name) { continue; } string val = basefun.valtag(tag, "{" + cols[i].Name + "}"); if (string.IsNullOrEmpty(val)) { val = basefun.valtag(tag, cols[i].Name); } if ("卡类" == cols[i].Name || "车型" == cols[i].Name) { data[i] = Convert.ToInt32(val); } else { data[i] = val; } } this.gdRecord.Rows.Add(data); } CommiManager.GlobalManager.RemoveCommand(this.target, cmdP); //生成参数列表 NameObjectList[] psList = new NameObjectList[this.gdRecord.Rows.Count]; for (int i = 0; i < psList.Length; i++) { NameObjectList p = new NameObjectList(); ParamManager.MergeParam(p, this.paramSystem, false); DataGridViewRow row = this.gdRecord.Rows[i]; foreach (DataGridViewColumn c in cols) { p[c.Name] = row.Cells[c.Name].Value; } psList[i] = p; } int devid = Convert.ToInt32(this.deviceID); if (devid < 129) { this.Query.ExecuteNonQuery("入场登记", psList, psList, psList); } else { this.Query.ExecuteNonQuery("出场登记", psList, psList, psList); } MessageBox.Show(msg); }