📄 count.aspx.cs
字号:
DataSet dsAll=GetDs(vSqlAll);
for(int i=0;i<24;i++)
{
DataRow drAll=dsAll.Tables[0].Rows[i];
Chart1.Series["Series2"].Points.AddXY(Convert.ToDouble(drAll["cHour"].ToString()),Convert.ToDouble(drAll["cCHC"].ToString()));
}
//为Series["Series2"]设置画图区
Chart1.Series["Series2"].ChartArea = "Chart Area 2";
Chart1.Series["Series2"].LegendText="所有24小时统计";
Chart1.ChartAreas["Chart Area 2"].AxisX.Interval=1;
// Chart1.ChartAreas["Chart Area 2"].AxisY.Interval=1;
}
/// <summary>
/// 天的统计
/// </summary>
private void BindDay()
{
//update
int MaxDay = Fn_MaxDay(DateTime.Now.AddMonths(-1).Month);
string strUpdate="update cD set cTDC=0,DMD=now() where DATEDIFF('d',DMD,Now()) > "+MaxDay;
OleDbCommand myCommandUpdate = new OleDbCommand(strUpdate, myConnection);
myConnection.Open();
myCommandUpdate.ExecuteNonQuery();
myConnection.Close();
// 过去一个月的统计
string vSql = "select cD.cDay,cD.cTDC from cD order by cD.cDay asc";
DataSet ds=GetDs(vSql);
DataRow dr;
DateTime t=DateTime.Now.Date;
int j=t.Day;
int k=Fn_MaxDay(DateTime.Now.Month);
for(int i=0;i< k;i++)
{
dr=ds.Tables[0].Rows[j-1];
Chart1.Series["Default"].Points.AddXY(t,Convert.ToDouble(dr["cTDC"].ToString()));
t=t.AddDays(-1);
j=t.Day;
}
//为Series["Default"]设置画图区
Chart1.Series["Default"].ChartArea = "Chart Area 1";
Chart1.Series["Default"].LegendText="过去一个月的统计";
Chart1.ChartAreas["Chart Area 1"].AxisX.LabelStyle.Format="M";//X轴设置为"月日"形式
SetAxisInterval(Chart1.ChartAreas["Chart Area 1"].AxisX,1,DateTimeIntervalType.Days);
// Chart1.ChartAreas["Chart Area 1"].AxisX.Interval=1;
// Chart1.ChartAreas["Chart Area 1"].AxisY.Interval=1;
//所有日的统计
//绑定数据
string vSqlAll = "select cD.cDay,cD.cCDC from cD order by cD.cDay asc";
DataSet dsAll=GetDs(vSqlAll);
for(int i=0;i<31;i++)
{
DataRow drAll=dsAll.Tables[0].Rows[i];
Chart1.Series["Series2"].Points.AddXY(Convert.ToDouble(drAll["cDay"].ToString()),Convert.ToDouble(drAll["cCDC"].ToString()));
}
//为Series["Series2"]设置画图区
Chart1.Series["Series2"].ChartArea = "Chart Area 2";
Chart1.Series["Series2"].LegendText="所有日的统计";
Chart1.ChartAreas["Chart Area 2"].AxisX.Interval=1;
// Chart1.ChartAreas["Chart Area 2"].AxisY.Interval=1;
}
/// <summary>
/// 月的统计
/// </summary>
private void BindMonth()
{
//update
string strUpdate="update cM set cTMC=0,MMD=now() where DATEDIFF('m',MMD,Now()) > 11 ";
OleDbCommand myCommandUpdate = new OleDbCommand(strUpdate, myConnection);
myConnection.Open();
myCommandUpdate.ExecuteNonQuery();
myConnection.Close();
// 过去12个月的统计
string vSql = "select cM.cMonth,cM.cTMC from cM order by cM.cMonth asc";
DataSet ds=GetDs(vSql);
DataRow dr;
DateTime t=DateTime.Now.Date;
int j=t.Month;
for(int i=0;i< 12;i++)
{
dr=ds.Tables[0].Rows[j-1];
Chart1.Series["Default"].Points.AddXY(t,Convert.ToDouble(dr["cTMC"].ToString()));
t=t.AddMonths(-1);
j=t.Month;
}
//为Series["Default"]设置画图区
Chart1.Series["Default"].ChartArea = "Chart Area 1";
Chart1.Series["Default"].LegendText="过去12个月的统计";
Chart1.ChartAreas["Chart Area 1"].AxisX.LabelStyle.Format="Y";//X轴设置为"年月"形式
SetAxisInterval(Chart1.ChartAreas["Chart Area 1"].AxisX,1,DateTimeIntervalType.Months);
Chart1.ChartAreas["Chart Area 1"].AxisX.Interval=1;
// Chart1.ChartAreas["Chart Area 1"].AxisY.Interval=1;
//所有月的统计
//绑定数据
string vSqlAll = "select cM.cMonth,cM.cCMC from cM order by cM.cMonth asc";
DataSet dsAll=GetDs(vSqlAll);
for(int i=0;i<12;i++)
{
DataRow drAll=dsAll.Tables[0].Rows[i];
Chart1.Series["Series2"].Points.AddXY(Convert.ToDouble(drAll["cMonth"].ToString()),Convert.ToDouble(drAll["cCMC"].ToString()));
}
//为Series["Series2"]设置画图区
Chart1.Series["Series2"].ChartArea = "Chart Area 2";
Chart1.Series["Series2"].LegendText="所有月的统计";
Chart1.ChartAreas["Chart Area 2"].AxisX.Interval=1;
// Chart1.ChartAreas["Chart Area 2"].AxisY.Interval=1;
}
/// <summary>
/// 地区统计
/// </summary>
private void BindWhere()
{
//系统统计,注意数据绑定的方法
//为Series["Default"]设置画图区
Chart2.Series["Default"].ChartArea = "Chart Area 1";
Chart2.Series["Default"].LegendText="地区统计";
Chart2.Series["Default"].XValueType=ChartValueTypes.String;
Chart2.Series["Default"].YValueType=ChartValueTypes.Double;
Chart2.ChartAreas["Chart Area 1"].AxisX.Interval=1;
string vSql = "select Top 20 cW.cWhere,cW.cCWC from cW order by cW.cCWC desc";
// create a database command on the connection using query
OleDbCommand myCommand = new OleDbCommand(vSql, myConnection);
// open the connection
myConnection.Open();
// create a database reader
OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
// since the reader implements IEnumerable, pass the reader directly into
// the DataBind method with the name of the Column selected in the query
Chart2.Series["Default"].Points.DataBind(
myReader,
"cWhere",
"cCWC",
"Label=cCWC");
// close the reader and the connection
myReader.Close();
}
/// <summary>
/// 最后20位来访者的资料
/// </summary>
private void BindLast20()
{
string vSql = "select * from Last20Vister order by cCT desc,id asc";
DataSet ds=GetDs(vSql);
this.dg20List.DataSource=ds.Tables[0].DefaultView;
this.dg20List.DataBind();
}
/// <summary>
/// 得到一个DateSet
/// </summary>
private DataSet GetDs(string vSql)
{
OleDbDataAdapter myCommand = new OleDbDataAdapter(vSql , myConnection);
DataSet ds = new DataSet();
// Execute the command
myConnection.Open();
myCommand.Fill(ds,"Detail");
myConnection.Close();
return ds;
}
/// <summary>
/// 得到第一个DataRow
/// </summary>
private DataRow GetDr(string vSql)
{
OleDbDataAdapter myCommand = new OleDbDataAdapter(vSql , myConnection);
DataSet ds = new DataSet();
// Execute the command
myConnection.Open();
myCommand.Fill(ds,"Detail");
myConnection.Close();
return ds.Tables[0].Rows[0];
}
/// <summary>
/// Sets intervals for the axis labels,
/// major tick marks and major grid lines.
/// </summary>
public void SetAxisInterval(Axis axis, double interval, DateTimeIntervalType intervalType)
{
SetAxisInterval(axis, interval, intervalType, 0, intervalType);
}
/// <summary>
/// Sets intervals for the axis labels,
/// major tick marks and major grid lines.
/// </summary>
public void SetAxisInterval(Axis axis, double interval, DateTimeIntervalType intervalType, double intervalOffset, DateTimeIntervalType intervalOffsetType )
{
// Set labels interval and interval offset
axis.LabelStyle.Interval = interval;
axis.LabelStyle.IntervalType = intervalType;
axis.LabelStyle.IntervalOffset = intervalOffset;
axis.LabelStyle.IntervalOffsetType = intervalOffsetType;
// Set major tick marks interval and interval offset
axis.MajorTickMark.Interval = interval;
axis.MajorTickMark.IntervalType = intervalType;
axis.MajorTickMark.IntervalOffset = intervalOffset;
axis.MajorTickMark.IntervalOffsetType = intervalOffsetType;
// Set major grid lines interval and interval offset
axis.MajorGrid.Interval = interval;
axis.MajorGrid.IntervalType = intervalType;
axis.MajorGrid.IntervalOffset = intervalOffset;
axis.MajorGrid.IntervalOffsetType = intervalOffsetType;
}
/// <summary>
/// 得到一个月的天数
/// </summary>
private int Fn_MaxDay(int Mon)
{
int result=30;
switch(Mon.ToString())
{
case "1":
case "3":
case "5":
case "7":
case "8":
case "10":
case "12":
result=31;
break;
case "4":
case "6":
case "9":
case "11":
result=30;
break;
case "2":
if(DateTime.Now.Year%4 == 0)
{
result=29;
}
else
{
result=28;
}
break;
}
return result;
}
public string GetHttp(string http)
{
string link="";
if(http=="直接输入网址进入的")
{
link="直接输入网址进入的";
}
else if(http.Length>25)
{
link="<a href='"+http+"' target='_blank'>"+http.Substring(0,25)+"..</a>";
}
else
{
link="<a href='"+http+"' target='_blank'>"+http+"..</a>";
}
return link;
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -