利用饼型图分析产品市场占有率 实例 附源码

    public partial class Frm_Main : Form
    {
        static int SumNum;
        static float TimeNum;
        SqlConnection con;
        SqlCommand cmd;
        Hashtable ht = new Hashtable();
        public Frm_Main()
        {
            InitializeComponent();
        }
        private void Conn()
        {
            con = new SqlConnection("server=WRET-MOSY688YVW\\MRGLL;UID=sa;Pwd=hbyt2008!@#;database=db_TomeOne");
            con.Open();
        }

        private void showPic(float f, Brush B)
        {
            Graphics g = this.panel1.CreateGraphics();					//通过panel1控件创建一个Graphics对象
            if (TimeNum == 0.0f)
            {
                g.FillPie(B, 0, 0, this.panel1.Width, this.panel1.Height, 0, f * 360);//绘制扇形
            }
            else
            {
                g.FillPie(B, 0, 0, this.panel1.Width, this.panel1.Height, TimeNum, f * 360);
            }
            TimeNum  = f * 360;
        }
        private void Form1_Paint(object sender, PaintEventArgs e)			//在Paint事件中绘制窗体
        {
            ht.Clear();
            Conn();											//连接数据库
            Random rnd = new Random();								//生成随机数
            using (cmd = new SqlCommand("select t_Name,sum(t_Num) as Num  from tb_product group by t_Name", con))
            {
                Graphics g2 = this.panel2.CreateGraphics();				//通过panel2控件创建一个Graphics对象
                SqlDataReader dr = cmd.ExecuteReader();					//创建SqlDataReader对象
                while (dr.Read())									//读取数据
                {
                    ht.Add(dr[0], Convert.ToInt32(dr[1]));					//将数据添加到Hashtable中
                }
                float[] flo = new float[ht.Count];
                int T = 0;
                foreach (DictionaryEntry de in ht)						//遍历Hashtable
                {
                    flo[T] = Convert.ToSingle((Convert.ToDouble(de.Value) / SumNum).ToString().Substring(0, 6));
                    Brush Bru = new SolidBrush(Color.FromArgb(rnd.Next(255), rnd.Next(255), rnd.Next(255)));
                    //绘制商品及百分比
                    g2.DrawString(de.Key   "  "   flo[T] * 100   "%", new Font("Arial", 8, FontStyle.Regular), Bru, 7, 5   T * 18);
                    showPic(flo[T], Bru);							//调用showPic方法绘制饼型图
                    T  ;
                }
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            Conn();
            using (cmd = new SqlCommand("select Sum(t_Num)  from tb_product", con))
            {
               SumNum=Convert.ToInt32(cmd.ExecuteScalar());
            }
        }
    }

资源下载

此资源下载价格为2D币（VIP免费），请先登录

资源文件列表

CAnalyseGoodsScale.sln , 944
CAnalyseGoodsScale.suo , 18944
CAnalyseGoodsScale/bin/Debug/CAnalyseGoodsScale.exe , 11264
CAnalyseGoodsScale/bin/Debug/CAnalyseGoodsScale.pdb , 24064
CAnalyseGoodsScale/CAnalyseGoodsScale.csproj , 4040
CAnalyseGoodsScale/Frm_Main.cs , 3086
CAnalyseGoodsScale/Frm_Main.designer.cs , 3504
CAnalyseGoodsScale/Frm_Main.resx , 5814
CAnalyseGoodsScale/obj/Debug/CAnalyseGoodsScale.csproj.FileListAbsolute.txt , 5145
CAnalyseGoodsScale/obj/Debug/CAnalyseGoodsScale.csproj.GenerateResource.Cache , 850
CAnalyseGoodsScale/obj/Debug/CAnalyseGoodsScale.csprojResolveAssemblyReference.cache , 1757
CAnalyseGoodsScale/obj/Debug/CAnalyseGoodsScale.exe , 11264
CAnalyseGoodsScale/obj/Debug/CAnalyseGoodsScale.Frm_Main.resources , 180
CAnalyseGoodsScale/obj/Debug/CAnalyseGoodsScale.pdb , 24064
CAnalyseGoodsScale/obj/Debug/CAnalyseGoodsScale.Properties.Resources.resources , 180
CAnalyseGoodsScale/obj/Debug/DesignTimeResolveAssemblyReferences.cache , 789
CAnalyseGoodsScale/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache , 7200
CAnalyseGoodsScale/obj/Debug/TempPE/Properties.Resources.Designer.cs.dll , 4608
CAnalyseGoodsScale/obj/Debug/└√╙├▒²╨══╝╖╓╬÷▓·╞╖╩╨│í╒╝╙╨┬╩.csproj.FileListAbsolute.txt , 2111
CAnalyseGoodsScale/Program.cs , 502
CAnalyseGoodsScale/Properties/AssemblyInfo.cs , 1368
CAnalyseGoodsScale/Properties/Resources.Designer.cs , 2876
CAnalyseGoodsScale/Properties/Resources.resx , 5612
CAnalyseGoodsScale/Properties/Settings.Designer.cs , 1118
CAnalyseGoodsScale/Properties/Settings.settings , 249
└√╙├▒²╨══╝╖╓╬÷▓·╞╖╩╨│í╒╝╙╨┬╩.suo , 28160