佛系糖果的博客

private void Frm_Main_MouseUp(object sender, MouseEventArgs e)
{
    Graphics myGraphics = this.CreateGraphics();	//创建窗体的Graphics对象
    Cursor.Draw(myGraphics, new Rectangle(e.X, e.Y, 10, 10));		//调用Cursor类的Draw方法抓取鼠标形状
}

private void Frm_Main_Load(object sender, EventArgs e)
{
//截取图片所在的文件路径
    strPath = Application.StartupPath.Substring(0, Application.StartupPath.Substring(0, Application.StartupPath.LastIndexOf("\\\")).LastIndexOf("\\\"));
    pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; 	//设置图片的显示类型
    pictureBox1.Image = Image.FromFile(strPath + @"\\image\\1.jpg");//为pictureBox1设置显示的图片
}
private void timer1_Tick(object sender, EventArgs e)
{
    Random r = new Random(); //声明一个随机类的对象
    pictureBox1.Image = Image.FromFile(strPath + @"\\image\\" + r.Next(1, 5) + ".jpg");	//为pictureBox1设置显示图片
}

public void GetAllFiles(DirectoryInfo dir)
{
    FileSystemInfo[] fileinfo = dir.GetFileSystemInfos();     //初始化一个FileSystemInfo类型的数组
    foreach (FileSystemInfo i in fileinfo)     //循环遍历fileinfo中的每一个记录
    {
        if (i is DirectoryInfo)         //当i在类DirectoryInfo中存在时
        {
            GetAllFiles((DirectoryInfo)i); //获取i下的所有文件
        }
        else        //当不存在该i时
        {
            string str = i.FullName;     //记录变量i的全名
            int b = str.LastIndexOf("\\\");    //在此示例中获取最后一个匹配项的索引
            string strType = str.Substring(b + 1);         //保存文件的后缀
                                                           //当文件格式为“jpg”或者“bmp”时
            if (strType.Substring(strType.Length - 3) == " jpg " || strType.Substring(strType.Length - 3) == " bmp ")
            {
                strInfo += strType + "#";    //为变量strInfo赋值
            }
        }
    }
}

private void Frm_Main_Load(object sender, EventArgs e)
{
    DirectoryInfo dir = new DirectoryInfo(strPath); //创建一个DirectoryInfo对象
    GetAllFiles(dir);     //获取dir下的所有文件
    if (strInfo != "")        //当字符串不为空时
    {
        strName = strInfo.Split('#');         //获取文件名
        Num = 0;         //初始化Num的值
        showPic(Num);     //显示图片
        Count = strName.Length - 1;         //记录Array中的元素数
    }
    else//当字符串为空时
    {
        MessageBox.Show("影集里没有照片");//弹出信息提示
    }
}

private void Frm_Main_Load(object sender, EventArgs e)
{
    this.axAnimation1.Open(Application.StartupPath + "//clock.avi");        //加载AVI文件
}
private void button1_Click(object sender, EventArgs e)
{
    try
    {
        this.axAnimation1.Stop();     //停止播放
        object start = this.textBox1.Text; //保存起始帧中的数据
        object end = this.textBox2.Text; //保存结束帧中的数据
        object time = 20; //初始化变量time
        this.axAnimation1.Play(time, start, end);         //播放指定的帧数
    }
    catch
    {
        MessageBox.Show("请输入正确帧数！");
    } 
}
private void button2_Click(object sender, EventArgs e)
{
    this.axAnimation1.Play();        //播放多媒体文件
}

private void button1_Click(object sender, EventArgs e)
{
    timer1.Enabled = true;    //启动计时器
    pictureBox1.Visible = false;//隐藏PictureBox控件
    label1.Visible = true;    //显示Label控件
}
private void button3_Click(object sender, EventArgs e)
{
    label1.Visible = false;    //隐藏Label控件
    timer1.Enabled = true;    //启动计时器
    pictureBox1.Visible = true;//显示PictureBox控件
}
private void timer1_Tick(object sender, EventArgs e)
{
    label1.Font = new Font(label1.Font.FontFamily, label1.Font.Size + 1);//使字体逐步加一
    pictureBox1.Size = new Size(pictureBox1.Size.Width + 5, pictureBox1.Size.Height + 5);//使图片逐渐增大
}

private void button1_Click(object sender, EventArgs e)
{
    ExportDataGridview(dataGridView1, true); //将DataGridView控件中的数据导出到Excel
}

public bool ExportDataGridview(DataGridView dgv, bool isShowExcle)
{
    if (dgv.Rows.Count == 0)//当DataGridView控件中没有数据时
        return false;         //返回false
    //建立Excel对象
    Excel.Application excel = new Excel.Application();    //实例化一个Excel对象
    excel.Application.Workbooks.Add(true);     //添加内容
    excel.Visible = isShowExcle; //设置为显示Excel
    //生成字段名称
    for (int i = 0; i & lt; dgv.ColumnCount; i++)    //循环遍历DataGridView控件中的每一列
    {
        excel.Cells[1, i + 1] = dgv.Columns[i].HeaderText;     //向Excel中填充数据
    }
    //填充数据
    for (int i = 0; i & lt; dgv.RowCount - 1; i++)    //循环遍历DataGridView控件中的每一行
    {
        for (int j = 0; j & lt; dgv.ColumnCount; j++)//循环遍历DataGridView控件中的每一列
        {
            if (dgv[j, i].ValueType == typeof(string))     //当当前数据类型为字符串时
            {
                excel.Cells[i + 2, j + 1] = " '" + dgv[j, i].Value.ToString();    //向Excel中填充数据
            }
            else        //当数据类型为其它类型时
            {
                excel.Cells[i + 2, j + 1] = dgv[j, i].Value.ToString();        //在Excel中直接显示内容
            }
        }
    }
    return true; //返回真
}

private void CreateImage(int ID)
{
    int height = 440, width = 600;    //设置画布宽和高
    System.Drawing.Bitmap image = new System.Drawing.Bitmap(width, height);    //创建画布
    Graphics g = Graphics.FromImage(image);        //创建Graphics对象
    try
    {
        g.Clear(Color.White);    //清空图片背景色
        Font font = new System.Drawing.Font(" Arial & quot;, 9, FontStyle.Regular);//设置字体
        Font font1 = new System.Drawing.Font(" 宋体 & quot;, 12, FontStyle.Regular);//设置字体
        Font font2 = new System.Drawing.Font(" Arial & quot;, 8, FontStyle.Regular);//设置字体
        System.Drawing.Drawing2D.LinearGradientBrush brush = new System.Drawing.Drawing2D.LinearGradientBrush(new Rectangle(0, 0, image.Width, image.Height), Color.Blue, Color.Blue, 1.2f, true);        //创建LinearGradientBrush对象
        g.FillRectangle(Brushes.AliceBlue, 0, 0, width, height);        //绘制矩形框
        Brush brush1 = new SolidBrush(Color.Blue);    //创建笔刷
        Brush brush2 = new SolidBrush(Color.SaddleBrown);        //创建笔刷
        string str = " SELECT* FROM tb_curve WHERE Years = " +ID + " " ;//声明SQL语句
                                                                                            //建立数据库连接
        SqlConnection Con = new SqlConnection(" server = mrwxk\\\wangxiaoke; pwd =; uid = sa; database = db_TomeOne & quot;);
        Con.Open();        //打开数据库连接
        SqlCommand Com = new SqlCommand(str, Con);//创建SqlCommand对象
        SqlDataReader dr = Com.ExecuteReader();    //创建SqlDataReader对象
        dr.Read();//开始读取记录
        if (dr.HasRows)        //如果有记录
        {
            //绘制标题
            g.DrawString(" " +ID + " 年公司内部人员统计表 & quot;, font1, brush1, new PointF(160, 30));
        }
        dr.Close();//关闭SqlDataReader对象
        //画图片的边框线
        g.DrawRectangle(new Pen(Color.Blue), 0, 0, image.Width - 1, image.Height - 1);
        Pen mypen = new Pen(brush, 1);        //创建画笔
        Pen mypen2 = new Pen(Color.Red, 2);        //创建画笔 
        int x = 60;
        for (int i = 0; i & lt; 12; i++)
        {
            g.DrawLine(mypen, x, 80, x, 340);    //绘制纵向线条
            x = x + 40;
        }
        Pen mypen1 = new Pen(Color.Blue, 2);    //创建画笔
        g.DrawLine(mypen1, x - 480, 80, x - 480, 340);//绘制线条
        int y = 106;
        for (int i = 0; i & lt; 9; i++)
        {
            g.DrawLine(mypen, 60, y, 540, y);    //绘制横向线条
            y = y + 26;
        }
        g.DrawLine(mypen1, 60, y, 540, y);
        //x轴
        String[] n = { " 一月 & quot;, " 二月 & quot;, " 三月 & quot;, " 四月 & quot;, " 五月 & quot;, " 六月 & quot;, " 七月 & quot;,
             " 八月 & quot;, " 九月 & quot;, " 十月 & quot;, " 十一月 & quot;, " 十二月 & quot;
    };    //绘制月份
    x = 35;
    for (int i = 0; i & lt; 12; i++)
        {
        g.DrawString(n[i].ToString(), font, Brushes.Red, x, 348);    //设置文字内容及输出位置
        x = x + 40;
    }
    //y轴
    String[] m = { " 900人 & quot;, " 800人 & quot;, " 700人 & quot;, " 600人 & quot;, " 565人 & quot;, " 400人 & quot;, " 300人 & quot;, " 200人 & quot;,
             " 100人 & quot;
};        //绘制人数
y = 100;
        for (int i = 0; i < 9; i++)
        {
            g.DrawString(m[i].ToString(), font, Brushes.Red, 10, y);     //设置文字内容及输出位置
            y = y + 26;
        }
        int[] Count1 = new int[12];
int[] Count2 = new int[12];
string[] NumChr = new string[12];
string cmdtxt2 = " SELECT* FROM tb_curve WHERE Years=" + ID + "";        //声明SQL语句
        SqlCommand Com1 = new SqlCommand(cmdtxt2, Con);        //创建SqlCommand对象
SqlDataAdapter da = new SqlDataAdapter();    //创建SqlDataAdapter对象
da.SelectCommand = Com1;
        DataSet ds = new DataSet();//创建DataSet对象
da.Fill(ds);//Fill方法填充DataSet
        int j = 0;
        for (int i = 0; i < 12; i++)
        {
            NumChr[i] = ds.Tables[0].Rows[0][i + 1].ToString();
        }
        for (j = 0; j < 12; j++)
        {
            Count1[j] = Convert.ToInt32(NumChr[j].Split('|')[0].ToString()) * 26 / 100;
        }
        for (int k = 0; k < 12; k++)
        {
            Count2[k] = Convert.ToInt32(NumChr[k].Split('|')[1].ToString()) * 26 / 100;
        }
        //显示折线效果
        SolidBrush mybrush = new SolidBrush(Color.Red);//创建SolidBrush对象
Point[] points1 = new Point[12];
points1[0].X = 60; points1[0].Y = 340 - Count1[0];
        points1[1].X = 100; points1[1].Y = 340 - Count1[1];
        points1[2].X = 140; points1[2].Y = 340 - Count1[2];
        points1[3].X = 180; points1[3].Y = 340 - Count1[3];
        points1[4].X = 220; points1[4].Y = 340 - Count1[4];
        points1[5].X = 260; points1[5].Y = 340 - Count1[5];
        points1[6].X = 300; points1[6].Y = 340 - Count1[6];
        points1[7].X = 340; points1[7].Y = 340 - Count1[7];
        points1[8].X = 380; points1[8].Y = 340 - Count1[8];
        points1[9].X = 420; points1[9].Y = 340 - Count1[9];
        points1[10].X = 460; points1[10].Y = 340 - Count1[10];
        points1[11].X = 565; points1[11].Y = 340 - Count1[11];
        g.DrawLines(mypen2, points1);//绘制折线
        Pen mypen3 = new Pen(Color.Black, 2);    //创建画笔
Point[] points2 = new Point[12];
points2[0].X = 60; points2[0].Y = 340 - Count2[0];
        points2[1].X = 100; points2[1].Y = 340 - Count2[1];
        points2[2].X = 140; points2[2].Y = 340 - Count2[2];
        points2[3].X = 180; points2[3].Y = 340 - Count2[3];
        points2[4].X = 220; points2[4].Y = 340 - Count2[4];
        points2[5].X = 260; points2[5].Y = 340 - Count2[5];
        points2[6].X = 300; points2[6].Y = 340 - Count2[6];
        points2[7].X = 340; points2[7].Y = 340 - Count2[7];
        points2[8].X = 380; points2[8].Y = 340 - Count2[8];
        points2[9].X = 420; points2[9].Y = 340 - Count2[9];
        points2[10].X = 460; points2[10].Y = 340 - Count2[10];
        points2[11].X = 565; points2[11].Y = 340 - Count2[11];
        g.DrawLines(mypen3, points2);//绘制折线
        //绘制标识
        g.DrawRectangle(new Pen(Brushes.Red), 150, 370, 250, 50);    //绘制范围框
        g.FillRectangle(Brushes.Red, 250, 380, 20, 10);//绘制小矩形
        g.DrawString("试用员工人数", font2, Brushes.Red, 270, 380);    //绘制试用员工人数
        g.FillRectangle(Brushes.Black, 250, 400, 20, 10);//绘制小矩形
        g.DrawString("正式员工人数", font2, Brushes.Black, 270, 400);    //绘制正式员工人数
        this.panel1.BackgroundImage = image;    //显示绘制的图像
    }
    catch
    { }
}

private void drowPic()
{
    Graphics g = this.CreateGraphics();		//创建Graphics对象
    g.Clear(Color.WhiteSmoke);//设置背景色
    Pen p = new Pen(Color.Blue);//绘制画笔
    //设置用到的字体
    Font fontO = new System.Drawing.Font("Arial", 9, FontStyle.Regular);
    Font fontT = new System.Drawing.Font("华文新魏", 16, FontStyle.Regular);
    Point pointStart = new Point(0, 0);		//绘制边框与显示字体
    Size sizeWindows = new Size(this.Width - 8, this.Height - 34);	//创建Size对象
    Rectangle rect = new Rectangle(pointStart, sizeWindows);	//创建Rectangle对象
    g.DrawRectangle(p, rect);//绘制矩形
    Brush brus = new SolidBrush(Color.Red);	//创建笔刷
    g.DrawString("网站人气指数曲线分析", fontT, brus, this.Width / 2.00f - 150, 10.00f);
    //绘制网格线
    int x = this.Width / 10;
    int y = this.Height / 14;
    int z = this.Width / 10;
    int k = y * 12;
    //X
    for (int i = 0; i < 12; i++)
    {
        g.DrawLine(p, x, y * 3 - 10, x, y * 12);	//绘制水平线条
        x = x + (this.Width - 34) / 14;
    }
    //X轴
    String[] n = {" 1月", " 2月", " 3月", " 4月", " 5月", " 6月", " 7月",
     " 8月", " 9月", "10月", "11月", "12月"};//绘制月份
    x = this.Width / 10 - 16;
    for (int i = 0; i < 12; i++)
    {
        g.DrawString(n[i].ToString(), fontO, Brushes.Red, x, y * 12);//设置文字内容及输出位置
        x = x + (this.Width - 34) / 14;
    }
    //Y
    for (int i = 0; i < 12; i++)
    {
        g.DrawLine(p, z, k, x + 10, k);		//绘制垂直线条
        k = k - (y * 12) / 16;
    }
    //Y轴
    int h = k;
    String[] m = {"5565","5650","4565", "4000", "3565", "3000", "2565", "2000", "1565", "1000",
     "  565"};		//绘制Y轴显示的文字
    k = y * 12;
    for (int i = 0; i < 11; i++)
    {
        g.DrawString(m[10 - i].ToString(), fontO, Brushes.Red, z - 35, k - y);		//开始绘制文字
        k = k - (y * 12) / 16;
    }
    int[] Count = new int[12];
    Pen mypen = new Pen(Color.Red, 2);	//创建画笔
    Point[] points = new Point[12];
    x = this.Width / 10;
    k = y * 12;
    SqlConnection Con = new SqlConnection("Server=mrwxk\\\wangxiaoke;DataBase=db_TomeOne;Uid=sa;Pwd=");
    string cmdtxt2 = "SELECT * FROM tb_reticulation";		//声明SQL语句
    SqlCommand Com1 = new SqlCommand(cmdtxt2, Con);		//创建SqlCommand对象
    SqlDataAdapter da = new SqlDataAdapter();//创建SqlDataAdapter对象
    da.SelectCommand = Com1;
    DataSet ds = new DataSet();//创建DataSet对象
    da.Fill(ds);		//Fill方法填充DataSet对象
    int j = 0;
    for (j = 0; j < 12; j++)
    {
        //与Y轴数生成有关(y * 12)/16因为起始为565
        Count[j] = Convert.ToInt32(ds.Tables[0].Rows[0][j + 2].ToString()) * (y * 12) / 16 / 565;
    }
    //设置绘制曲线的坐标数组
    points[0].X = x; points[0].Y = k - Count[0];
    x = x + (this.Width - 34) / 14;
    points[1].X = x; points[1].Y = k - Count[1];
    x = x + (this.Width - 34) / 14;
    points[2].X = x; points[2].Y = k - Count[2];
    x = x + (this.Width - 34) / 14;
    points[3].X = x; points[3].Y = k - Count[3];
    x = x + (this.Width - 34) / 14;
    points[4].X = x; points[4].Y = k - Count[4];
    x = x + (this.Width - 34) / 14;
    points[5].X = x; points[5].Y = k - Count[5];
    x = x + (this.Width - 34) / 14;
    points[6].X = x; points[6].Y = k - Count[6];
    x = x + (this.Width - 34) / 14;
    points[7].X = x; points[7].Y = k - Count[7];
    x = x + (this.Width - 34) / 14;
    points[8].X = x; points[8].Y = k - Count[8];
    x = x + (this.Width - 34) / 14;
    points[9].X = x; points[9].Y = k - Count[9];
    x = x + (this.Width - 34) / 14;
    points[10].X = x; points[10].Y = k - Count[10];
    x = x + (this.Width - 34) / 14;
    points[11].X = x; points[11].Y = k - Count[11];
    g.DrawLines(mypen, points);//绘制折线
}

private void ShowPic(string SexCode,float f)
{
    Graphics g = this.panel1.CreateGraphics();		//通过panel1控件创建一个Graphics对象
    Pen p=new Pen(new SolidBrush(Color.Blue));	//创建画笔
    Point p1=new Point(0,0);	//创建Point对象
    Size s=new Size(this.panel1.Width,this.panel1.Height);//创建Size对象
    Rectangle trct = new Rectangle(p1, s);		//创建Rectangle对象
    g.FillEllipse(new SolidBrush(Color.Red), trct);	//绘制椭圆
    g.FillPie(new SolidBrush(Color.Blue), trct, 180, f*360);//绘制扇形
    Graphics ginfo = this.panel2.CreateGraphics();	//通过panel2控件创建一个Graphics对象
    Font font=new Font("宋体",10,FontStyle.Regular);//设置字体
//绘制性别
    ginfo.DrawString(SexCode +" "+f.ToString().Substring(0,4), font, new SolidBrush(Color.Blue), 0, 5);
    ginfo.DrawString("女" + " " + (1.0 - Convert.ToDouble(f.ToString().Substring(0, 4))).ToString().Substring(0, 4), font, new SolidBrush(Color.Red), 0, 25);		//绘制比例
}

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_14 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++;
        }  
    }
}