Calendar/Month.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.Collections;
using System.Data;

public partial class Calendar_Month : MojoCube.Api.UI.MyPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            hlAdd.NavigateUrl = "Edit.aspx?back=Month.aspx&active=" + Request.QueryString["active"];
            this.Title = "我的日历";
        }
    }

    protected void lnbSearch_Click(object sender, EventArgs e)
    {
        Response.Redirect("List.aspx?q=" + txtKeyword.Text.Trim() + "&active=" + Request.QueryString["active"]);
    }

    protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
    {
        string date = e.Day.Date.ToString("yyyy-MM-dd");

        if (Request.QueryString["for"] == "birthday" && Session["ViewCalendar"] != null && (bool)Session["ViewCalendar"])
        {
            DataTable dt = MojoCube.Office.Sql.SqlQueryDS("select * from (select FullName,DepartmentName,convert(nvarchar,YEAR('" + e.Day.Date.Year.ToString() + "'))+'-'+convert(varchar(5),Birthday,110) as Birthday2 from View_User_List) as Table1 where Birthday2='" + date + "' order by Birthday2 asc").Tables[0];

            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    Label lblInfo = new Label();

                    lblInfo.Text = "<a href=\"#\"><div class=\"fc_content\" style=\"background:" + MojoCube.Office.Sys.StatusID.GetVisual("Calendar_List", "0") + "\"><span class=\"fc_title\"><i class=\"fa fa-birthday-cake\"></i> " + dt.Rows[i]["FullName"].ToString() + "（" + dt.Rows[i]["DepartmentName"].ToString() + "）</span></div></a>";

                    e.Cell.Controls.Add(lblInfo);
                }
            }
        }
        else
        {
            ArrayList parameter = new ArrayList();
            parameter.Add(MojoCube.Office.SqlHelper.CreateParameter("@fk_User", Session["UserID"].ToString(), SqlDbType.Int));
            DataTable dt = MojoCube.Office.SqlHelper.SqlQueryDS("select * from View_Calendar_List where (fk_User=@fk_User or UserList2 like '%|" + Session["UserID"].ToString() + "|%') and StartDate<='" + date + " 23:59:59' and EndDate>'" + date + " 00:00:00' order by StartDate asc", parameter).Tables[0];

            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    Label lblInfo = new Label();

                    string id = MojoCube.Api.Text.Security.EncryptString(dt.Rows[i]["pk_Calendar"].ToString());

                    string remind = "";