SysManage/InstructorKaoQingStatistic.aspx.cs

（开头部分） 4KB

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

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 System.Data.SqlClient;

public partial class SysManage_InstructorKaoQingStatistic : System.Web.UI.Page   
{
    //列表SQL
    public string sqltxt = "";
    //总数SQL
    public string cmdtxt2 = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        sqltxt = "select studentId,c.RealName,sum(case when Status='出席' then 1 else 0 end) CXCount, "+
                " sum(case when Status='请假' then 1 else 0 end) QJCount,sum(case when Status='迟到' then 1 else 0 end) CDCount, "+
                " sum(case when Status='早退' then 1 else 0 end) ZTCount, "+
                " sum(case when Status='旷课' then 1 else 0 end) KKCount, "+
                " (sum(case when Status='迟到' then 1 else 0 end)+sum(case when Status='早退' then 1 else 0 end)+sum(case when Status='旷课' then 1 else 0 end))WJCount, "+
                " CONVERT(varchar(4), CourseDate, 23)CourseDate,CourseName,Semester from dbo.CallNames a "+
                " left join Courses b on a.CourseId=b.CourseId "+
                " left join Users c on c.UserId=a.StudentId "+
                " left join Classes d on d.ClassId=a.ClassId " +
                " where d.InstructorId='" + Session["UserId"] + "' " +
                " group by studentId,RealName,CONVERT(varchar(4), CourseDate, 23),CourseName,Semester";

        cmdtxt2 = "select COUNT(*) from (select studentId,c.RealName,sum(case when Status='出席' then 1 else 0 end) CXCount, " +
                " sum(case when Status='请假' then 1 else 0 end) QJCount,sum(case when Status='迟到' then 1 else 0 end) CDCount, " +
                " sum(case when Status='早退' then 1 else 0 end) ZTCount, " +
                " sum(case when Status='旷课' then 1 else 0 end) KKCount, " +
                " (sum(case when Status='迟到' then 1 else 0 end)+sum(case when Status='早退' then 1 else 0 end)+sum(case when Status='旷课' then 1 else 0 end))WJCount, " +
                " CONVERT(varchar(4), CourseDate, 23)CourseDate,CourseName,Semester from dbo.CallNames a " +
                " left join Courses b on a.CourseId=b.CourseId " +
                " left join Users c on c.UserId=a.StudentId " +
                 " left join Classes d on d.ClassId=a.ClassId " +
                "  where d.InstructorId='" + Session["UserId"] + "' " +
                " group by studentId,RealName,CONVERT(varchar(4), CourseDate, 23),CourseName,Semester)t";

        if (!IsPostBack)
        {
            if (Session["UserName"] != null)
            {
                Get_Pager_Data();
            }
            else
            {
                Response.Redirect("Login.aspx");
            }

        }
    }

    /// <summary>
    /// 获取记录总数
后面还有 71 行代码，购买后查看完整代码

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

AI 解读 AI

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

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