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?System.Data.OleDb;
using?System.Runtime.InteropServices;
using?Access?=?Microsoft.Office.Interop.Access;
using?System.IO;
using?System.Collections;



namespace?前臺(tái)
{
????public?partial?class?Form1?:?Form
????{
????????OleDbConnection?objConnection;
????????OleDbDataAdapter?data;
????????double?rmb?=?0.0;

????????public?Form1（）
????????{
???????????
????????????InitializeComponent（）;
????????}
????????///?

????????///?程序加載
????????///?

????????///?
????????///?
????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????try
????????????{
????????????????if?（File.Exists（System.Environment.CurrentDirectory?+?“\\config.dat“））
????????????????{
????????????????????a?=?Convert.ToInt32（File.ReadAllText（System.Environment.CurrentDirectory?+?“\\config.dat“））;
???????????????????this.BackgroundImage?=?imageList1.Images[a];
????????????????????a++;
????????????????}
??????????????
????????????????string?backPath?=?System.Environment.CurrentDirectory?+?“\\Back“;
????????????????if?（!Directory.Exists（backPath））
?????????????????Directory.CreateDirectory（backPath）;
?????????????????leath?=?Directory.GetFiles（System.Environment.CurrentDirectory?+?“\\Back“）.Length?-?1;

????????????????string?strConnection?=?“Provider=Microsoft.Jet.OleDb.4.0;“;
????????????????strConnection?+=?@“Data?Source=“?+?System.Environment.CurrentDirectory?+?“\\qiantaiDB.mdb“;
????????????????objConnection?=?new?OleDbConnection（strConnection）;??//建立連接???
????????????????data1（）;
????????????????data2（）;
????????????????sun（）;
????????????????sun1（）;
????????????????allSun（）;
???????????dataGridView1.ClearSelection（）;
???????????dataGridView2.ClearSelection（）;
????????????????tianchong（）;
????????????????clean（）;
????????????}
????????????catch?（Exception?e1）
????????????{
????????????????MessageBox.Show（e1.Message）;
????????????}

????????}
????????///?

????????///?填充?下拉選項(xiàng)列表
????????///?

????????void?tianchong（）
????????{

????????????try
????????????{
????????????????string?sqlcom1?=?@“select?distinct?公司名稱(chēng)?from?biao“;
????????????????string?sqlcom2?=?@“select?distinct?產(chǎn)品名稱(chēng)?from?biao“;
????????????????string?sqlcom3?=?@“select?distinct?型號(hào)?from?biao“;
????????????????string?sqlcom4?=?@“select?distinct?所屬項(xiàng)目?from?biao“;
??????????????

????????????????//??“公司名稱(chēng)“;
????????????????data?=?new?OleDbDataAdapter（sqlcom1?objConnection）;
????????????????DataSet?ds?=?new?DataSet（）;
????????????????data.Fill（ds?“one“）;
????????????????comboBox1.DataSource?=?ds.Tables[“one“];
????????????????comboBox1.DisplayMember?=?“公司名稱(chēng)“;
????????????????gongsimingcheng.DataSource?=?ds.Tables[“one“];
????????????????gongsimingc

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2013-05-07?13:57??財(cái)務(wù)軟件v1.61\
?????文件?????3014656??2013-03-13?16:59??財(cái)務(wù)軟件v1.61\company_1.mdb
?????文件??????634880??2013-04-26?08:48??財(cái)務(wù)軟件v1.61\qiantaiDB.mdb
?????目錄???????????0??2013-05-07?13:59??財(cái)務(wù)軟件v1.61\前臺(tái)\
?????文件?????????908??2013-03-04?13:18??財(cái)務(wù)軟件v1.61\前臺(tái).sln
?????文件???????27136??2013-05-07?14:04??財(cái)務(wù)軟件v1.61\前臺(tái).suo
?????文件???????92102??2013-03-04?16:37??財(cái)務(wù)軟件v1.61\前臺(tái)\8.ico
?????目錄???????????0??2013-05-07?13:57??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\
?????目錄???????????0??2013-08-08?14:15??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Debug\
?????文件???????92102??2013-03-04?16:37??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Debug\8.ico
?????文件??????339968??2013-03-19?11:00??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Debug\qiantaiDB.mdb
?????文件???????22016??2013-03-04?16:31??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Debug\前臺(tái).exe
?????文件???????34304??2013-03-04?16:31??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Debug\前臺(tái).pdb
?????文件???????14328??2013-03-04?16:32??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Debug\前臺(tái).vshost.exe
?????文件?????????490??2009-06-11?05:14??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Debug\前臺(tái).vshost.exe.manifest
?????目錄???????????0??2013-08-10?12:29??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\
?????目錄???????????0??2013-08-10?12:29??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\Back\
?????文件??????634880??2013-08-10?12:28??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\Back\20130810122844.mdb
?????文件??????634880??2013-08-10?12:28??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\Back\20130810122851.mdb
?????文件??????634880??2013-08-10?12:28??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\Back\20130810122921.mdb
?????文件??????634880??2013-08-10?12:29??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\Back\20130810122929.mdb
?????文件??????634880??2013-08-10?12:29??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\Back\20130810122934.mdb
?????文件???????????1??2013-08-10?12:29??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\config.dat
?????文件???????11699??2005-09-17?19:44??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\png-0048.png
?????文件???????10935??2005-09-17?19:42??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\png-0057.png
?????文件????????9150??2005-02-21?22:32??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\png-0084.png
?????文件???????19825??2002-10-12?03:54??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\png-0098.png
?????文件????????9199??2005-06-08?14:46??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\png-0099.png
?????文件????????8125??2005-04-09?20:21??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\png-0644.png
?????文件????????8746??2005-04-09?20:21??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\png-0650.png
?????文件???????14147??2005-04-09?20:21??財(cái)務(wù)軟件v1.61\前臺(tái)\bin\Release\png-0651.png
............此處省略79個(gè)文件信息