温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:小区物业管理系统源码
当前文件:
SmallHouse/admin/editchargetype.aspx.cs,打开代码结构图
SmallHouse/admin/editchargetype.aspx.cs,打开代码结构图1using System; 2
using System.Data; 3
using System.Configuration; 4
using System.Collections; 5
using System.Web; 6
using System.Web.Security; 7
using System.Web.UI; 8
using System.Web.UI.WebControls; 9
using System.Web.UI.WebControls.WebParts; 10
using System.Web.UI.HtmlControls; 11
using System.Data.SqlClient; 12
13
public partial class admin_Default2 : System.Web.UI.Page 14
{ 15
protected void Page_Load(object sender, EventArgs e) 16
{ 17
18
19
20
if (Convert.ToString(Session["UID"]) == "") 21
{ 22
Response.Redirect("login.aspx"); 23
24
} 25
if (!IsPostBack) 26
{ 27
this.bind(); 28
29
} 30
31
32
} 33
34
protected void bind() 35
{ 36
string ID = Request.QueryString["ID"].ToString(); 37
string str = "select * from chargeFeetype where typeID='" + ID + "'"; 38
39
BaseClass bc = new BaseClass(); 40
41
SqlDataReader sda = bc.ExecRead(str); 42
if (sda.Read()) 43
{ //绑定数据 44
TextBox1.Text = sda["Name"].ToString(); 45
TextBox2.Text = sda["textmemo"].ToString(); 46
TextBox3.Text = sda["format"].ToString(); 47
48
49
} 50
51
52
bc.Closeconn(); 53
54
55
} 56
57
58
59
protected void Button1_Click(object sender, EventArgs e) 60
{ 61
BaseClass bcc = new BaseClass(); 62
string name = TextBox1.Text; 63
string textmemo = TextBox2.Text; 64
string format = TextBox3.Text; 65
66
string sqlstr = "update chargeFeeType set Name='" +name+ "',textmemo='" + textmemo +"',format='"+format+"' where typeID="+Request["ID"].ToString()+""; 67
// Response.Write(sqlstr); 68
// Response.End(); 69
70
if (bcc.ExecSql(sqlstr)) 71
{ 72
Response.Write("<script language=javascript>alert('修改小区收费成功!');location='chargetype.aspx'</script>"); 73
} 74
else 75
{ 76
Response.Write("<script>alert('修改失败,请重试!');</script>"); 77
} 78
79
} 80
} 81





}
}