dd_paiban.cs

此系统开发了一个公交车管理系统。系统根据权限的不同

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;

namespace CarManage
{
    public partial class DD_paiban : Form
    {
        public DD_paiban()
        {
            InitializeComponent();
        }

        private void DD_paiban_Load(object sender, EventArgs e)
        {
            this.Time();
            this.up();
            this.down();
        }
           private void Time()
        {
            string dl = ConfigurationManager.AppSettings["sqlString"];
            //创建connection对象con进行连接
            SqlConnection con = new SqlConnection(dl);
            //打开连接
            con.Open();
            string sql = "select  oilticket_number as 车牌号, oilticket_namer as 姓名 , oilticket_person as 工人编号  from db_oilticket order by oilticket_avercount desc";
            SqlCommand cmd = new SqlCommand(sql, con);
            SqlDataAdapter sdr = new SqlDataAdapter();
            //sdr的查询方法为cmd
            sdr.SelectCommand = cmd;
            //创建一个dataset容器
            DataSet ds = new DataSet();
            //填充数据ds
            sdr.Fill(ds);
            this.GridViewTime.DataSource = ds.Tables[0].DefaultView;
        }
        private void up()
        {
            string dl = ConfigurationManager.AppSettings["sqlString"];
            //创建connection对象con进行连接
            SqlConnection con = new SqlConnection(dl);
            //打开连接
            con.Open();
            string sql = "select top 5  oilticket_number as 车牌号, oilticket_namer as 姓名 , oilticket_person as 工人编号  from db_oilticket order by oilticket_avercount desc";
            SqlCommand cmd = new SqlCommand(sql, con);
            SqlDataAdapter sdr = new SqlDataAdapter();
            //sdr的查询方法为cmd
            sdr.SelectCommand = cmd;
            //创建一个dataset容器
            DataSet ds = new DataSet();
            //填充数据ds
            sdr.Fill(ds);
            this.GridViewup.DataSource = ds.Tables[0].DefaultView;
        }
        private void down()
        {
            string dl = ConfigurationManager.AppSettings["sqlString"];
            //创建connection对象con进行连接
            SqlConnection con = new SqlConnection(dl);
            //打开连接
            con.Open();
            string sql = "select top 5  oilticket_number as 车牌号, oilticket_namer as 姓名 , oilticket_person as 工人编号  from db_oilticket order by oilticket_avercount";
            SqlCommand cmd = new SqlCommand(sql, con);
            SqlDataAdapter sdr = new SqlDataAdapter();
            //sdr的查询方法为cmd
            sdr.SelectCommand = cmd;
            //创建一个dataset容器
            DataSet ds = new DataSet();
            //填充数据ds
            sdr.Fill(ds);
            this.GridViewdown.DataSource = ds.Tables[0].DefaultView;
        }
    
    }
}