protected void Page_Load(object sender, EventArgs e)
{
string sql = "SELECT p.cha, u.LocateRegion AS province, Count(u.EntFullName) AS [count] FROM EntUserInfor as u LEFT JOIN province as p ON u.LocateRegion=p.name GROUP BY p.cha, u.LocateRegion ORDER BY [count] DESC";
//DataTable TempDataTable = new DataTable();
DataTable TempDataTable = DbHelperSQL.FindTable(3, sql);
//TempDataTable.Columns.Add("Name");
//TempDataTable.Columns.Add("Age");
//TempDataTable.Columns.Add("Address");
sql = "SELECT p.cha, u.EntFullName FROM EntUserInfor as u LEFT JOIN province as p ON u.LocateRegion=p.name ";
DataTable TempDataTable2 = DbHelperSQL.FindTable(3, sql);
/////////////////////////////////////////////////////////////////////
JSON_Class Object_JSON_Class = new JSON_Class();
///////// JSON String with Rows And Cols////////////////////////////
JSON_DataTable_DataHolder.Value = Object_JSON_Class.JSON_DataTable(TempDataTable);
JSON_DataTable_DataHolder2.Value = Object_JSON_Class.JSON_DataTable(TempDataTable2);
///////// JSON String with Rows And ColNames////////////////////////////
//JSON_Parameter_DataHolder.Value= Object_JSON_Class.CreateJsonParameters(TempDataTable);
}
protected void Page_Load(object sender, EventArgs e)
{
string sql = "SELECT datename(YYYY, RegisterTime)+ '-' + DATENAME(MM, RegisterTime) AS MyDate, COUNT(*) as origin FROM UserInfor where UserState='1' GROUP BY DATENAME(YYYY, RegisterTime), DATENAME(MM, RegisterTime),DATEPART(YYYY, RegisterTime),DATEPART(MM, RegisterTime) ORDER BY DATEPART(YYYY, RegisterTime),DATEPART(MM, RegisterTime)";
DataTable TempDataTable = DbHelperSQL.FindTable(2, sql);
DataRow[] myrow = new DataRow[TempDataTable.Rows.Count];
TempDataTable.Rows.CopyTo(myrow, 0);
double[] myValue = Array.ConvertAll(myrow, new Converter <DataRow, double>(ConvertOriginToDouble));
int num = 5;//待预测数据个数
ES es1 = new ES(myValue, num, 0.8);
double[] result = es1.ES_SecResult();
DataColumn dc = new DataColumn("predict", typeof(string));
TempDataTable.Columns.Add(dc);
int length = myValue.GetLength(0);
int i;
for (i = 0; i < (length + num); i++)
{
if (i >= length)
{
DataRow dr = TempDataTable.NewRow();
dr[0] = JSON_Class.YearMonthAdd(TempDataTable.Rows[i - 1][0].ToString(), 1);
dr[2] = Math.Round(result[i], 0).ToString();//将预测值四舍五入为整数
TempDataTable.Rows.Add(dr);
}
else
{
DataRow dr = TempDataTable.Rows[i];
dr[0] = JSON_Class.YearMonthAdd(dr[0].ToString(), -1);
dr[2] = Math.Round(result[i], 0).ToString();
}
}
JSON_Class Object_JSON_Class = new JSON_Class();
string[] c = { "date", "origin", "predict" };
sjson = Object_JSON_Class.JSON_DT_YearMonth(TempDataTable, c);//
}
protected void Page_Load(object sender, EventArgs e)
{
//string sql = "SELECT YEAR(注册时间) as year, COUNT(*) as origin FROM ServResource GROUP BY YEAR(注册时间) ORDER BY year ASC";
string sql = "SELECT datename(YYYY, 注册时间)+ '-' + DATENAME(MM, 注册时间) AS MyDate, COUNT(*) as origin FROM ServResource GROUP BY DATENAME(YYYY, 注册时间), DATENAME(MM, 注册时间),DATEPART(YYYY, 注册时间),DATEPART(MM, 注册时间) ORDER BY DATEPART(YYYY, 注册时间),DATEPART(MM, 注册时间)";
//DataTable TempDataTable = new DataTable();
DataTable TempDataTable = DbHelperSQL.FindTable(3, sql);
//TempDataTable.Columns.Add("Name");
//TempDataTable.Columns.Add("Age");
//TempDataTable.Columns.Add("Address");
///////// JSON String with Rows And Cols////////////////////////////
//JSON_DataTable_DataHolder.Value= Object_JSON_Class.JSON_DataTable(TempDataTable);
///////// JSON String with Rows And ColNames////////////////////////////
//JSON_Parameter_DataHolder.Value= Object_JSON_Class.CreateJsonParameters(TempDataTable);
DataRow[] myrow = new DataRow[TempDataTable.Rows.Count];
TempDataTable.Rows.CopyTo(myrow, 0);
//double[] myValue = { 3, 4, 5, 6, 7, 9, 11, 13, 15, 17, 22, 27, 29 };
//double[] myValue = { 3, 4, 5, 6, 7, 8, 9, 10, 13, 14, 15, 17, 19};
//double[] myValue = { 3, 1, 2, 1, 1, 1, 1, 3, 3, 4, 32};//GM模型不适用数据有突变的序列
double[] myValue = Array.ConvertAll(myrow, new Converter <DataRow, double>(ConvertOriginToDouble));
/*
* Response.Write("历史值： ");
* foreach (var item in myValue)
* {
* Response.Write(item.ToString() + " ");
* }
*/
int num = 5;//待预测数据个数
GM gm1 = new GM(myValue, num);
double[] result = gm1.Result();
//double[] result = gm1.Result_revised();
/*
* Response.Write("预测值： ");
* foreach (var item in result)
* {
* Response.Write(item.ToString() + " ");
* }
*/
/////////////////////////////////////////////////////////////////////
DataColumn dc = new DataColumn("predict", typeof(string));
TempDataTable.Columns.Add(dc);
int length = myValue.GetLength(0);
int i;
for (i = 0; i < (length + num); i++)
{
if (i >= length)
{
DataRow dr = TempDataTable.NewRow();
dr[0] = JSON_Class.YearMonthAdd(TempDataTable.Rows[i - 1][0].ToString(), 1);
dr[2] = Math.Round(result[i], 0).ToString();//将预测值四舍五入为整数
TempDataTable.Rows.Add(dr);
}
else
{
DataRow dr = TempDataTable.Rows[i];
dr[0] = JSON_Class.YearMonthAdd(dr[0].ToString(), -1);
dr[2] = Math.Round(result[i], 0).ToString();
}
}
JSON_Class Object_JSON_Class = new JSON_Class();
string[] c = { "date", "origin", "predict" };
sjson = Object_JSON_Class.JSON_DT_YearMonth(TempDataTable, c);//
//chartdiv.Style["width"] = "870px";
}
protected void Page_Load(object sender, EventArgs e)
{
//string sql = "SELECT YEAR(DealDate) as year, COUNT(*) as count,Sum(price) as price FROM deal_fact WHERE deal='1' GROUP BY YEAR(DealDate) ORDER BY year ASC";
//string sql = "SELECT CAST(YEAR(DealDate) AS VARCHAR(4))+ '-' + CAST(MONTH(DealDate) AS VARCHAR(2)) AS MyDate, COUNT(*) as count,Sum(price) as price FROM deal_fact WHERE deal='1' GROUP BY CAST(YEAR(DealDate) AS VARCHAR(4))+ '-' + CAST(MONTH(DealDate) AS VARCHAR(2)) ORDER BY MyDate ASC";
string sql = "SELECT datename(YYYY, DealDate)+ '-' + DATENAME(MM, DealDate) AS MyDate, COUNT(*) as count,Sum(price) as price FROM deal_fact WHERE deal='1' GROUP BY DATENAME(YYYY, DealDate), DATENAME(MM, DealDate),DATEPART(YYYY, DealDate),DATEPART(MM, DealDate) ORDER BY DATEPART(YYYY, DealDate),DATEPART(MM, DealDate)";
//DataTable TempDataTable = new DataTable();
DataTable TempDataTable = DbHelperSQL.FindTable(3, sql);
//TempDataTable.Columns.Add("Name");
//TempDataTable.Columns.Add("Age");
//TempDataTable.Columns.Add("Address");
///////// JSON String with Rows And Cols////////////////////////////
//JSON_DataTable_DataHolder.Value= Object_JSON_Class.JSON_DataTable(TempDataTable);
///////// JSON String with Rows And ColNames////////////////////////////
//JSON_Parameter_DataHolder.Value= Object_JSON_Class.CreateJsonParameters(TempDataTable);
DataRow[] myrow = new DataRow[TempDataTable.Rows.Count];
TempDataTable.Rows.CopyTo(myrow, 0);
double[] myValue = Array.ConvertAll(myrow, new Converter <DataRow, double>(ConvertOriginToDouble));
double[] myValue2 = Array.ConvertAll(myrow, new Converter <DataRow, double>(ConvertPriceToDouble));
//double[] xValue ={2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018};
int length = myValue.GetLength(0);
int num = 5;//待预测数据个数
double[] xValue = new double[length + num];
//int s=Int32.Parse(TempDataTable.Rows[0][0].ToString());
for (int i = 0; i < (length + num); i++)
{
xValue[i] = Convert.ToDouble(i);
}
//for (int i = 1; i <= (length + num); i++) xValue[i] = Convert.ToDouble(i);
/*
* Response.Write("历史值： ");
* foreach (var item in xValue)
* {
* Response.Write(item.ToString() + " ");
* }
*/
//GM gm1 = new GM(myValue, num);
//double[] result = gm1.Result();
LinearRegression lr1 = new LinearRegression(myValue, xValue, num);
LinearRegression lr2 = new LinearRegression(myValue2, xValue, num);
double[] result = lr1.FirResult();
double[] result2 = lr2.FirResult();
DataColumn dc = new DataColumn("predict", typeof(string));
DataColumn dc2 = new DataColumn("predict2", typeof(string));
TempDataTable.Columns.Add(dc); TempDataTable.Columns.Add(dc2);
//int i;
for (int i = 0; i < (length + num); i++)
{
if (i >= length)
{
DataRow dr = TempDataTable.NewRow();
dr[0] = JSON_Class.YearMonthAdd(TempDataTable.Rows[i - 1][0].ToString(), 1);
dr[3] = Math.Round(result[i], 0).ToString();//将预测值四舍五入为整数
dr[4] = Math.Round(result2[i], 0).ToString();
TempDataTable.Rows.Add(dr);
}
else
{
DataRow dr = TempDataTable.Rows[i];
dr[0] = JSON_Class.YearMonthAdd(dr[0].ToString(), -1);
dr[3] = Math.Round(result[i], 0).ToString();
dr[4] = Math.Round(result2[i], 0).ToString();
}
}
JSON_Class Object_JSON_Class = new JSON_Class();
//string[] c = { "year", "origin", "price", "predict", "predict2" };
string[] c = { "date", "origin", "price", "predict", "predict2" };
sjson = Object_JSON_Class.JSON_DT_YearMonth(TempDataTable, c);//
//chartdiv.Style["width"] = "870px";
}