data_from_txt_bk.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.IO;
using System.Data.OleDb;

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

        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog oFdg = new OpenFileDialog();
            oFdg.DefaultExt = "dat ";
            oFdg.Filter = "dat文件(*.dat)|*.dat ";
            oFdg.InitialDirectory = @"c:\dw_mis_data_bk";
            oFdg.ShowDialog();
            string stat_file = oFdg.FileName;
            if (stat_file.Trim() == "")
                return;
            else
                TB_file.Text = stat_file.Trim();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            progressBar1.Value = 0;
            if (TB_file.Text.Trim() == "")
            {
                MessageBox.Show("请选择文件路径");
                button1.Focus();
            }
            else
            {
                for (int i = 0; i < 200; i++)
                {
                    data.myinfo[i].button_id = "";
                    data.myinfo[i].read_time = "";
                    data.myinfo[i].flag = 0;
                }

                DataSet mydataset = new DataSet();
                mydataset.Tables.Add("info_table");
                mydataset.Tables["info_table"].Columns.Add("信息钮号");
                mydataset.Tables["info_table"].Columns.Add("设备名称");
                mydataset.Tables["info_table"].Columns.Add("检查开始时间");
                mydataset.Tables["info_table"].Columns.Add("检查结束时间");
                mydataset.Tables["info_table"].Columns.Add("车间名称");
                mydataset.Tables["info_table"].Columns.Add("工区名称");
                OleDbConnection myconn = new OleDbConnection(data.connstr);
                string ck_button_str = "select e_name,workshop_name,group_name from zd_button where button_id=@ibutton_id";
                OleDbCommand ck_button_cmd = new OleDbCommand(ck_button_str, myconn);
                ck_button_cmd.Parameters.Add("ibutton_id", OleDbType.VarChar);
                OleDbDataAdapter ck_button_da = new OleDbDataAdapter(ck_button_cmd);
                DataSet ck_button_ds = new DataSet();
                StreamReader myread = File.OpenText(TB_file.Text.Trim());
                myread.ReadLine();
                myread.ReadLine();
                string input;
                string[] subinput;
                int loopvar = 1;
                int info_num = 0;
                while ((input = myread.ReadLine()) != null)
                {                    
                    input = input.Replace("\t", ",").ToString().Trim();
                    subinput = input.Split(',');
                    foreach (string i in subinput)
                    {
                        if (loopvar == 1)
                            data.myinfo[info_num].button_id = i.ToString();
                        if (loopvar == 2)
                            data.myinfo[info_num].read_time = i.ToString();
                        loopvar++;
                    }
                    info_num++;
                    loopvar = 1;
                }
                progressBar1.Value = info_num;
                for (int i = 0; i <= info_num-1; i++)
                {
                    if (data.myinfo[i].flag == 0)
                    {
                        DataRow dr = mydataset.Tables["info_table"].NewRow();
                        ck_button_cmd.Parameters["ibutton_id"].Value = data.myinfo[i].button_id;
                        try
                        {
                            myconn.Open();
                            ck_button_da.Fill(ck_button_ds);
                            if (ck_button_ds.Tables[0].Rows.Count == 0)
                            {
                                //no_list_button = no_list_button + "," + data.myinfo[i].button_id;
                            }
                            else
                            {
                                data.myinfo[i].flag = 1;
                                dr["信息钮号"] = data.myinfo[i].button_id;
                                dr["设备名称"] = ck_button_ds.Tables[0].Rows[0]["e_name"].ToString();
                                dr["检查开始时间"] = data.myinfo[i].read_time;
                                for (int k = i + 1; k <= info_num; k++)
                                {
                                    if (data.myinfo[k].button_id == data.myinfo[i].button_id)
                                    {
                                        dr["检查结束时间"] = data.myinfo[k].read_time;
                                        data.myinfo[k].flag = 1;
                                    }
                                }
                                dr["车间名称"] = ck_button_ds.Tables[0].Rows[0]["workshop_name"].ToString();
                                dr["工区名称"] = ck_button_ds.Tables[0].Rows[0]["group_name"].ToString();
                            }
                            ck_button_ds.Clear();
                            myconn.Close();
                        }
                        catch (Exception t)
                        {
                            MessageBox.Show(t.ToString());
                        }
                        mydataset.Tables["info_table"].Rows.Add(dr);
                        progressBar1.Value = progressBar1.Value + 1;
                    }
                }
            }
        }

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