private void listener_ReceiveHandler(object sender, ReceiveEventArg e) { Record record = e.record; string verify = ConvertObject.IOMode(record.Verify); string action = ConvertObject.GLogType(record.Action); ListViewItem lvi = new ListViewItem(new string[] { no.ToString(), record.DN.ToString(), record.DIN.ToString(), string.Empty, verify, action, record.Clock.ToString("yyyy-MM-dd HH:mm:ss") }); BeginInvoke(new AddRecord(AddRecordToListView), new object[] { lvi }); no++; }
private void listener_ReceiveHandler(object sender, ReceiveEventArg e) { Record record = e.record; var logInfo = DeviceAccessLogMapper.ToModel(record); var deviceAccessEvent = new DeviceTrafficEvent() { DeviceTrafficLog = logInfo }; var message = DataContractSerializationHelper.Serialize(deviceAccessEvent); Log.Info(message); //var logInfo2 = DeviceAdminLogMapper.ToModel(record); //var message2 = DataContractSerializationHelper.Serialize(logInfo2); //Log.Info(message2); ReportMessage(message); }
private void OnReceiveEvent(object sender, ReceiveEventArg eventArg) { if (chatRichTextBox.InvokeRequired) { chatRichTextBox.BeginInvoke(new EventHandler <ReceiveEventArg>(OnReceiveEvent), new object[] { sender, eventArg }); return; } this.chatRichTextBox.SelectionStart = this.chatRichTextBox.Text.Length; this.chatRichTextBox.SelectionLength = 0; this.chatRichTextBox.SelectionColor = Color.Lime; this.chatRichTextBox.AppendText(string.Format("({0})接收: ", DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒ffff"))); this.chatRichTextBox.SelectionFont = new Font("Tahoma", 12, FontStyle.Regular); this.chatRichTextBox.AppendText(eventArg.xml.Replace("><", ">\r\n<")); this.chatRichTextBox.AppendText("\r\n"); this.chatRichTextBox.Refresh(); }
private void listener_ReceiveHandler(object sender, ReceiveEventArg e) { Record record = e.record; string verify = ConvertObject.IOMode(record.Verify); string action = ConvertObject.GLogType(record.Action); ListViewItem lvi = new ListViewItem(new string[] { no.ToString(), record.DN.ToString(), record.DIN.ToString(), string.Empty, verify, action, record.Clock.ToString("yyyy-MM-dd HH:mm:ss") }); string sql = "insert into dbo.DeviceOriginalData(UserID,DeviceID,DateTime,Verify,Action,Remark,MDIN,DoorStatus,JobCode,Antipassback) " + "values(@UserID,@DeviceID,@DateTime,@Verify,@Action,@Remark,@MDIN,@DoorStatus,@JobCode,@Antipassback)"; SqlConnection connection = new SqlConnection(conn); SqlCommand command = new SqlCommand(sql, connection); connection.Open(); command.Parameters.Add(new SqlParameter("@UserID", record.DIN.ToString())); command.Parameters.Add(new SqlParameter("@DeviceID", record.DN)); command.Parameters.Add(new SqlParameter("@DateTime", record.Clock.ToString("yyyy-MM-dd HH:mm:ss"))); command.Parameters.Add(new SqlParameter("@Verify", record.Verify)); command.Parameters.Add(new SqlParameter("@Action", record.Action)); command.Parameters.Add(new SqlParameter("@Remark", record.Remark)); command.Parameters.Add(new SqlParameter("@MDIN", record.MDIN.ToString())); command.Parameters.Add(new SqlParameter("@DoorStatus", record.DoorStatus)); command.Parameters.Add(new SqlParameter("@JobCode", record.JobCode)); command.Parameters.Add(new SqlParameter("@Antipassback", record.Antipassback)); command.ExecuteNonQuery(); connection.Close(); string sql1 = "select * from dbo.Staffs where PhysicalCardNumber='" + record.DIN.ToString() + "'";// + record.DIN.ToString(); // connection.Open(); SqlConnection connection1 = new SqlConnection(conn); connection1.Open(); SqlCommand command1 = new SqlCommand(sql1, connection1); SqlDataReader dataReader = command1.ExecuteReader(); string staffNumber = null; if (dataReader.Read()) { staffNumber = dataReader["StaffNumber"].ToString(); } else { return; } SqlConnection sdb = new SqlConnection("Data Source = 211.149.199.42,1433;Initial Catalog = BonsaiiSystem;User ID = sa;Password = admin123@;");//连接平台数据库 string conn1 = "Data Source = 211.149.199.42,1433;User ID = sa;Password = admin123@;Initial Catalog = Bonsaii0000000008;"; string sql2 = "select * from dbo.BindCodes where ConnectionString='" + conn1 + "' and StaffNumber='" + staffNumber + "'"; dataReader.Close(); connection1.Close(); sdb.Open(); SqlCommand command2 = new SqlCommand(sql2, sdb); SqlDataReader dataReader1 = command2.ExecuteReader(); if (dataReader1.Read()) { JPushClient client = new JPushClient(app_key, master_secret); // PushPayload payload = PushObject_all_alias_alert(dataReader1["Phone"].ToString(), record.Clock.ToString("yyyy-MM-dd HH:mm:ss"));//选择一种方式 PushPayload pushPayload = new PushPayload(); pushPayload.platform = Platform.android(); pushPayload.audience = Audience.s_alias(dataReader1["Phone"].ToString()); pushPayload.message = cn.jpush.api.push.mode.Message.content("hello").AddExtras("Tag", "2").AddExtras("ComapnyTag", "3"); pushPayload.notification = Notification.android("打卡完成!", "在" + record.Clock.ToString("yyyy-MM-dd HH:mm:ss")); try { var result = client.SendPush(pushPayload);//推送 } catch (APIRequestException eee) { Console.WriteLine("Error response from JPush server. Should review and fix it. "); Console.WriteLine("HTTP Status: " + eee.Status); Console.WriteLine("Error Code: " + eee.ErrorCode); Console.WriteLine("Error Message: " + eee.ErrorCode); } catch (APIConnectionException ee) { Console.WriteLine(ee.Message); } } dataReader1.Close(); sdb.Close(); //connection.Close(); BeginInvoke(new AddRecord(AddRecordToListView), new object[] { lvi }); no++; }