editchargetype.aspx.cs

物业管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class admin_Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {


       
            if (Convert.ToString(Session["UID"]) == "")
            {
                Response.Redirect("login.aspx");

            }
            if (!IsPostBack)
            {
                this.bind();

            }
        
      
    }

    protected void bind()
    {
        string ID = Request.QueryString["ID"].ToString();
        string str = "select * from chargeFeetype where typeID='" + ID + "'";

        BaseClass bc = new BaseClass();

        SqlDataReader sda = bc.ExecRead(str);
        if (sda.Read())
        {   //绑定数据
            TextBox1.Text = sda["Name"].ToString();
            TextBox2.Text = sda["textmemo"].ToString();
            TextBox3.Text = sda["format"].ToString();
            
        
        }


        bc.Closeconn(); 


    }


    
    protected void Button1_Click(object sender, EventArgs e)
    {
        BaseClass bcc = new BaseClass();
        string name = TextBox1.Text;
        string textmemo = TextBox2.Text;
        string format = TextBox3.Text;

    string sqlstr = "update chargeFeeType set Name='" +name+ "',textmemo='" + textmemo +"',format='"+format+"' where typeID="+Request["ID"].ToString()+"";
  //  Response.Write(sqlstr);
   // Response.End();

        if (bcc.ExecSql(sqlstr))
        {
            Response.Write("<script language=javascript>alert('修改小区收费成功！');location='chargetype.aspx'</script>");
        }
        else
        {
            Response.Write("<script>alert('修改失败，请重试！');</script>");
        }

    }
}