資源簡介
系統功能基本要求 :
1. 操作員權限管理
2. 水電費單價設置
3. 樓宇信息的錄入
4. 樓宇住戶信息錄入
5. 水電費用量信息錄入
6. 欠繳水電費查詢:查詢每月的水電用量及費用的統計信息,包括:
實際用水量、本月水損耗、本月水損耗率、公共用水合計、水費單價;
實際用電量、本月電損耗、本月電損耗率、公共用電量分攤、電費單價

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Data;
using?System.Data.SqlClient;
public?partial?class?DetailChange?:?System.Web.UI.Page
{
????protected?void?Page_Load(object?sender?EventArgs?e)
????{
????}
????protected?void?ImageButton1_Click(object?sender?ImageClickEventArgs?e)
????{
????????String?number;
????????String?buildings?unit?house_number?house_hold;
????????buildings?=?this.TextBox1.Text.ToString();
????????unit?=?this.TextBox2.Text.ToString();
????????house_number?=?this.TextBox3.Text.ToString();
????????house_hold?=?this.TextBox4.Text.ToString();
????????string?strConn?=?System.Configuration.ConfigurationManager.AppSettings[“DSN“];
????????SqlConnection?Conn?=?new?SqlConnection(strConn);
????????Conn.Open();
????????string?sql1?=?“select?number?from?house?where?buildings=‘“?+?buildings?+?“‘and?unit=‘“?+?unit?+?“‘?and?house_number=‘“?+?house_number?+?“‘?and?house_hold=‘“?+?house_hold?+?“‘“;
????????SqlCommand?cmd?=?new?SqlCommand(sql1?Conn);
????????SqlDataReader?reader?=?cmd.ExecuteReader();
????????if?(reader.Read())
????????{
????????????number?=?reader[“number“].ToString();
????????????Session[“number“]?=?number;
????????????Conn.Close();
????????}
????????else
????????{
????????????Response.Write(“ript>alert(\“此用戶不存在!\“) ript>“);
????????}
????}
????protected?void?ImageButton2_Click(object?sender?ImageClickEventArgs?e)
????{
????????Response.Redirect(“HomePage.aspx“);
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-03-16?20:59??水電費管理課設1\
?????文件???????21321??2014-01-05?02:34??水電費管理課設1\123.png
?????文件???????38794??2014-01-05?14:47??水電費管理課設1\12345.png
?????文件???????18594??2014-01-05?02:35??水電費管理課設1\456.png
?????文件???????27774??2014-01-05?02:33??水電費管理課設1\789.png
?????文件??????369196??2014-03-13?23:25??水電費管理課設1\aaa.jpg
?????文件??????268110??2014-01-05?13:54??水電費管理課設1\asd.jpg
?????文件??????236823??2014-03-13?23:27??水電費管理課設1\bbb.jpg
?????目錄???????????0??2014-03-16?20:59??水電費管理課設1\Bin\
?????文件????????5120??2012-06-19?14:18??水電費管理課設1\Bin\AspNet.sc
?????文件??????????96??2014-03-13?16:07??水電費管理課設1\Bin\AspNet.sc
?????文件??????560883??2014-03-13?23:27??水電費管理課設1\ccc.jpg
?????文件???????11235??2014-03-13?23:07??水電費管理課設1\DetailChange.aspx
?????文件????????1609??2014-03-13?23:07??水電費管理課設1\DetailChange.aspx.cs
?????文件????????9497??2014-03-13?20:30??水電費管理課設1\HomePage.aspx
?????文件????????8825??2014-03-13?22:37??水電費管理課設1\HomePage.aspx.cs
?????文件????????4846??2014-03-13?23:35??水電費管理課設1\LoginPage.aspx
?????文件????????2820??2014-03-13?21:28??水電費管理課設1\LoginPage.aspx.cs
?????文件????????4800??2014-03-14?15:41??水電費管理課設1\PassWord.aspx
?????文件????????1913??2014-03-14?15:41??水電費管理課設1\PassWord.aspx.cs
?????文件????????6452??2014-03-13?22:12??水電費管理課設1\PersonData.aspx
?????文件????????2718??2014-03-13?22:37??水電費管理課設1\PersonData.aspx.cs
?????文件?????????653??2014-03-13?14:55??水電費管理課設1\Web.config
?????文件??????710273??2011-10-26?16:39??水電費管理課設1\zxc.jpg
- 上一篇:員工考勤管理信息系統
- 下一篇:長途汽車信息管理系統
評論
共有 條評論