private void AddDecoderButton(object sender, EventArgs e) { if (!dxValidationProvider1.Validate()) { return; } //string errMessage = ""; DecoderInfo di = new DecoderInfo(); di.id = Id; di.Name = textEditname.Text; di.Port = int.Parse(textEditport.Text); di.Ip = textEditIp.Text; di.MaxDecodeChannelNo = int.Parse(textEditmax.Text); switch(Opt) { case Util.Operateion.Add: DecoderBusiness.Instance.Insert(ref errMessage, di); OperateLog ol = new OperateLog { HappenTime = DateTime.Now, OperateTypeId = (int)(OperateLogTypeId.DecoderAdd), OperateTypeName = OperateLogTypeName.DecoderAdd, Content = di.ToString(), Id = di.id, OperateUserName = MainForm.CurrentUser.UserName, ClientUserName = MainForm.CurrentUser.UserName, ClientUserId = MainForm.CurrentUser.UserId }; OperateLogBusiness.Instance.Insert(ref errMessage, ol); break; case Util.Operateion.Update: di = DecoderBusiness.Instance.GetDecoderInfoByDecoderId(ref errMessage, Id); di.Name = textEditname.Text; di.Port = int.Parse(textEditport.Text); di.Ip = textEditIp.Text; di.MaxDecodeChannelNo = int.Parse(textEditmax.Text); Id = DecoderBusiness.Instance.Update(ref errMessage, di); OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog { HappenTime = DateTime.Now, OperateTypeId = (int)(OperateLogTypeId.DecoderUpdate), OperateTypeName = OperateLogTypeName.DecoderUpdate, Content = di.ToString(), Id = di.id, OperateUserName = MainForm.CurrentUser.UserName, ClientUserName = MainForm.CurrentUser.UserName, ClientUserId = MainForm.CurrentUser.UserId }); break; case Util.Operateion.Delete: break; default: break; } Close(); Dispose(); }
public DecoderClientConnection(Socket socket) { string errMessage = ""; _socket = socket; Ip = ((IPEndPoint) socket.RemoteEndPoint).Address.ToString(); Port = ((IPEndPoint)socket.RemoteEndPoint).Port; DecoderInfo = DecoderBusiness.Instance.GetDecoderInfoByDecoderIP(ref errMessage, Ip); _networkStream = new NetworkStream(socket); LiveDecoderPacketHandle = new LiveDecoderPacketHandle(); DecoderStateHandle = new DecoderStateHandle(); _handlers = new IPacketHandler[] { LiveDecoderPacketHandle, DecoderStateHandle }; }
public frmDecoder(DecoderInfo 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.MaxDecodeChannelNo.ToString(); Opt = Util.Operateion.Update; decoderOldName = decoderInfo.Name; InitValidationRules(); }
public int Update(ref string errMessage, DecoderInfo DecoderInfo) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { return DecoderDataAccess.Update(db, DecoderInfo); } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return -1; } }
public Dictionary<int, DecoderInfo> GetDecoderInfoByName(ref string errMessage, string Name) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; Dictionary<int, DecoderInfo> mylist = new Dictionary<int, DecoderInfo>(); try { DataSet ds = DecoderDataAccess.GetDecoderInfoByName(db, Name); DecoderInfo decoderInfo; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { decoderInfo = new DecoderInfo(ds.Tables[0].Rows[i]); DataSet dsCamera; CameraInfo oCamera; dsCamera = DecoderDataAccess.GetCameraInfoByDecoderId(db, decoderInfo.id); //DecoderDataAccess.GetCamInfoByCameraId(db,dsCamera.Tables[0].Rows[i].) decoderInfo.ListCameras = new Dictionary<int, CameraInfo>(); foreach (DataRow dr in dsCamera.Tables[0].Rows) { oCamera = new CameraInfo(dr); decoderInfo.ListCameras.Add(oCamera.CameraId, oCamera); } mylist.Add(decoderInfo.id, decoderInfo); } return mylist; } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return null; } }
public DecoderInfo GetDecoderInfoByDecoderIP(ref string errMessage, string IP) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { DataSet ds = DecoderDataAccess.GetDecoderInfoByDecoderIP(db, IP); if (ds.Tables[0].Rows.Count == 0) { return null; } DecoderInfo decoderInfo = new DecoderInfo(ds.Tables[0].Rows[0]); DataSet dsCamera; CameraInfo oCamera; dsCamera = DecoderDataAccess.GetCameraInfoByDecoderId(db, decoderInfo.id); //DecoderDataAccess.GetCamInfoByCameraId(db,dsCamera.Tables[0].Rows[i].) decoderInfo.ListCameras = new Dictionary<int, CameraInfo>(); foreach (DataRow dr in dsCamera.Tables[0].Rows) { oCamera = new CameraInfo(dr); decoderInfo.ListCameras.Add(oCamera.CameraId, oCamera); } return decoderInfo; } 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, DecoderInfo oDecoderInfo) { StringBuilder sb = new StringBuilder(); sb.Append("update DecoderInfo set"); sb.AppendFormat(" Name='{0}'", oDecoderInfo.Name); //sb.AppendFormat(",id='{0}'", oDecoderInfo.id); sb.AppendFormat(",Ip='{0}'", oDecoderInfo.Ip); sb.AppendFormat(",Port={0}", oDecoderInfo.Port); sb.AppendFormat(",MaxDecodeChannelNo={0}", oDecoderInfo.MaxDecodeChannelNo); sb.AppendFormat(" where id={0}", oDecoderInfo.id); string cmdText = sb.ToString(); try { return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
public static int Insert(Database db, DecoderInfo oDecoderInfo) { /* StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO DecoderInfo("); sbValue.Append("values("); sbField.Append("id"); sbValue.AppendFormat("{0}", oDecoderInfo.id); sbField.Append(",Name"); sbValue.AppendFormat(",'{0}'", oDecoderInfo.Name); sbField.Append(",Ip"); sbValue.AppendFormat(",'{0}'", oDecoderInfo.Ip); sbField.Append(",Port"); sbValue.AppendFormat(",{0}", oDecoderInfo.Port); sbField.Append(",MaxDecodeChannelNo"); sbValue.AppendFormat(",{0}", oDecoderInfo.MaxDecodeChannelNo); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { // cmdText = cmdText.Replace("\r\n", ""); return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; }*/ StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO [DecoderInfo]("); sbValue.Append("values ("); //sbField.Append("[id]"); //sbValue.AppendFormat("'{0}'", oDecoderInfo.id); sbField.Append("[Name]"); sbValue.AppendFormat("'{0}'", oDecoderInfo.Name); sbField.Append(",[Ip]"); sbValue.AppendFormat(",'{0}'", oDecoderInfo.Ip); sbField.Append(",[Port]"); sbValue.AppendFormat(",{0}", oDecoderInfo.Port); sbField.Append(",[MaxDecodeChannelNo])"); sbValue.AppendFormat(",'{0}')", oDecoderInfo.MaxDecodeChannelNo); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { cmdText = cmdText.Replace("\r\n", ""); return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }