Views/Stats/General.ashx

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

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

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

using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using MicroDBHelper;
using MicroDTHelper;

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

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

        string flag = "This tips.",
                Action = context.Server.UrlDecode(context.Request.QueryString["action"]),
                MID = context.Server.UrlDecode(context.Request.QueryString["mid"]),
                Type = context.Server.UrlDecode(context.Request.QueryString["type"]),
                StartDate = context.Server.UrlDecode(context.Request.QueryString["startdate"]),
                EndDate = context.Server.UrlDecode(context.Request.QueryString["enddate"]);

        //Type = "Test";
        //StartDate = "2021-10-13"; //DateTime.Now.toDateFormat("yyyy-MM-dd");
        //EndDate = "2021-10-13"; //DateTime.Now.ToString("yyyy-MM-dd");

        if (!string.IsNullOrEmpty(StartDate) && !string.IsNullOrEmpty(EndDate))
            flag = GetOvertimeMeal(Type, StartDate, EndDate);

        context.Response.Write(flag);
    }


    private string GetOvertimeMeal(string Location, string StartDate, string EndDate)
    {
        string flag = string.Empty,
                TotalData = string.Empty,
                MealData = string.Empty,
                DutyData = string.Empty,
               QueryFieldsStr = string.Empty;

        int Meal0 = 0,
                Meal1 = 0,
                Meal2 = 0,
                Meal3 = 0,
                Meal4 = 0;

        if (!string.IsNullOrEmpty(Location))
        {
            Location = Location.toStringTrim();
            QueryFieldsStr = " and Location='" + Location + "'";
        }

        //*****************统计加班就餐Start********************
        DataTable _dt = MicroDataTable.GetDataTable("OvertimeMeal");
        if (_dt != null && _dt.Rows.Count > 0)
        {
            for (int i = 0; i < _dt.Rows.Count; i++)
            {