/*****************************************************************
*从数据库读取车辆报站数据
*以一辆车的buscode为一次读取索引
*
*变量解释：
* filepath buscode存储文件对应路径
* Buscode 存储buscode
* filenamebusadtime 每个buscode所对应的报站数据的存储文件名
* adflagA A站的出入站布尔值，0代表进站，1代表出站
* adflagB B站的出入站布尔值，0代表进站，1代表出站
* busstopnumA A站的站台对应序号（在Bus_Stop.txt）
* busstopnumB B站的站台对应序号（在Bus_Stop.txt）
* begin BusAD_i.txt的首行预留
* 预防首条报站数据出错的情况
* routecode 存储线路编码
* busstopnum 存储站台编码
* adflag 存储出入站的布尔值
* service 存储车辆运行方向
* adtime 存储报站时间数据
* str 报站数据记录格式
******************************************************************/
private void ADTime_Click(object sender, EventArgs e)
{
string filepath = "Buscode_0507.txt";
List <string> Buscode = IOTool.ReadText(filepath);
for (int i = 0; i < Buscode.Count; i++)
{
int j = i;//第几个buscode，从0开始
string filenamebusadtime = "BusAD_" + j + "_" + Buscode[i] + ".txt";
string getSQL = string.Empty;
getSQL += "select * from BUSADINFO2013100822 t where LENGTH(BUSSTOPNUM) <> 0 and BUSCODE ='";
getSQL += Buscode[i] + "'order by adtime";
DataSet ds = ado163.ExecuteGet(getSQL, "BUSADINFO2013101622_COPY");//读入数据库内容存入缓存
if (ds != null)
{
int m = 0;//BusAD的第几条记录,从1开始
int adflagA = 0, adflagB;
int busstopnumA = 1, busstopnumB;
string begin = "00000" + " " + "0" + " " + "0" + " " + "0000/00/00 00:00:00";
IOTool.WriteFile(filenamebusadtime, begin); //保留首行，预防首条报站数据出错的情况
foreach (DataRow dr in ds.Tables[0].Rows) //遍历该表中的每一行
{
string routecode = Convert.ToString(dr["ROUTECODE"]); //内容对应转换
int busstopnum = Convert.ToInt32(dr["BUSSTOPNUM"]);
int adflag = Convert.ToInt32(dr["ADFLAGNUM"]);
string service = Convert.ToString(dr["SERVICE"]);
DateTime adtime = Convert.ToDateTime(dr["ADTIME"]);
string str = routecode + " " + busstopnum + " " + adflag + " " + adtime + " " + service;
/********************************************************************************************************
*报站数据的筛选和整理
*
*选择有出入站匹配的数据记录
* 即某站必须有进站和出站数据才记录，缺一不可
*
*对同一时间段重复出入站数据筛选
*多条进站取第一条进站数据
*多条出站取最后一条出站数据
*
*分为十种情况，逐条筛选
*
* 1、确保数据的第一条是正确且有效数据
*逐条读取，直到读取到第一个进站数据
*
* 2、进出站连续（adflagB != adflagA）
* A进A出 A站停靠时间
* B进B出 B站停靠时间
* A出B进 AB站间运行时间
* A进B出 无效数据，需排除
*
*
*变量解释：
* busadm 重新读取报站文件，取得m值
* busadterror 当上一条数据出错需要删除的时候
* 重新读取报站数据并存入
* errorline 需删除数据的行数值
* busadreread 重置adflagA、busstopnumA的时候
* 重新读取删除后的报站数据
* rereadlastline 重新读取删除后的报站数据的最后一行内容
* busadtime 在写入前读取报站数据
* 重新读取报站数据并存入
* adcheck 需要对比的报站数据（判断记录是否重复）
* wstr 需要写入的报站数据记录
* lastline 计算时读取的上一条报站数据
* lastad 上一条报站数据时间（字符串格式）
* ladtime 上一条报站数据时间（DateTime格式）
* lservice 上一条报站数据方向
********************************************************************************************************/
if (m == 0) //确保数据的第一条是正确且有效数据，逐条读取，直到读取到第一个进站数据
{
if (adflag == 0) //第一条记录是进站记录
{
IOTool.WriteFile(filenamebusadtime, str);
List <string> busadm = IOTool.ReadText(filenamebusadtime);
m = busadm.Count - 1;
adflagA = adflag;
busstopnumA = busstopnum;
}
else//如果是出站，则忽略读取下一条，
{
m = 0;
continue;//回到Line72
}
}
else//不是第一条记录的情况下
{
adflagB = adflag;
busstopnumB = busstopnum;
if (adflagB != adflagA) //进出站连续的情况
{
if (adflagB == 1 && busstopnumB != busstopnumA) //排除A进B出的情况，处理是删掉A，不记录B
{
List <string> busadterror = IOTool.ReadText(filenamebusadtime);
string errorline = Convert.ToString(busadterror.Count - 1);
IOTool.DeleteLine(filenamebusadtime, errorline);
List <string> busadm = IOTool.ReadText(filenamebusadtime);
m = busadm.Count - 1;
if (m == 0)//如果是只有一条记录，删除了回到m=0
{
m = 0;
continue;//回到Line72
}
List <string> busadreread = IOTool.ReadText(filenamebusadtime);//重新读取adflagA和busstopnumA
string[] rereadlastline = busadreread[busadreread.Count - 1].Split(' ');
busstopnumA = Convert.ToInt32(rereadlastline[1]);
adflagA = Convert.ToInt32(rereadlastline[2]);
continue;//回到Line72
}
else//剩余3种情况，A进A出，B进B出，A出B进，非错误记录，判断是否重复，记录
{
/*************写入数据段******************/
List <string> busadtime = IOTool.ReadText(filenamebusadtime);
bool bp = true;
for (int k = 0; k < busadtime.Count; k++)
{
string[] adcheck = busadtime[k].Split(' ');
string[] wstr = str.Split(' ');
if (adcheck[4].Equals(wstr[4]) && adcheck[3].Equals(wstr[3]))//时间判断是否重复
{
bp = false;
break;
}
}
if (bp == true) //不重复记录
{
adflagA = adflagB; //更新判断标志
busstopnumA = busstopnumB;
IOTool.WriteFile(filenamebusadtime, str);
List <string> busadm = IOTool.ReadText(filenamebusadtime);
m = busadm.Count - 1;
string buscode = Buscode[i];
Calculation.Calculate(filenamebusadtime, m, str, buscode);
continue;
}
/******************************************************************/
}
}
else//连续进站或者连续出站
{
if (busstopnumB == busstopnumA)//A进A进、A出A出、B进B进、B出B出
{
if (adflagB == 1)//情况A出A出，B出B出，取后者，删前一记录，记录后一数据
{
List <string> busadterror = IOTool.ReadText(filenamebusadtime);
string errorline = Convert.ToString(busadterror.Count - 1);
IOTool.DeleteLine(filenamebusadtime, errorline);
List <string> busadtime = IOTool.ReadText(filenamebusadtime);
bool bp = true;
for (int k = 0; k < busadtime.Count; k++)
{
string[] adcheck = busadtime[k].Split(' ');
string[] wstr = str.Split(' ');
if (adcheck[4].Equals(wstr[4]) && adcheck[3].Equals(wstr[3]))//如果已记录，则不再记录，若无，则记录
{
bp = false;
break;
}
}
if (bp == true)
{
adflagA = adflagB;
busstopnumA = busstopnumB;
IOTool.WriteFile(filenamebusadtime, str);
List <string> busadm = IOTool.ReadText(filenamebusadtime);
m = busadm.Count - 1;
string buscode = Buscode[i];
Calculation.Calculate(filenamebusadtime, m, str, buscode);
continue;
}
}
else //A进A进、B进B进,不记录
{
continue;
}
}
else //A进B进、A出B出
{
if (adflagB == 0 && busstopnumB != busstopnumA)//排除A进B进，删A进，留B进
{
List <string> busadterror = IOTool.ReadText(filenamebusadtime);
string errorline = Convert.ToString(busadterror.Count - 1);
IOTool.DeleteLine(filenamebusadtime, errorline);
adflagA = adflagB;
busstopnumA = busstopnumB;
List <string> busadtime = IOTool.ReadText(filenamebusadtime);
bool bp = true;
for (int k = 0; k < busadtime.Count; k++)
{
string[] adcheck = busadtime[k].Split(' ');
string[] wstr = str.Split(' ');
if (adcheck[4].Equals(wstr[4]) && adcheck[3].Equals(wstr[3]))//如果已记录，则不再记录，若无，则记录
{
bp = false;
break;
}
}
if (bp == true)
{
IOTool.WriteFile(filenamebusadtime, str);
List <string> busadm = IOTool.ReadText(filenamebusadtime);
m = busadm.Count - 1;
string buscode = Buscode[i];
Calculation.Calculate(filenamebusadtime, m, str, buscode);
continue;
}
}
else
{
continue;//A出B出，不记录B出
}
}
}
}
}
}
}
MessageBox.Show("OK!");
}
public static void Calculate(string filenamebusadtime, int m, string str, string buscode)
{
/****************计算数据段**************************/
if (m > 1)
{
List <string> busadreread = IOTool.ReadText(filenamebusadtime);
string lstline = busadreread[busadreread.Count - 2];
string[] lastline = busadreread[busadreread.Count - 2].Split(' ');
string lastad = lastline[3] + " " + lastline[4];
DateTime ladtime = Convert.ToDateTime(lastad);
string lservice = Convert.ToString(lastline[5]);
int lstopnum = Convert.ToInt32(lastline[1]);
int ladflag = Convert.ToInt32(lastline[2]);
string[] adcontent = busadreread[busadreread.Count - 1].Split(' ');
string contentad = adcontent[3] + " " + adcontent[4];
DateTime cadtime = Convert.ToDateTime(contentad);
string cservice = Convert.ToString(adcontent[5]);
int cstopnum = Convert.ToInt32(adcontent[1]);
int cadflag = Convert.ToInt32(adcontent[2]);
TimeSpan DeltaT = cadtime - ladtime;
int DeltaStop = Math.Abs(lstopnum - cstopnum);
if (lservice.Equals(cservice) && adcontent[0].Equals(lastline[0]))//判断是否同向且是否同线路，如果不同向，则两个数据无法计算
{
/*****************全数据分析*************************************/
if (DeltaStop == 0 && ladflag < cadflag && DeltaT.TotalSeconds < 700)//A进A出、B进B出的情况
{
string filenamewt = "Stopwaittime_" + lastline[1] + "_" + cservice + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
else if (DeltaStop == 1 && DeltaT.TotalSeconds < 1000)
{
string filename3 = "Stopruntime_" + lastline[1] + "_" + cstopnum + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filename3, strd);
}
/****************************************************************/
/*****************时间段分析*************************************/
if (DeltaStop == 0 && ladflag < cadflag && DeltaT.TotalSeconds < 700)//A进A出、B进B出的情况
{
if (cadtime.Hour > 6 && cadtime.Hour < 9)
{
string filenamewt = "Stopwaittime_" + "time_" + "7-9am_" + lastline[1] + "_" + cservice + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
else if (cadtime.Hour > 16 && cadtime.Hour < 19)
{
string filenamewt = "Stopwaittime_" + "time_" + "5-7pm_" + lastline[1] + "_" + cservice + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
else
{
string filenamewt = "Stopwaittime_" + "time_" + "other_" + lastline[1] + "_" + cservice + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
}
else if (DeltaStop == 1 && ladflag > cadflag && DeltaT.TotalSeconds < 1000)
{
if (cadtime.Hour > 6 && cadtime.Hour < 9)
{
string filenamewt = "Stopruntime_" + "time_" + "7-9am_" + lastline[1] + "_" + cstopnum + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
else if (cadtime.Hour > 16 && cadtime.Hour < 19)
{
string filenamewt = "Stopruntime_" + "time_" + "5-7pm_" + lastline[1] + "_" + cstopnum + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
else
{
string filenamewt = "Stopruntime_" + "time_" + "other_" + lastline[1] + "_" + cstopnum + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
}
/****************************************************************/
/*****************线路分析***************************************/
if (DeltaStop == 0 && ladflag < cadflag && DeltaT.TotalSeconds < 700)//A进A出、B进B出的情况
{
string filenamewt = "Stopwaittime_" + "route_" + adcontent[0] + "_" + lastline[1] + "_" + cservice + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
else if (DeltaStop == 1 && DeltaT.TotalSeconds < 1000)
{
string filename3 = "Stopruntime_" + "route_" + adcontent[0] + "_" + lastline[1] + "_" + cstopnum + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filename3, strd);
}
/****************************************************************/
/*****************线路时间分析***************************************/
if (DeltaStop == 0 && ladflag < cadflag && DeltaT.TotalSeconds < 700)//A进A出、B进B出的情况
{
if (cadtime.Hour > 6 && cadtime.Hour < 9)
{
string filenamewt = "Stopwaittime_" + "route_" + adcontent[0] + "_time_" + "7-9am_" + lastline[1] + "_" + cservice + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
else if (cadtime.Hour > 16 && cadtime.Hour < 19)
{
string filenamewt = "Stopwaittime_" + "route_" + adcontent[0] + "_time_" + "5-7pm_" + lastline[1] + "_" + cservice + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
else
{
string filenamewt = "Stopwaittime_" + "route_" + adcontent[0] + "_time_" + "other_" + lastline[1] + "_" + cservice + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
}
else if (DeltaStop == 1 && DeltaT.TotalSeconds < 1000)
{
if (cadtime.Hour > 6 && cadtime.Hour < 9)
{
string filenamewt = "Stopruntime_" + "route_" + adcontent[0] + "_time_" + "7-9am_" + lastline[1] + "_" + cstopnum + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
else if (cadtime.Hour > 16 && cadtime.Hour < 19)
{
string filenamewt = "Stopruntime_" + "route_" + adcontent[0] + "_time_" + "5-7pm_" + lastline[1] + "_" + cstopnum + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
else
{
string filenamewt = "Stopruntime_" + "route_" + adcontent[0] + "_time_" + "other_" + lastline[1] + "_" + cstopnum + ".txt";
string strd = adcontent[0] + " " + lastline[1] + "," + cstopnum + " " + lastline[2] + cadflag + " " + DeltaT.TotalSeconds + " " + lstline + " " + str + " " + buscode;//记录的格式，转换为字符串，可以再加个cservice
IOTool.WriteFile(filenamewt, strd);
}
}
/****************************************************************/
}
}
/******************************************************************/
}