Views/Stats/Attendance/UserOvertime.ashx

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

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

<%@ WebHandler Language="C#" Class="UserOvertime" %>

using System;
using System.Web;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using MicroDBHelper;
using MicroPublicHelper;
using MicroDTHelper;
using MicroAuthHelper;
using MicroUserHelper;

public class UserOvertime : IHttpHandler, System.Web.SessionState.IRequiresSessionState
{

    //****************
    //说明
    //根据表名返回表的内容
    //如父项和子项，主要菜单和子菜单等
    //****************

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        MicroAuth.CheckLogin();

        string flag = MicroPublic.GetMsg("SubmitFailed"),
                    Action = context.Server.UrlDecode(context.Request.QueryString["Action"]),
                    ModuleID = context.Server.UrlDecode(context.Request.QueryString["ModuleID"]),
                    ShortTableName = context.Server.UrlDecode(context.Request.QueryString["STN"]),
                    DataType = context.Server.UrlDecode(context.Request.QueryString["DataType"]),
                    QueryType = context.Server.UrlDecode(context.Request.QueryString["QueryType"]),
                    Keyword = context.Server.UrlDecode(context.Request.QueryString["Keyword"]),
                    StartDate = context.Server.UrlDecode(context.Request.QueryString["StartDate"]),
                    EndDate = context.Server.UrlDecode(context.Request.QueryString["EndDate"]),
                    Page = context.Server.UrlDecode(context.Request.QueryString["page"]),
                    Limit = context.Server.UrlDecode(context.Request.QueryString["limit"]);

        ////测试数据
        //Action = "View";
        //ShortTableName = "Overtime";
        //ModuleID = "37";
        //DataType = "GetPersonalOvertime";
        //StartDate = "2021-02-01";
        //EndDate = "2021-02-28";
        //QueryType = "Dept";
        //Keyword = "82";

        Page = string.IsNullOrEmpty(Page) == true ? "1" : Page;
        Limit = string.IsNullOrEmpty(Limit) == true ? "10" : Limit;

        if (!string.IsNullOrEmpty(ModuleID) && !string.IsNullOrEmpty(ShortTableName))
            flag = GetUserOvertime(ModuleID, ShortTableName, DataType, QueryType, Keyword, StartDate, EndDate, Page, Limit);

        context.Response.Write(flag);
    }