📄 i_mydeskweb.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using functionClass;
using dotnetCHARTING;
namespace jpgSoftware_SM.i
{
/// <summary>
/// i_myDeskWeb 的摘要说明。
/// </summary>
public class i_myDeskWeb : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label emailNum_SystemIn;
protected dotnetCHARTING.Chart saleChart;
protected dotnetCHARTING.Chart storageChart;
protected System.Web.UI.WebControls.Repeater saleListRp;
DataBaseLink db = new DataBaseLink();
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
string emailSql = "select * from Messge_SystemIn where msgTo = '"+Session["areaID"].ToString().Trim()+"' and msgIsRead = 'N'";
DataTable emailDt = db.ExecuteQueryReturnTable(emailSql);
this.emailNum_SystemIn.Text = emailDt.Rows.Count.ToString().Trim(); //获得未读系统内邮件个数
string saleSql = "select top 8 *,left(customer,7) as cus,Substring(Convert(varchar,crdate,120),1,10) as crrdate from saleList order by crDate desc";
DataTable saleDt = db.ExecuteQueryReturnTable(saleSql);
this.saleListRp.DataSource = saleDt;
this.saleListRp.DataBind();
getSaleChart();
getStorageChart();
//testChart();
}
#region
public void testChart()
{
saleChart.Title="Weekday Report";
saleChart.ChartArea.XAxis.Label.Text ="Days";
saleChart.ChartArea.YAxis.Label.Text="Dollars (Thousands)";
saleChart.TempDirectory="saleChart";
saleChart.Debug=true;
saleChart.DefaultSeries.DefaultElement.ShowValue=true;
saleChart.ChartArea.XAxis.ReverseSeries=true;
saleChart.DefaultSeries.Type = SeriesType.Spline;
saleChart.ShadingEffect = false;
saleChart.FileName = "JpgSoftware"+"_"+System.DateTime.Now.ToShortDateString();
SeriesCollection SC = new SeriesCollection();
Series s1 = new Series();
s1.Name="Vancouver";
//saleChart.Series.Type = SeriesType.Cylinder;
s1.Elements.Add(new Element("Mon",2));
s1.Elements.Add(new Element("Tue",4));
s1.Elements.Add(new Element("Wed",6));
s1.Elements.Add(new Element("Thr",7));
s1.Elements.Add(new Element("Fri",4));
s1.Elements.Add(new Element("Sat",0));
SC.Add(s1);
Series s2 = new Series();
s2.Name="Vancouver";
//saleChart.Series.Type = SeriesType.Cylinder;
s2.Element = new Element("Mon",0);
s2.Elements.Add();
s2.Element = new Element("Tue",3);
s2.Elements.Add();
s2.Element = new Element("Wed",7);
s2.Elements.Add();
s2.Element = new Element("Thr",0);
s2.Elements.Add();
s2.Element = new Element("Fri",15);
s2.Elements.Add();
SC.Add(s2);
saleChart.SeriesCollection.Add(SC);
// string sql = "select pCode,crdate,sum(productNum) as productNum from saleList group by crdate,pCode";
// DataTable dt = db.ExecuteQueryReturnTable(sql);
// saleChart.Series.Data = dt;
// saleChart.SeriesCollection.Add();
// string sql = "SELECT Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),-1),120),1,10),";
// sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),0),120),1,10),";
// sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),1),120),1,10),";
// sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),2),120),1,10),";
// sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),3),120),1,10),";
// sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),4),120),1,10),";
// sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),5),120),1,10)";
// DataTable tempDt = db.ExecuteQueryReturnTable(sql);
//
//
// string checkProductNum = "select pcode,sum(productNum) as productNum from saleList where crDate>='"+Convert.ToDateTime(tempDt.Rows[0][0])+"' and crDate<='"+Convert.ToDateTime(tempDt.Rows[0][6])+"' group by pCode";
// DataTable checkProductNumDt = db.ExecuteQueryReturnTable(checkProductNum);
// SeriesCollection SC = new SeriesCollection();
// for(int n=0;n<checkProductNumDt.Rows.Count;n++)
// {
//
// string prSql = "select * from saleList where pCode = '"+checkProductNumDt.Rows[n]["pCode"].ToString().Trim()+"'";
// DataTable prDt = db.ExecuteQueryReturnTable(prSql);
// Series s = new Series();
// s.Name = prDt.Rows[0]["productName"].ToString().Trim();
// s.Data = checkProductNumDt.Rows[n]["productNum"];
// SC.Add(s);
// }
// saleChart.SeriesCollection.Add(SC);
}
#endregion
#region 销售记录折线图
public void getSaleChart()
{
saleChart.Title="本周销售量走势图";
saleChart.ChartArea.XAxis.Label.Text ="日期";
saleChart.ChartArea.YAxis.Label.Text="销售量(单位:件)";
saleChart.TempDirectory="saleChart";
saleChart.Debug=true;
saleChart.ShadingEffect = false;
saleChart.Use3D = false;
saleChart.Width = 770;
saleChart.Height = 480;
saleChart.ChartArea.XAxis.ReverseSeries=true;
saleChart.DefaultSeries.DefaultElement.ShowValue=true;
saleChart.DefaultSeries.Type = SeriesType.Spline;
saleChart.FileName = "JpgSoftware "+"_"+Session["employeeid"].ToString().Trim()+"_"+System.DateTime.Now.ToShortDateString();
string sql = "SELECT Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),-1),120),1,10),";
sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),0),120),1,10),";
sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),1),120),1,10),";
sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),2),120),1,10),";
sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),3),120),1,10),";
sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),4),120),1,10),";
sql = sql +"Substring(Convert(varchar,DATEADD(wk,DATEDIFF(wk,0,getdate()),5),120),1,10)";
DataTable tempDt = db.ExecuteQueryReturnTable(sql);
string sql2="";
sql2 = "select distinct pcode as pCode from saleList ";
DataTable dt1 = db.ExecuteQueryReturnTable(sql2);
for(int ii=0;ii<dt1.Rows.Count;ii++)
{
string pSql = "select * from saleList where pCode = '"+dt1.Rows[ii]["pCode"].ToString().Trim()+"'";
DataTable pDt = db.ExecuteQueryReturnTable(pSql);
saleChart.Series.Name = pDt.Rows[0]["productName"].ToString().Trim();
for(int i=0;i<7;i++)
{
string sumSql = "select sum(productNum) as productNum from saleList where pCode = '"+dt1.Rows[ii]["pCode"].ToString().Trim()+"' and Substring(Convert(varchar,crDate,120),1,10) = '"+tempDt.Rows[0][i].ToString().Trim()+"'";
DataTable sumDt = db.ExecuteQueryReturnTable(sumSql);
int productNum = 0;
try
{
productNum = Convert.ToInt32(sumDt.Rows[0]["productNum"]);
}
catch(Exception exx)
{
productNum = 0;
}
saleChart.Series.Elements.Add(new Element(tempDt.Rows[0][i].ToString().Trim(),productNum));
}
saleChart.SeriesCollection.Add();
}
}
#endregion
public void getStorageChart()
{
this.storageChart.Debug = false;
//Chart1.Mentor = false;
storageChart.Title="库存产品统计分析";
storageChart.XAxis.Label.Text="产品名称";
storageChart.YAxis.Label.Text="库存量(单位:件)";
storageChart.TempDirectory="storageChart";
storageChart.ShadingEffect = true;
storageChart.Use3D = false;
storageChart.Width = 770;
storageChart.Height = 480;
storageChart.DefaultSeries.DefaultElement.ShowValue=true;
storageChart.FileName = "JpgSoftware "+Session["areaID"].ToString().Trim()+"_"+Session["employeeid"].ToString().Trim()+"_"+System.DateTime.Now.ToShortDateString();
DataTable dt = new DataTable();
string sql = "select distinct pCode from headquarter_Storage where areaid = '"+Session["areaID"].ToString().Trim()+"'";
dt = db.ExecuteQueryReturnTable(sql);
SeriesCollection SC = new SeriesCollection();
for(int i=0;i<dt.Rows.Count;i++)
{
string pSql = "select pCode,sum(productNum) as productNum from headquarter_Storage where pCode = '"+dt.Rows[i]["pCode"].ToString().Trim()+"' group by pCode ";
DataTable pDt = db.ExecuteQueryReturnTable(pSql);
string sql1 = "select * from headquarter_Storage where pCode = '"+pDt.Rows[0]["pCode"].ToString().Trim()+"'";
DataTable dt1 = db.ExecuteQueryReturnTable(sql1);
Series s = new Series();
s.Name = dt1.Rows[0]["productName"].ToString().Trim();
s.Elements.Add(new Element(dt1.Rows[0]["productName"].ToString().Trim(),Convert.ToInt32(pDt.Rows[0]["productNum"])));
SC.Add(s);
}
storageChart.SeriesCollection.Add(SC);
}
#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 + -