public RecognizerClientConnection(Socket socket) { string errMessage = ""; Ip = ((IPEndPoint) socket.RemoteEndPoint).Address.ToString(); Port = ((IPEndPoint)socket.RemoteEndPoint).Port; RecognizerInfo = RecognizerBusiness.Instance.GetRecognizerInfoByRecognizerIP(ref errMessage, Ip); _networkStream = new NetworkStream(socket); LiveRecognizerEventPacketHandle = new LiveRecognizerEventPacketHandle(); LiveRecognizerFacePacketHandle = new LiveRecognizerFacePacketHandle(); LiveRecognizerVehiclePacketHandle = new LiveRecognizerVehiclePacketHandle(); _handlers = new IPacketHandler[] { LiveRecognizerEventPacketHandle, LiveRecognizerFacePacketHandle, LiveRecognizerVehiclePacketHandle }; }
public AddRecognizer(RecognizerInfo decoderInfo) { InitializeComponent(); this.Text = "更新识别器"; simpleButtonOk.TabIndex = 0; this.textEditname.Text = decoderInfo.Name; this.textEditIp.Text = decoderInfo.Ip; this.textEditport.Text = decoderInfo.Port.ToString(); this.textEditmax.Text = decoderInfo.MaxRecogNumber.ToString(); if(decoderInfo.RecogType==1) this.comboBoxEdit_Type.Text ="Event"; if (decoderInfo.RecogType == 2) this.comboBoxEdit_Type.Text = "Vehicle"; if (decoderInfo.RecogType == 4) this.comboBoxEdit_Type.Text = "Face"; Opt = Util.Operateion.Update; recognizerOldName = decoderInfo.Name; InitValidationRules(); }
public int Update(ref string errMessage, RecognizerInfo oRecognizerInfo) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { return RecognizerDataAccess.Update(db, oRecognizerInfo); } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return -1; } }
public RecognizerInfo GetRecognizerInfoByRecognizerIP(ref string errMessage, string IP) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { DataSet ds = RecognizerDataAccess.GetRecognizerInfoByRecognizerIP(db, IP); if (ds.Tables[0].Rows.Count == 0) { return null; } RecognizerInfo oRecognizerInfo = new RecognizerInfo(ds.Tables[0].Rows[0]); DataSet dsCamera; CameraInfo oCamera; dsCamera = RecognizerDataAccess.GetCameraInfoByRecognizerId(db, oRecognizerInfo.Id); //DecoderDataAccess.GetCamInfoByCameraId(db,dsCamera.Tables[0].Rows[i].) oRecognizerInfo.ListCameras = new Dictionary<int, CameraInfo>(); foreach (DataRow dr in dsCamera.Tables[0].Rows) { oCamera = new CameraInfo(dr); oRecognizerInfo.ListCameras.Add(oCamera.CameraId, oCamera); } return oRecognizerInfo; } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return null; } }
public Dictionary<int, RecognizerInfo> GetRecognizerInfoByName(ref string errMessage, string Name) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; Dictionary<int, RecognizerInfo> mylist = new Dictionary<int, RecognizerInfo>(); try { DataSet ds = RecognizerDataAccess.GetRecognizerInfoByName(db, Name); RecognizerInfo oRecognizerInfo; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { oRecognizerInfo = new RecognizerInfo(ds.Tables[0].Rows[i]); DataSet dsCamera; CameraInfo oCamera; dsCamera = RecognizerDataAccess.GetCameraInfoByRecognizerId(db, oRecognizerInfo.Id); //DecoderDataAccess.GetCamInfoByCameraId(db,dsCamera.Tables[0].Rows[i].) oRecognizerInfo.ListCameras = new Dictionary<int, CameraInfo>(); foreach (DataRow dr in dsCamera.Tables[0].Rows) { oCamera = new CameraInfo(dr); oRecognizerInfo.ListCameras.Add(oCamera.CameraId, oCamera); } mylist.Add(oRecognizerInfo.Id, oRecognizerInfo); } return mylist; } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return null; } }
public static int Update(Database db, RecognizerInfo oRecognizerInfo) { StringBuilder sb = new StringBuilder(); sb.Append("update RecognizerInfo set"); sb.AppendFormat(" Name='{0}'", oRecognizerInfo.Name); //sb.AppendFormat(",id='{0}'", oDecoderInfo.id); sb.AppendFormat(",Ip='{0}'", oRecognizerInfo.Ip); sb.AppendFormat(",Port={0}", oRecognizerInfo.Port); sb.AppendFormat(",MaxRecogNumber={0}", oRecognizerInfo.MaxRecogNumber); sb.AppendFormat(",RecogType={0}", oRecognizerInfo.RecogType); sb.AppendFormat(" where Id={0}", oRecognizerInfo.Id); string cmdText = sb.ToString(); try { return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
public static int Insert(Database db, RecognizerInfo oRecognizerInfo) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO [RecognizerInfo]("); sbValue.Append("values ("); //sbField.Append("[id]"); //sbValue.AppendFormat("'{0}'", oDecoderInfo.id); sbField.Append("[Name]"); sbValue.AppendFormat("'{0}'", oRecognizerInfo.Name); sbField.Append(",[Ip]"); sbValue.AppendFormat(",'{0}'", oRecognizerInfo.Ip); sbField.Append(",[Port]"); sbValue.AppendFormat(",{0}", oRecognizerInfo.Port); sbField.Append(",[RecogType]"); sbValue.AppendFormat(",{0}", oRecognizerInfo.RecogType); sbField.Append(",[MaxRecogNumber])"); sbValue.AppendFormat(",'{0}')", oRecognizerInfo.MaxRecogNumber); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { cmdText = cmdText.Replace("\r\n", ""); return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
/// <summary> /// 增加识别器 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void simpleButtonOk_Click(object sender, EventArgs e) { if (!dxValidationProvider1.Validate()) { return; } RecognizerInfo ri = new RecognizerInfo(); ri.Id = Id; ri.Name = textEditname.Text; ri.Port = int.Parse(textEditport.Text); ri.Ip = textEditIp.Text; ri.MaxRecogNumber = int.Parse(textEditmax.Text); if (comboBoxEdit_Type.Text == "Event") ri.RecogType = (int)E_Type.E_Event; if (comboBoxEdit_Type.Text == "Vehicle") ri.RecogType = (int)E_Type.E_Vehicle; if (comboBoxEdit_Type.Text == "Face") ri.RecogType = (int)E_Type.E_Face; switch (Opt) { case Util.Operateion.Add: RecognizerBusiness.Instance.Insert(ref errMessage, ri); OperateLog ol = new OperateLog { HappenTime = DateTime.Now, OperateTypeId = (int)(OperateLogTypeId.RecognizerAdd), OperateTypeName = OperateLogTypeName.RecognizerAdd, Content = ri.ToString(), Id = ri.Id, OperateUserName = MainForm.CurrentUser.UserName, ClientUserName = MainForm.CurrentUser.UserName, ClientUserId = MainForm.CurrentUser.UserId }; OperateLogBusiness.Instance.Insert(ref errMessage, ol); break; case Util.Operateion.Update: ri = RecognizerBusiness.Instance.GetRecognizerInfoByRecognizerId(ref errMessage,Id); ri.Name = textEditname.Text; ri.Port = int.Parse(textEditport.Text); ri.Ip = textEditIp.Text; ri.MaxRecogNumber = int.Parse(textEditmax.Text); Id = RecognizerBusiness.Instance.Update(ref errMessage, ri); OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog { HappenTime = DateTime.Now, OperateTypeId = (int)(OperateLogTypeId.RecognizerUpdate), OperateTypeName = OperateLogTypeName.RecognizerUpdate, Content = ri.ToString(), Id = ri.Id, OperateUserName = MainForm.CurrentUser.UserName, ClientUserName = MainForm.CurrentUser.UserName, ClientUserId = MainForm.CurrentUser.UserId }); break; case Util.Operateion.Delete: break; default: break; } Close(); Dispose(); }