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;

namespace?余款軟件
{
????public?partial?class?Frm_Add?:?Form
????{
????????public?Frm_Add（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????string?Conn?=?“provider=microsoft.jet.oledb.4.0;“;
????????????Conn?+=?“?data?source=mydata.mdb“;
????????????OleDbConnection?myconn?=?new?OleDbConnection（Conn）;
????????????myconn.Open（）;

????????????if?（txt酒店名.Text?==?““?||?txt顧客名.Text?==?““?||?txt費用.Text?==?““?||?txt備注.Text?==?““?||?txt流水號.Text?==?““）
????????????{
????????????????MessageBox.Show（“有部分項目為空值請填滿!“?“來自系統的消息“）;
????????????}



????????????else
????????????{
????????????????string?insStr?=?“insert?into?hotel?（jiudianminggukemingjinebeizhuliushuihaoriqiyuenian）?values?（‘“?+?txt酒店名.Text?+?“‘‘“?+?txt顧客名.Text?+?“‘‘“?+?txt費用.Text?+?“‘‘“?+?txt備注.Text?+?“‘‘“?+?txt流水號.Text?+?“‘‘“?+?DateTime.Now.ToString（）?+?“‘‘“?+?DateTime.Now.Month.ToString（）?+?“‘‘“?+?DateTime.Now.Year.ToString（）?+?“‘）“;?//‘“?+?DateTime.Now.ToString（）?+?“‘‘“?+??DateTime.Now.Month.ToString（）?+?“‘‘“?+?DateTime.Now.Year.ToString（）+?“‘
????????????????OleDbCommand?myCmd?=?new?OleDbCommand（insStr?myconn）;
????????????????myCmd.ExecuteNonQuery（）;
????????????????myconn.Close（）;
????????????????MessageBox.Show（“添加成功!“?“來自系統的消息“）;

????????????????txt酒店名.Text?=?““;
????????????????txt顧客名.Text?=?““;
????????????????txt費用.Text?=?““;
????????????????txt備注.Text?=?““;
????????????????txt流水號.Text?=?““;
????????????}
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????txt酒店名.Text?=?““;
????????????txt顧客名.Text?=?““;
????????????txt費用.Text?=?““;
????????????txt備注.Text?=?““;
????????????txt流水號.Text?=?““;
????????}

????????private?void?button3_Click（object?sender?EventArgs?e）
????????{
????????????Frm_Main?f1?=?new?Frm_Main（）;
????????????f1.Show（）;
????????????this.Hide（）;
????????}

????????private?void?txt費用_KeyPress（object?sender?KeyPressEventArgs?e）
????????{
????????????if?（（e.KeyChar?>=?‘0‘?&&?e.KeyChar?<=?‘9‘）?||?e.KeyChar?==?‘.‘?||?e.KeyChar?==?‘-‘?||?e.KeyChar?==?‘\b‘）?//‘\b‘為回退字符
????????????{
????????????????e.Handled?=?false;
????????????}
????????????else
????????????{
????????????????e.Handled?=?true;
????????????????MessageBox.Show（“只能輸入數字或者小數點!“?“來自系統的消息“）;

????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-05-19?20:20??余款軟件\
?????目錄???????????0??2015-05-22?21:02??余款軟件\余款軟件\
?????文件?????????878??2015-05-19?20:20??余款軟件\余款軟件.sln
?????文件???????34304??2015-05-23?00:53??余款軟件\余款軟件.suo
?????目錄???????????0??2015-05-21?20:07??余款軟件\余款軟件\bin\
?????目錄???????????0??2015-05-23?00:52??余款軟件\余款軟件\bin\Debug\
?????文件??????662120??2015-05-21?20:06??余款軟件\余款軟件\bin\Debug\Microsoft.Office.Interop.Word.dll
?????文件??????389120??2015-05-23?00:46??余款軟件\余款軟件\bin\Debug\mydata.mdb
?????文件???????42496??2015-05-23?00:46??余款軟件\余款軟件\bin\Debug\余款軟件.exe
?????文件???????81408??2015-05-23?00:46??余款軟件\余款軟件\bin\Debug\余款軟件.pdb
?????文件???????11600??2015-05-23?00:52??余款軟件\余款軟件\bin\Debug\余款軟件.vshost.exe
?????文件?????????490??2010-03-17?22:39??余款軟件\余款軟件\bin\Debug\余款軟件.vshost.exe.manifest
?????文件??????662120??2015-05-21?20:06??余款軟件\余款軟件\bin\Microsoft.Office.Interop.Word.dll
?????目錄???????????0??2015-05-19?20:21??余款軟件\余款軟件\bin\Release\
?????文件????????2860??2015-05-23?00:45??余款軟件\余款軟件\Frm_Add.cs
?????文件???????11682??2015-05-22?21:01??余款軟件\余款軟件\Frm_Add.Designer.cs
?????文件????????5817??2015-05-22?21:01??余款軟件\余款軟件\Frm_Add.resx
?????文件????????3181??2015-05-19?20:42??余款軟件\余款軟件\Frm_Cal_Hotel.cs
?????文件????????9740??2015-05-19?20:42??余款軟件\余款軟件\Frm_Cal_Hotel.Designer.cs
?????文件????????5817??2015-05-19?20:42??余款軟件\余款軟件\Frm_Cal_Hotel.resx
?????文件????????3242??2015-05-19?20:45??余款軟件\余款軟件\Frm_Cal_Personal.cs
?????文件????????9753??2015-05-19?20:44??余款軟件\余款軟件\Frm_Cal_Personal.Designer.cs
?????文件????????5817??2015-05-19?20:44??余款軟件\余款軟件\Frm_Cal_Personal.resx
?????文件????????3459??2015-05-23?00:17??余款軟件\余款軟件\Frm_Cal_PinH.cs
?????文件???????10959??2015-05-19?20:48??余款軟件\余款軟件\Frm_Cal_PinH.Designer.cs
?????文件????????5817??2015-05-19?20:48??余款軟件\余款軟件\Frm_Cal_PinH.resx
?????文件????????1591??2015-05-19?20:36??余款軟件\余款軟件\Frm_Main.cs
?????文件????????8634??2015-05-19?20:35??余款軟件\余款軟件\Frm_Main.Designer.cs
?????文件????????6015??2015-05-19?20:35??余款軟件\余款軟件\Frm_Main.resx
?????文件????????7919??2015-05-23?00:41??余款軟件\余款軟件\Frm_Select.cs
?????文件???????11858??2015-05-23?00:14??余款軟件\余款軟件\Frm_Select.Designer.cs
............此處省略33個文件信息