資源簡介
以前財務用軟件升級版,添加撤銷,等功能,分為兩個部分,第一部分登記一個項目采購物品登記,第二個人部分根據項目,或者根據采購的公司統計欠款,以及設置什么時候付款,到時間提醒付款,等等,1.61版美化界面圖標按鈕等!里面包含源碼,需要的可以根據實際情況做修改!

代碼片段和文件信息
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?前臺
{
????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);
????????????}
????????}
????????///?
????????///?填充?下拉選項列表
????????///?
????????void?tianchong()
????????{
????????????try
????????????{
????????????????string?sqlcom1?=?@“select?distinct?公司名稱?from?biao“;
????????????????string?sqlcom2?=?@“select?distinct?產品名稱?from?biao“;
????????????????string?sqlcom3?=?@“select?distinct?型號?from?biao“;
????????????????string?sqlcom4?=?@“select?distinct?所屬項目?from?biao“;
??????????????
????????????????//??“公司名稱“;
????????????????data?=?new?OleDbDataAdapter(sqlcom1?objConnection);
????????????????DataSet?ds?=?new?DataSet();
????????????????data.Fill(ds?“one“);
????????????????comboBox1.DataSource?=?ds.Tables[“one“];
????????????????comboBox1.DisplayMember?=?“公司名稱“;
????????????????gongsimingcheng.DataSource?=?ds.Tables[“one“];
????????????????gongsimingc
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-05-07?13:57??財務軟件v1.61\
?????文件?????3014656??2013-03-13?16:59??財務軟件v1.61\company_1.mdb
?????文件??????634880??2013-04-26?08:48??財務軟件v1.61\qiantaiDB.mdb
?????目錄???????????0??2013-05-07?13:59??財務軟件v1.61\前臺\
?????文件?????????908??2013-03-04?13:18??財務軟件v1.61\前臺.sln
?????文件???????27136??2013-05-07?14:04??財務軟件v1.61\前臺.suo
?????文件???????92102??2013-03-04?16:37??財務軟件v1.61\前臺\8.ico
?????目錄???????????0??2013-05-07?13:57??財務軟件v1.61\前臺\bin\
?????目錄???????????0??2013-08-08?14:15??財務軟件v1.61\前臺\bin\Debug\
?????文件???????92102??2013-03-04?16:37??財務軟件v1.61\前臺\bin\Debug\8.ico
?????文件??????339968??2013-03-19?11:00??財務軟件v1.61\前臺\bin\Debug\qiantaiDB.mdb
?????文件???????22016??2013-03-04?16:31??財務軟件v1.61\前臺\bin\Debug\前臺.exe
?????文件???????34304??2013-03-04?16:31??財務軟件v1.61\前臺\bin\Debug\前臺.pdb
?????文件???????14328??2013-03-04?16:32??財務軟件v1.61\前臺\bin\Debug\前臺.vshost.exe
?????文件?????????490??2009-06-11?05:14??財務軟件v1.61\前臺\bin\Debug\前臺.vshost.exe.manifest
?????目錄???????????0??2013-08-10?12:29??財務軟件v1.61\前臺\bin\Release\
?????目錄???????????0??2013-08-10?12:29??財務軟件v1.61\前臺\bin\Release\Back\
?????文件??????634880??2013-08-10?12:28??財務軟件v1.61\前臺\bin\Release\Back\20130810122844.mdb
?????文件??????634880??2013-08-10?12:28??財務軟件v1.61\前臺\bin\Release\Back\20130810122851.mdb
?????文件??????634880??2013-08-10?12:28??財務軟件v1.61\前臺\bin\Release\Back\20130810122921.mdb
?????文件??????634880??2013-08-10?12:29??財務軟件v1.61\前臺\bin\Release\Back\20130810122929.mdb
?????文件??????634880??2013-08-10?12:29??財務軟件v1.61\前臺\bin\Release\Back\20130810122934.mdb
?????文件???????????1??2013-08-10?12:29??財務軟件v1.61\前臺\bin\Release\config.dat
?????文件???????11699??2005-09-17?19:44??財務軟件v1.61\前臺\bin\Release\png-0048.png
?????文件???????10935??2005-09-17?19:42??財務軟件v1.61\前臺\bin\Release\png-0057.png
?????文件????????9150??2005-02-21?22:32??財務軟件v1.61\前臺\bin\Release\png-0084.png
?????文件???????19825??2002-10-12?03:54??財務軟件v1.61\前臺\bin\Release\png-0098.png
?????文件????????9199??2005-06-08?14:46??財務軟件v1.61\前臺\bin\Release\png-0099.png
?????文件????????8125??2005-04-09?20:21??財務軟件v1.61\前臺\bin\Release\png-0644.png
?????文件????????8746??2005-04-09?20:21??財務軟件v1.61\前臺\bin\Release\png-0650.png
?????文件???????14147??2005-04-09?20:21??財務軟件v1.61\前臺\bin\Release\png-0651.png
............此處省略79個文件信息
評論
共有 條評論