jl_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 JL_paiban : Form
    {
        public JL_paiban()
        {
            InitializeComponent();
        }

        private void JL_paiban_Load(object sender, EventArgs e)
        {
             this.Time();
             this.up();
             this.down();
        }
        #region  创建gridviewcar()方法调用所有库中信息
        private void gridviewcar()
        {
            //调用config配置文件对象dl连接对象
            string dl = ConfigurationManager.AppSettings["sqlString"];
            //创建connection对象con进行连接
            SqlConnection con = new SqlConnection(dl);
            //打开连接
            con.Open();
            //创建sql语句将信息从库中调出
            string sql = "select  oilticket_number as 车牌号, oilticket_namer as 姓名 , oilticket_person as 工人编号 from db_oilticket";
            //创建执行对象cmd
            SqlCommand cmd = new SqlCommand(sql, con);
            //创建读取器对象sdr
            SqlDataAdapter sdr = new SqlDataAdapter();
            //sdr的查询方法为cmd
            sdr.SelectCommand = cmd;
            //创建一个dataset容器
            DataSet ds = new DataSet();
            //填充数据ds
            sdr.Fill(ds);
            //绑定datagriview数据源为ds
            this.GridViewTime.DataSource = ds.Tables[0].DefaultView;
            //关闭连接
            con.Close();
        }
        #endregion
        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;
        }
    }
}