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++;
}
