data_export.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;
using System.IO;

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

        private void data_export_Load(object sender, EventArgs e)
        {
            startdate.Value = System.DateTime.Today;
            enddate.Value = System.DateTime.Today;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string startdatestr = startdate.Value.ToString("yyyy-MM-dd");
            string enddatestr = enddate.Value.ToString("yyyy-MM-dd");            
            string sqlstr = "select check_date as 时间, check_emp_id as 工号,check_emp_name as 姓名,button_id as 信息钮号,e_name as 设备名称,start_time as 检查开始时间,end_time as 检查结束时间,group_name as 工区名称 from e_check_list where check_date>=@idate and check_date<=@idate2";
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            OleDbCommand mycmd = new OleDbCommand(sqlstr, myconn);
            mycmd.Parameters.Add("idate1",OleDbType.VarChar).Value = startdatestr;
            mycmd.Parameters.Add("idate2", OleDbType.VarChar).Value = enddatestr;
            OleDbDataAdapter myda = new OleDbDataAdapter(mycmd);
            try
            {
                myconn.Open();
                DataSet myds = new DataSet();
                myda.Fill(myds);
                data_result.DataSource = myds.Tables[0].DefaultView;
            }
            catch (Exception t)
            {
                MessageBox.Show(t.ToString());
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //申明保存对话框 
            SaveFileDialog dlg = new SaveFileDialog();
            //默然文件后缀 
            dlg.DefaultExt = "dat ";
            //文件后缀列表 
            dlg.Filter = "dat文件(*.dat)|*.dat ";
            //默然路径是系统当前路径 
            dlg.InitialDirectory = Directory.GetCurrentDirectory();
            //打开保存对话框 
            //dlg.ShowDialog();
            if (dlg.ShowDialog() == DialogResult.OK)
            {
                //返回文件路径 
                string fileNameString = dlg.FileName;
                //验证strFileName是否为空或值无效 
                if (fileNameString.Trim() == " ")
                { return; }
                FileInfo file = new FileInfo(fileNameString);
                if (file.Exists)
                {
                    try
                    {
                        file.Delete();
                    }
                    catch (Exception error)
                    {
                        MessageBox.Show(error.Message, "删除失败 ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                }
                StreamWriter rw = File.AppendText(fileNameString);
                rw.WriteLine(startdate.Value.ToString("yyyy-MM-dd"));
                rw.WriteLine(enddate.Value.ToString("yyyy-MM-dd"));
                rw.WriteLine(data.workshop_name);
                rw.WriteLine("==ZD_EMP==");
                string sqlstr = "select emp_num,emp_name,workshop_name,group_name from zd_emp order by group_name,emp_id";
                OleDbConnection myconn = new OleDbConnection(data.connstr);
                OleDbCommand mycmd = new OleDbCommand(sqlstr, myconn);
                OleDbDataAdapter myda = new OleDbDataAdapter(mycmd);
                string emp_id, emp_name, workshop_name, group_name;
                try
                {
                    myconn.Open();
                    DataSet myds = new DataSet();
                    myda.Fill(myds);
                    if (myds.Tables[0].Rows.Count > 0)
                    {
                        for (int i = 0; i <= myds.Tables[0].Rows.Count - 1; i++)
                        {
                            emp_id = myds.Tables[0].Rows[i]["emp_num"].ToString();
                            emp_name = myds.Tables[0].Rows[i]["emp_name"].ToString();
                            workshop_name = myds.Tables[0].Rows[i]["workshop_name"].ToString();
                            group_name = myds.Tables[0].Rows[i]["group_name"].ToString();
                            rw.WriteLine(emp_id + "\t" + emp_name + "\t" + workshop_name + "\t" + group_name);
                        }
                    }
                }
                catch (Exception t)
                {
                    MessageBox.Show(t.ToString());
                }
                myconn.Close();
                rw.WriteLine("==ZD_USER==");
                string get_user_str = "select user_id,user_name,pwd from zd_user order by user_id";
                OleDbCommand get_user_cmd = new OleDbCommand(get_user_str,myconn);
                OleDbDataAdapter get_user_da = new OleDbDataAdapter(get_user_cmd);
                string user_id,user_name,pwd,myworkshop_name;
                try
                {
                    myconn.Open();
                    DataSet get_user_ds = new DataSet();
                    get_user_da.Fill(get_user_ds);
                    if (get_user_ds.Tables[0].Rows.Count>0)
                    {
                        for (int i = 0; i <= get_user_ds.Tables[0].Rows.Count - 1; i++)
                        {
                            user_id = get_user_ds.Tables[0].Rows[i]["user_id"].ToString();
                            user_name = get_user_ds.Tables[0].Rows[i]["user_name"].ToString();
                            pwd = get_user_ds.Tables[0].Rows[i]["pwd"].ToString();
                            myworkshop_name = data.workshop_name;
                            rw.WriteLine(user_id + "\t" + user_name + "\t" + pwd + "\t" + myworkshop_name);
                        }
                        
                    }
                }
                catch (Exception t)
                {
                    MessageBox.Show(t.ToString());
                }
                myconn.Close();
                rw.WriteLine("==INFO==");
                for (int i = 0; i <= data_result.Rows.Count - 1; i++)
                {
                    rw.WriteLine(data_result.Rows[i].Cells[0].Value.ToString().Trim() + "\t"
                        + data_result.Rows[i].Cells[1].Value.ToString().Trim() + "\t"
                        + data_result.Rows[i].Cells[2].Value.ToString().Trim() + "\t"
                        + data_result.Rows[i].Cells[3].Value.ToString().Trim() + "\t"
                        + data_result.Rows[i].Cells[4].Value.ToString().Trim() + "\t"
                        + data_result.Rows[i].Cells[5].Value.ToString().Trim() + "\t"
                        + data_result.Rows[i].Cells[6].Value.ToString().Trim() + "\t"
                        + data_result.Rows[i].Cells[7].Value.ToString().Trim());
                }
                rw.Flush();
                rw.Close();
                MessageBox.Show(fileNameString + "\n\n导出完毕! ", "提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

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