資源簡介
主要實體為:會員、財務、郵件、日志與系統。
“會員”屬性為:編號、姓名、性別、學院、班級、骨干、QQ、年度、電話、寢室號、生日。
“財務”屬性為:編號、經手人、收支、金額、用途、年度、時間。
“郵件”屬性為:發送人、郵箱地址、發送時間。
“系統”屬性為:管理員、郵箱賬號、發送時間。
“日志”屬性為:Id、用戶、時間、事件。

代碼片段和文件信息
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.IO;
using?ChuDian.DAL;
using?ChuDian.EntityClass;
namespace?ChuDian
{
????public?partial?class?Accounting?:?Form
????{
????????public?Accounting()
????????{
????????????InitializeComponent();
????????????//從數據庫讀取年度下拉列表值
????????????string?sql?=?“select?distinct?年度?from?財務表?order?by?年度“;
????????????System.Data.DataTable?table?=?ChuDian.DAL.DAL.ExecuteDataTable(sql);
????????????comboBoxND.Items.Add(“全體“);
????????????for?(int?i?=?0;?i?????????????{
????????????????comboBoxND.Items.Add(table.Rows[i][0]);
????????????}
????????????//年度下拉列表值
????????????int?time?=?DateTime.Now.Year;
????????????for?(int?i?=?4;?i?>?0;?i--)
????????????{
????????????????comboBoxND2.Items.Add(time?-?i);
????????????}
????????????for?(int?i?=?0;?i?4;?i++)
????????????{
????????????????comboBoxND2.Items.Add(time?+?i);
????????????}
????????}
????????private?void?Accounting_Load(object?sender?EventArgs?e)
????????{
????????????Win32.AnimateWindow(this.Handle?500?Win32.AW_CENTER);
????????????DataTable?dt=?AccountingDAL.ExecuteDataTableMAXBH();
????????????if?(dt.Rows.Count?!=?0)
????????????{
????????????????this.textBoxBH2.Text?=?(Double.Parse(dt.Rows[0][0].ToString())?+?1).ToString();
????????????}
????????????this.comboBoxND2.Text?=?DateTime.Now.Year.ToString();
????????}
????????private?void?buttonCX_Click_1(object?sender?EventArgs?e)
????????{
????????????AccountingDAL.dataTableToListview(CX()?listViewCX);
????????}
????????private?DataTable?CX()
????????{
????????????if?(textBoxJSR.Text?!=?“無限制“)
????????????{
????????????????AccountingDAL.CXsql(“and?經手人?=?‘“?+?textBoxJSR.Text?+?“‘“);
????????????}
????????????if?(textBoxBH.Text?!=?“無限制“)
????????????{
????????????????AccountingDAL.CXsql(“and?編號?=?‘“?+?textBoxBH.Text?+?“‘“);
????????????}
????????????if?(textBoxJE.Text?!=?“無限制“)
????????????{
????????????????AccountingDAL.CXsql(“and?金額?=?‘“?+?textBoxJE.Text?+?“‘“);
????????????}
????????????if?(comboBoxSZ.Text?!=?“全體“)
????????????{
????????????????AccountingDAL.CXsql(“and?收支?=?‘“?+?comboBoxSZ.Text?+?“‘“);
????????????}
????????????if?(textBoxYT.Text?!=?“無限制“)
????????????{
????????????????AccountingDAL.CXsql(“and?用途?=?‘“?+?textBoxYT.Text?+?“‘“);
????????????}
????????????if?(comboBoxND.Text?!=?“全體“)
????????????{
????????????????AccountingDAL.CXsql(“and?年度?=?‘“?+?comboBoxND.Text?+?“‘“);
????????????}
????????????return?AccountingDAL.ExecuteDataTableCX();
????????}
????????private?void?buttonQK_Click(object?sender?EventArgs?e)
????????{
????????????listViewCX.Clear();
????????????textBoxJSR.Text?=?“無限制“;
????????????textBoxBH.Text?=?“無限制“;
????????????textBoxJE.Text?=?“無限制“;
????????????comboBoxSZ.Text?=?“全體“;
????????????textBoxY
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????7454??2013-10-16?19:10??社團管理系統\ChuDian\Accounting.cs
?????文件??????29102??2013-10-16?19:10??社團管理系統\ChuDian\Accounting.Designer.cs
?????文件???????5817??2013-10-16?19:10??社團管理系統\ChuDian\Accounting.resx
?????文件????????238??2013-10-16?19:10??社團管理系統\ChuDian\App.config
?????文件?????339456??2013-10-16?19:10??社團管理系統\ChuDian\bin\Debug\ChuDian.exe
?????文件????????239??2013-10-16?19:10??社團管理系統\ChuDian\bin\Debug\ChuDian.exe.config
?????文件?????157184??2013-10-16?19:10??社團管理系統\ChuDian\bin\Debug\ChuDian.pdb
?????文件??????22984??2013-10-16?19:10??社團管理系統\ChuDian\bin\Debug\ChuDian.vshost.exe
?????文件????????239??2013-10-16?19:10??社團管理系統\ChuDian\bin\Debug\ChuDian.vshost.exe.config
?????文件??????34304??2013-10-16?19:10??社團管理系統\ChuDian\bin\Debug\zh\ChuDian.resources.dll
?????文件??????10240??2013-10-16?19:10??社團管理系統\ChuDian\bin\Debug\zu\ChuDian.resources.dll
?????文件?????403968??2013-10-16?19:10??社團管理系統\ChuDian\bin\Release\ChuDian.exe
?????文件????????236??2013-10-16?19:10??社團管理系統\ChuDian\bin\Release\ChuDian.exe.Config
?????文件?????146944??2013-10-16?19:10??社團管理系統\ChuDian\bin\Release\ChuDian.pdb
?????文件??????22984??2013-10-20?18:49??社團管理系統\ChuDian\bin\Release\ChuDian.vshost.exe
?????文件????????236??2013-10-16?19:10??社團管理系統\ChuDian\bin\Release\ChuDian.vshost.exe.config
?????文件????????490??2012-06-06?02:06??社團管理系統\ChuDian\bin\Release\ChuDian.vshost.exe.manifest
?????文件????????238??2013-10-16?19:10??社團管理系統\ChuDian\bin\Release\觸電.vshost.exe.config
?????文件????????490??2013-10-16?19:10??社團管理系統\ChuDian\bin\Release\觸電.vshost.exe.manifest
?????文件???????7696??2013-10-16?19:10??社團管理系統\ChuDian\ChuDian.csproj
?????文件???????1950??2013-10-16?19:10??社團管理系統\ChuDian\DAL\AccountingDAL.cs
?????文件???????4731??2013-10-16?19:10??社團管理系統\ChuDian\DAL\DAL.cs
?????文件???????1129??2013-10-16?19:10??社團管理系統\ChuDian\DAL\EMailDAL.cs
?????文件???????3207??2013-10-16?19:10??社團管理系統\ChuDian\DAL\MembershipDAL.cs
?????文件???????5886??2013-10-16?19:10??社團管理系統\ChuDian\EMail.cs
?????文件??????14071??2013-10-16?19:10??社團管理系統\ChuDian\EMail.Designer.cs
?????文件???????5817??2013-10-16?19:10??社團管理系統\ChuDian\EMail.resx
?????文件???????2989??2013-10-16?19:10??社團管理系統\ChuDian\EMails.cs
?????文件????????469??2013-10-16?19:10??社團管理系統\ChuDian\EntityClass\AccountingInfo.cs
?????文件???????3298??2013-10-16?19:10??社團管理系統\ChuDian\EntityClass\MenbershipInfo.cs
............此處省略112個文件信息
- 上一篇:餐飲管理系統+(SQL 數據庫C#源代碼)
- 下一篇:asp.net多頁簽頁面切換
評論
共有 條評論