Attendance/Report_M.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data;
using System.Collections;

public partial class Attendance_Report_M : MojoCube.Api.UI.MyPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            lblDate.Text = DateTime.Now.ToString("yyyy年MM月");

            GridBind();
            this.Title = "考勤月报表";
        }
    }

    protected void lnbPrev_Click(object sender, EventArgs e)
    {
        DateTime date = DateTime.Parse(lblDate.Text);
        lblDate.Text = date.AddMonths(-1).ToString("yyyy年MM月");
        GridBind();
    }

    protected void lnbNext_Click(object sender, EventArgs e)
    {
        DateTime date = DateTime.Parse(lblDate.Text);
        lblDate.Text = date.AddMonths(1).ToString("yyyy年MM月");
        GridBind();
    }

    protected void lnbSearch_Click(object sender, EventArgs e)
    {
        GridBind();
    }

    private void GridBind()
    {
        GridView1.Columns.Clear();
        MojoCube.Api.UI.AdminGridView.AddGridColumn(GridView1, "DepartmentName", "部门", "", "");
        MojoCube.Api.UI.AdminGridView.AddGridColumn(GridView1, "FullName", "成员", "", "");

        DataTable newDT = new DataTable();

        ArrayList parameter = new ArrayList();
        parameter.Add(MojoCube.Office.SqlHelper.CreateParameter("@Keyword", txtKeyword.Text.Trim(), SqlDbType.NVarChar));
        newDT = MojoCube.Office.SqlHelper.SqlQueryDS("select * from View_User_List where (FullName like '%'+@Keyword+'%' or DepartmentName like '%'+@Keyword+'%') order by pk_User desc", parameter).Tables[0];

        DateTime getDate = DateTime.Parse(lblDate.Text);
        int days = DateTime.DaysInMonth(getDate.Year, getDate.Month);
        string dateStart = getDate.ToString("yyyy-MM") + "-01";
        string dateEnd = getDate.ToString("yyyy-MM") + "-" + days.ToString();

        CreateDT(newDT, "Type", dateStart, dateEnd);