updatemsg2.aspx.cs

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

        this.Country.DataValueField = "CountryID";
        this.Country.DataTextField = "CountryName";
        this.Country.DataBind();

        //添加一个"请选择"行
        //  this.Country.Items.Insert(0, new ListItem("请选择分类", ""));

        //为此下拉框添加一个默认选择项,选中第2个选项
        if (this.Country.Items.Count > 1)
        {
            this.Country.SelectedIndex = 0;
        }

        //为此下拉框添加选择事件,第一个参数是自己
        //第二个参数为要填充的下拉框的名称 
        //第三个参数为求取类型
        this.Country.Attributes.Add("onchange", "XmlPost(this,'" + this.Province.ClientID + "','1') ");
    }

    /// <summary>
    /// 绑定第二个下拉框
    /// </summary>
    private void DownBind2()
    {
        string sValue = this.Country.SelectedValue;

        //为第二个下拉框添加事件
        this.Province.Attributes.Add("onchange", "XmlPost(this,'" + this.City.ClientID + "','2') ");

        //第一个下拉框有值才开始绑定第二个下拉框
        if (sValue != "")
        {
            //默认显示分类号为1的所有子类
            string sql = "select provinceID,province from province where father = " + sValue;
            DataTable mytab = this.Get_Dt(sql);

            //绑牢控件

            this.Province.DataSource = mytab;
            this.Province.DataValueField = "provinceID";
            this.Province.DataTextField = "province";
            this.Province.DataBind();
        }

        //添加一个空的首行
        //   this.Province.Items.Insert(0, new ListItem("请选择省份", ""));

        //如果有选项,则选中它
        if (this.Province.Items.Count > 1)
        {
            this.Province.SelectedIndex = 0;
        }
    }

    protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    public string picpath(object source)
    {

        String Temp = source.ToString();

        Temp = Temp.Substring(2, Temp.Length - 2);
        return Temp;

    }
    public void Databind()
{

    SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);

   // string cmd = "select * from UserInfo where UserID='" + Session["UserID"].ToString() + "'"; //设置SQL命令
    string cmd = " select * from UserInfo where UserID='04157008'";
        conn.Open();
    SqlCommand myCommand = new SqlCommand(cmd, conn);
    SqlDataReader jie = myCommand.ExecuteReader();
    
        //保存用户 资料
      //  、、－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
      //  Session["StudentID"] = jie["StudentID"];
 if(jie.Read())
 {
    this.UserID.Text = Session["UserID"].ToString();
    this.Question.Text =jie["Question"].ToString();
    this.Answer.Text = jie["Answer"].ToString();
  //  this.NickName.Text = jie["NickName"].ToString();
    //TextBox1.Attributes("value")="123456"
    this.Password.Attributes["value"] = jie["PWD"].ToString().Trim();
    this.CheckPwd.Attributes["value"] = jie["PWD"].ToString().Trim();
    this.Address.Text = jie["Address"].ToString().Trim();
          this.Post.Text=jie["PostNum"].ToString().Trim();
          this.Tele.Text = jie["Tele"].ToString().Trim();
          this.Mobile.Text = jie["MobilePh"].ToString().Trim();
        this.Email.Text=jie["Email"].ToString().Trim();
        this.QQ.Text = jie["QQ"].ToString().Trim();
        this.Remark.Text = jie["Remark"].ToString().Trim();
        this.Year.SelectedIndex = Convert.ToInt16(jie["biryear"].ToString())-1900;
        this.Mounth.SelectedIndex = Convert.ToInt16(jie["birmounth"].ToString())-1  ;
        string mth = Convert.ToString(Convert.ToInt16(jie["birmounth"].ToString()));
        day(mth, Convert.ToInt16(jie["biryear"].ToString()));
        this.Day.SelectedIndex = Convert.ToInt16(jie["birday"].ToString()) - 1;
        this.Figure.SelectedIndex= picinit(jie["PicName"].ToString());
        this.PicLink.Text = " 头像列表 <img id=\"SelPic\" alt=\"\" src=\"HeadPic/" + piclinkinit(jie["PicName"].ToString()) + "\" style=\"width: 46px; height: 43px ;border-top-style: none; border-right-style: none; border-left-style: none; border-bottom-style: none;\" />";

        if (jie["Sex"].ToString().Trim() == "帅哥")
            this.Boy.Checked = true;
        else
            this.Girl.Checked = true;
      //  this.Country.Attributes["text"] = "dsjkf;";
        




 }


        
          //  cmd.Parameters["@UserID"].Value = this.UserID.Text;
          //  cmd.Parameters["@StudentID"].Value = this.SorT_ID.Text;
          //  cmd.Parameters["@PWD"].Value = this.Password.Text;
          //  cmd.Parameters["@NickName"].Value = this.NickName.Text;
          //  cmd.Parameters["@Question"].Value = this.Question.Text;
          //  cmd.Parameters["@Answer"].Value = this.Answer.Text;

          //  cmd.Parameters["@PicName"].Value = "~/HeadPic/" + this.Figure.SelectedItem.Text ;
          //  cmd.Parameters["@Remark"].Value = this.Remark.Text;
          // if(this.Boy.Checked==true)
            
          // cmd.Parameters["@Sex"].Value=this.Boy.Text;
          // else
          // cmd.Parameters["@Sex"].Value = this.Girl.Text;
          //cmd.Parameters["@Tele"].Value = this.Tele.Text;
          //cmd.Parameters["@MobilePh"].Value = this.Mobile.Text;
          //cmd.Parameters["@QQ"].Value = this.QQ.Text;
          //cmd.Parameters["@Email"].Value = this.Email.Text;
          //cmd.Parameters["@Country"].Value = this.Country.SelectedItem.Text;
          //cmd.Parameters["@Province"].Value = this.Province.SelectedItem.Text;

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

          //  ////////////////////////////
          //cmd.Parameters["@Address"].Value = this.Address.Text;
          //cmd.Parameters["@PostNum"].Value = this.Post.Text;
          //cmd.Parameters["@RegClass"].Value = "";
          //cmd.Parameters["@biryear"].Value = this.Year.Text;
          //cmd.Parameters["@birmounth"].Value = this.Mounth.Text;
          //cmd.Parameters["@birday"].Value = this.Day.Text;
      
    //--------------------------------------------------------------------------------------------

    conn.Close();    

}
    public int  picinit(string str)
    {
        //~/HeadPic/image1.gif                                        
        string temp = str.Substring(15, 1);


        return Convert.ToInt32(temp)-1;

    }
    public string piclinkinit(string str)
    {

        //~/HeadPic/image1.gif      
        string temp = str.Substring(10);


        return temp.Trim();


    }


    protected void Update_Click(object sender, EventArgs e)
    {
        //@etryear char(10)

        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);

        SqlCommand cmd = new SqlCommand("updateuser", 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.ToString().Trim();
        cmd.Parameters["@NickName"].Value = this.NickName.Text.ToString().Trim();
        cmd.Parameters["@Question"].Value = this.Question.Text.ToString().Trim();
        cmd.Parameters["@Answer"].Value = this.Answer.Text.ToString().Trim();
        cmd.Parameters["@PicName"].Value = "~/HeadPic/" + this.Figure.SelectedItem.Text.ToString().Trim();
        cmd.Parameters["@Remark"].Value = this.Remark.Text.ToString().Trim();
        if (this.Boy.Checked == true)

            cmd.Parameters["@Sex"].Value = this.Boy.Text.ToString().Trim();
        else
            cmd.Parameters["@Sex"].Value = this.Girl.Text.ToString().Trim();
        cmd.Parameters["@Tele"].Value = this.Tele.Text.ToString().Trim();
        cmd.Parameters["@MobilePh"].Value = this.Mobile.Text.ToString().Trim();
        cmd.Parameters["@QQ"].Value = this.QQ.Text.ToString().Trim();
        cmd.Parameters["@Email"].Value = this.Email.Text.ToString().Trim();
        cmd.Parameters["@Country"].Value = this.Country.SelectedItem.Text.ToString().Trim();
        if (this.Country.SelectedIndex == 0)
        {
            cmd.Parameters["@Province"].Value = this.Province.SelectedItem.Text.ToString().Trim();
            cmd.Parameters["@City"].Value = this.City.SelectedItem.Text.ToString().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 = "";


        cmd.Parameters["@PostNum"].Value = this.Post.Text.ToString().Trim();

        cmd.Parameters["@biryear"].Value = this.Year.Text.ToString().Trim();
        cmd.Parameters["@birmounth"].Value = this.Mounth.Text.ToString().Trim();
        cmd.Parameters["@birday"].Value = this.Day.Text.ToString().Trim();
        //   cmd.Parameters["@etryear"].Value = this.ETRTime.Text;



        cmd.Connection.Open();
        try
        {
            this.Remark.Text = Convert.ToString(cmd.ExecuteNonQuery());

        }
        catch (SqlException)
        {
            this.Remark.Text = "wrong";
            //  Response.Write("wrong");
            return;
        }
        cmd.Connection.Close();

        //   this.selspan.InnerHtml =





      //  this.Remark.Text = this.Day.SelectedItem.Text.ToString().Trim(); ;








    }
}