Admin/AttendanceManage.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 LaboratoryOrder.DataBase;
using System.Data.SqlClient;

namespace LaboratoryOrder.Admin
{
    public partial class AttendanceManage : System.Web.UI.Page
    {
        protected DataTable table = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlParameter[] para = null;
            if (Request.QueryString["t"] != null)
            {
                string t = Request.QueryString["t"].ToString();
                para = new SqlParameter[2];
                para[0] = SqlBase.CreateParam("@adminID", SqlDbType.VarChar, 16, ParameterDirection.Input, Context.User.Identity.Name);
                para[1] = SqlBase.CreateParam("@IP", SqlDbType.VarChar, 15, ParameterDirection.Input, Request.ServerVariables["Remote_Addr"]);
                if (t == "in") {
                    SqlBase.ExecuteQuery("if not exists(select * from attendance where attendanceDate = convert(varchar(10),getdate(),120) and adminID = @adminID) insert into attendance(adminID,adminname,inTime,inIP,attendanceDate) select adminID,adminName,convert(varchar(30),getdate(),120),@IP,convert(varchar(10),getdate(),120) from labUsers where adminID = @adminID",para,CommandType.Text);
                }
                else if (t == "out")
                {
                    SqlBase.ExecuteQuery("update attendance set outTime = convert(varchar(30),getdate(),120),outIP = @IP where adminID = @adminID and attendanceDate = convert(varchar(10),getdate(),120) and isnull(outtime,'') = ''", para, CommandType.Text);
                }
            }

            para = new SqlParameter[1];
            para[0] = SqlBase.CreateParam("@adminID", SqlDbType.VarChar, 16, ParameterDirection.Input, Context.User.Identity.Name);
            table = SqlBase.ExecuteDataTable("select top 100 * from Attendance where adminID = @adminID order by inTime desc",para, CommandType.Text);
        }
    }
}