register.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 myPaimai;
public partial class Register : System.Web.UI.Page,ICallbackEventHandler
{
    string s;
    static string password="";
    static  string path = "";
    dataOperate do1 = new dataOperate();
    protected void Page_Load(object sender, EventArgs e)
    {
        ClientScriptManager csm = Page.ClientScript;
        String scr = csm.GetCallbackEventReference(this, "arg", "receiveFromServer", "content");
        csm.RegisterClientScriptBlock(this.GetType(), "callback", "function callback(arg,content){" + scr + ";}", true);
        if (!IsPostBack)
        {
            DropDownList1.DataSource = do1.getDataView("SELECT proQuestion,questionName from question");
            DropDownList1.DataTextField = "questionName";
            DropDownList1.DataValueField = "proQuestion";
            DropDownList1.DataBind();
        }
    }

    #region ICallbackEventHandler 成员

    string ICallbackEventHandler.GetCallbackResult()
    {
        return s;
    }

    void ICallbackEventHandler.RaiseCallbackEvent(string eventArgument)
    {
      
        int f =(int) do1.executeScalar("select count(*) from userPaimai where userID='" + eventArgument + "'");
        if (f == 0)
        {
            s =" <label id=\"lblvalue\" class=\"lablegreen\">恭喜，此用户可以使用！</label>";
        }
        else
        {
            s = "<label id=\"lblvalue\" class=\"lablered\">对不起，此用户已被使用！</label>";   
        }
        
    }

    #endregion

    Random rd = new Random();
    static string name ="";
    protected void imageSubmit_ServerClick(object sender, EventArgs e)
    {       
        if (FileUpload1.HasFile)
        {
            name = DateTime.Now.ToFileTime().ToString() + rd.Next(1000);
            string txt=FileUpload1.PostedFile.FileName;
            string txt1=txt.Substring(txt.LastIndexOf('.'));
            try
            {
                name = name + txt1;
                path=Server.MapPath("~/upLoad/")+name;
                FileUpload1.PostedFile.SaveAs(path);
            }
            catch (Exception ex)
            {
                HttpContext.Current.Response.Write("<script language='javascript'>alert('对不起！出现错误了...')</script>");
            }
            img.ImageUrl ="upLoad/"+name;
            img.Visible = true;

        }
        else
        {
            Response.Write("<script language='javascript'>alert('对不起！选择文件...')</script>");
        }

    }
    protected void rigister_ServerClick1(object sender, EventArgs e)
    {
        if ((int)do1.executeScalar("select count(*) from userPaimai where userID='" + username.Text + "'") > 0)
        {
            HttpContext.Current.Response.Write("<script language='javascript'>alert('对不起！用户名已经被注册了...')</script>");
        }
        else
        {
            password = password1.Text;
            panel1.Visible = false;
            panel2.Visible = true;
        }
    }
    
    protected void rigister1_ServerClick(object sender, EventArgs e)
    {
        string strSQL = "INSERT INTO userPaimai" +
        "(userID,bool,password,realName,sex,age,detailAddress,connectNO,imagePath,email,nickName,proQuestion,proAnswer,registerTime)" +
      " VAlUES(@userID,@bool,@password,@realName,@sex,@age,@detailAddress,@connectNO,@imagePath,@email,@nickName,@proQuestion,@proAnswer,@registerTime)";
        string  sexS = sex.Text;
        int ageS ;
        if (age.Text == "")
        {
            ageS = 0;
        }
        else
        {
          ageS= int.Parse(age.Text);
        }
        if (sex.Text == "")
        {
            sexS = "秘密...";
        }
        do1.setParameter("@userID", username.Text);
        do1.setParameter("@bool", 1);
        do1.setParameter("@password", password);
        do1.setParameter("@realName", realUserName.Text);
        do1.setParameter("@age", ageS);
        do1.setParameter("@sex", sexS);
        do1.setParameter("@detailAddress", detailAddress.Text);
        do1.setParameter("@connectNO", connectNO.Text);
        do1.setParameter("@imagePath",name);
        do1.setParameter("@email", email.Text);
        do1.setParameter("@nickName", nickname.Text);
        do1.setParameter("@proQuestion", DropDownList1.SelectedValue);
        do1.setParameter("@proAnswer", answer.Text);
        do1.setParameter("@registerTime",DateTime.Now.ToString());
        do1.executeNonQuery(strSQL);
    }
}