/// <summary>
/// 设备统计
/// </summary>
private void DeviceFlowData()
{
DataTable table = new DataTable();
table.TableName = "视综_设备统计";
table.Columns.Add("Id", typeof(Int32));
table.Columns.Add("Active", typeof(Int32));
table.Columns.Add("FaceActive", typeof(Int32));
table.Columns.Add("CarActive", typeof(Int32));
table.Columns.Add("Regist", typeof(Int32));
table.Columns.Add("FaceRegist", typeof(Int32));
table.Columns.Add("CarRegist", typeof(Int32));
table.Columns.Add("Time", typeof(DateTime));
OtherLabelModel otherLabelModel = HttpHelper.HttpYiSuoGet <OtherLabelModel>("http://14.29.73.91:8080/statisticsServer/getOtherLabel");
int faceRegist = 0;
int carRegist = 0;
int faceActive = 0;
int carActive = 0;
foreach (OtherLabelData item in otherLabelModel.data)
{
//人
string urlPath = "http://14.29.73.91:8080/statisticsServer/getDeviceFlowInfo?TYPE=2&FCTYPE=1&CODE=" + item.code;
DeviceFlowModel persionModel = HttpHelper.HttpYiSuoGet <DeviceFlowModel>(urlPath);
foreach (DeviceFlowData person in persionModel.data)
{
faceRegist += Convert.ToInt32(person.libNum);
faceActive += Convert.ToInt32(person.activeNum);
}
//车
urlPath = "http://14.29.73.91:8080/statisticsServer/getDeviceFlowInfo?TYPE=2&FCTYPE=2&CODE=" + item.code;
DeviceFlowModel carModel = HttpHelper.HttpYiSuoGet <DeviceFlowModel>(urlPath);
foreach (DeviceFlowData car in carModel.data)
{
carRegist += Convert.ToInt32(car.libNum);
carActive += Convert.ToInt32(car.activeNum);
}
}
DataRow row = table.NewRow();
row["Id"] = 1;
row["FaceActive"] = faceActive;
row["CarActive"] = carActive;
row["FaceRegist"] = faceRegist;
row["CarRegist"] = carRegist;
row["Active"] = faceActive + carActive;
row["Regist"] = faceRegist + carRegist;
row["Time"] = DateTime.Now;
table.Rows.Add(row);
DataHelper.SaveCsv(table);
}
/// <summary>
/// 公安网分局
/// </summary>
private void PoliceNetSubPoliceData()
{
DataTable table = new DataTable();
table.TableName = "视综_公安网分局";
table.Columns.Add("Id", typeof(Int32));
table.Columns.Add("Name", typeof(string));
table.Columns.Add("People", typeof(Int32));
table.Columns.Add("Car", typeof(Int32));
table.Columns.Add("Time", typeof(DateTime));
OtherLabelModel otherLabelModel = HttpHelper.HttpYiSuoGet <OtherLabelModel>("http://14.29.73.91:8080/statisticsServer/getOtherLabel");
Dictionary <string, string[]> dic = new Dictionary <string, string[]>();
int carRegist = 0;
foreach (OtherLabelData item in otherLabelModel.data)
{
//人
DeviceFlowModel personModel = HttpHelper.HttpYiSuoGet <DeviceFlowModel>("http://14.29.73.91:8080/statisticsServer/getDeviceFlowInfo?TYPE=2&FCTYPE=1&CODE=" + item.code);
//车
DeviceFlowModel carModel = HttpHelper.HttpYiSuoGet <DeviceFlowModel>("http://14.29.73.91:8080/statisticsServer/getDeviceFlowInfo?TYPE=2&FCTYPE=2&CODE=" + item.code);
//如果是北京市
if (item.code == "110100")
{
for (int i = 0; i < personModel.data.Count; i++)
{
if (personModel.data[i].name == "房山区" || personModel.data[i].name == "密云区" || personModel.data[i].name == "西站")
{
string[] temp = { personModel.data[i].libNum, "" };
dic.Add(personModel.data[i].name, temp);
}
}
foreach (DeviceFlowData car in carModel.data)
{
if (dic.ContainsKey(car.name))
{
dic[car.name][1] = car.libNum;
}
}
}
//如果是交管局
else if (item.code == "110200")
{
foreach (DeviceFlowData car in carModel.data)
{
carRegist += Convert.ToInt32(car.libNum);
}
string[] temp = { null, carRegist.ToString() };
dic.Add("交管局", temp);
}
//如果是检查站
else if (item.code == "110300")
{
foreach (DeviceFlowData car in carModel.data)
{
carRegist += Convert.ToInt32(car.libNum);
}
string[] temp = { null, carRegist.ToString() };
dic.Add("检查站", temp);
}
}
int index = 1;
foreach (var key in dic.Keys)
{
DataRow row = table.NewRow();
row["Id"] = index;
row["Name"] = key;
row["People"] = dic[key][0] != null?Convert.ToInt32(dic[key][0]) : 0;
row["Car"] = dic[key][1] != null?Convert.ToInt32(dic[key][1]) : 0;
row["Time"] = DateTime.Now;
table.Rows.Add(row);
index++;
}
DataHelper.SaveCsv(table);
}
