//文件名：BuildingForm.cs
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;

using?Microsoft.Office.Interop.Excel;
using?System.Reflection;
using?Microsoft.Office.Core;
namespace?MyCommunity
{
?public?partial?class?BuildingForm?:?Form
?{
????public?BuildingForm（）
????{
??????InitializeComponent（）;
????}
????public?string?MyCommunity;
????private?void?樓棟信息BindingNavigatorSaveItem_Click（object?sender?EventArgs?e）
????{
??????if?（（Convert.ToDouble（this.總戶數TextBox.Text）?-?Convert.ToDouble（this.入住戶數TextBox.Text）?!=?Convert.ToDouble（this.空置戶數TextBox.Text））?||?（Convert.ToDouble（this.總戶數TextBox.Text）?-?Convert.ToDouble（this.住宅戶數TextBox.Text）?!=?Convert.ToDouble（this.商用戶數TextBox.Text）））
??????{
????????MessageBox.Show（“總戶數、入住戶數、空置戶數、住宅戶數、商用戶數其中之一有錯！“?“信息提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????return;
??????}
??????this.Validate（）;
??????this.樓棟信息BindingSource.EndEdit（）;
??????this.樓棟信息TableAdapter.Update（this.dBCommunityDataSet.樓棟信息）;
????}
????private?void?BuildingForm_Load（object?sender?EventArgs?e）
????{
??????//?TODO:?這行代碼將數據加載到表“dBCommunityDataSet.樓棟信息”中
??????this.樓棟信息TableAdapter.Fill（this.dBCommunityDataSet.樓棟信息）;
????}
????private?void?打印ToolStripButton_Click（object?sender?EventArgs?e）
????{//打印樓棟信息
??????ApplicationClass?MyExcel;
??????Workbooks?MyWorkBooks;
??????Workbook?MyWorkBook;
??????Worksheet?MyWorkSheet;
??????char?MyColumns;
??????Range?MyRange;
??????object[]?MyData?=?new?object[500?35];
??????int?i?j;
??????MyExcel?=?new?ApplicationClass（）;
??????MyExcel.Visible?=?true;
??????if?（MyExcel?==?null）
??????{
????????MessageBox.Show（“Excel程序無法啟動！“?“信息提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????return;
??????}
??????MyWorkBooks?=?MyExcel.Workbooks;
??????MyWorkBook?=?MyWorkBooks.Add（Missing.Value）;
??????MyWorkSheet?=?（Worksheet）MyWorkBook.Worksheets[1];
??????MyColumns?=?（char）（this.dBCommunityDataSet.樓棟信息.Columns.Count?+?64）;
??????MyRange?=?MyWorkSheet.get_Range（“A5“?MyColumns.ToString（）?+?“5“）;
??????int?Count?=?0;
??????foreach?（DataColumn?MyNewColumn?in?this.dBCommunityDataSet.樓棟信息.Columns）
??????{
????????MyData[0?Count]?=?MyNewColumn.ColumnName;
????????Count?=?Count?+?1;
??????}
??????j?=?1;
??????//輸出數據庫記錄
??????foreach?（DataRow?MyRow?in?this.dBCommunityDataSet.樓棟信息.Rows）
??????{
???????for?（i?=?0;?i????????{
?????????MyData[j?i]?=?MyRow[i].ToString（）;
???????}
???????j++;
??????}
??????MyRange?=?MyRange.get_Resize（this.dBCommunityDataSet.樓棟信息.Rows.Count?+?1?this.dBCommunityDataSet.樓棟信息.Columns.Count）;
??????MyRange.Value2?=?MyData;
??????MyRange.EntireColumn.AutoFit（）;
??????MyWorkSheet.Cells[2?2]?=?this.MyCommunity?+?“樓棟信息表“;
??????Range?MyRange22?=?MyWorkSheet.get_Range（“B2“?“B2“）;
??????MyRange22.Font.Bold?=?true;
??????MyRange22.

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

?????文件????????441??2007-11-29?08:41??第1章?小區物業管理系統\MyCommunity\MyCommunity\app.config

?????文件???????5632??2005-11-11?22:25??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Debug\MyCommunity.vshost.exe

?????文件????2093056??2007-12-07?14:45??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\Data\DBCommunity.mdb

?????文件??????66964??2007-07-07?09:03??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\Data\GodLakeHome.JPG

?????文件????????766??2006-12-10?16:49??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\Data\GodLakeLogo.ico

?????文件??????55218??2007-06-27?09:39??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\Data\HuaMeiHome.jpg

?????文件???????2238??1996-07-04?00:00??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\Data\HuaMeiLogo.ico

?????文件??????72398??2007-12-01?16:44??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\Data\ShowGodLakeHome.JPG

?????文件??????62013??2007-10-08?21:14??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\Data\ShowHuaMeiHome.jpg

?????文件???????7168??2007-11-29?15:10??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\Interop.IasHelperLib.dll

?????文件?????839680??2007-12-07?14:35??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\MyCommunity.exe

?????文件????????441??2007-11-29?08:41??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\MyCommunity.exe.config

?????文件?????927232??2007-12-07?14:35??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\MyCommunity.pdb

?????文件???????5632??2005-11-11?22:25??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\MyCommunity.vshost.exe

?????文件????????441??2007-11-29?08:41??第1章?小區物業管理系統\MyCommunity\MyCommunity\bin\Release\MyCommunity.vshost.exe.config

?????文件???????3436??2007-12-01?16:51??第1章?小區物業管理系統\MyCommunity\MyCommunity\BuildingForm.cs

?????文件??????46281??2007-11-29?15:13??第1章?小區物業管理系統\MyCommunity\MyCommunity\BuildingForm.Designer.cs

?????文件??????16374??2007-11-29?15:13??第1章?小區物業管理系統\MyCommunity\MyCommunity\BuildingForm.resx

?????文件???????2785??2007-12-01?08:53??第1章?小區物業管理系統\MyCommunity\MyCommunity\ChangeUserPasswordForm.cs

?????文件???????8760??2007-11-29?11:19??第1章?小區物業管理系統\MyCommunity\MyCommunity\ChangeUserPasswordForm.Designer.cs

?????文件???????7080??2007-11-29?11:19??第1章?小區物業管理系統\MyCommunity\MyCommunity\ChangeUserPasswordForm.resx

?????文件???????3125??2007-12-01?08:55??第1章?小區物業管理系統\MyCommunity\MyCommunity\CommonPropertyForm.cs

?????文件??????39951??2007-11-29?15:37??第1章?小區物業管理系統\MyCommunity\MyCommunity\CommonPropertyForm.Designer.cs

?????文件??????15417??2007-11-29?15:37??第1章?小區物業管理系統\MyCommunity\MyCommunity\CommonPropertyForm.resx

?????文件???????6358??2007-12-01?08:57??第1章?小區物業管理系統\MyCommunity\MyCommunity\CommonRepairForm.cs

?????文件??????51940??2007-11-30?15:14??第1章?小區物業管理系統\MyCommunity\MyCommunity\CommonRepairForm.Designer.cs

?????文件??????33375??2007-11-30?15:14??第1章?小區物業管理系統\MyCommunity\MyCommunity\CommonRepairForm.resx

?????文件???????2402??2007-12-01?16:40??第1章?小區物業管理系統\MyCommunity\MyCommunity\CommunityForm.cs

?????文件??????43033??2007-12-01?16:40??第1章?小區物業管理系統\MyCommunity\MyCommunity\CommunityForm.Designer.cs

?????文件??????15039??2007-12-01?16:40??第1章?小區物業管理系統\MyCommunity\MyCommunity\CommunityForm.resx

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