数据库课程设计—新生入学管理系统-有报告有文档-完整

1. 录入、修改录取名单及相关资料 2. 新生报到处理、班级调整后自动生成学号 3. 统计报到率等

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace test
{
    public partial class baobiao : Form
    {
        private float yd;
        private float zs;
        public baobiao（）
        {
            InitializeComponent（）;
        }

        private void baobiao_Load（object sender EventArgs e）
        {
            con（）;
            showPic（）;

        }

        private void showPic（）
        {
            float t=yd/zs;
            float a = t * 360;
            float b=360-a;
            Bitmap bitM = new Bitmap（this.pictureBox1.Width this.pictureBox1.Height）;
            Graphics g = Graphics.FromImage（bitM）;
            g.FillPie（new SolidBrush（Color.BlueViolet） 0 0 this.pictureBox1.Width this.pictureBox1.Height 90 a）;
            g.FillPie（new SolidBrush（Color.Yellow） 0 0 this.pictureBox1.Width this.pictureBox1.Height 90+a b）;
            this.pictureBox1.BackgroundImage = bitM;
            label1.Text =“报到率\n“+ t.ToString（）;
            label2.Text = “应到：“ + zs.ToString（） +“人“;
            label3.Text = “实到：“ + yd.ToString（） + “人“;
//            MessageBox.Show（zs.ToString（））;
        }
        private void con（）
        {
            string ConStr = “Persist Security Info=False;Integrated Security=SSPI;database=xiemeilong;server=（local）“;
            SqlConnection con = new SqlConnection（ConStr）;
            string SqlStr = “select count（NO）  from u_students where BAODAO = 1 “;
            SqlDataAdapter ada = new SqlDataAdapter（SqlStr con）;
            DataSet ds = new DataSet（）;
            ada.Fill（ds）;

            yd = Convert.ToSingle（ds.Tables[0].Rows[0].ItemArray[0]）;
            SqlStr = “select count（NO）  from u_students “;
            SqlDataAdapter ada2 = new SqlDataAdapter（SqlStr con）;
            DataSet ds2 = new DataSet（）;
            ada2.Fill（ds2）;
            zs = Convert.ToSingle（ds2.Tables[0].Rows[0].ItemArray[0]）;

        }

    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       2175  2009-07-09 12:46  test\test\baobiao.cs

     文件       6084  2009-07-09 12:46  test\test\baobiao.Designer.cs

     文件       5814  2009-07-09 12:46  test\test\baobiao.resx

     文件       4305  2009-07-09 12:48  test\test\BDForm.cs

     文件       8672  2009-07-09 12:48  test\test\BDForm.Designer.cs

     文件       5814  2009-07-09 12:48  test\test\BDForm.resx

     文件      60416  2009-07-09 17:44  test\test\bin\Debug\test.exe

     文件      85504  2009-07-09 17:44  test\test\bin\Debug\test.pdb

     文件      14328  2009-07-09 18:12  test\test\bin\Debug\test.vshost.exe

     文件      58880  2009-07-09 17:44  test\test\bin\Release\test.exe

     文件      81408  2009-07-09 17:44  test\test\bin\Release\test.pdb

     文件       2529  2009-07-09 12:48  test\test\Form1.cs

     文件       7066  2009-07-09 12:48  test\test\Form1.Designer.cs

     文件       5814  2009-07-09 12:48  test\test\Form1.resx

     文件       1881  2009-07-09 12:48  test\test\Form2.cs

     文件       9806  2009-07-09 12:48  test\test\Form2.Designer.cs

     文件       5814  2009-07-09 12:48  test\test\Form2.resx

     文件       2327  2009-07-09 12:48  test\test\Form3.cs

     文件       4467  2009-07-09 12:48  test\test\Form3.Designer.cs

     文件       5814  2009-07-09 12:48  test\test\Form3.resx

     文件       5677  2009-07-09 17:44  test\test\login.cs

     文件       8782  2009-07-09 17:44  test\test\login.Designer.cs

     文件      36045  2009-07-09 17:44  test\test\login.resx

     文件       5124  2009-07-09 12:48  test\test\LUQU.cs

     文件       8189  2009-07-09 12:48  test\test\LUQU.Designer.cs

     文件       5814  2009-07-09 12:48  test\test\LUQU.resx

     文件        180  2009-07-09 12:46  test\test\obj\Debug\test.baobiao.resources

     文件        180  2009-07-09 12:48  test\test\obj\Debug\test.BDForm.resources

     文件       2688  2009-07-09 18:12  test\test\obj\Debug\test.csproj.FileListAbsolute.txt

     文件       1261  2009-07-09 17:44  test\test\obj\Debug\test.csproj.GenerateResource.Cache

............此处省略52个文件信息