qiandao.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial  class qiandao : System.Web.UI.Page
{
    SqlData da = new SqlData();
    protected void Page_Load(object sender, EventArgs e)
    {
        string sql = @"select count(1) from qiandao where userid = " + Session["uname"] + " and CONVERT(VARCHAR(10),ctime,121) = '" + DateTime.Now.ToString("yyyy-MM-dd") + "'";
        var count = "" + da.ExecuteScalar(sql);
        if (count != "0")
        {
            Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<Script language='javascript'>alert('每天只能签到一次！');document.location=document.location;</script>");
            return;
        }
        sql = "insert into qiandao([userid]) values('" + Session["uname"] + "')";
        bool f = da.ExecuteSQL(sql);
        if (f)
        {
            //修改积分
            sql = @"UPDATE users SET integral= ISNULL(integral,0) +10 where username = " + Session["uname"];
            f = da.ExecuteSQL(sql);
            // Response.Write("<Script language='javascript'>alert('提交评论成功！');document.location=document.location;</script>");
            Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<Script language='javascript'>alert('签到成功！');document.location=document.location;</script>");
        }
    }
}