文章标题

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Test.Dal;
using System.IO;
using System.Reflection;

namespace Test
{
    public partial class Form1 : Form
    {

        privateExcleDal ed =null;
        StringFileName = null;
        DataSetds = new DataSet();
        publicForm1()
        {
            InitializeComponent();
        }

        privatevoid button1_Click(objectsender,EventArgs e)
        {
            this.openFileDialog1.Title="请选择导入资料文件";
            this.openFileDialog1.FileName="";
            this.openFileDialog1.InitialDirectory=Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
            this.openFileDialog1.Filter="excel文件(*.xls)|*.xls";
            this.openFileDialog1.ValidateNames=true;
            this.openFileDialog1.CheckFileExists=true;
            this.openFileDialog1.CheckPathExists=true;



            if(this.openFileDialog1.ShowDialog() ==DialogResult.OK)
            {
                ed = newExcleDal();
                DataTabletable = ed.ExcelToDataTable(this.openFileDialog1.FileName,"Sheet1");
                MessageBox.Show(table.Rows.Count.ToString());
                ed.DataTableToDb(table,"hg_test");
                MessageBox.Show("已经成功导入数据");
            }
        }


        //EXCEL导出
        privatevoid button2_Click(objectsender,EventArgs e)
        {
            if((this.textBox1.Text.ToString().Trim().Equals("")) || (this.textBox2.Text.ToString().Trim().Equals("")) || (this.textBox3.Text.ToString().Trim().Equals("")))
            {
                MessageBox.Show("填入数字并随机生成序号):");
            }
            elseif (Convert.ToInt32(this.textBox2.Text.ToString().Trim()) <Convert.ToInt32(this.textBox1.Text.ToString().Trim()))
            {
                MessageBox.Show("最大数不能小于最小数):");
            }
            else
            {
                this.saveFileDialog1.Title="保存文件";
                this.saveFileDialog1.Filter="excel文件(*.xls)|*.xls";
                this.saveFileDialog1.RestoreDirectory=true;
                saveFileDialog1.FilterIndex =2;
                stringfileNa = saveFileDialog1.FileName;
                ed = newExcleDal();
                DataTabledt = ed.findAll().Tables[0];
                dt.Columns.Add("序号,typeof(String));
                //随机返回范围内数字并插入datatable
                int[]i = ed.GetRandomArray(Convert.ToInt32(this.textBox3.Text.ToString()),Convert.ToInt32(this.textBox1.Text.ToString()),Convert.ToInt32(this.textBox2.Text.ToString()));
                //int[]i = ed.GetRandomArray(60,1,60);
                for(int k = 0; k < dt.Rows.Count-1; k++)
                {
                    if(k >= i.Length)
                    {
                        break;
                    }
                    else
                    {
                        dt.Rows[k]["序¨°号?"] = i[k].ToString();
                    }


                }

                if(saveFileDialog1.ShowDialog() ==DialogResult.OK)
                {
                    CreateExcel(dt,saveFileDialog1.FileName);
                }
            }


        }

        public voidCreateExcel(DataTable dt, string fileName)
        {
            System.Diagnostics.Process[] arrProcesses;
            arrProcesses = System.Diagnostics.Process.GetProcessesByName("Excel");
            foreach(System.Diagnostics.Process myProcessin arrProcesses)
            {
                myProcess.Kill();
            }

            Objectmissing = Missing.Value;
           Microsoft.Office.Interop.Excel.Application m_objExcel =

             newMicrosoft.Office.Interop.Excel.Application();
           Microsoft.Office.Interop.Excel.Workbooks m_objWorkBooks =m_objExcel.Workbooks;
           Microsoft.Office.Interop.Excel.Workbook m_objWorkBook =m_objWorkBooks.Add(true);
           Microsoft.Office.Interop.Excel.Sheets m_objWorkSheets =m_objWorkBook.Sheets; ;
           Microsoft.Office.Interop.Excel.Worksheet m_objWorkSheet =

            (Microsoft.Office.Interop.Excel.Worksheet)m_objWorkSheets[1];
            intintFeildCount = dt.Columns.Count;
            for(int col = 0; col < intFeildCount; col++)
            {
                m_objWorkSheet.Cells[1, col +1] = dt.Columns[col].ToString();
            }
            for(int intRowCount = 0; intRowCount < dt.Rows.Count;intRowCount++)
            {
                for(int intCol = 0; intCol < dt.Columns.Count;intCol++)
                {
                   m_objWorkSheet.Cells[intRowCount + 2, intCol + 1] ="'" +dt.Rows[intRowCount][intCol].ToString();
                }
            }

            if(File.Exists(fileName))
            {
                File.Delete(fileName);
            }
            m_objWorkBook.SaveAs(fileName,missing, missing, missing, missing,
            missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
            missing, missing, missing, missing,missing);
            m_objExcel = null;

        }

        privatevoid button3_Click(objectsender,EventArgs e)
        {
            ed = newExcleDal();

            ed.delereAll();
            MessageBox.Show("数据清空");
        }

        privatevoid Form1_Load(objectsender,EventArgs e)
        {

        }


    }
}