AddSign.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 System.Data.SqlClient;

public partial class AddSign : System.Web.UI.Page
{
    SqlHelper data = new SqlHelper();
    Alert al = new Alert();
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Title = "《计算机通信与安全》课程教学网站";
        if (!IsPostBack)
        {
            if (Session["UserName"] != null)
            {
            }
            else
            {
                Alert.AlertAndRedirect("对不起您还没有登录", "Default.aspx");
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            string sql = string.Empty;
            string userId = Session["UserId"].ToString();
            DateTime signDate = DateTime.Now.Date;
            sql = "select * from Signs where UserId='" + userId + "' and SignDate='" + signDate + "'";
            SqlDataReader sdr = data.GetDataReader(sql);
            if (sdr.Read())
            {
                string message = string.Format("您{0}已经签到过，不能重复签到!", signDate.ToString("yyyy年MM月dd日"));
                Alert.AlertAndRedirect(message, "MySignList.aspx");
            }
            else
            {
                sql = "insert into Signs(UserId, SignDate)values('" + userId + "','" + signDate + "')";
                data.RunSql(sql);
                Alert.AlertAndRedirect("签到成功", "MySignList.aspx");
            }
        }
        catch (Exception ex)
        {
            Common.ShowMessage(this.Page, "页面加载时出现异常。", "");
            return;
        }
    }
}