C#中dotnetcharting的用法實(shí)例詳解
更新時(shí)間：2014年10月29日 09:23:02 投稿：shichen2014
這篇文章主要介紹了C#中dotnetcharting的用法,以實(shí)例形式詳細(xì)分析了基于dotnetcharting的圖表繪制的各種常用方法,是非常實(shí)用的技巧,需要的朋友可以參考下
本文以實(shí)例形式詳細(xì)講述了dotnetcharting控件的用法。分享給大家供大家參考。具體用法分析如下：
dotnetcharting 是一個(gè)很好用的圖表控件，能畫出很漂亮的報(bào)表，一般常用到的主要有柱狀圖、餅圖、折線圖三種。
dotnetcharting 有web版、winform版多個(gè)版本可供使用，官方網(wǎng)址：http://www.dotnetcharting.com/ ，官網(wǎng)有很多示例（http://www.dotnetcharting.com/gallery/），而且有winform安裝版示例和代碼，如下圖。
dotnetcharting 有網(wǎng)上破解版的，去百度或谷歌一搜一堆。
說(shuō)下個(gè)人感受，該控件是國(guó)外開(kāi)發(fā)的，雖然說(shuō)這個(gè)控件挺好用的，但是感覺(jué)這個(gè)控件應(yīng)該在有xp系統(tǒng)的時(shí)候就應(yīng)該有了吧？是國(guó)外剩下的技術(shù)，咱們一直在用別人不用的技術(shù)，捧為珍寶。
有些技術(shù)有些人，有些本事就開(kāi)始自大起來(lái)，小有成就的那點(diǎn)技術(shù)還藏著掖著。 呵呵。。。
接下來(lái)上干貨，前兩天剛使用dotnetcharting 做了個(gè)統(tǒng)計(jì)報(bào)表，代碼如下：
復(fù)制代碼 代碼如下:
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using dotnetCHARTING.WinForms;
using StationChart.Model;
using StationChart.Utility;
using Chart = dotnetCHARTING.WinForms.Chart;
using Series = dotnetCHARTING.WinForms.Series;
using SeriesCollection = dotnetCHARTING.WinForms.SeriesCollection;
namespace ManageSystem
{
// <summary>
// 作者：薛江濤
// 版本：V1.0.0
// 時(shí)間：2014/10/9 11:49:48
// </summary>
public class ShowData
{
#region 屬性
private string _phaysicalimagepath;//圖片存放路徑
private string _xtitle;//圖片x座標(biāo)名稱
private string _ytitle;//圖片y座標(biāo)名稱
private string _seriesname;//圖例名稱
private int _picwidth;//圖片寬度
private int _pichight;//圖片高度
private DataTable _dt;//圖片數(shù)據(jù)源
private DataSet _ds;//圖片數(shù)據(jù)源
private Color _titleBoxColor;//圖片標(biāo)題背景色
private Font _titleBoxFont;//圖片標(biāo)題字體
private Color _chartAreaBackgroundColor;//圖片背景顏色
private Font _xAxisLabelFont;//X軸柱狀圖值字體
private Font _yAxisLabelFont;//Y軸柱狀圖值字體
private Font _xAxisDefaultTickLabelFont;//X軸刻度字體
private Font _yAxisDefaultTickLabelFont;//Y軸刻度字體
private SeriesType _chartDefaultSeriesType;//圖片類型
private ChartType _chartType;//圖片類型
//private bool _isMonth; //是否是月顯示
private int _staticColumnWidth;//設(shè)置柱狀圖每個(gè)單元格的寬度
private int _numberPercision;//設(shè)置數(shù)值小數(shù)點(diǎn)
/// <summary>
/// 圖片存放路徑
/// </summary>
public string PhaysicalImagePath
{
set { _phaysicalimagepath = value; }
get { return _phaysicalimagepath; }
}
/// <summary>
/// 圖片標(biāo)題
/// </summary>
public string Title { get; set; }
/// <summary>
/// 圖片標(biāo)題
/// </summary>
public string XTitle
{
set { _xtitle = value; }
get { return _xtitle; }
}
/// <summary>
/// 圖片標(biāo)題
/// </summary>
public string YTitle
{
set { _ytitle = value; }
get { return _ytitle; }
}
/// <summary>
/// 圖例名稱
/// </summary>
public string SeriesName
{
set { _seriesname = value; }
get { return _seriesname; }
}
/// <summary>
/// 圖片寬度
/// </summary>
public int PicWidth
{
set { _picwidth = value; }
get { return _picwidth; }
}
/// <summary>
/// 圖片高度
/// </summary>
public int PicHight
{
set { _pichight = value; }
get { return _pichight; }
}
/// <summary>
/// 圖片數(shù)據(jù)源
/// </summary>
public DataTable DataSource
{
set { _dt = value; }
get { return _dt; }
}
/// <summary>
/// 圖片數(shù)據(jù)源
/// </summary>
public DataSet DataSetSource
{
set { _ds = value; }
get { return _ds; }
}
public int NumberPercision
{
set { _numberPercision = value; }
get { return _numberPercision; }
}
public Color TitleBoxColor
{
get { return _titleBoxColor; }
set { _titleBoxColor = value; }
}
public Font TitleBoxFont
{
get { return _titleBoxFont; }
set { _titleBoxFont = value; }
}
public Color ChartAreaBackgroundColor
{
get { return _chartAreaBackgroundColor; }
set { _chartAreaBackgroundColor = value; }
}
public Font XAxisLabelFont
{
get { return _xAxisLabelFont; }
set { _xAxisLabelFont = value; }
}
public Font YAxisLabelFont
{
get { return _yAxisLabelFont; }
set { _yAxisLabelFont = value; }
}
public Font XAxisDefaultTickLabelFont
{
get { return _xAxisDefaultTickLabelFont; }
set { _xAxisDefaultTickLabelFont = value; }
}
public Font YAxisDefaultTickLabelFont
{
get { return _yAxisDefaultTickLabelFont; }
set { _yAxisDefaultTickLabelFont = value; }
}
public SeriesType ChartDefaultSeriesType
{
get { return _chartDefaultSeriesType; }
set { _chartDefaultSeriesType = value; }
}
public ChartType ChartType
{
get { return _chartType; }
set { _chartType = value; }
}
//public bool IsMonth
//{
// get { return _isMonth; }
// set { _isMonth = value; }
//}
public ModelConseme.DateChartEnum SeriesTypeE { get; set; }
public int StaticColumnWidth
{
get { return _staticColumnWidth; }
set { _staticColumnWidth = value; }
}
#endregion
#region 構(gòu)造函數(shù)
public ShowData()
{
//
// TODO: 在此處添加構(gòu)造函數(shù)邏輯
//
NumberPercision = 2;
}
public ShowData(string phaysicalImagePath, string title, string xTitle, string yTitle, string seriesName)
{
_phaysicalimagepath = phaysicalImagePath;
Title = title;
_xtitle = xTitle;
_ytitle = yTitle;
_seriesname = seriesName;
}
#endregion
private static readonly object ThisLock = new object();
#region 輸出柱形圖
/// <summary>
/// 柱形圖
/// </summary>
/// <returns></returns>
public void CreateColumn(Chart chart)
{
try
{
//清空?qǐng)D片
chart.SeriesCollection.Clear();
//標(biāo)題框設(shè)置
//標(biāo)題的顏色
chart.TitleBox.Label.Color = _titleBoxColor;
//標(biāo)題字體設(shè)置
chart.TitleBox.Label.Font = _titleBoxFont;
//控制柱狀圖顏色
chart.ShadingEffectMode = ShadingEffectMode.One;
chart.TitleBox.Position = TitleBoxPosition.None;
//圖表背景顏色
chart.ChartArea.Background.Color = ChartAreaBackgroundColor;
//1.圖表類型
chart.DefaultSeries.Type = _chartDefaultSeriesType;// SeriesType.Column;
//chart.DefaultSeries.Type = SeriesType.Cylinder;
//2.圖表類型
//柱狀圖
//chart.Type = ChartType.TreeMap;
////橫向柱狀圖
chart.Type = _chartType;// ChartType.ComboHorizontal
////橫向柱狀圖
//chart.Type =_chartType;// ChartType.Gantt;
////餅狀圖
//chart.Type = ChartType.Pies;
//y軸圖表陰影顏色
//chart.YAxis.AlternateGridBackground.Color = Color.FromArgb(255, 250, 250, 250);
chart.LegendBox.HeaderLabel = new Label("圖表說(shuō)明", new Font("Microsoft Sans Serif", 10F, FontStyle.Bold, GraphicsUnit.Point, 134));
//chart.LegendBox.HeaderLabel.Font = new Font("Microsoft Sans Serif", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
chart.LegendBox.Label.Font = new Font("Microsoft Sans Serif", 9F, FontStyle.Bold, GraphicsUnit.Point, 134);
chart.Palette = new Color[] { Color.FromArgb(0, 156, 255), Color.FromArgb(255, 99, 49), Color.FromArgb(49, 255, 49), Color.FromArgb(255, 255, 0), };
chart.Title = Title;
//X軸柱狀圖值字體
chart.XAxis.Label.Text = _xtitle;
chart.XAxis.Label.Font = _xAxisLabelFont;
//設(shè)置X軸刻度值說(shuō)明字體
chart.XAxis.DefaultTick.Label.Font = _xAxisDefaultTickLabelFont;
chart.XAxis.StaticColumnWidth = _staticColumnWidth; //每個(gè)單元格的寬度
//Y軸柱狀圖值字體
chart.YAxis.Label.Text = _ytitle;
chart.YAxis.Label.Font = _yAxisLabelFont;
//設(shè)置Y軸刻度值說(shuō)明字體
chart.YAxis.DefaultTick.Label.Font = _yAxisDefaultTickLabelFont;
//Y軸箭頭標(biāo)示
chart.XAxis.Name = XTitle;
if (_chartType == ChartType.ComboHorizontal)
{
chart.XAxis.TickLabelPadding = 10;
chart.XAxis.Line.StartCap = System.Drawing.Drawing2D.LineCap.Square;
chart.XAxis.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
chart.XAxis.Line.Width = 5;//箭頭寬度
chart.XAxis.Line.Color = Color.Gray;
}
else
{
chart.YAxis.TickLabelPadding = 10;
chart.YAxis.Line.StartCap = System.Drawing.Drawing2D.LineCap.Square;
chart.YAxis.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
chart.YAxis.Line.Width = 5;//箭頭寬度
chart.YAxis.Line.Color = Color.Gray;
//顯示值格式化(小數(shù)點(diǎn)顯示幾位)
chart.YAxis.NumberPercision = _numberPercision;
}
//圖片存放路徑
chart.TempDirectory = System.Environment.CurrentDirectory + "\\" + _phaysicalimagepath;
//圖表寬度
chart.Width = _picwidth;
//圖表高度
chart.Height = _pichight;
chart.Series.Name = _seriesname;
//單一圖形
//chart.Series.Data = _dt;
//chart.SeriesCollection.Add();
//圖例在標(biāo)題行顯示，但是沒(méi)有合計(jì)信息
//chart.TitleBox.Position = TitleBoxPosition.FullWithLegend;
//chart.TitleBox.Label.Alignment = StringAlignment.Center;
//chart.LegendBox.Position = LegendBoxPosition.None; //不顯示圖例,指不在右側(cè)顯示，對(duì)上面一行的屬性設(shè)置并沒(méi)有影響
chart.DefaultSeries.DefaultElement.ShowValue = true;
chart.ShadingEffect = true;
chart.Use3D = false;
chart.Series.DefaultElement.ShowValue = true;
chart.SeriesCollection.Add(GetArrayData());
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
}
}
/// <summary>
/// 柱形圖
/// </summary>
/// <returns></returns>
public void CreateColumn(Chart chart, List<int> list)
{
try
{
chart.SeriesCollection.Clear();
//標(biāo)題框設(shè)置
//標(biāo)題的顏色
chart.TitleBox.Label.Color = _titleBoxColor;
//標(biāo)題字體設(shè)置
chart.TitleBox.Label.Font = _titleBoxFont;
//控制柱狀圖顏色
chart.ShadingEffectMode = ShadingEffectMode.Five;
//圖表背景顏色
chart.ChartArea.Background.Color = ChartAreaBackgroundColor;
//1.圖表類型
chart.DefaultSeries.Type = _chartDefaultSeriesType;// SeriesType.Column;
//chart.DefaultSeries.Type = SeriesType.Cylinder;
//2.圖表類型
//柱狀圖
//chart.Type = ChartType.TreeMap;
////橫向柱狀圖
chart.Type = _chartType;// ChartType.ComboHorizontal
////橫向柱狀圖
//chart.Type =_chartType;// ChartType.Gantt;
////餅狀圖
//chart.Type = ChartType.Pies;
//y軸圖表陰影顏色
//chart.YAxis.AlternateGridBackground.Color = Color.FromArgb(255, 250, 250, 250);
chart.LegendBox.HeaderLabel = new Label("圖表說(shuō)明", new Font("Microsoft Sans Serif", 10F, FontStyle.Bold, GraphicsUnit.Point, 134));
//chart.LegendBox.HeaderLabel.Font = new Font("Microsoft Sans Serif", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
chart.LegendBox.Label.Font = new Font("Microsoft Sans Serif", 9F, FontStyle.Bold, GraphicsUnit.Point, 134);
chart.Palette = new Color[] { Color.FromArgb(0, 156, 255), Color.FromArgb(255, 99, 49), Color.FromArgb(49, 255, 49), Color.FromArgb(255, 255, 0), };
chart.Title = Title;
//X軸柱狀圖值字體
chart.XAxis.Label.Text = _xtitle;
chart.XAxis.Label.Font = _xAxisLabelFont;
//設(shè)置X軸刻度值說(shuō)明字體
chart.XAxis.DefaultTick.Label.Font = _xAxisDefaultTickLabelFont;
chart.XAxis.StaticColumnWidth = _staticColumnWidth; //每個(gè)單元格的寬度
//Y軸柱狀圖值字體
chart.YAxis.Label.Text = _ytitle;
chart.YAxis.Label.Font = _yAxisLabelFont;
//設(shè)置Y軸刻度值說(shuō)明字體
chart.YAxis.DefaultTick.Label.Font = _yAxisDefaultTickLabelFont;
//Y軸箭頭標(biāo)示
chart.XAxis.Name = XTitle;
if (_chartType == dotnetCHARTING.WinForms.ChartType.ComboHorizontal)
{
chart.XAxis.TickLabelPadding = 10;
chart.XAxis.Line.StartCap = System.Drawing.Drawing2D.LineCap.Square;
chart.XAxis.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
chart.XAxis.Line.Width = 5;//箭頭寬度
chart.XAxis.Line.Color = Color.Gray;
}
else
{
chart.YAxis.TickLabelPadding = 10;
chart.YAxis.Line.StartCap = System.Drawing.Drawing2D.LineCap.Square;
chart.YAxis.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
chart.YAxis.Line.Width = 5;//箭頭寬度
chart.YAxis.Line.Color = Color.Gray;
//顯示值格式化(小數(shù)點(diǎn)顯示幾位)
chart.YAxis.NumberPercision = _numberPercision;
}
//圖片存放路徑
chart.TempDirectory = System.Environment.CurrentDirectory + "\\" + _phaysicalimagepath;
//圖表寬度
chart.Width = _picwidth;
//圖表高度
chart.Height = _pichight;
chart.Series.Name = _seriesname;
//單一圖形
//chart.Series.Data = _dt;
//chart.SeriesCollection.Add();
//圖例在標(biāo)題行顯示，但是沒(méi)有合計(jì)信息
//chart.TitleBox.Position = TitleBoxPosition.FullWithLegend;
//chart.TitleBox.Label.Alignment = StringAlignment.Center;
//chart.LegendBox.Position = LegendBoxPosition.None; //不顯示圖例,指不在右側(cè)顯示，對(duì)上面一行的屬性設(shè)置并沒(méi)有影響
chart.DefaultSeries.DefaultElement.ShowValue = true;
chart.ShadingEffect = true;
chart.Use3D = false;
chart.Series.DefaultElement.ShowValue = true;
chart.SeriesCollection.Add(GetArrayData(list));
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
}
}
///// <summary>
///// 柱形圖,單一圖片
///// </summary>
///// <returns></returns>
//public void CreateColumn(Chart chart1)
//{
// Chart1.Title = _title;
// Chart1.XAxis.Label.Text = _xtitle;
// Chart1.YAxis.Label.Text = _ytitle;
// Chart1.TempDirectory = PhaysicalImagePath;
// Chart1.Width = _picwidth;
// Chart1.Height = _pichight;
// Chart1.Type = ChartType.Combo;
// Chart1.Series.Type = SeriesType.Cylinder;
// Chart1.Series.Name = _seriesname;
// Chart1.Series.Data = _dt;
// Chart1.SeriesCollection.Add();
// Chart1.DefaultSeries.DefaultElement.ShowValue = true;
// Chart1.ShadingEffect = true;
// Chart1.Use3D = false;
// Chart1.Series.DefaultElement.ShowValue = true;
//}
#endregion
#region 輸出餅圖
/// <summary>
/// 餅圖
/// </summary>
/// <returns></returns>
public void CreatePie(Chart chart)
{
try
{
chart.SeriesCollection.Clear();
//控制餅圖顏色
chart.ShadingEffectMode = ShadingEffectMode.Two;
chart.TitleBox.Position = TitleBoxPosition.None;
chart.Title = Title;
//標(biāo)題的顏色
chart.TitleBox.Label.Color = _titleBoxColor;
//標(biāo)題字體設(shè)置
chart.TitleBox.Label.Font = _titleBoxFont;
//圖表說(shuō)明
chart.LegendBox.HeaderLabel = new dotnetCHARTING.WinForms.Label("圖表說(shuō)明", new Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134));
//chart.LegendBox.HeaderLabel.Font = new Font("Microsoft Sans Serif", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
chart.LegendBox.Label.Font = new Font("Microsoft Sans Serif", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
chart.Palette = new Color[] { Color.FromArgb(0, 156, 255), Color.FromArgb(255, 99, 49), Color.FromArgb(49, 255, 49), Color.FromArgb(255, 255, 0), };
chart.Title = Title;
//X軸柱狀圖值字體
chart.XAxis.Label.Text = _xtitle;
chart.XAxis.Label.Font = _xAxisLabelFont;
//設(shè)置X軸刻度值說(shuō)明字體
chart.XAxis.DefaultTick.Label.Font = _xAxisDefaultTickLabelFont;
chart.XAxis.Label.Text = _xtitle;
chart.YAxis.Label.Text = _ytitle;
chart.TempDirectory = _phaysicalimagepath;
chart.Width = _picwidth;
chart.Height = _pichight;
chart.Type = ChartType.Pie;
chart.Series.Type = SeriesType.Cylinder;
chart.Series.Name = _seriesname;
chart.YAxis.NumberPercision = _numberPercision;
chart.ShadingEffect = true;
chart.Use3D = false;
chart.DefaultSeries.DefaultElement.Transparency = 20;//線條透明度
chart.DefaultSeries.DefaultElement.ShowValue = true;
chart.PieLabelMode = dotnetCHARTING.WinForms.PieLabelMode.Outside;
chart.SeriesCollection.Add(GetPieArrayData());
chart.Series.DefaultElement.ShowValue = true;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
}
}
#region 輸出曲線圖
/// <summary>
/// 曲線圖，昨日今日對(duì)比
/// </summary>
/// <returns></returns>
public void CreateLine(Chart chart)
{
try
{
chart.SeriesCollection.Clear();
chart.TitleBox.Position = TitleBoxPosition.None;
//標(biāo)題的顏色
chart.TitleBox.Label.Color = _titleBoxColor;
//標(biāo)題字體設(shè)置
chart.TitleBox.Label.Font = _titleBoxFont;
//圖表背景顏色
chart.ChartArea.Background.Color = ChartAreaBackgroundColor;
//X軸柱狀圖值字體
chart.XAxis.Label.Font = _xAxisLabelFont;
//設(shè)置X軸刻度值說(shuō)明字體
chart.XAxis.DefaultTick.Label.Font = _xAxisDefaultTickLabelFont;
//Y軸柱狀圖值字體
chart.YAxis.Label.Font = _yAxisLabelFont;
//設(shè)置Y軸刻度值說(shuō)明字體
chart.YAxis.DefaultTick.Label.Font = _yAxisDefaultTickLabelFont;
//Y軸箭頭標(biāo)示
chart.YAxis.TickLabelPadding = 0;
chart.YAxis.Line.StartCap = System.Drawing.Drawing2D.LineCap.Square;
chart.YAxis.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
chart.YAxis.Line.Width = 5;//箭頭寬度
chart.YAxis.Line.Color = Color.Gray;
chart.Title = Title;
chart.XAxis.Label.Text = _xtitle;
chart.YAxis.Label.Text = _ytitle;
chart.TempDirectory = _phaysicalimagepath;
// Set the size
chart.Width = _picwidth;
chart.Height = _pichight;
// Set the temp directory
chart.TempDirectory = "temp";
// Debug mode. ( Will show generated errors if any )
chart.Debug = true;
chart.Type = ChartType.Combo;
chart.DefaultSeries.Type = SeriesType.Line;
//chart.Series.Type = SeriesType.Line;
chart.Series.Name = _seriesname;
chart.DefaultSeries.DefaultElement.ShowValue = false;
chart.ShadingEffect = true;
chart.Use3D = false;
chart.Series.DefaultElement.ShowValue = true;
chart.DefaultSeries.DefaultElement.Transparency = 20;//線條透明度
chart.DateGrouping = TimeInterval.Day;
////顯示值格式化(小數(shù)點(diǎn)顯示幾位)
chart.YAxis.NumberPercision = _numberPercision;
chart.OverlapFooter = false;
SeriesCollection mySC = GetRandomData();
mySC[0].DefaultElement.Color = Color.FromArgb(255, 99, 49);
mySC[1].DefaultElement.Color = Color.FromArgb(0, 156, 255);
// Add the random data.
chart.SeriesCollection.Add(mySC);
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
}
}
#endregion
/// <summary>
/// 曲線圖
/// </summary>
/// <returns></returns>
SeriesCollection GetRandomData()
{
SeriesCollection sc = new SeriesCollection();
try
{
DataTable dt = _dt;
var s = new Series();
var s2 = new Series();
switch (SeriesTypeE)
{
case ModelConseme.DateChartEnum.DayChart:
for (int i = 0; i < 24; i++)
{
s.Name = "今天";
s2.Name = "昨天";
Element e = new Element();
// 每元素的名稱
e.Name = (i).ToString();
// 每元素的大小數(shù)值
e.YValue = 0;
Element e2 = new Element();
// 每元素的名稱
e2.Name = (i).ToString();
// 每元素的大小數(shù)值
e2.YValue = 0;
s.Elements.Add(e);
s2.Elements.Add(e2);
sc.Add(s);
sc.Add(s2);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
string sodayHH = dt.Rows[i][1].ToString();
string today = dt.Rows[i][1].ToString().Substring(0, 10);
int HH = Convert.ToInt32(sodayHH.Substring(11));
if (DateTime.Now.ToString("yyyy-MM-dd").Equals(today))
{
sc[0].Elements[HH].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
else
{
sc[1].Elements[HH].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
}
break;
case ModelConseme.DateChartEnum.MonthChart:
for (int i = 1; i < 32; i++)
{
s.Name = "本月";
s2.Name = "上月";
var e = new Element();
// 每元素的名稱
e.Name = (i).ToString();
// 每元素的大小數(shù)值
e.YValue = 0;
var e2 = new Element();
// 每元素的名稱
e2.Name = (i).ToString();
// 每元素的大小數(shù)值
e2.YValue = 0;
s.Elements.Add(e);
s2.Elements.Add(e2);
sc.Add(s);
sc.Add(s2);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
string sodayHH = dt.Rows[i][1].ToString();
string month = dt.Rows[i][1].ToString().Substring(0, 7);
int ovaule = Convert.ToInt32(sodayHH.Substring(8));
if (DateTime.Now.ToString("yyyy-MM").Equals(month))
{
sc[0].Elements[ovaule - 1].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
else
{
sc[1].Elements[ovaule - 1].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
}
break;
case ModelConseme.DateChartEnum.YearChart:
for (int i = 1; i < 13; i++)
{
s.Name = "本年";
s2.Name = "去年";
Element e = new Element();
// 每元素的名稱
e.Name = (i).ToString();
// 每元素的大小數(shù)值
e.YValue = 0;
Element e2 = new Element();
// 每元素的名稱
e2.Name = (i).ToString();
// 每元素的大小數(shù)值
e2.YValue = 0;
s.Elements.Add(e);
s2.Elements.Add(e2);
sc.Add(s);
sc.Add(s2);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
string sodayHH = dt.Rows[i][1].ToString();
string year = dt.Rows[i][1].ToString().Substring(0, 4);
int ovaule = sodayHH.Contains("-") ? Convert.ToInt32(sodayHH.Substring(5)) : Convert.ToInt32(sodayHH.Substring(4));
if (DateTime.Now.ToString("yyyy").Equals(year))
{
sc[0].Elements[ovaule - 1].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
else
{
sc[1].Elements[ovaule - 1].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
}
break;
}
//SC[0].PaletteName = Palette.None;//.Color = Color.FromArgb(49,255,49);
return sc;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
return sc;
}
}
/// <summary>
/// 餅圖
/// </summary>
/// <returns></returns>
private SeriesCollection GetPieArrayData()
{
SeriesCollection sc = new SeriesCollection();
try
{
DataTable dt = _dt;
for (int i = 0; i < dt.Rows.Count; i++)
{
Series s = new Series();
s.Name = dt.Rows[i][1].ToString();
Element e = new Element();
// 每元素的名稱
e.Name = dt.Rows[i][1].ToString();
//設(shè)置柱狀圖值的字體
e.SmartLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
//e.SmartLabel.DynamicDisplay = true;
//e.SmartLabel.AutoWrap = true;
// 每元素的大小數(shù)值
e.YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
//s.PaletteName = Palette.Three;
//s.DefaultElement.Color = Color.FromArgb(49, 255, 49);
s.Elements.Add(e);
sc.Add(s);
}
//SC[0].PaletteName = Palette.Poppies;//.Color = Color.FromArgb(49,255,49);
//SC[0].DefaultElement.Color = Color.FromArgb(49, 255, 49);
//SC[0].DefaultElement.Color = Color.FromArgb(49, 255, 49);
//SC[1].DefaultElement.Color = Color.FromArgb(255, 255, 0);
//SC[2].DefaultElement.Color = Color.FromArgb(255, 99, 49);
//SC[3].DefaultElement.Color = Color.FromArgb(0, 156, 255);
return sc;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
return sc;
}
}
/// <summary>
/// 柱狀圖
/// </summary>
/// <returns></returns>
private SeriesCollection GetArrayData()
{
SeriesCollection sc = new SeriesCollection();
try
{
DataTable dt = _dt;
Series s = new Series();
for (int i = 0; i < dt.Rows.Count; i++)
{
s.Name = dt.Rows[i][1].ToString();
if (s.Name == "") continue;
var e = new Element();
// 每元素的名稱
e.Name = dt.Rows[i][1].ToString();
//設(shè)置柱狀圖值的字體
e.SmartLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
//e.SmartLabel.DynamicDisplay = true;
//e.SmartLabel.AutoWrap = true;
// 每元素的大小數(shù)值
e.YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
//調(diào)整柱子顏色
//s.PaletteName = Palette.Three;
s.Palette = new Color[] { Color.FromArgb(0, 156, 255), Color.FromArgb(255, 99, 49), Color.FromArgb(49, 255, 49), Color.FromArgb(255, 255, 0), };
s.Elements.Add(e);
}
sc.Add(s);
return sc;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
return sc;
}
}
/// <summary>
/// 柱狀圖
/// </summary>
/// <returns></returns>
private SeriesCollection GetArrayData(List<int> list)
{
SeriesCollection sc = new SeriesCollection();
try
{
DataTable dt = _ds.Tables[list[0]];
DataTable dt2 = _ds.Tables[list[1]];
Dictionary<string, string> oilDicT = new Dictionary<string, string>();
Dictionary<string, string> oilDicY = new Dictionary<string, string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
oilDicT.Add(dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString());
}
for (int i = 0; i < dt2.Rows.Count; i++)
{
oilDicY.Add(dt2.Rows[i][1].ToString(), dt2.Rows[i][2].ToString());
}
foreach (KeyValuePair<string, string> keyValue in oilDicT)
{
if (!oilDicY.ContainsKey(keyValue.Key))
{
oilDicY.Add(keyValue.Key, "0");
}
}
foreach (KeyValuePair<string, string> keyValue in oilDicY)
{
if (!oilDicT.ContainsKey(keyValue.Key))
{
oilDicT.Add(keyValue.Key, "0");
}
}
var oiList = new List<Dictionary<string, string>> { oilDicT, oilDicY };
for (int a = 0; a < oiList.Count; a++)
{
var dicN = oiList[a];
Series s = new Series();
switch (SeriesTypeE)
{
case ModelConseme.DateChartEnum.DayChart:
s.Name = a == 0 ? "今天" : "昨天";
break;
case ModelConseme.DateChartEnum.MonthChart:
s.Name = a == 0 ? "本月" : "上月";
break;
case ModelConseme.DateChartEnum.YearChart:
s.Name = a == 0 ? "今年" : "去年";
break;
}
foreach (KeyValuePair<string, string> keyValue in dicN)
{
Element e = new Element();
// 每元素的名稱
e.Name = keyValue.Key;
//設(shè)置柱狀圖值的字體
e.SmartLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F,
System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
//e.SmartLabel.DynamicDisplay = true;
//e.SmartLabel.AutoWrap = true;
// 每元素的大小數(shù)值
e.YValue = Convert.ToDouble(keyValue.Value);
//s.PaletteName = Palette.Poppies;
//s.DefaultElement.Color = Color.FromArgb(49, 255, 49);
s.Elements.Add(e);
}
sc.Add(s);
}
return sc;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
return sc;
}
}
/// <summary>
/// 柱狀圖2
/// </summary>
/// <returns></returns>
private SeriesCollection GetArrayData2()
{
SeriesCollection sc = new SeriesCollection();
try
{
DataTable dt = _dt;
for (int a = 0; a < 2; a++)
{
Series s = new Series();
s.Name = (a == 0 ? "今天" : "昨天");
for (int i = 0; i < dt.Rows.Count; i++)
{
Element e = new Element();
// 每元素的名稱
e.Name = dt.Rows[i][1].ToString();
//設(shè)置柱狀圖值的字體
e.SmartLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
//e.SmartLabel.DynamicDisplay = true;
//e.SmartLabel.AutoWrap = true;
// 每元素的大小數(shù)值
e.YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
s.PaletteName = Palette.Poppies;
//s.DefaultElement.Color = Color.FromArgb(49, 255, 49);
s.Elements.Add(e);
}
sc.Add(s);
}
return sc;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
return sc;
}
}
#endregion
}
}
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using dotnetCHARTING.WinForms;
using StationChart.Model;
using StationChart.Utility;
using Chart = dotnetCHARTING.WinForms.Chart;
using Series = dotnetCHARTING.WinForms.Series;
using SeriesCollection = dotnetCHARTING.WinForms.SeriesCollection;
namespace ManageSystem
{
// <summary>
// 作者：薛江濤
// 版本：V1.0.0
// 時(shí)間：2014/10/9 11:49:48
// </summary>
public class ShowData
{
#region 屬性
private string _phaysicalimagepath;//圖片存放路徑
private string _xtitle;//圖片x座標(biāo)名稱
private string _ytitle;//圖片y座標(biāo)名稱
private string _seriesname;//圖例名稱
private int _picwidth;//圖片寬度
private int _pichight;//圖片高度
private DataTable _dt;//圖片數(shù)據(jù)源
private DataSet _ds;//圖片數(shù)據(jù)源
private Color _titleBoxColor;//圖片標(biāo)題背景色
private Font _titleBoxFont;//圖片標(biāo)題字體
private Color _chartAreaBackgroundColor;//圖片背景顏色
private Font _xAxisLabelFont;//X軸柱狀圖值字體
private Font _yAxisLabelFont;//Y軸柱狀圖值字體
private Font _xAxisDefaultTickLabelFont;//X軸刻度字體
private Font _yAxisDefaultTickLabelFont;//Y軸刻度字體
private SeriesType _chartDefaultSeriesType;//圖片類型
private ChartType _chartType;//圖片類型
//private bool _isMonth; //是否是月顯示
private int _staticColumnWidth;//設(shè)置柱狀圖每個(gè)單元格的寬度
private int _numberPercision;//設(shè)置數(shù)值小數(shù)點(diǎn)
/// <summary>
/// 圖片存放路徑
/// </summary>
public string PhaysicalImagePath
{
set { _phaysicalimagepath = value; }
get { return _phaysicalimagepath; }
}
/// <summary>
/// 圖片標(biāo)題
/// </summary>
public string Title { get; set; }
/// <summary>
/// 圖片標(biāo)題
/// </summary>
public string XTitle
{
set { _xtitle = value; }
get { return _xtitle; }
}
/// <summary>
/// 圖片標(biāo)題
/// </summary>
public string YTitle
{
set { _ytitle = value; }
get { return _ytitle; }
}
/// <summary>
/// 圖例名稱
/// </summary>
public string SeriesName
{
set { _seriesname = value; }
get { return _seriesname; }
}
/// <summary>
/// 圖片寬度
/// </summary>
public int PicWidth
{
set { _picwidth = value; }
get { return _picwidth; }
}
/// <summary>
/// 圖片高度
/// </summary>
public int PicHight
{
set { _pichight = value; }
get { return _pichight; }
}
/// <summary>
/// 圖片數(shù)據(jù)源
/// </summary>
public DataTable DataSource
{
set { _dt = value; }
get { return _dt; }
}
/// <summary>
/// 圖片數(shù)據(jù)源
/// </summary>
public DataSet DataSetSource
{
set { _ds = value; }
get { return _ds; }
}
public int NumberPercision
{
set { _numberPercision = value; }
get { return _numberPercision; }
}
public Color TitleBoxColor
{
get { return _titleBoxColor; }
set { _titleBoxColor = value; }
}
public Font TitleBoxFont
{
get { return _titleBoxFont; }
set { _titleBoxFont = value; }
}
public Color ChartAreaBackgroundColor
{
get { return _chartAreaBackgroundColor; }
set { _chartAreaBackgroundColor = value; }
}
public Font XAxisLabelFont
{
get { return _xAxisLabelFont; }
set { _xAxisLabelFont = value; }
}
public Font YAxisLabelFont
{
get { return _yAxisLabelFont; }
set { _yAxisLabelFont = value; }
}
public Font XAxisDefaultTickLabelFont
{
get { return _xAxisDefaultTickLabelFont; }
set { _xAxisDefaultTickLabelFont = value; }
}
public Font YAxisDefaultTickLabelFont
{
get { return _yAxisDefaultTickLabelFont; }
set { _yAxisDefaultTickLabelFont = value; }
}
public SeriesType ChartDefaultSeriesType
{
get { return _chartDefaultSeriesType; }
set { _chartDefaultSeriesType = value; }
}
public ChartType ChartType
{
get { return _chartType; }
set { _chartType = value; }
}
//public bool IsMonth
//{
// get { return _isMonth; }
// set { _isMonth = value; }
//}
public ModelConseme.DateChartEnum SeriesTypeE { get; set; }
public int StaticColumnWidth
{
get { return _staticColumnWidth; }
set { _staticColumnWidth = value; }
}
#endregion
#region 構(gòu)造函數(shù)
public ShowData()
{
//
// TODO: 在此處添加構(gòu)造函數(shù)邏輯
//
NumberPercision = 2;
}
public ShowData(string phaysicalImagePath, string title, string xTitle, string yTitle, string seriesName)
{
_phaysicalimagepath = phaysicalImagePath;
Title = title;
_xtitle = xTitle;
_ytitle = yTitle;
_seriesname = seriesName;
}
#endregion
private static readonly object ThisLock = new object();
#region 輸出柱形圖
/// <summary>
/// 柱形圖
/// </summary>
/// <returns></returns>
public void CreateColumn(Chart chart)
{
try
{
//清空?qǐng)D片
chart.SeriesCollection.Clear();
//標(biāo)題框設(shè)置
//標(biāo)題的顏色
chart.TitleBox.Label.Color = _titleBoxColor;
//標(biāo)題字體設(shè)置
chart.TitleBox.Label.Font = _titleBoxFont;
//控制柱狀圖顏色
chart.ShadingEffectMode = ShadingEffectMode.One;
chart.TitleBox.Position = TitleBoxPosition.None;
//圖表背景顏色
chart.ChartArea.Background.Color = ChartAreaBackgroundColor;
//1.圖表類型
chart.DefaultSeries.Type = _chartDefaultSeriesType;// SeriesType.Column;
//chart.DefaultSeries.Type = SeriesType.Cylinder;
//2.圖表類型
//柱狀圖
//chart.Type = ChartType.TreeMap;
////橫向柱狀圖
chart.Type = _chartType;// ChartType.ComboHorizontal
////橫向柱狀圖
//chart.Type =_chartType;// ChartType.Gantt;
////餅狀圖
//chart.Type = ChartType.Pies;
//y軸圖表陰影顏色
//chart.YAxis.AlternateGridBackground.Color = Color.FromArgb(255, 250, 250, 250);
chart.LegendBox.HeaderLabel = new Label("圖表說(shuō)明", new Font("Microsoft Sans Serif", 10F, FontStyle.Bold, GraphicsUnit.Point, 134));
//chart.LegendBox.HeaderLabel.Font = new Font("Microsoft Sans Serif", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
chart.LegendBox.Label.Font = new Font("Microsoft Sans Serif", 9F, FontStyle.Bold, GraphicsUnit.Point, 134);
chart.Palette = new Color[] { Color.FromArgb(0, 156, 255), Color.FromArgb(255, 99, 49), Color.FromArgb(49, 255, 49), Color.FromArgb(255, 255, 0), };
chart.Title = Title;
//X軸柱狀圖值字體
chart.XAxis.Label.Text = _xtitle;
chart.XAxis.Label.Font = _xAxisLabelFont;
//設(shè)置X軸刻度值說(shuō)明字體
chart.XAxis.DefaultTick.Label.Font = _xAxisDefaultTickLabelFont;
chart.XAxis.StaticColumnWidth = _staticColumnWidth; //每個(gè)單元格的寬度
//Y軸柱狀圖值字體
chart.YAxis.Label.Text = _ytitle;
chart.YAxis.Label.Font = _yAxisLabelFont;
//設(shè)置Y軸刻度值說(shuō)明字體
chart.YAxis.DefaultTick.Label.Font = _yAxisDefaultTickLabelFont;
//Y軸箭頭標(biāo)示
chart.XAxis.Name = XTitle;
if (_chartType == ChartType.ComboHorizontal)
{
chart.XAxis.TickLabelPadding = 10;
chart.XAxis.Line.StartCap = System.Drawing.Drawing2D.LineCap.Square;
chart.XAxis.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
chart.XAxis.Line.Width = 5;//箭頭寬度
chart.XAxis.Line.Color = Color.Gray;
}
else
{
chart.YAxis.TickLabelPadding = 10;
chart.YAxis.Line.StartCap = System.Drawing.Drawing2D.LineCap.Square;
chart.YAxis.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
chart.YAxis.Line.Width = 5;//箭頭寬度
chart.YAxis.Line.Color = Color.Gray;
//顯示值格式化(小數(shù)點(diǎn)顯示幾位)
chart.YAxis.NumberPercision = _numberPercision;
}
//圖片存放路徑
chart.TempDirectory = System.Environment.CurrentDirectory + "\\" + _phaysicalimagepath;
//圖表寬度
chart.Width = _picwidth;
//圖表高度
chart.Height = _pichight;
chart.Series.Name = _seriesname;
//單一圖形
//chart.Series.Data = _dt;
//chart.SeriesCollection.Add();
//圖例在標(biāo)題行顯示，但是沒(méi)有合計(jì)信息
//chart.TitleBox.Position = TitleBoxPosition.FullWithLegend;
//chart.TitleBox.Label.Alignment = StringAlignment.Center;
//chart.LegendBox.Position = LegendBoxPosition.None; //不顯示圖例,指不在右側(cè)顯示，對(duì)上面一行的屬性設(shè)置并沒(méi)有影響
chart.DefaultSeries.DefaultElement.ShowValue = true;
chart.ShadingEffect = true;
chart.Use3D = false;
chart.Series.DefaultElement.ShowValue = true;
chart.SeriesCollection.Add(GetArrayData());
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
}
}
/// <summary>
/// 柱形圖
/// </summary>
/// <returns></returns>
public void CreateColumn(Chart chart, List<int> list)
{
try
{
chart.SeriesCollection.Clear();
//標(biāo)題框設(shè)置
//標(biāo)題的顏色
chart.TitleBox.Label.Color = _titleBoxColor;
//標(biāo)題字體設(shè)置
chart.TitleBox.Label.Font = _titleBoxFont;
//控制柱狀圖顏色
chart.ShadingEffectMode = ShadingEffectMode.Five;
//圖表背景顏色
chart.ChartArea.Background.Color = ChartAreaBackgroundColor;
//1.圖表類型
chart.DefaultSeries.Type = _chartDefaultSeriesType;// SeriesType.Column;
//chart.DefaultSeries.Type = SeriesType.Cylinder;
//2.圖表類型
//柱狀圖
//chart.Type = ChartType.TreeMap;
////橫向柱狀圖
chart.Type = _chartType;// ChartType.ComboHorizontal
////橫向柱狀圖
//chart.Type =_chartType;// ChartType.Gantt;
////餅狀圖
//chart.Type = ChartType.Pies;
//y軸圖表陰影顏色
//chart.YAxis.AlternateGridBackground.Color = Color.FromArgb(255, 250, 250, 250);
chart.LegendBox.HeaderLabel = new Label("圖表說(shuō)明", new Font("Microsoft Sans Serif", 10F, FontStyle.Bold, GraphicsUnit.Point, 134));
//chart.LegendBox.HeaderLabel.Font = new Font("Microsoft Sans Serif", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
chart.LegendBox.Label.Font = new Font("Microsoft Sans Serif", 9F, FontStyle.Bold, GraphicsUnit.Point, 134);
chart.Palette = new Color[] { Color.FromArgb(0, 156, 255), Color.FromArgb(255, 99, 49), Color.FromArgb(49, 255, 49), Color.FromArgb(255, 255, 0), };
chart.Title = Title;
//X軸柱狀圖值字體
chart.XAxis.Label.Text = _xtitle;
chart.XAxis.Label.Font = _xAxisLabelFont;
//設(shè)置X軸刻度值說(shuō)明字體
chart.XAxis.DefaultTick.Label.Font = _xAxisDefaultTickLabelFont;
chart.XAxis.StaticColumnWidth = _staticColumnWidth; //每個(gè)單元格的寬度
//Y軸柱狀圖值字體
chart.YAxis.Label.Text = _ytitle;
chart.YAxis.Label.Font = _yAxisLabelFont;
//設(shè)置Y軸刻度值說(shuō)明字體
chart.YAxis.DefaultTick.Label.Font = _yAxisDefaultTickLabelFont;
//Y軸箭頭標(biāo)示
chart.XAxis.Name = XTitle;
if (_chartType == dotnetCHARTING.WinForms.ChartType.ComboHorizontal)
{
chart.XAxis.TickLabelPadding = 10;
chart.XAxis.Line.StartCap = System.Drawing.Drawing2D.LineCap.Square;
chart.XAxis.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
chart.XAxis.Line.Width = 5;//箭頭寬度
chart.XAxis.Line.Color = Color.Gray;
}
else
{
chart.YAxis.TickLabelPadding = 10;
chart.YAxis.Line.StartCap = System.Drawing.Drawing2D.LineCap.Square;
chart.YAxis.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
chart.YAxis.Line.Width = 5;//箭頭寬度
chart.YAxis.Line.Color = Color.Gray;
//顯示值格式化(小數(shù)點(diǎn)顯示幾位)
chart.YAxis.NumberPercision = _numberPercision;
}
//圖片存放路徑
chart.TempDirectory = System.Environment.CurrentDirectory + "\\" + _phaysicalimagepath;
//圖表寬度
chart.Width = _picwidth;
//圖表高度
chart.Height = _pichight;
chart.Series.Name = _seriesname;
//單一圖形
//chart.Series.Data = _dt;
//chart.SeriesCollection.Add();
//圖例在標(biāo)題行顯示，但是沒(méi)有合計(jì)信息
//chart.TitleBox.Position = TitleBoxPosition.FullWithLegend;
//chart.TitleBox.Label.Alignment = StringAlignment.Center;
//chart.LegendBox.Position = LegendBoxPosition.None; //不顯示圖例,指不在右側(cè)顯示，對(duì)上面一行的屬性設(shè)置并沒(méi)有影響
chart.DefaultSeries.DefaultElement.ShowValue = true;
chart.ShadingEffect = true;
chart.Use3D = false;
chart.Series.DefaultElement.ShowValue = true;
chart.SeriesCollection.Add(GetArrayData(list));
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
}
}
///// <summary>
///// 柱形圖,單一圖片
///// </summary>
///// <returns></returns>
//public void CreateColumn(Chart chart1)
//{
// Chart1.Title = _title;
// Chart1.XAxis.Label.Text = _xtitle;
// Chart1.YAxis.Label.Text = _ytitle;
// Chart1.TempDirectory = PhaysicalImagePath;
// Chart1.Width = _picwidth;
// Chart1.Height = _pichight;
// Chart1.Type = ChartType.Combo;
// Chart1.Series.Type = SeriesType.Cylinder;
// Chart1.Series.Name = _seriesname;
// Chart1.Series.Data = _dt;
// Chart1.SeriesCollection.Add();
// Chart1.DefaultSeries.DefaultElement.ShowValue = true;
// Chart1.ShadingEffect = true;
// Chart1.Use3D = false;
// Chart1.Series.DefaultElement.ShowValue = true;
//}
#endregion
#region 輸出餅圖
/// <summary>
/// 餅圖
/// </summary>
/// <returns></returns>
public void CreatePie(Chart chart)
{
try
{
chart.SeriesCollection.Clear();
//控制餅圖顏色
chart.ShadingEffectMode = ShadingEffectMode.Two;
chart.TitleBox.Position = TitleBoxPosition.None;
chart.Title = Title;
//標(biāo)題的顏色
chart.TitleBox.Label.Color = _titleBoxColor;
//標(biāo)題字體設(shè)置
chart.TitleBox.Label.Font = _titleBoxFont;
//圖表說(shuō)明
chart.LegendBox.HeaderLabel = new dotnetCHARTING.WinForms.Label("圖表說(shuō)明", new Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134));
//chart.LegendBox.HeaderLabel.Font = new Font("Microsoft Sans Serif", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
chart.LegendBox.Label.Font = new Font("Microsoft Sans Serif", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
chart.Palette = new Color[] { Color.FromArgb(0, 156, 255), Color.FromArgb(255, 99, 49), Color.FromArgb(49, 255, 49), Color.FromArgb(255, 255, 0), };
chart.Title = Title;
//X軸柱狀圖值字體
chart.XAxis.Label.Text = _xtitle;
chart.XAxis.Label.Font = _xAxisLabelFont;
//設(shè)置X軸刻度值說(shuō)明字體
chart.XAxis.DefaultTick.Label.Font = _xAxisDefaultTickLabelFont;
chart.XAxis.Label.Text = _xtitle;
chart.YAxis.Label.Text = _ytitle;
chart.TempDirectory = _phaysicalimagepath;
chart.Width = _picwidth;
chart.Height = _pichight;
chart.Type = ChartType.Pie;
chart.Series.Type = SeriesType.Cylinder;
chart.Series.Name = _seriesname;
chart.YAxis.NumberPercision = _numberPercision;
chart.ShadingEffect = true;
chart.Use3D = false;
chart.DefaultSeries.DefaultElement.Transparency = 20;//線條透明度
chart.DefaultSeries.DefaultElement.ShowValue = true;
chart.PieLabelMode = dotnetCHARTING.WinForms.PieLabelMode.Outside;
chart.SeriesCollection.Add(GetPieArrayData());
chart.Series.DefaultElement.ShowValue = true;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
}
}
#region 輸出曲線圖
/// <summary>
/// 曲線圖，昨日今日對(duì)比
/// </summary>
/// <returns></returns>
public void CreateLine(Chart chart)
{
try
{
chart.SeriesCollection.Clear();
chart.TitleBox.Position = TitleBoxPosition.None;
//標(biāo)題的顏色
chart.TitleBox.Label.Color = _titleBoxColor;
//標(biāo)題字體設(shè)置
chart.TitleBox.Label.Font = _titleBoxFont;
//圖表背景顏色
chart.ChartArea.Background.Color = ChartAreaBackgroundColor;
//X軸柱狀圖值字體
chart.XAxis.Label.Font = _xAxisLabelFont;
//設(shè)置X軸刻度值說(shuō)明字體
chart.XAxis.DefaultTick.Label.Font = _xAxisDefaultTickLabelFont;
//Y軸柱狀圖值字體
chart.YAxis.Label.Font = _yAxisLabelFont;
//設(shè)置Y軸刻度值說(shuō)明字體
chart.YAxis.DefaultTick.Label.Font = _yAxisDefaultTickLabelFont;
//Y軸箭頭標(biāo)示
chart.YAxis.TickLabelPadding = 0;
chart.YAxis.Line.StartCap = System.Drawing.Drawing2D.LineCap.Square;
chart.YAxis.Line.EndCap = System.Drawing.Drawing2D.LineCap.ArrowAnchor;
chart.YAxis.Line.Width = 5;//箭頭寬度
chart.YAxis.Line.Color = Color.Gray;
chart.Title = Title;
chart.XAxis.Label.Text = _xtitle;
chart.YAxis.Label.Text = _ytitle;
chart.TempDirectory = _phaysicalimagepath;
// Set the size
chart.Width = _picwidth;
chart.Height = _pichight;
// Set the temp directory
chart.TempDirectory = "temp";
// Debug mode. ( Will show generated errors if any )
chart.Debug = true;
chart.Type = ChartType.Combo;
chart.DefaultSeries.Type = SeriesType.Line;
//chart.Series.Type = SeriesType.Line;
chart.Series.Name = _seriesname;
chart.DefaultSeries.DefaultElement.ShowValue = false;
chart.ShadingEffect = true;
chart.Use3D = false;
chart.Series.DefaultElement.ShowValue = true;
chart.DefaultSeries.DefaultElement.Transparency = 20;//線條透明度
chart.DateGrouping = TimeInterval.Day;
////顯示值格式化(小數(shù)點(diǎn)顯示幾位)
chart.YAxis.NumberPercision = _numberPercision;
chart.OverlapFooter = false;
SeriesCollection mySC = GetRandomData();
mySC[0].DefaultElement.Color = Color.FromArgb(255, 99, 49);
mySC[1].DefaultElement.Color = Color.FromArgb(0, 156, 255);
// Add the random data.
chart.SeriesCollection.Add(mySC);
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
}
}
#endregion
/// <summary>
/// 曲線圖
/// </summary>
/// <returns></returns>
SeriesCollection GetRandomData()
{
SeriesCollection sc = new SeriesCollection();
try
{
DataTable dt = _dt;
var s = new Series();
var s2 = new Series();
switch (SeriesTypeE)
{
case ModelConseme.DateChartEnum.DayChart:
for (int i = 0; i < 24; i++)
{
s.Name = "今天";
s2.Name = "昨天";
Element e = new Element();
// 每元素的名稱
e.Name = (i).ToString();
// 每元素的大小數(shù)值
e.YValue = 0;
Element e2 = new Element();
// 每元素的名稱
e2.Name = (i).ToString();
// 每元素的大小數(shù)值
e2.YValue = 0;
s.Elements.Add(e);
s2.Elements.Add(e2);
sc.Add(s);
sc.Add(s2);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
string sodayHH = dt.Rows[i][1].ToString();
string today = dt.Rows[i][1].ToString().Substring(0, 10);
int HH = Convert.ToInt32(sodayHH.Substring(11));
if (DateTime.Now.ToString("yyyy-MM-dd").Equals(today))
{
sc[0].Elements[HH].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
else
{
sc[1].Elements[HH].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
}
break;
case ModelConseme.DateChartEnum.MonthChart:
for (int i = 1; i < 32; i++)
{
s.Name = "本月";
s2.Name = "上月";
var e = new Element();
// 每元素的名稱
e.Name = (i).ToString();
// 每元素的大小數(shù)值
e.YValue = 0;
var e2 = new Element();
// 每元素的名稱
e2.Name = (i).ToString();
// 每元素的大小數(shù)值
e2.YValue = 0;
s.Elements.Add(e);
s2.Elements.Add(e2);
sc.Add(s);
sc.Add(s2);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
string sodayHH = dt.Rows[i][1].ToString();
string month = dt.Rows[i][1].ToString().Substring(0, 7);
int ovaule = Convert.ToInt32(sodayHH.Substring(8));
if (DateTime.Now.ToString("yyyy-MM").Equals(month))
{
sc[0].Elements[ovaule - 1].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
else
{
sc[1].Elements[ovaule - 1].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
}
break;
case ModelConseme.DateChartEnum.YearChart:
for (int i = 1; i < 13; i++)
{
s.Name = "本年";
s2.Name = "去年";
Element e = new Element();
// 每元素的名稱
e.Name = (i).ToString();
// 每元素的大小數(shù)值
e.YValue = 0;
Element e2 = new Element();
// 每元素的名稱
e2.Name = (i).ToString();
// 每元素的大小數(shù)值
e2.YValue = 0;
s.Elements.Add(e);
s2.Elements.Add(e2);
sc.Add(s);
sc.Add(s2);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
string sodayHH = dt.Rows[i][1].ToString();
string year = dt.Rows[i][1].ToString().Substring(0, 4);
int ovaule = sodayHH.Contains("-") ? Convert.ToInt32(sodayHH.Substring(5)) : Convert.ToInt32(sodayHH.Substring(4));
if (DateTime.Now.ToString("yyyy").Equals(year))
{
sc[0].Elements[ovaule - 1].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
else
{
sc[1].Elements[ovaule - 1].YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
}
}
break;
}
//SC[0].PaletteName = Palette.None;//.Color = Color.FromArgb(49,255,49);
return sc;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
return sc;
}
}
/// <summary>
/// 餅圖
/// </summary>
/// <returns></returns>
private SeriesCollection GetPieArrayData()
{
SeriesCollection sc = new SeriesCollection();
try
{
DataTable dt = _dt;
for (int i = 0; i < dt.Rows.Count; i++)
{
Series s = new Series();
s.Name = dt.Rows[i][1].ToString();
Element e = new Element();
// 每元素的名稱
e.Name = dt.Rows[i][1].ToString();
//設(shè)置柱狀圖值的字體
e.SmartLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
//e.SmartLabel.DynamicDisplay = true;
//e.SmartLabel.AutoWrap = true;
// 每元素的大小數(shù)值
e.YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
//s.PaletteName = Palette.Three;
//s.DefaultElement.Color = Color.FromArgb(49, 255, 49);
s.Elements.Add(e);
sc.Add(s);
}
//SC[0].PaletteName = Palette.Poppies;//.Color = Color.FromArgb(49,255,49);
//SC[0].DefaultElement.Color = Color.FromArgb(49, 255, 49);
//SC[0].DefaultElement.Color = Color.FromArgb(49, 255, 49);
//SC[1].DefaultElement.Color = Color.FromArgb(255, 255, 0);
//SC[2].DefaultElement.Color = Color.FromArgb(255, 99, 49);
//SC[3].DefaultElement.Color = Color.FromArgb(0, 156, 255);
return sc;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
return sc;
}
}
/// <summary>
/// 柱狀圖
/// </summary>
/// <returns></returns>
private SeriesCollection GetArrayData()
{
SeriesCollection sc = new SeriesCollection();
try
{
DataTable dt = _dt;
Series s = new Series();
for (int i = 0; i < dt.Rows.Count; i++)
{
s.Name = dt.Rows[i][1].ToString();
if (s.Name == "") continue;
var e = new Element();
// 每元素的名稱
e.Name = dt.Rows[i][1].ToString();
//設(shè)置柱狀圖值的字體
e.SmartLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
//e.SmartLabel.DynamicDisplay = true;
//e.SmartLabel.AutoWrap = true;
// 每元素的大小數(shù)值
e.YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
//調(diào)整柱子顏色
//s.PaletteName = Palette.Three;
s.Palette = new Color[] { Color.FromArgb(0, 156, 255), Color.FromArgb(255, 99, 49), Color.FromArgb(49, 255, 49), Color.FromArgb(255, 255, 0), };
s.Elements.Add(e);
}
sc.Add(s);
return sc;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
return sc;
}
}
/// <summary>
/// 柱狀圖
/// </summary>
/// <returns></returns>
private SeriesCollection GetArrayData(List<int> list)
{
SeriesCollection sc = new SeriesCollection();
try
{
DataTable dt = _ds.Tables[list[0]];
DataTable dt2 = _ds.Tables[list[1]];
Dictionary<string, string> oilDicT = new Dictionary<string, string>();
Dictionary<string, string> oilDicY = new Dictionary<string, string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
oilDicT.Add(dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString());
}
for (int i = 0; i < dt2.Rows.Count; i++)
{
oilDicY.Add(dt2.Rows[i][1].ToString(), dt2.Rows[i][2].ToString());
}
foreach (KeyValuePair<string, string> keyValue in oilDicT)
{
if (!oilDicY.ContainsKey(keyValue.Key))
{
oilDicY.Add(keyValue.Key, "0");
}
}
foreach (KeyValuePair<string, string> keyValue in oilDicY)
{
if (!oilDicT.ContainsKey(keyValue.Key))
{
oilDicT.Add(keyValue.Key, "0");
}
}
var oiList = new List<Dictionary<string, string>> { oilDicT, oilDicY };
for (int a = 0; a < oiList.Count; a++)
{
var dicN = oiList[a];
Series s = new Series();
switch (SeriesTypeE)
{
case ModelConseme.DateChartEnum.DayChart:
s.Name = a == 0 ? "今天" : "昨天";
break;
case ModelConseme.DateChartEnum.MonthChart:
s.Name = a == 0 ? "本月" : "上月";
break;
case ModelConseme.DateChartEnum.YearChart:
s.Name = a == 0 ? "今年" : "去年";
break;
}
foreach (KeyValuePair<string, string> keyValue in dicN)
{
Element e = new Element();
// 每元素的名稱
e.Name = keyValue.Key;
//設(shè)置柱狀圖值的字體
e.SmartLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F,
System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
//e.SmartLabel.DynamicDisplay = true;
//e.SmartLabel.AutoWrap = true;
// 每元素的大小數(shù)值
e.YValue = Convert.ToDouble(keyValue.Value);
//s.PaletteName = Palette.Poppies;
//s.DefaultElement.Color = Color.FromArgb(49, 255, 49);
s.Elements.Add(e);
}
sc.Add(s);
}
return sc;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
return sc;
}
}
/// <summary>
/// 柱狀圖2
/// </summary>
/// <returns></returns>
private SeriesCollection GetArrayData2()
{
SeriesCollection sc = new SeriesCollection();
try
{
DataTable dt = _dt;
for (int a = 0; a < 2; a++)
{
Series s = new Series();
s.Name = (a == 0 ? "今天" : "昨天");
for (int i = 0; i < dt.Rows.Count; i++)
{
Element e = new Element();
// 每元素的名稱
e.Name = dt.Rows[i][1].ToString();
//設(shè)置柱狀圖值的字體
e.SmartLabel.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, 134);
//e.SmartLabel.DynamicDisplay = true;
//e.SmartLabel.AutoWrap = true;
// 每元素的大小數(shù)值
e.YValue = Convert.ToDouble(dt.Rows[i][2].ToString());
s.PaletteName = Palette.Poppies;
//s.DefaultElement.Color = Color.FromArgb(49, 255, 49);
s.Elements.Add(e);
}
sc.Add(s);
}
return sc;
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex.ToString(), ex);
return sc;
}
}
#endregion
}
}
調(diào)用方法：
復(fù)制代碼 代碼如下:
ShowData show = new ShowData();
//show.PicHight = 494;
//show.PicWidth = 1336;
show.SeriesName = "具體詳情";
show.PhaysicalImagePath = "ChartImages";
show.TitleBoxColor = Color.Blue;
show.TitleBoxFont = new Font("Arial", 10, FontStyle.Bold);
show.ChartAreaBackgroundColor = Color.Honeydew;
show.XAxisLabelFont = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
show.YAxisLabelFont = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
show.XAxisDefaultTickLabelFont = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
show.YAxisDefaultTickLabelFont = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
show.ChartDefaultSeriesType = SeriesType.Column;
show.DataSetSource = dsSet;
show.SeriesTypeE = modelConseme.DateChart;
//show.PicHight = 494;
//show.PicWidth = 1336;
show.SeriesName = "具體詳情";
show.PhaysicalImagePath = "ChartImages";
show.TitleBoxColor = Color.Blue;
show.TitleBoxFont = new Font("Arial", 10, FontStyle.Bold);
show.ChartAreaBackgroundColor = Color.Honeydew;
show.XAxisLabelFont = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
show.YAxisLabelFont = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
show.XAxisDefaultTickLabelFont = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
show.YAxisDefaultTickLabelFont = new System.Drawing.Font("Microsoft Sans Serif", 10F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
show.ChartDefaultSeriesType = SeriesType.Column;
show.DataSetSource = dsSet;
show.SeriesTypeE = modelConseme.DateChart;
//餅圖
show.YTitle = "油量(升)";
//show.Title = strOils + strDate + strConsume + "銷售油量報(bào)表統(tǒng)計(jì)圖";
show.XTitle = "";
show.DataSource = dsSet.Tables[0];
show.CreatePie(this.chart1);
//柱狀圖（兩條柱子對(duì)比）
show.YTitle = "油量(升)";
label2.Text = strDate + strOils + strConsume + @"油品對(duì)比圖";
show.XTitle = "油品";
//show.DataSource = dsSet.Tables[2];
show.StaticColumnWidth = 0;
show.CreateColumn(chart2, new List<int>()
{
0,
1
});
//曲線圖
show.YTitle = "油量(升)";
label5.Text = strDate + strOils + strConsume + @"油量環(huán)比圖";
show.XTitle = "時(shí)間";
show.DataSource = dsSet.Tables[4];
show.CreateLine(this.chart5);
//單個(gè)柱子
var show = new ShowData
{
Title = "近30天加油會(huì)員統(tǒng)計(jì)",
XTitle = "人數(shù)",
YTitle = "會(huì)員分類",
SeriesName = "具體詳情",
PhaysicalImagePath = "ChartImages",
DataSource = dsSet.Tables[0],
TitleBoxColor = Color.Blue,
TitleBoxFont = new Font("Arial", 10, FontStyle.Bold),
ChartAreaBackgroundColor = Color.Honeydew,
XAxisLabelFont = new Font("Microsoft Sans Serif", 10F, FontStyle.Bold, GraphicsUnit.Point, 134),
YAxisLabelFont = new Font("Microsoft Sans Serif", 10F, FontStyle.Bold, GraphicsUnit.Point, 134),
XAxisDefaultTickLabelFont =
new Font("Microsoft Sans Serif", 10F, FontStyle.Bold, GraphicsUnit.Point, 134),
YAxisDefaultTickLabelFont =
new Font("Microsoft Sans Serif", 10F, FontStyle.Bold, GraphicsUnit.Point, 134),
ChartDefaultSeriesType = SeriesType.Column,
ChartType = ChartType.ComboHorizontal,
StaticColumnWidth = 80
};
show.CreateColumn(chart1);
show.NumberPercision = 0;
show.CreatePie(chart2);
運(yùn)行效果圖如下：
希望本文所述對(duì)大家的C#程序設(shè)計(jì)有所幫助。
相關(guān)文章
這篇文章主要介紹了C#與java TCP通道加密通信，文章通過(guò)真實(shí)的案例詳細(xì)講解說(shuō)明C#與java TCP通道加密通信的相關(guān)資料，需要的小伙伴可以參考一下2021-10-10
C#開(kāi)發(fā)Windows UWP系列之布局面板RelativePanel
這篇文章介紹了C#開(kāi)發(fā)Windows UWP系列之布局面板RelativePanel，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2022-06-06
淺談C#單例模式的實(shí)現(xiàn)和性能對(duì)比
這篇文章主要介紹了淺談C#單例模式的實(shí)現(xiàn)和性能對(duì)比的相關(guān)資料,詳細(xì)的介紹了6種實(shí)現(xiàn)方式，需要的朋友可以參考下2017-09-09
基于C# wpf 實(shí)現(xiàn)Grid內(nèi)控件拖動(dòng)詳情
這篇文章主要介紹了基于C# wpf 實(shí)現(xiàn)Grid內(nèi)控件拖動(dòng),有一些業(yè)務(wù)場(chǎng)景中我們需要拖動(dòng)控件，在Grid中就可以實(shí)現(xiàn)控件拖動(dòng)，通過(guò)設(shè)置Margin屬性即可,下面文章我們來(lái)看看具體的實(shí)現(xiàn)內(nèi)容2021-11-11
本篇文章是對(duì)C#中XmlReader讀取Xml進(jìn)行了詳細(xì)的分析介紹，需要的朋友參考下2013-05-05
C#中out參數(shù)、ref參數(shù)與值參數(shù)的用法及區(qū)別
這篇文章主要給大家介紹了關(guān)于C#中out參數(shù)、ref參數(shù)與值參數(shù)的用法及區(qū)別的相關(guān)資料，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2018-09-09
這篇文章主要介紹了C#實(shí)現(xiàn)的SQL備份與還原功能,結(jié)合具體實(shí)例形式分析了C#操作數(shù)據(jù)庫(kù)實(shí)現(xiàn)SQL備份與還原相關(guān)的控件、SQL連接、文件等操作技巧,需要的朋友可以參考下2017-06-06
這篇文章主要介紹了C#不可變類型,對(duì)于C#程序員深入理解string數(shù)據(jù)類型有很大的幫助,需要的朋友可以參考下2014-08-08
C# 控件屬性和InitializeComponent()關(guān)系案例詳解
這篇文章主要介紹了C# 控件屬性和InitializeComponent()關(guān)系案例詳解,本篇文章通過(guò)簡(jiǎn)要的案例,講解了該項(xiàng)技術(shù)的了解與使用,以下就是詳細(xì)內(nèi)容,需要的朋友可以參考下2021-08-08
這篇文章主要介紹了C#屬性(Attribute)用法實(shí)例解析,需要的朋友可以參考下2014-08-08