/// <summary> /// 设备统计 - 自定义区域接口 /// </summary> private void CustomAreaData() { OtherLabelModel otherLabelModel = HttpHelper.HttpYiSuoGet <OtherLabelModel>("http://14.29.73.91:8080/statisticsServer/getOtherLabel"); DataTable table = new DataTable(); table.TableName = "视综_自定义区域"; table.Columns.Add("Id", typeof(Int32)); table.Columns.Add("Code", typeof(string)); table.Columns.Add("Name", typeof(string)); table.Columns.Add("Time", typeof(DateTime)); for (int index = 0; index < otherLabelModel.data.Count; index++) { OtherLabelData data = otherLabelModel.data[index]; DataRow row = table.NewRow(); row["Id"] = index; row["Code"] = data.code; row["Name"] = data.name; 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); }