select_info.cs

铁路电务信号设备维修记录系统 c#+acce

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.OleDb;

namespace D_Equipment_Mis
{
    public partial class select_info : Form
    {
        public select_info()
        {
            InitializeComponent();
        }

        public void select_sb_data(string startdatestr, string enddatestr, string gq)
        {
            string mystr = "select e_name as 设备名称 ,count(e_name)  as 检查次数, group_name as 工区名称 from e_check_list where check_date>=@idate1 and check_date<=@idate2 and group_name like @igroup_name group by e_name,group_name";
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            OleDbCommand mycmd = new OleDbCommand(mystr, myconn);
            mycmd.Parameters.Add("idate1", OleDbType.VarChar).Value = startdatestr;
            mycmd.Parameters.Add("idate2", OleDbType.VarChar).Value = enddatestr;
            mycmd.Parameters.Add("igroup_name", OleDbType.VarChar).Value = "%" + gq + "%";
            OleDbDataAdapter myda = new OleDbDataAdapter(mycmd);
            try
            {
                myconn.Open();
                DataSet myds = new DataSet();
                myda.Fill(myds);
                grid_sb.DataSource = myds.Tables[0].DefaultView;                
            }
            catch (Exception t)
            {
                MessageBox.Show(t.ToString());
            }
        }

        public void ini_gq(string cj_name)
        {
            string ini_str = "select group_name from zd_workgroup where workshop_name like @iworkshop_name order by workshop_name,group_id";
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            OleDbCommand ini_cmd = new OleDbCommand(ini_str, myconn);
            ini_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = "%" + cj_name + "%";
            OleDbDataAdapter ini_da = new OleDbDataAdapter(ini_cmd);
            myconn.Open();
            DataSet ini_ds = new DataSet();
            ini_da.Fill(ini_ds);
            if (ini_ds.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("没有车间数据，请先进行车间数据的维护!");
                return;
            }
            else
            {
                OleDbDataReader ini_read = ini_cmd.ExecuteReader();
                cbogq.Items.Clear();
                cbogq.Items.Add("");
                while (ini_read.Read())
                {
                    cbogq.Items.Add(ini_read["group_name"].ToString());
                }

            }
        }

        private void select_info_Load(object sender, EventArgs e)
        {
            int yy = System.DateTime.Today.Year;
            int mm = System.DateTime.Today.Month;
            int ldd = DateTime.DaysInMonth(yy, mm);
            e_start_date.Value = Convert.ToDateTime(yy.ToString() + "-" + mm.ToString() + "-" + "01");
            e_end_date.Value = Convert.ToDateTime(yy.ToString() + "-" + mm.ToString() + "-" + ldd.ToString());
            r_start_date.Value = Convert.ToDateTime(yy.ToString() + "-" + mm.ToString() + "-" + "01");
            r_end_date.Value = Convert.ToDateTime(yy.ToString() + "-" + mm.ToString() + "-" + ldd.ToString());
            ini_gq(data.workshop_name);
        }

        private void button1_Click(object sender, EventArgs e)
        {
            select_sb_data(e_start_date.Value.ToString("yyyy-MM-dd"), e_end_date.Value.ToString("yyyy-MM-dd"), cbogq.Text);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            get_info.DataGridViewToExcel(grid_sb);
            
        }

        private void button3_Click(object sender, EventArgs e)
        {
            Close();
        }
    }
}