checks/Add.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Text;
using System.Data.SqlClient;

public partial class checks_Add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Button2.Enabled = false;

            if (SqlHelper.GetCount("select count(*) from checks where staffNo='" + Session["adminId"].ToString() + "' and datediff(day,checkTime1,getdate())=0 ") > 0)
            {
                Button1.Text = "已签到";
                Button1.Enabled = false;

                Button2.Enabled = true;
            }

            if (SqlHelper.GetCount("select count(*) from checks where staffNo='" + Session["adminId"].ToString() + "' and datediff(day,checkTime2,getdate())=0 ") > 0)
            {
                Button2.Text = "已签退";
                Button2.Enabled = false;
            }
        }
    }

    /// <summary>
    /// 签到
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSave_Click(object sender, EventArgs e)
    {
        string stime = SqlHelper.ExecuteScalar("select top 1 standStime from standard").ToString();

        stime = DateTime.Now.ToString("yyyy-MM-dd") + " " + stime;
        int flag=0;
        if(DateTime.Parse(stime)<DateTime.Now)
        {
            flag = 1;
        }

        //设置添加sql
        string strSql = String.Format(@"insert into checks(staffNo,checkTime1,checkFlag1)
                                        values ('{0}','{1}',{2})",
                                 Session["adminId"].ToString(), DateTime.Now,flag);
        //提交到数据库
        SqlHelper.ExecuteNonQuery(strSql.ToString());