protected void InsertBadReCordInfo(string strAlarmType, string strCarNo, string strDecript) { if (InsertState == 0) { #region 报警实体类 CoalTraffic.Model.TT_BadRecord modelBad = new CoalTraffic.Model.TT_BadRecord(); modelBad.AlarmType = strAlarmType; modelBad.BreakDate = DateTime.Now; modelBad.CarNo = strCarNo; modelBad.CollCode = ""; modelBad.Decript = ""; modelBad.NavicertCode = strNavicertCode; modelBad.RecordID = Guid.NewGuid().ToString().Replace("-", ""); modelBad.RoomCode = strRoomCode; if (strIsVideo == "1") { modelBad.FrontImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.FrontImageContent = ((DHVideo)Form1.PF.Controls["videoFrontImage"]).CapturePic(); modelBad.RoomImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.RoomImageContent = ((DHVideo)Form1.PF.Controls["videoRoomImage"]).CapturePic(); modelBad.UpImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.UpImageContent = ((DHVideo)Form1.PF.Controls["videoUpImage"]).CapturePic(); modelBad.BackImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.BackImageContent = ((DHVideo)Form1.PF.Controls["videoBackImage"]).CapturePic(); } else { modelBad.FrontImage = ""; modelBad.FrontImageContent = null; modelBad.RoomImage = ""; modelBad.RoomImageContent = null; modelBad.UpImage = ""; modelBad.UpImageContent = null; modelBad.BackImage = ""; modelBad.BackImageContent = null; } #endregion #region 数据同步 //MSMQClient MC = new MSMQClient(); StringBuilder sbInsertBR = new StringBuilder(); sbInsertBR.Append("PT_BadRecord '" + modelBad.RecordID + "','" + modelBad.NavicertCode + "','" + modelBad.RoomCode + "','" + modelBad.CarNo + "','" + modelBad.Decript + "',"); sbInsertBR.Append("'" + modelBad.BreakDate + "','" + modelBad.AlarmType + "','" + modelBad.AlarmStatus + "','" + modelBad.CollCode + "','" + modelBad.FrontImage + "',"); sbInsertBR.Append("'" + modelBad.FrontImageContent + "','" + modelBad.BackImage + "','" + modelBad.BackImageContent + "','" + modelBad.UpImage + "',"); sbInsertBR.Append("'" + modelBad.UpImageContent + "','" + modelBad.RoomImage + "','" + modelBad.RoomImageContent + "'"); MC.AddNewSqlText(sbInsertBR.ToString()); #endregion string strRecordID = new CoalTraffic.BLL.TT_BadRecord().Add(modelBad); //添加违规记录成功,上传违规记录到服务器 if (strRecordID != "") { InsertState = 0; } else { alSound.Alarm("该站的数据库异常"); InsertBadReCordInfo("异常", "", ini.IniReadValue("RoomSetting", "RoomName") + "的数据库异常"); InsertState = 0; } } }
protected void InsertBadReCordInfo(string strAlarmType, string strDecript) { string isConnection = ini.IniReadValue("Connection", "isConnection"); if (InsertState == 0) { #region 报警实体类 CoalTraffic.Model.TT_BadRecord modelBad = new CoalTraffic.Model.TT_BadRecord(); modelBad.AlarmType = strAlarmType; modelBad.BreakDate = DateTime.Now; modelBad.CarNo = txtCarNo.Text.Trim(); modelBad.CollCode = strCollCode; modelBad.Decript = strDecript; modelBad.NavicertCode = ""; modelBad.RecordID = Guid.NewGuid().ToString().Replace("-", ""); modelBad.RoomCode = strRoomCode; if (StaticParameter.IsVideo == "1") { if (byteFrontImage == null && byteBackImage == null && byteUpImage == null && byteRoomImage == null) { strFrontImage = Guid.NewGuid().ToString().Replace("-", ""); strBackImage = Guid.NewGuid().ToString().Replace("-", ""); strUpImage = Guid.NewGuid().ToString().Replace("-", ""); strRoomImage = Guid.NewGuid().ToString().Replace("-", ""); byteFrontImage = this.videoFrontImage.CapturePic(); byteBackImage = this.videoBackImage.CapturePic(); byteUpImage = this.videoUpImage.CapturePic(); byteRoomImage = this.videoRoomImage.CapturePic(); } modelBad.FrontImage = strFrontImage; modelBad.FrontImageContent = byteFrontImage; modelBad.RoomImage = strRoomImage; modelBad.RoomImageContent = byteRoomImage; modelBad.UpImage = strUpImage; modelBad.UpImageContent = byteUpImage; modelBad.BackImage = strBackImage; modelBad.BackImageContent = byteBackImage; } else { modelBad.FrontImage = ""; modelBad.FrontImageContent = null; modelBad.RoomImage = ""; modelBad.RoomImageContent = null; modelBad.UpImage = ""; modelBad.UpImageContent = null; modelBad.BackImage = ""; modelBad.BackImageContent = null; } #endregion string strRecordID = new CoalTraffic.BLL.TT_BadRecord().Add(modelBad); #region 当联网的时:插入同步sql语句到服务器,sql语句本地执行 if (isConnection == "0") { StringBuilder sbInsertBRLocal = new StringBuilder(); sbInsertBRLocal.Append("PT_BadRecord '" + modelBad.RecordID + "','" + modelBad.NavicertCode + "','" + modelBad.RoomCode + "','" + modelBad.CarNo + "','" + modelBad.Decript + "',"); sbInsertBRLocal.Append("'" + modelBad.BreakDate + "','" + modelBad.AlarmType + "','" + modelBad.AlarmStatus + "','" + modelBad.CollCode + "','" + modelBad.FrontImage + "',"); sbInsertBRLocal.Append("null,'" + modelBad.BackImage + "',null,'" + modelBad.UpImage + "',"); sbInsertBRLocal.Append("null,'" + modelBad.RoomImage + "',null"); DbHelperSQL.ExecuteSql2(sbInsertBRLocal.ToString(), "1");//sql语句本地执行 string sqlInsertLog = "insert [NetWorkDisconnectionLog] (ID, SQLcontext, datetime, IP) values (@ID,@SQLcontext,@datetime,@IP)"; SqlParameter[] sqlpars = new SqlParameter[] { new SqlParameter("@ID",DateTime.Now.ToString("yyyyMMddHHmmss")), new SqlParameter("@SQLcontext",sbInsertBRLocal.ToString().ToString()), new SqlParameter("@datetime",DateTime.Now.ToString()), new SqlParameter("@IP",ini.IniReadValue("Connection","LServer")) }; DbHelperSQL.ExecuteSql(sqlInsertLog,sqlpars); //插入同步sql语句 } #endregion #region 当断网时,添加报警日志相关sql语句 StringBuilder sbInsertBR = new StringBuilder(); sbInsertBR.Append("PT_BadRecord '" + modelBad.RecordID + "','" + modelBad.NavicertCode + "','" + modelBad.RoomCode + "','" + modelBad.CarNo + "','" + modelBad.Decript + "',"); sbInsertBR.Append("'" + modelBad.BreakDate + "','" + modelBad.AlarmType + "','" + modelBad.AlarmStatus + "','" + modelBad.CollCode + "','" + modelBad.FrontImage + "',"); sbInsertBR.Append("null,'" + modelBad.BackImage + "',null,'" + modelBad.UpImage + "',"); sbInsertBR.Append("null,'" + modelBad.RoomImage + "',null"); string id = DateTime.Now.ToString("yyyyMMddHHmmss"); StringBuilder sbsqlcontext = new StringBuilder(); sbsqlcontext.Append("insert into NetWorkDisconnection (ID, SQLcontext, DateTime) values(@id,@sqlcontext,@datetime)"); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@id",id), new SqlParameter("@sqlcontext",sbInsertBR.ToString()), new SqlParameter("@datetime",DateTime.Now) }; DbHelperSQL.ExecuteSql(sbsqlcontext.ToString(), parameters); #endregion #region 判断插入数据库是否成功 if (strRecordID != "") { InsertState = 0; } else { if (isConnection == "0") { ini.IniWriteValue("Connection", "isConnection", CommonMethod.ToDBC("1")); MessageBox.Show("本系统与服务器断开连接,请联系中心机房!", "天大天科", MessageBoxButtons. OK, MessageBoxIcon.Asterisk); Application.ExitThread(); Application.Exit(); } else { alSound.Alarm("该站的数据库异常"); MessageBox.Show("该站的数据库连接字符串配置异常", "天大天科", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); InsertState = 1; InsertBadReCordInfo("异常", strRoomName + "数据库异常"); } } #endregion } }
protected void InsertBadReCordInfo(string strAlarmType, string strDecript) { if (InsertState == 0) { #region 报警实体类 CoalTraffic.Model.TT_BadRecord modelBad = new CoalTraffic.Model.TT_BadRecord(); modelBad.AlarmType = strAlarmType; modelBad.BreakDate = DateTime.Now; modelBad.CarNo = txtCarNo.Text.Trim(); modelBad.CollCode = strCollCode; modelBad.Decript = strDecript; modelBad.NavicertCode = ""; modelBad.RecordID = Guid.NewGuid().ToString().Replace("-", ""); modelBad.RoomCode = strRoomCode; if (StaticParameter.IsVideo == "1") { if (byteFrontImage == null && byteBackImage == null && byteUpImage == null && byteRoomImage == null) { strFrontImage = Guid.NewGuid().ToString().Replace("-", ""); strBackImage = Guid.NewGuid().ToString().Replace("-", ""); strUpImage = Guid.NewGuid().ToString().Replace("-", ""); strRoomImage = Guid.NewGuid().ToString().Replace("-", ""); byteFrontImage = this.videoFrontImage.CapturePic(); byteBackImage = this.videoBackImage.CapturePic(); byteUpImage = this.videoUpImage.CapturePic(); byteRoomImage = this.videoRoomImage.CapturePic(); } modelBad.FrontImage = strFrontImage; modelBad.FrontImageContent = byteFrontImage; modelBad.RoomImage = strRoomImage; modelBad.RoomImageContent = byteRoomImage; modelBad.UpImage = strUpImage; modelBad.UpImageContent = byteUpImage; modelBad.BackImage = strBackImage; modelBad.BackImageContent = byteBackImage; } else { modelBad.FrontImage = ""; modelBad.FrontImageContent = null; modelBad.RoomImage = ""; modelBad.RoomImageContent = null; modelBad.UpImage = ""; modelBad.UpImageContent = null; modelBad.BackImage = ""; modelBad.BackImageContent = null; } #endregion #region 数据同步 //MSMQClient MC = new MSMQClient(); StringBuilder sbInsertBR = new StringBuilder(); sbInsertBR.Append("PT_BadRecord '" + modelBad.RecordID + "','" + modelBad.NavicertCode + "','" + modelBad.RoomCode + "','" + modelBad.CarNo + "','" + modelBad.Decript + "',"); sbInsertBR.Append("'" + modelBad.BreakDate + "','" + modelBad.AlarmType + "','" + modelBad.AlarmStatus + "','" + modelBad.CollCode + "','" + modelBad.FrontImage + "',"); sbInsertBR.Append("null,'" + modelBad.BackImage + "',null,'" + modelBad.UpImage + "',"); sbInsertBR.Append("null,'" + modelBad.RoomImage + "',null"); MC.AddNewSqlText(MC.ServerStation + MC.Prefix + "TT_BadRecord" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + sbInsertBR.ToString()); //发送图片 string strIsSendPicToRoom = StaticParameter.IsSendPicToRoom; int iSend = MC.ServerStation; string strPic = ""; if (modelBad.FrontImageContent != null) { strPic = iSend + MC.Prefix + "Sys_FileSave" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + modelBad.FrontImage + ",jpg," + Convert.ToBase64String(modelBad.FrontImageContent, 0, modelBad.FrontImageContent.Length); MC.AddNewSqlText(strPic); } if (modelBad.BackImageContent != null) { strPic = iSend + MC.Prefix + "Sys_FileSave" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + modelBad.BackImage + ",jpg," + Convert.ToBase64String(modelBad.BackImageContent, 0, modelBad.BackImageContent.Length); MC.AddNewSqlText(strPic); } if (modelBad.UpImageContent != null) { strPic = iSend + MC.Prefix + "Sys_FileSave" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + modelBad.UpImage + ",jpg," + Convert.ToBase64String(modelBad.UpImageContent, 0, modelBad.UpImageContent.Length); MC.AddNewSqlText(strPic); } if (modelBad.RoomImageContent != null) { strPic = iSend + MC.Prefix + "Sys_FileSave" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + modelBad.RoomImage + ",jpg," + Convert.ToBase64String(modelBad.RoomImageContent, 0, modelBad.RoomImageContent.Length); MC.AddNewSqlText(strPic); } #endregion string strRecordID = new CoalTraffic.BLL.TT_BadRecord().Add(modelBad); //添加违规记录成功,上传违规记录到服务器 if (strRecordID != "") { InsertState = 0; } else { alSound.Alarm("该站的数据库异常"); InsertState = 1; InsertBadReCordInfo("异常", strRoomName + "数据库异常"); } } }
protected void InsertBadReCordInfo(string strAlarmType, string strCarNo, string strDecript) { string isConnection = ini.IniReadValue("Connection", "isConnection"); if (InsertState == 0) { #region 报警实体类 CoalTraffic.Model.TT_BadRecord modelBad = new CoalTraffic.Model.TT_BadRecord(); modelBad.AlarmType = strAlarmType; modelBad.BreakDate = DateTime.Now; modelBad.CarNo = strCarNo; modelBad.CollCode = ""; modelBad.Decript = ""; modelBad.NavicertCode = strNavicertCode; modelBad.RecordID = Guid.NewGuid().ToString().Replace("-", ""); modelBad.RoomCode = strRoomCode; if (strIsVideo == "1") { modelBad.FrontImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.FrontImageContent = ((DHVideo)Form1.PF.Controls["videoFrontImage"]).CapturePic(); modelBad.RoomImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.RoomImageContent = ((DHVideo)Form1.PF.Controls["videoRoomImage"]).CapturePic(); modelBad.UpImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.UpImageContent = ((DHVideo)Form1.PF.Controls["videoUpImage"]).CapturePic(); modelBad.BackImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.BackImageContent = ((DHVideo)Form1.PF.Controls["videoBackImage"]).CapturePic(); } else { modelBad.FrontImage = ""; modelBad.FrontImageContent = null; modelBad.RoomImage = ""; modelBad.RoomImageContent = null; modelBad.UpImage = ""; modelBad.UpImageContent = null; modelBad.BackImage = ""; modelBad.BackImageContent = null; } #endregion #region 数据同步 //MSMQClient MC = new MSMQClient(); StringBuilder sbInsertBR = new StringBuilder(); sbInsertBR.Append("PT_BadRecord '" + modelBad.RecordID + "','" + modelBad.NavicertCode + "','" + modelBad.RoomCode + "','" + modelBad.CarNo + "','" + modelBad.Decript + "',"); sbInsertBR.Append("'" + modelBad.BreakDate + "','" + modelBad.AlarmType + "','" + modelBad.AlarmStatus + "','" + modelBad.CollCode + "','" + modelBad.FrontImage + "',"); sbInsertBR.Append("'" + modelBad.FrontImageContent + "','" + modelBad.BackImage + "','" + modelBad.BackImageContent + "','" + modelBad.UpImage + "',"); sbInsertBR.Append("'" + modelBad.UpImageContent + "','" + modelBad.RoomImage + "','" + modelBad.RoomImageContent + "'"); if (isConnection == "0") { mqServer.AddMsmq(sbInsertBR.ToString()); } else { MC.AddNewSqlText(sbInsertBR.ToString()); } #endregion string strRecordID = new CoalTraffic.BLL.TT_BadRecord().Add(modelBad); //添加违规记录成功,上传违规记录到服务器 if (strRecordID != "") { InsertState = 0; } else { if (isConnection == "0") { //ini.IniWriteValue("Connection", "isConnection", CommonMethod.ToDBC("1")); //MessageBox.Show("系统与服务器断开连接,请重新登陆系统!"); MessageBox.Show("系统与服务器断开连接,请联系中心机房!"); Application.ExitThread(); Application.Exit(); } else { alSound.Alarm("该站的数据库异常"); InsertBadReCordInfo("异常", "", ini.IniReadValue("RoomSetting", "RoomName") + "的数据库异常"); InsertState = 0; } } } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public CoalTraffic.Model.TT_BadRecord GetModel(string RecordID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 RecordID,NavicertCode,RoomCode,CarNo,Decript,BreakDate,AlarmType,AlarmStatus,CollCode,FrontImage,BackImage,UpImage,RoomImage from TT_BadRecord "); strSql.Append(" where RecordID=@RecordID "); SqlParameter[] parameters = { new SqlParameter("@RecordID", SqlDbType.VarChar,50)}; parameters[0].Value = RecordID; CoalTraffic.Model.TT_BadRecord model = new CoalTraffic.Model.TT_BadRecord(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { model.RecordID=ds.Tables[0].Rows[0]["RecordID"].ToString(); model.NavicertCode=ds.Tables[0].Rows[0]["NavicertCode"].ToString(); model.RoomCode=ds.Tables[0].Rows[0]["RoomCode"].ToString(); model.CarNo=ds.Tables[0].Rows[0]["CarNo"].ToString(); model.Decript=ds.Tables[0].Rows[0]["Decript"].ToString(); if(ds.Tables[0].Rows[0]["BreakDate"].ToString()!="") { model.BreakDate=DateTime.Parse(ds.Tables[0].Rows[0]["BreakDate"].ToString()); } model.AlarmType=ds.Tables[0].Rows[0]["AlarmType"].ToString(); model.AlarmStatus=ds.Tables[0].Rows[0]["AlarmStatus"].ToString(); model.CollCode=ds.Tables[0].Rows[0]["CollCode"].ToString(); model.FrontImage=ds.Tables[0].Rows[0]["FrontImage"].ToString(); model.BackImage=ds.Tables[0].Rows[0]["BackImage"].ToString(); model.UpImage=ds.Tables[0].Rows[0]["UpImage"].ToString(); model.RoomImage=ds.Tables[0].Rows[0]["RoomImage"].ToString(); return model; } else { return null; } }
protected void InsertBadReCordInfo(string strAlarmType, string strCarNo, string strDecript) { if (InsertState == 0) { #region ����ʵ���� CoalTraffic.Model.TT_BadRecord modelBad = new CoalTraffic.Model.TT_BadRecord(); modelBad.AlarmType = strAlarmType; modelBad.BreakDate = DateTime.Now; modelBad.CarNo = strCarNo; modelBad.CollCode = strCollCode; modelBad.Decript = strDecript; modelBad.NavicertCode = strNavicertCode; modelBad.RecordID = Guid.NewGuid().ToString().Replace("-", ""); modelBad.RoomCode = strRoomCode; if (strIsVideo == "1") { modelBad.FrontImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.FrontImageContent = ((DHVideo)Form1.PF.Controls["videoFrontImage"]).CapturePic(); modelBad.RoomImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.RoomImageContent = ((DHVideo)Form1.PF.Controls["videoRoomImage"]).CapturePic(); modelBad.UpImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.UpImageContent = ((DHVideo)Form1.PF.Controls["videoUpImage"]).CapturePic(); modelBad.BackImage = Guid.NewGuid().ToString().Replace("-", ""); modelBad.BackImageContent = ((DHVideo)Form1.PF.Controls["videoBackImage"]).CapturePic(); } else { modelBad.FrontImage = ""; modelBad.FrontImageContent = null; modelBad.RoomImage = ""; modelBad.RoomImageContent = null; modelBad.UpImage = ""; modelBad.UpImageContent = null; modelBad.BackImage = ""; modelBad.BackImageContent = null; } #endregion #region ����ͬ�� //MSMQClient MC = new MSMQClient(); StringBuilder sbInsertBR = new StringBuilder(); sbInsertBR.Append("PT_BadRecord '" + modelBad.RecordID + "','" + modelBad.NavicertCode + "','" + modelBad.RoomCode + "','" + modelBad.CarNo + "','" + modelBad.Decript + "',"); sbInsertBR.Append("'" + modelBad.BreakDate + "','" + modelBad.AlarmType + "','" + modelBad.AlarmStatus + "','" + modelBad.CollCode + "','" + modelBad.FrontImage + "',"); sbInsertBR.Append("'" + modelBad.FrontImageContent + "','" + modelBad.BackImage + "','" + modelBad.BackImageContent + "','" + modelBad.UpImage + "',"); sbInsertBR.Append("'" + modelBad.UpImageContent + "','" + modelBad.RoomImage + "','" + modelBad.RoomImageContent + "'"); MC.AddNewSqlText(MC.ServerStation + MC.Prefix + "TT_BadRecord" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + sbInsertBR.ToString()); #endregion string strRecordID = new CoalTraffic.BLL.TT_BadRecord().Add(modelBad); //���Υ���¼�ɹ����ϴ�Υ���¼�������� if (strRecordID != "") { InsertState = 0; } else { alarmSound.Alarm("��վ�����ݿ��쳣"); InsertBadReCordInfo("�쳣", "", strRoomName + "�����ݿ��쳣"); InsertState = 0; } } }