usergetqq.aspx.cs

本程序基于 asp.net 2.0 +sql server 2

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 lalablog;
public partial class user_userGetQQ : System.Web.UI.Page
{
    int userid;
    protected void Page_Load(object sender, EventArgs e)
    {
         if (Session["userid"] == null)
            Response.Redirect("~/user/userLogin.aspx?url=" + Server.HtmlEncode(Request.RawUrl));
        else
            this.userid = Convert.ToInt32(Session["userid"]);

        displayFicq();

    }


 

    private bool HaveFicq()
    {
        string sql = "select ficq from users where userid=" + this.userid;
        openDb o1 = new openDb(sql);
        int  x= Convert .ToInt32 ( o1.getValue ());
        if (x == 0)
            return false;
        else
            return true;
    }

    private void displayFicq()
    {
        if (HaveFicq())
        {
            string sql = "select ficq from users where userid=" + this.userid;
            openDb o1 = new openDb(sql);
            int uin = Convert.ToInt32(o1.getValue());
            yourFicq.InnerHtml = "您好，您的Ficq号码为" + uin;
            getFicq.Visible = false;
        }
        else
            yourFicq.InnerHtml = "您还未开通Ficq号码，请填写密码，然后生成您的Ficq号码";
    }

    protected void btnGetQQ_Click(object sender, EventArgs e)
    {
        if (!HaveFicq())
            genFicq();
        else
        {
            myfunc m1 = new myfunc("您已经有Ficq号码了，不必重复申请");
            Response.Write(m1.JavaMsg());
        }
    }

    private void genFicq()
    {
        int uin=0,maxUin=0;

        string sqlMax = "select max(uin) from icqusers_tb where uin<100000";
        openDb oMax = new openDb(sqlMax);
        maxUin = Convert.ToInt32(oMax.getValue());

        Random r1=new Random ();
        uin=r1.Next (1,20)+maxUin ;

        
        string pass = Server.HtmlEncode(tbFicqPass.Text);
        string nickname = Session["username"].ToString ();
        string regip = Request.UserHostAddress;
        DateTime createdate = DateTime.Now;

        string sql = "insert into icqusers_tb(";
        sql += "uin,password,nickname,regip,createdate)";
        sql += " values (" + uin + ",'" + pass + "','" + nickname + "','";
        sql += regip + "','" + createdate + "')";

        if (pass.Length > 2)
        {
            openDb o1 = new openDb(sql);
            o1.update();

            string sql2 = "update users set ficq=" + uin + " where userid=" + this.userid;
            openDb o2 = new openDb(sql2);
            o2.update();

            displayFicq();
        }
        
    }
}