public static void Ticket(int sessionId, string gameName)
{
LogManager.WriteLog("购买数据开始处理");
try
{
string sql = "SELECT * FROM white_names where session_id = '" + sessionId + "' and isupload = 0 ";
DataTable dataTable = MySqlDBHelper.ExecuteDataTable(PoliceDataFactory.entranceCon, sql);
bool flag = dataTable.Rows.Count > 0;
if (flag)
{
LogManager.WriteLog("本次上次购买数据数量为" + dataTable.Rows.Count + "条");
Ticket ticket = new Ticket
{
verification = verification,
dataVoList = new List <TicketInfo>()
};
foreach (object obj in dataTable.Rows)
{
DataRow item = (DataRow)obj;
ticket.dataVoList.Add(new TicketInfo
{
activityId = gameName,
purchaserName = item["buy_name"].ToString(),
purchaserIdCardNo = item["id_no"].ToString(),
purchaserTel = item["purchaser_tel"].ToString(),
purchaserSeatNo = string.Concat(new string[]
{
item["area"].ToString(),
item["row"].ToString(),
"排",
item["seat"].ToString(),
"号"
}),
ticketNo = item["ticket_no"].ToString()
});
}
string url = URL + "/api/ticket";
string ticketdata = JsonConvert.SerializeObject(ticket);
LogManager.WriteLog("购买上传数据：" + ticketdata);
string msg = PoliceDataFactory.HttpPost(url, ticketdata, null);
LogManager.WriteLog("购买数据上传完成");
LogManager.WriteLog("购买数据上传返回结果：" + msg);
LogManager.WriteLog("更新上传数据状态");
string updatesql = "update white_names set isupload=1 where session_id = '" + sessionId + "'";
MySqlDBHelper.ExecuteNonQuery(PoliceDataFactory.entranceCon, CommandType.Text, updatesql);
}
else
{
LogManager.WriteLog("无购买数据上传");
}
}
catch (Exception ex)
{
LogManager.WriteLog("购买数据上传异常" + ex.Message);
}
}
/// <summary>
/// 检票数据上传
/// </summary>
public static void Entrance(int sessionId, string gameName)
{
LogManager.WriteLog("检票数据开始上传");
try
{
string sql = "SELECT DISTINCT s.session_id,s.tel_no,s.tel_area,s.ticket_no,s.id_no, s.buy_name,s.create_date from in_sessions s where session_id = '" + sessionId + "' and isupload = 0";
DataTable dataTable = MySqlDBHelper.ExecuteDataTable(entranceCon, sql);
Entrance entrance = new Entrance()
{
verification = verification, dataVoList = new List <EntranceInfo>()
};
foreach (DataRow item in dataTable.Rows)
{
entrance.dataVoList.Add(new EntranceInfo()
{
activityId = serverGameName,
entranceCode = item["tel_no"].ToString(),
entranceName = item["tel_area"].ToString(),
ticketNumber = 1,
certificationNumber = 0,
ticketNo = item["ticket_no"].ToString(),
ticketHolderIdCardNo = item["id_no"].ToString(),
ticketHolderName = item["buy_name"].ToString(),
entranceFacePic = "",
abnormalNumber = 0,
entranceTime = Convert.ToDateTime(item["create_date"].ToString())
});
}
string url = URL + "/api/entrance";
string ticketdata = Newtonsoft.Json.JsonConvert.SerializeObject(entrance);
LogManager.WriteLog("检票上传数据：" + ticketdata);
string msg = PoliceDataFactory.HttpPost(url, ticketdata, null);
LogManager.WriteLog("检票数据上传完成");
LogManager.WriteLog("检票数据上传返回结果：" + msg);
LogManager.WriteLog("更新上传数据状态");
string updatesql = "update in_sessions set isupload=1 where session_id = '" + sessionId + "'";
MySqlDBHelper.ExecuteNonQuery(PoliceDataFactory.entranceCon, CommandType.Text, updatesql);
}
catch (Exception ex)
{
LogManager.WriteLog("检票数据上传异常" + ex.Message);
}
}
/// <summary>
/// 告警数据上传
/// </summary>
public static void InspectTicket(int sessionId, string gameName)
{
LogManager.WriteLog("告警数据开始上传");
try
{
string sql = "SELECT id,session_id,buy_name,id_no,id_card_photo,year_ticket_photo,address,status,remark from black_names where session_id = '" + sessionId + "' and isupload = 0";
DataTable dataTable = MySqlDBHelper.ExecuteDataTable(entranceCon, sql);
InspectTicket inspectTicket = new InspectTicket()
{
verification = verification, dataVoList = new List <InspectTicketInfo>()
};
foreach (DataRow item in dataTable.Rows)
{
inspectTicket.dataVoList.Add(new InspectTicketInfo()
{
taskId = serverGameName,
warningTime = DateTime.Now,
warningPosition = IrAdvanced.ReadString("TelArea"),
ticketWarningType = 1,
ticketNo = item["id"].ToString(),
ticketHolderIdCardNo = item["id_no"].ToString(),
ticketHolderName = item["buy_name"].ToString(),
entranceFacePic = item["remark"].ToString()
});
}
string url = URL + "/api/inspectTicket";
string data = JsonConvert.SerializeObject(inspectTicket);
LogManager.WriteLog("告警上传数据：" + data);
string msg = PoliceDataFactory.HttpPost(url, data, null);
LogManager.WriteLog("告警数据上传完成");
LogManager.WriteLog("告警数据上传返回结果：" + msg);
LogManager.WriteLog("更新上传数据状态");
string updatesql = "update black_names set isupload=1 where session_id = '" + sessionId + "'";
MySqlDBHelper.ExecuteNonQuery(PoliceDataFactory.entranceCon, CommandType.Text, updatesql);
}
catch (Exception ex)
{
LogManager.WriteLog("检票数据上传异常" + ex.Message);
}
}