edithomepark.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 addpavilion : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
       

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

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

            }
        
    }
   
     protected void bind()
    {
        bc.ExecDropDownList(parkname, "select * from basepark", "Name", "parkID");
     
         string id = Request.QueryString["ID"].ToString();
        string sql = "select * from v_homepark where ID=" + id;
        SqlDataReader sdr = bc.ExecRead(sql);
        if (sdr.Read())
        {
            parkname.Text = sdr["parkID"].ToString();
            Label1.Text = sdr["ownerID"].ToString();
            txtcarplace.Text = sdr["carplace"].ToString();
            txtcarcode.Text = sdr["carID"].ToString();
            txttype.Text = sdr["type"].ToString();
            txtbuydate.Text = sdr["buyDate"].ToString();
            txtcolor.Text = sdr["color"].ToString();
        }


      
       





    }


    protected void Button1_Click(object sender, EventArgs e)
    {
        
         string id=Request.QueryString["ID"].ToString();
           string parkID = parkname.SelectedItem.Value;
           string carplace = txtcarplace.Text;
           string carID = txtcarcode.Text;
           string type = txttype.Text;
           string buyDate = txtbuydate.Text;
           string color = txtcolor.Text;

           string valsql = "select count(*) from homepark where (carplace='" + carplace + "' or carID='" + carID + "') and ID!="+id+"";//除此之外是否还有相同的车牌或车位
         //  Response.Write(valsql);
          // Response.End();
           int val=(int)bc.ExecCscalar(valsql);//检查车牌号和车位是否重复添加
           if(val>0)
           {
               Response.Write("<script language=javascript>alert('车牌号或车位重复，请检查！');</script>");
              return;
           }



           string updatesql = "update homepark set parkID='"+parkID+"',carplace='"+carplace+"',carID='";
           updatesql=updatesql+carID+"',type='"+type+"',buyDate='"+buyDate+"',color='"+color+"' where ID="+id;
         // Response.Write(updatesql);
         //  Response.End();
               if (bc.ExecSql(updatesql))
               {
                   Response.Write("<script language=javascript>alert('编辑住户车辆信息成功！');location='homepark.aspx'</script>");
                   return;
               }
               else
               {
                   Response.Write("<script language=javascript>alert('编辑住户车辆信息失败！')</script>");

                   return;
               }




          
       }

      
    }