Web/ReportMgr/TransgressBuildDailyStat.aspx.cs

（开头部分） 6KB

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CityMgr;
using RhData;
using System.Data;
using CityMgr.Base;
using CityMgr.Report;
using System.Transactions;

namespace WebApp.ReportMgr
{
    public partial class TransgressBuildDailyStat : System.Web.UI.Page
    {
        protected LxUserContext m_uct = null;
        protected string p_YearList = "";
        protected string p_MonthList = "";
        protected void Page_Load(object sender, EventArgs e)
        {
            m_uct = Session["UserContext"] as LxUserContext;
            if (m_uct == null)
                Response.Redirect("../Login.aspx");

            AjaxPro.Utility.RegisterTypeForAjax(typeof(TransgressBuildDailyStat));
            AjaxPro.Utility.RegisterTypeForAjax(typeof(LxAjaxEntityHelpper));
            AjaxPro.Utility.RegisterTypeForAjax(typeof(LxEasyUITableHelperr));
            AjaxPro.Utility.RegisterTypeForAjax(typeof(LxAjaxFunction));
            AjaxPro.Utility.RegisterTypeForAjax(typeof(LxUserContext));
            AjaxPro.Utility.RegisterTypeForAjax(typeof(LxEasyUITreeNode));

            for (int i = 1; i <= 12; i++)
                p_MonthList += "<option " + (DateTime.Today.Month == i ? "selected" : "") + " value=\"" + i + "\">" + i.ToString("00") + "</option>";
            for (int i = DateTime.Today.Year - 5; i < DateTime.Today.Year + 10; i++)
                p_YearList += "<option " + (DateTime.Today.Year == i ? "selected" : "") + " value=\"" + i + "\">" + i + "</option>";
        }
        /// <summary>
        /// 获取统计数据
        /// </summary>
        /// <param name="strDeptCode">部门编码</param>
        /// <param name="beginTime">开始时间</param>
        /// <param name="endTime">结束时间</param>
        /// <returns></returns>
        [AjaxPro.AjaxMethod]
        public string GetStatData(string strDeptCode, string beginTime, string endTime,string LastMonth)
        {
            string sql = "";
            int intDeptGrade = 0;
            LxDepartment Department=LxDepartment.GetData(strDeptCode);
            if (strDeptCode == "0106")
            {
                intDeptGrade = Department.Grade;
            }
            else
            {
                intDeptGrade = Department.Grade + 1;
            }
            sql = "select max(D.cDeptName) as DeptName,case when (max(TBRI.iBackout)=1) then count(TBRI.gId) else 0 end as LNum,case when (max(TBRI.iBackout)=1) then sum(TBRI.iArea) else 0 end as LArea,sum(TBRI.iConstructing) as LConstructing,sum(TBRI.iControlStop) as LControlStop,sum(TBRI.iFinish) as LFinish,sum(TBRI.iBackout) as LBackout,"
后面还有 40 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。