edituser.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)
    {
        //Response.Write(Session["ownerID"]);
        //Response.End();
        if (!IsPostBack)
        {


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

            else
            {
                string user = Convert.ToString(Session["code"]);

                BaseClass bc = new BaseClass();
                string sqlstr = "select * from homeHold where code='" + user + "'";


                SqlDataReader sda = bc.ExecRead(sqlstr);

                try
                {
                    if (sda.Read())
                    {
                        Label1.Text = sda["uid"].ToString();

                    }
                }
                catch
                {

                }
                finally
                {
                    bc.Closeconn();
                }
            }








        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {


        if (val())
        {


            string username = TextBox2.Text;
            string ownerid = Session["code"].ToString();

            //Response.Write(ownerid);
            //Response.End();

            BaseClass bcc = new BaseClass();




            string sqlstr = "update homeHold set uid='" + username + "' where code='" + ownerid + "'";

            if (bcc.ExecSql(sqlstr))
            {
                Response.Write("<script>alert('恭喜您，修改成功！');</script>");
            }
            else
            {
                Response.Write("<script>alert('操作失败！');</script>");
            }

            bcc.Closeconn();
        }
        else
        {

            Response.Write("<script>alert('对不起，用户名已有人注册！');</script>");
            return;
        }

    }

    # region 检测用户名是否可用
    /// <summary>
    /// 检测用户名是否可用
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Button3_Click(object sender, EventArgs e)
    {

        if (val())
        {
            Response.Write("<script>alert('恭喜您，用户名可用！');</script>");
        }
        else
        {
            Response.Write("<script>alert('对不起，用户名已有人注册！');</script>");
        }
    }
    #endregion


    //判断函数，判断用户名是否可用，返回ＴＲＥＵ
    protected bool val()
    {
        string conn = Convert.ToString(ConfigurationManager.ConnectionStrings["SmallHouseConn"]);

        SqlConnection sqlcon = new SqlConnection(conn);
        sqlcon.Open();
        string sqlstr = "select count(*) from homeHold where uid='" + TextBox2.Text.ToString() + "'";


        //Response.Write(sqlstr);
        SqlCommand scd = new SqlCommand(sqlstr, sqlcon);
        int count = Convert.ToInt32(scd.ExecuteScalar());

        //Response.Write(count);
        //Response.End();

        if (count <= 0)
        {

            return true;
        }
        else
        {

            return false;

        }

    }



}