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


namespace?qimo
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}
????????private?double[]?data?=?new?double[20];?//保存表中的數(shù)據(jù)?
????????private?double?f?=?0;?//主距?
????????private?void?btnFilePath_Click（object?sender?EventArgs?e）
????????{
????????????folderBrowserDialog1.ShowNewFolderButton?=?true;
????????????if?（folderBrowserDialog1.ShowDialog（）?==?DialogResult.OK）
????????????{
????????????????string?s?=?folderBrowserDialog1.SelectedPath?+?“\\“?+?“RESULT.txt“;
????????????????if?（s.Contains（@“\\“）?==?true）?//解決根目錄下出現(xiàn)如同C:\\RESULT.txt等不正確路徑情況?
????????????????{
????????????????????s?=?s.Replace（@“\\“?@“\“）;
????????????????}
????????????????this.textBox1.Text?=?s;
????????????}

????????}
????????public?static?DataTable?ExcelToDataTable（string?strExcelFileName?string?strSheetName）
????????{
????????????//源的定義
????????????string?strConn?=?“Provider=Microsoft.Jet.OLEDB.4.0;“?+?“Data?Source=“?+?strExcelFileName?+?“;“?+?“Extended?Properties=‘Excel?8.0;HDR=NO;IMEX=1‘;“;

????????????//Sql語句
????????????//string?strExcel?=?string.Format（“select?*?from?[{0}$]“?strSheetName）;?這是一種方法
????????????string?strExcel?=?“select?*?from???[sheet1$]“;

????????????//定義存放的數(shù)據(jù)表
????????????DataSet?ds?=?new?DataSet（）;

????????????//連接數(shù)據(jù)源
????????????OleDbConnection?conn?=?new?OleDbConnection（strConn）;

????????????conn.Open（）;

????????????//適配到數(shù)據(jù)源
????????????OleDbDataAdapter?adapter?=?new?OleDbDataAdapter（strExcel?strConn）;
????????????adapter.Fill（ds?strSheetName）;

????????????conn.Close（）;

????????????return?ds.Tables[strSheetName];
????????}
????????private?void?btnStart_Click（object?sender?EventArgs?e）
????????{
????????????btnCheck.Enabled?=?false;?//解算過程中不響應(yīng)按鍵?
????????????btnExit.Enabled?=?false;
????????????btnStart.Enabled?=?false;
????????????this.label2.Text?=?“程序解算中，請稍等......“;
????????????try
????????????{
????????????????scale?s?=?new?scale（f?data）;?//新建實例解算傳入數(shù)據(jù)?
????????????????s.makeSure（）;?//迭代解算?
????????????????this.label2.Text?=?“解算完成迭代次數(shù):“?+?s.COUNT.ToString（）;?//顯示狀態(tài)?
????????????????StreamWriter?sw?=?new?StreamWriter（this.textBox1.Text）;?//保存結(jié)果文件?
????????????????sw.WriteLine（string.Format（“u={0:F9}“?s.U））;
????????????????sw.WriteLine（string.Format（“w={0:F10}“?s.W））;
????????????????sw.WriteLine（string.Format（“k={0:F9}“?s.K））;
????????????????sw.WriteLine（string.Format（“Xs={0:F5}“?s.XS））;
????????????????sw.WriteLine（string.Format（“Ys={0:F5}“?s.YS））;
????????????????sw.WriteLine（string.Format（“Zs={0:F6}“?s.ZS））;
????????????????sw.Close（）;
????????????????try?//若成功則解算完成后自動打開結(jié)果文檔?
????????????????{
????????????????????Process?p?=?new?Process（）;

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????189??2017-11-30?14:13??qimo\App.config

?????文件??????19456??2017-12-14?14:43??qimo\bin\Debug\qimo.exe

?????文件????????189??2017-11-30?14:13??qimo\bin\Debug\qimo.exe.config

?????文件??????40448??2017-12-14?14:43??qimo\bin\Debug\qimo.pdb

?????文件??????22984??2017-12-14?15:22??qimo\bin\Debug\qimo.vshost.exe

?????文件????????189??2017-11-30?14:13??qimo\bin\Debug\qimo.vshost.exe.config

?????文件????????490??2010-03-17?22:39??qimo\bin\Debug\qimo.vshost.exe.manifest

?????文件???????6360??2017-12-14?14:43??qimo\Form1.cs

?????文件???????5863??2017-12-14?14:06??qimo\Form1.Designer.cs

?????文件???????6025??2017-12-14?14:06??qimo\Form1.resx

?????文件???????1318??2017-12-14?14:06??qimo\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????6616??2017-12-14?20:11??qimo\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1545??2017-12-14?15:22??qimo\obj\Debug\qimo.csproj.FileListAbsolute.txt

?????文件????????975??2017-12-14?14:26??qimo\obj\Debug\qimo.csproj.GenerateResource.Cache

?????文件???????2231??2017-12-14?14:26??qimo\obj\Debug\qimo.csprojResolveAssemblyReference.cache

?????文件??????19456??2017-12-14?14:43??qimo\obj\Debug\qimo.exe

?????文件????????180??2017-12-14?14:26??qimo\obj\Debug\qimo.Form1.resources

?????文件??????40448??2017-12-14?14:43??qimo\obj\Debug\qimo.pdb

?????文件????????180??2017-11-30?15:06??qimo\obj\Debug\qimo.Properties.Resources.resources

?????文件??????????0??2017-11-30?14:13??qimo\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2017-11-30?14:13??qimo\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2017-11-30?14:13??qimo\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件????????516??2017-11-30?14:13??qimo\Program.cs

?????文件???????1346??2017-11-30?14:13??qimo\Properties\AssemblyInfo.cs

?????文件???????2860??2017-11-30?14:13??qimo\Properties\Resources.Designer.cs

?????文件???????5612??2017-11-30?14:13??qimo\Properties\Resources.resx

?????文件???????1091??2017-11-30?14:13??qimo\Properties\Settings.Designer.cs

?????文件????????249??2017-11-30?14:13??qimo\Properties\Settings.settings

?????文件???????3825??2017-11-30?14:47??qimo\qimo.csproj

?????文件???????7355??2017-12-14?14:06??qimo\scale.cs

............此處省略11個文件信息