addhomepark.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");
        bc.ExecDropDownList(pav, "select * from pavilion", "Name", "paID");//楼宇
        bc.ExecDropDownList(cell, "select * from type where type='DY'", "name", "code");//单元
        string pavcell = pav.SelectedItem.Value.ToString() + cell.SelectedItem.Value.ToString();
        int pavcelllength = pavcell.Length;
        string sql = "select Code,ownerID from room where left(Code," + pavcelllength + ")=" + pavcell + " and state=1";
        // Response.Write(sql);
        //  Response.End();
        bc.ExecDropDownList(ddlownerID, sql, "ownerID", "Code");





    }


    protected void Button1_Click(object sender, EventArgs e)
    {
        string sql = "select amount from basepark where parkID=" + parkname.SelectedItem.Value;

       int parkcount=(int)bc.ExecCscalar(sql);//实际停车数量

       string sql2 = "select count(*) from homepark where parkID=" + parkname.SelectedItem.Value;
       int parkcounted = (int)bc.ExecCscalar(sql2);//已有车辆数量

       if (parkcounted > parkcount)
       {
           Response.Write("<script language=javascript>alert('停车场已潢，请选择其它停车场！');</script>");

           return;
       }
       else
       {
           string code=ddlownerID.SelectedItem.Value;
           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 + "'";
           //int val=(int)bc.ExecCscalar(valsql);//检查车牌号和车位是否重复添加
           //if(val>0)
           //{
           //    Response.Write("<script language=javascript>alert('车牌号或车位重复，请检查！');</script>");
           //   return;
           //}
           string valsql2 = "select count(*) from homepark  where carplace='" + carplace + "' and parkID=" + parkID + "";
          int val = (int)bc.ExecCscalar(valsql2);
           if (val > 0)
           {
               Response.Write("<script language=javascript>alert('停车场:"+parkname.SelectedItem.Text+"停车位已有住户！');</script>");
               return;
           }



           string insertsql = "insert into homepark (code,parkID,carplace,carID,type,buyDate,color)values('";
               insertsql += code + "','" + parkID + "','" + carplace + "','" + carID + "','" +type+"','"+ buyDate + "','" + color + "')";
         //  Response.Write(insertsql);
          // Response.End();
               if (bc.ExecSql(insertsql))
               {
                   Response.Write("<script language=javascript>alert('添加住户车输信息成功！');location='homepark.aspx'</script>");
                   return;
               }
               else
               {
                   Response.Write("<script language=javascript>alert('添加住户车辆信息失败！')</script>");

                   return;
               }




          
       }

      
    }

    protected void cell_SelectedIndexChanged(object sender, EventArgs e)
    {
        string pavcell = pav.SelectedItem.Value.ToString() + cell.SelectedItem.Value.ToString();
        int pavcelllength = pavcell.Length;
        string sql = "select Code,ownerID from room where left(Code," + pavcelllength + ")=" + pavcell + " and state=1";
        // Response.Write(sql);
        //  Response.End();
        bc.ExecDropDownList(ddlownerID, sql, "ownerID", "Code");
    }
}