public static void Main(string[] args)
{
//new Spider().GetRequst();
Console.WriteLine("begin...." + DateTime.Now);
PullData spider = new PullData();
// 债券新闻
spider.GetBondsNewsData("银行 基金");
// 上交所
// spider.GetNewsFromShangExchangeTest("新奥股份*2018");
// spider.GetNewsFromShangExchange("新奥股份*2018");
// 深交所
// spider.GetSZNewsByPostTest("监管关注");
// spider.GetSZNewsByPost("华联股份 高级管理人员辞职");
// 证监会
// spider.GetSecuritiesNewsByPostTest("中心");
// spider.GetSecuritiesNewsByPost("监管");
// spider.ConvertToModelList("");
// spider.GetSecuritiesDetail();
// 失信人信息查询23
//var code = "";
var count = 0;
while (count < 0)
{
var needPerson = true;
spider.ParseImgToCode(needPerson);
Thread.Sleep(500);
count++;
}
//Console.WriteLine("输入验证码:");
//var code = Console.ReadLine();
//Console.WriteLine("已输入:" + code);
// spider.GetPersonInHttpClient("codeImgF50DF51363C61749730C6B4BE9AB96BE", "4jlx");
var queryUri = "http://zxgk.court.gov.cn/shixin/findDis";
var req = HttpWebRequest.Create(queryUri) as HttpWebRequest;
// spider.GetPersonInfo(req,"","1234");
// 百度新闻
//spider.TestRequest();
// ParseImgCode parser = new ParseImgCode();
// parser.Test();
Console.ReadKey();
}
/// <summary>
/// Proceed to Buyer Page
/// </summary>
public IActionResult BuyerSearch()
{
PullData db = new PullData(Configuration);
ViewBag.Location = db.BindDropDownListCustomer("select distinct 1 Id, street Name from pmiresidenceresult limit 0,500;", "Location");
ViewBag.propertyType = db.BindDropDownListCustomer("select distinct 1 Id,propertyType Name from pmiresidenceresult limit 0,500;", "Property Type");
return(View());
}
public static bool TEST(PullData spider)
{
Console.WriteLine("输入验证码:");
Console.ReadLine();
var code = Console.ReadLine();
// spider.GetCourtPersonInfo("", code);
return(true);
}
public string AjaxFilter(string Locations, string propertyTypes, string PriceRange, string SaleType, string LandArea, string FloorRange)
{
PullData db = new PullData(Configuration);
string whrQuery = " Where 0=0";
if (Locations != null)
{
whrQuery = whrQuery + " and street='" + Locations + "'";
}
if (propertyTypes != null)
{
whrQuery = whrQuery + " and propertyType='" + propertyTypes + "'";
}
if (SaleType != null)
{
whrQuery = whrQuery + " and typeOfSale='" + SaleType + "'";
}
if (FloorRange != null)
{
whrQuery = whrQuery + " and floorRange='" + FloorRange + "'";
}
if (PriceRange != null)
{
if (PriceRange == "1")
{
whrQuery = whrQuery + " and CAST(price AS UNSIGNED)<" + 1000000;
}
else if (PriceRange == "11")
{
whrQuery = whrQuery + " and CAST(price AS UNSIGNED)>" + 10000000;
}
else
{
whrQuery = whrQuery + " and (CAST(price AS UNSIGNED)<" + Convert.ToInt32(PriceRange) * 1000000 + " and CAST(price AS UNSIGNED)>" + ((Convert.ToInt32(PriceRange) * 1000000) - 1000000) + " )";
}
}
if (LandArea != null)
{
if (LandArea == "1")
{
whrQuery = whrQuery + " and CAST(area AS UNSIGNED)<" + 100;
}
else
{
whrQuery = whrQuery + " and (CAST(area AS UNSIGNED)<" + Convert.ToInt32(LandArea) * 100 + " and CAST(area AS UNSIGNED)>" + ((Convert.ToInt32(LandArea) * 100) - 100) + " )";
}
}
whrQuery = whrQuery + " ORDER BY idtransaction DESC LIMIT 600";
string query = " Select * From pmiresidenceresult " + whrQuery;
DataTable dt = db.LoadData(query, "Loaddt");
string json = JsonConvert.SerializeObject(dt);
return(JsonConvert.SerializeObject(dt));
}
///<summary>
///Uses the dictionary returned from GetAllPrices to create a list of chartmodels with appropriate values
/// </summary>
///<returns>
///List of chart models with calculated average for the month and moving average across 3 months
/// </returns>
public List <ChartViewModel> GetAvgPriceList(string Location)
{
PullData db = new PullData(Configuration);
string Query = "SELECT Sum(price) FROM bricks.pmiresidenceresult ";
if (Location != "" && Location != null)
{
Query = Query + " Where street='" + Location + "'";
}
DataTable dtPriceSum = db.LoadData(Query, "PriceSum");
string resultQuery = "SELECT contractDate,FORMAT(((Sum(price)/" + dtPriceSum.Rows[0][0].ToString() + ")*100),6) AveragePrice FROM bricks.pmiresidenceresult ";
if (Location != "" && Location != null)
{
resultQuery = resultQuery + " Where street='" + Location + "'";
}
resultQuery = resultQuery + @" Group by contractDate order by STR_TO_DATE(concat('01,', left(contractDate, 2),',20',right(contractDate, 2)),'%d,%m,%Y')";
DataTable dtresultQuery = db.LoadData(resultQuery, "resultQuery");
for (int i = 0; i < dtresultQuery.Rows.Count; i++)
{
string strMonth = dtresultQuery.Rows[i]["contractDate"].ToString().Substring(0, 2);
string strYear = "20" + dtresultQuery.Rows[i]["contractDate"].ToString().Substring(2, 2);
dtresultQuery.Rows[i]["contractDate"] = strMonth + "-" + strYear;
}
var datalist = new List <ChartViewModel>();
datalist.Add(new ChartViewModel {
saleTime = dtresultQuery.Rows[0][0].ToString(), averagePrice = dtresultQuery.Rows[0][1].ToString(), movingAveragePrice = dtresultQuery.Rows[0][1].ToString()
});
double sumOfMonths = Double.Parse(dtresultQuery.Rows[0][1].ToString()) + Double.Parse(dtresultQuery.Rows[1][1].ToString());
double movingAverage = sumOfMonths / 2;
datalist.Add(new ChartViewModel {
saleTime = dtresultQuery.Rows[1][0].ToString(), averagePrice = dtresultQuery.Rows[1][1].ToString(), movingAveragePrice = movingAverage.ToString("N6")
});
for (int i = 2; i < dtresultQuery.Rows.Count; i++)
{
sumOfMonths = Double.Parse(dtresultQuery.Rows[i - 2][1].ToString()) + Double.Parse(dtresultQuery.Rows[i - 1][1].ToString()) + Double.Parse(dtresultQuery.Rows[i][1].ToString());
movingAverage = sumOfMonths / 3;
datalist.Add(new ChartViewModel {
saleTime = dtresultQuery.Rows[i][0].ToString(), averagePrice = dtresultQuery.Rows[i][1].ToString(), movingAveragePrice = movingAverage.ToString("N6")
});
}
return(datalist);
}
