updatemsg.aspx.cs

校友录的总体功能分为三个子功能模块:管理功能模块,用户注册功能模块,用户个性化服务

                                //Question=@Question ,
                                //Answer=@Answer ,
                                //PicName=@PicName ,
                                //Remark=@Remark ,
                                //Sex=@Sex,
                                //Tele=@Tele  ,
                                //MobilePh=@MobilePh ,
                                //QQ=@QQ ,
                                //Email=@Email ,
                                //Country=@Country ,
                                //Province=@Province ,
                                //City=@City,
                                //Address=@Address ,
                                //PostNum=@PostNum ,
                                //biryear=@biryear   ,
                                //birmounth=@birmounth  ,
                                //birday=@birday

        //                        //where     UserID=@UserID




      //  Sqlcmd();
        StoredProcedure();
        datalist();

    }
    public void Sqlcmd()
    {

//        <Tab Name="C#"> SqlConnection myConnection = new SqlConnection("server=(local)NetSDK;database=pubs;Trusted_Connection=yes");
   //     SqlCommand myCommand = new SqlCommand( "UPDATE Authors SET phone=[phone] WHERE au_id = 123-45-6789", myConnection);

//myCommand.Connection.Open(); myCommand.ExecuteNonQuery(); myCommand.Connection.Close();
//</Tab>

        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        string sql, strsex, strpro, strcity;
        //  cmdUpdateB=new SqlCommand("update data set Datas='"+this.TextBox3.Text+"'where ID=2 ",con);
        if (this.Boy.Checked == true)
            strsex =  this.Boy.Text.Trim()  ;

        else
            strsex =   this.Girl.Text.Trim() ;
        if (this.Country.SelectedIndex == 0)
        {
            strpro =  this.Province.SelectedItem.Text.Trim()   ;
            strcity =   this.City.SelectedItem.Text.Trim() ;


        }
        else
        {
            strpro ="";
            strcity = "";

            //   this.City.SelectedItem.Text;IdToCity(strcity)
        }



        sql = "update UserInfo SET PWD='" + this.Password.Text.Trim() + "', NickName='" + this.NickName.Text.Trim() + "' ,Question='" + this.Question.Text.Trim() + "' ,Answer='" + this.Answer.Text.Trim() + "' ,PicName='" + "~/HeadPic/" + this.Figure.SelectedItem.Text.Trim() + "', Remark='" + this.Remark.Text.Trim() + "', Sex='" + strsex + "' ,Tele='" + this.Tele.Text.Trim() + "' ,MobilePh='" + this.Mobile.Text.Trim() + "' ,QQ='" + this.QQ.Text.Trim() + "', Email='" + this.Email.Text.Trim() + "', Country='" + this.Country.SelectedItem.Text.Trim() + "', Province='" + strpro + "', City='" + strcity + "' ,Address='" + this.Address.Text.Trim() + "', PostNum='" + this.Post.Text.Trim() + "', biryear='" + this.Year.Text.Trim() + "', birmounth='" + this.Mounth.Text.Trim() + "',birday='" + this.Day.Text.Trim() + "'where UserID='" + Session["UserID"].ToString().Trim() + "' ";

       // sql+="NickName='" + this.NickName.Text.Trim() + "' ";
        //sql += "Question='" + this.Question.Text.Trim() + "' ";
        //sql += "Answer='" + this.Answer.Text.Trim() + "' ";
        //sql += "PicName='" + "~/HeadPic/" + this.Figure.SelectedItem.Text.Trim() + "' ";
        //sql += "Remark='" + this.Remark.Text.Trim() + "' ";
        //if (this.Boy.Checked == true)
        //    sql += "Sex='" + this.Boy.Text.Trim() + "' ";

        //else
        //    sql += "Sex='" + this.Girl.Text.Trim() + "' ";


        //sql += "Tele='" + this.Tele.Text.Trim() + "' ";
        //sql += "MobilePh='" + this.Mobile.Text.Trim() + "' ";
        //sql += "QQ='" + this.QQ.Text.Trim() + "' "; 
        //sql += "Email='" + this.Email.Text.Trim() + "' ";
        //sql += "Country='" + this.Country.SelectedItem.Text.Trim() + "' ";


        //if (this.Country.SelectedIndex == 0)
        //{
        //    sql += "Province='" + this.Province.SelectedItem.Text.Trim() + "' ";
        //   sql+="City='"+this.City.SelectedItem.Text.Trim()+"' ";


        //}
        //else
        //{
        //    sql += "Province='' ";
        //    sql += "City='' ";

        //    //   this.City.SelectedItem.Text;IdToCity(strcity)
        //}

        ////cmd.Parameters["@Address"].Value = this.Address.Text.Trim();
        ////cmd.Parameters["@PostNum"].Value = this.Post.Text.Trim();
        ////cmd.Parameters["@biryear"].Value = this.Year.Text.Trim();
        ////cmd.Parameters["@birmounth"].Value = this.Mounth.Text.Trim();
        ////cmd.Parameters["@birday"].Value = this.Day.Text.Trim();
        //sql += "Address='" + this.Address.Text.Trim() + "' ";
        //sql += "PostNum='" + this.Post.Text.Trim() + "' ";
        //sql += "biryear='" + this.Year.Text.Trim() + "' ";
        //sql += "bircounth='" + this.Mounth.Text.Trim() + "' ";
        //sql += "birday='" + this.Day.Text.Trim() + "' ";
        //sql+="where UserID='"+ Session["UserID"].ToString().Trim()+"' ";
        SqlCommand cmd = new SqlCommand(sql, conn);
        cmd.Connection.Open();
        //try
        //{
        //    //this.Remark.Text = 
        //    //this.Remark.Text = Convert.ToString(cmd.ExecuteNonQuery());
        cmd.ExecuteNonQuery();
        //}
        //catch (SqlException ex)
        //{
        //    this.Remark.Text = ex.ToString();
        //    Response.Write("wrong");

        //}
       cmd.Connection.Close();

        ////   this.selspan.InnerHtml =





    }
    public void StoredProcedure()
    {

        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        SqlCommand cmd = new SqlCommand("updatemsg", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Char, 20));
        cmd.Parameters.Add(new SqlParameter("@PWD", SqlDbType.NChar, 16));
        cmd.Parameters.Add(new SqlParameter("@NickName", SqlDbType.Char, 10));
        cmd.Parameters.Add(new SqlParameter("@Question", SqlDbType.VarChar, 50));
        cmd.Parameters.Add(new SqlParameter("@Answer", SqlDbType.VarChar, 50));
        cmd.Parameters.Add(new SqlParameter("@PicName", SqlDbType.NChar, 60));
        cmd.Parameters.Add(new SqlParameter("@Remark", SqlDbType.NVarChar, 200));
        cmd.Parameters.Add(new SqlParameter("@Sex", SqlDbType.Char, 20));
        cmd.Parameters.Add(new SqlParameter("@Tele", SqlDbType.Char, 20));
        cmd.Parameters.Add(new SqlParameter("@MobilePh", SqlDbType.NChar, 16));
        cmd.Parameters.Add(new SqlParameter("@QQ", SqlDbType.Char, 10));
        cmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.NChar, 30));
        cmd.Parameters.Add(new SqlParameter("@Country", SqlDbType.Char, 10));
        cmd.Parameters.Add(new SqlParameter("@Province", SqlDbType.Char, 10));
        cmd.Parameters.Add(new SqlParameter("@City", SqlDbType.Char, 10));
        cmd.Parameters.Add(new SqlParameter("@Address", SqlDbType.NChar, 40));
        cmd.Parameters.Add(new SqlParameter("@PostNum", SqlDbType.NChar, 10));
        cmd.Parameters.Add(new SqlParameter("@biryear", SqlDbType.Char, 10));
        cmd.Parameters.Add(new SqlParameter("@birmounth", SqlDbType.Char, 10));
        cmd.Parameters.Add(new SqlParameter("@birday", SqlDbType.Char, 10));
        //cmd.Parameters.Add(new SqlParameter("@etryear", SqlDbType.Char, 10));
        //
        cmd.Parameters["@UserID"].Value = Session["UserID"].ToString().Trim();
        cmd.Parameters["@PWD"].Value = this.Password.Text.Trim();
        cmd.Parameters["@NickName"].Value = this.NickName.Text.Trim();
        cmd.Parameters["@Question"].Value = this.Question.Text.Trim();
        cmd.Parameters["@Answer"].Value = this.Answer.Text.Trim();
        cmd.Parameters["@PicName"].Value = "~/HeadPic/" + this.Figure.SelectedItem.Text.Trim();
        this.PicLink.Text = " 头像列表 <img id=\"SelPic\" alt=\"\" src=\"HeadPic/" + this.Figure.SelectedItem.Text.Trim() + "\" style=\"width: 46px; height: 43px ;border-top-style: none; border-right-style: none; border-left-style: none; border-bottom-style: none;\" />";

        cmd.Parameters["@Remark"].Value = this.Remark.Text.Trim();
        if (this.Boy.Checked == true)
            cmd.Parameters["@Sex"].Value = this.Boy.Text.Trim();
        else
            cmd.Parameters["@Sex"].Value = this.Girl.Text.Trim();
        cmd.Parameters["@Tele"].Value = this.Tele.Text.Trim();
        cmd.Parameters["@MobilePh"].Value = this.Mobile.Text.Trim();
        cmd.Parameters["@QQ"].Value = this.QQ.Text.ToString().Trim();
        cmd.Parameters["@Email"].Value = this.Email.Text.Trim();
        cmd.Parameters["@Country"].Value = this.Country.SelectedItem.Text.Trim();
        if (this.Country.SelectedIndex == 0)
        {
            cmd.Parameters["@Province"].Value = this.Province.SelectedItem.Text.Trim();
            cmd.Parameters["@City"].Value = this.City.SelectedItem.Text.Trim();

        }
        else
        {
            cmd.Parameters["@Province"].Value = "";
            cmd.Parameters["@City"].Value = "";
            //   this.City.SelectedItem.Text;IdToCity(strcity)
        }



        //cmd.Parameters["@Province"].Value = "";

        //cmd.Parameters["@Province"].Value = this.Province.SelectedItem.Text.ToString().Trim();
        // //Hiddenpro
        //   this.City.SelectedItem.Text;IdToCity(strcity)
        //cmd.Parameters["@City"].Value = strcity.ToString().Trim();
        //cmd.Parameters["@Country"].Value = "";

        //cmd.Parameters["@Province"].Value = "";

        //cmd.Parameters["@Province"].Value = this.Province.SelectedItem.Text.ToString().Trim();
        //Hiddenpro
        //   this.City.SelectedItem.Text;IdToCity(strcity)
        //   cmd.Parameters["@City"].Value = strcity.ToString().Trim();
        ////////////////////////////
        //   cmd.Parameters["@Address"].Value = this.Address.Text.ToString().Trim();

        cmd.Parameters["@Address"].Value = this.Address.Text.Trim();
        cmd.Parameters["@PostNum"].Value = this.Post.Text.Trim();
        cmd.Parameters["@biryear"].Value = this.Year.Text.Trim();
        cmd.Parameters["@birmounth"].Value = this.Mounth.Text.Trim();
        cmd.Parameters["@birday"].Value = this.Day.Text.Trim();
        //   cmd.Parameters["@etryear"].Value = this.ETRTime.Text;
        cmd.Connection.Open();
        try
        {
            //this.Remark.Text = 
            cmd.ExecuteNonQuery();

        }
        catch (SqlException ex)
        {
            this.Remark.Text = ex.ToString();
            Response.Write("wrong");

        }
        cmd.Connection.Close();

        //   this.selspan.InnerHtml =




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

        SqlConnection conn2 = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        conn2.Open();
        SqlCommand cmd2 = new SqlCommand();
        cmd2.Connection = conn2;
        cmd2.CommandText = "select  distinct id,city from city where father IN (select provinceID from province where province='" + this.Province.SelectedItem.Text + "')";//"+this.Province.Text.ToString()+"
        SqlDataReader sdr2 = cmd2.ExecuteReader();
        this.City.DataSource = sdr2;
        this.City.DataTextField = "city";
        this.City.DataValueField = "id";
        this.City.DataBind();
        conn2.Close();
        SetCountry();

        //  Session["TempPro"] = this.Province.SelectedItem.Text;
    }
    protected void City_SelectedIndexChanged(object sender, EventArgs e)
    {
        SetCountry();
        if (this.Province.SelectedItem.Text == "")
        {
            this.Binder();

        }

    }
    protected void Country_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (this.Country.SelectedIndex == 1)
        {


            //     ArrayList ListImg = new ArrayList();

            //    String temp="不用填写";

            //    ListImg.Add(temp);

            //this.Province.DataSource = ListImg;
            //this.Province.DataBind();
            //  this.City.DataSource = ListImg;
            //this.City.DataBind();
            this.Province.Items.Clear();
            this.City.Items.Clear();

        }
        else
        {
            this.Binder();

        }

    }
   
}