ddd.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
{
    BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {

        if (Session["uid"] == "")
        {
            Response.Redirect("login.aspx");
        }
        if (!IsPostBack)
        {
            this.bind();
        }

    }
    protected void bind()
    {

       

        bc.ExecDropDownList(name, "select * from chargeFeeType", "name", "typeID");
       
       
       string ownerID = Request.QueryString["ID"].ToString();
       string sql = "select * from v_homefee where ID='" + ownerID + "'";
      // Response.Write(sql);
     //  Response.End();
       SqlDataReader sdr = bc.ExecRead(sql);
       if (sdr.Read())
       {
           Label1.Text = sdr["ownerID"].ToString();
           name.Text = sdr["typeID"].ToString();
           txtstart.Text = sdr["startDate"].ToString();
           txtlogindate.Text = sdr["loginDate"].ToString();
           txtsum.Text = sdr["tSum"].ToString();
           yesno.Text = sdr["sign"].ToString();
           Label2.Text = sdr["format"].ToString();

       }
       else
       {
           Response.Write("获取数据失败");
           return;
       }

       











    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string ID = Request.QueryString["ID"].ToString();

        string typeID = name.SelectedItem.Value;
        string startDate = txtstart.Text;
        string loginDate = txtlogindate.Text;
        string tsum = txtsum.Text;
        string sign = yesno.SelectedItem.Value;

        string sql = "update homeChargeFee set typeID=" + typeID + ",startDate='" + startDate + "',loginDate='";
        sql = sql + loginDate + "',tsum=" + tsum + ",sign=" + sign+" where ID="+ID;
       // Response.Write(sql);
     //   Response.End();
        if (bc.ExecSql(sql))
        {
            Response.Write("<script language=javascript>alert('修改成功！');location='homechargefee.aspx'</script>");
        }
        else
        {
            Response.Write("<script>alert(修改失败，请重试！');</script>");
            return;
        }


       
        
    }






}