private string InsertCarTrafficViolation(ViolationModel model)
{
SqlHelper helper = new SqlHelper();
int isSucc = helper.ExecuteNonQuery("P_TrafficViolation_I", model.CarNumber, model.ViolationAddress, model.ViolationDateTime, model.ViolationAmount, model.ViolationScore, model.ViolationContent, model.ViolationStatus);
return isSucc.ToString();
}
public void GetAllCompleted(SCParams scParams, ref List<ViolationModel> listCompleted)
{
HTTPHelper httpHelper = new HTTPHelper();
ViolationModel model = new ViolationModel();
string currentCarP = HttpUtility.UrlEncode(scParams.CarNumber).ToUpper();
string urlCompleted = string.Format(CompletedAddress, currentCarP, scParams.CarFrame);
string pageContentCompleted = httpHelper.GetPage(urlCompleted);
if (!pageContentCompleted.Contains("车架号后6位不匹配"))
{
#region if there is only one page
int numberCompleted = int.Parse(pageContentCompleted.Substring(pageContentCompleted.IndexOf(" 的 小型汽车 共有 <font color=\"#d42e2f\">") + 34, 1));
if (numberCompleted != 0)
{
string[] completeds = pageContentCompleted.Split(new string[] { "<div class=\"result_r\"><h2>", "</h2><p>", "<font color=\"#d42e2f\">", "</font>元", "</font>分", "于 ", "，在" }, StringSplitOptions.None);
int j = 1;
if (completeds.Length > 0)
{
for (int i = 0; i < completeds.Length; i++)
{
if (!completeds[i].Contains("<")
&& !completeds[i].Contains("/>")
&& !completeds[i].Contains("罚款，记")
&& !completeds[i].Contains("小型汽车")
)
{
switch (j)
{
case 1:
model.ViolationAddress = completeds[i];
break;
case 2:
model.ViolationDateTime = completeds[i];
break;
case 3:
model.ViolationContent = completeds[i];
break;
case 4:
model.ViolationAmount = int.Parse(completeds[i]);
break;
case 5:
model.ViolationScore = int.Parse(completeds[i]);
break;
default: break;
}
j++;
if (j > 5)
{
model.CarNumber = scParams.CarNumber;
model.ViolationStatus = "C";
listCompleted.Add(model);
model = new ViolationModel();
j = 1;
}
}
}
}
}
#endregion
#region if there are some pages
if (pageContentCompleted.Contains("条记录")
&& pageContentCompleted.Contains("下一页"))
{
int totalPage = int.Parse(pageContentCompleted.Substring(pageContentCompleted.IndexOf("条记录 "), 8).Substring(6, 2).Trim());
for (int pageNumber = 2; pageNumber <= totalPage; pageNumber++)
{
urlCompleted = string.Format(CompletedAddress + "&p=" + pageNumber.ToString(), currentCarP, scParams.CarFrame);
pageContentCompleted = httpHelper.GetPage(urlCompleted);
numberCompleted = int.Parse(pageContentCompleted.Substring(pageContentCompleted.IndexOf(" 的 小型汽车 共有 <font color=\"#d42e2f\">") + 34, 1));
if (numberCompleted != 0)
{
string[] completeds = pageContentCompleted.Split(new string[] { "<div class=\"result_r\"><h2>", "</h2><p>", "<font color=\"#d42e2f\">", "</font>元", "</font>分", "于 ", "，在" }, StringSplitOptions.None);
int j = 1;
if (completeds.Length > 0)
{
for (int i = 0; i < completeds.Length; i++)
{
if (!completeds[i].Contains("<")
&& !completeds[i].Contains("/>")
&& !completeds[i].Contains("罚款，记")
&& !completeds[i].Contains("小型汽车")
)
{
switch (j)
{
case 1:
model.ViolationAddress = completeds[i];
break;
case 2:
model.ViolationDateTime = completeds[i];
break;
case 3:
model.ViolationContent = completeds[i];
break;
case 4:
model.ViolationAmount = int.Parse(completeds[i]);
break;
case 5:
model.ViolationScore = int.Parse(completeds[i]);
break;
default: break;
}
j++;
if (j > 5)
{
model.CarNumber = scParams.CarNumber;
model.ViolationStatus = "C";
listCompleted.Add(model);
model = new ViolationModel();
j = 1;
}
}
}
}
}
}
}
#endregion
}
else
{
listCompleted.Add(new ViolationModel() { ViolationAddress = "车架号后6位不匹配" });
}
}
