pt_yuepiao.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 PT_Yuepiao : Form
    {
        public PT_Yuepiao()
        {
            InitializeComponent();
        }

        private void label19_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        private void btnClear_Click_1(object sender, EventArgs e)
        {
            this.text_ticketCheckName.Clear();
        }

        private void btnCheck_Click_1(object sender, EventArgs e)
        {
            string ticketCheckName = this.text_ticketCheckName.Text.ToString().Trim();
            string ticketCheckKinds = this.text_ticketCheckKinds.SelectedItem.ToString();
            string sqlstr = "select ticket_id as 序号,ticket_name as 姓名,ticket_aver as 月票单价,ticket_kind as 月票种类,ticket_count as 车票数量,ticket_money as 总金额,ticket_remark as 备注 from db_ticket where 1=1";
            //调用config配置文件对象dl连接对象
            string dl = ConfigurationManager.AppSettings["sqlString"];
            //创建connection对象con进行连接
            SqlConnection con = new SqlConnection(dl);
            //打开连接
            con.Open();
            if (ticketCheckKinds != "--未选择--")
            {
                sqlstr = sqlstr + "and ticket_kind = '" + ticketCheckKinds + "'";

            }
            if (ticketCheckName != "")
            {
                sqlstr = sqlstr + "and ticket_name = '" + ticketCheckName + "'";

            }
            SqlCommand cmd = new SqlCommand(sqlstr, con);
            //创建读取器对象sdr
            SqlDataAdapter sdr = new SqlDataAdapter();
            //sdr的查询方法为cmd
            sdr.SelectCommand = cmd;
            //创建一个dataset容器
            DataSet ds = new DataSet();
            //填充数据ds
            sdr.Fill(ds);
            //绑定datagriview数据源为ds
            this.GridViewCheckOil.DataSource = ds.Tables[0].DefaultView;
            //关闭连接
            con.Close();
        }

        private void PT_Yuepiao_Load(object sender, EventArgs e)
        {
            this.text_ticketCheckKinds.SelectedItem = "--未选择--";
        }
    }
}