Calendar/View.aspx.cs

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

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

public partial class Calendar_View : MojoCube.Api.UI.MyPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["id"] != null)
            {
                ViewState["pk_Calendar"] = MojoCube.Api.Text.Security.DecryptString(Request.QueryString["id"]);

                DataTable dt = new DataTable();

                ArrayList parameter = new ArrayList();
                parameter.Add(MojoCube.Office.SqlHelper.CreateParameter("@pk_Calendar", ViewState["pk_Calendar"].ToString(), SqlDbType.Int));
                parameter.Add(MojoCube.Office.SqlHelper.CreateParameter("@fk_User", Session["UserID"].ToString(), SqlDbType.Int));
                dt = MojoCube.Office.SqlHelper.SqlQueryDS("select * from View_Calendar_List where pk_Calendar=@pk_Calendar and (fk_User=@fk_User or UserList2 like '%|" + Session["UserID"].ToString() + "|%')", parameter).Tables[0];

                if (dt.Rows.Count > 0)
                {
                    if (dt.Rows[0]["fk_User"].ToString() == Session["UserID"].ToString())
                    {
                        btnEdit.Visible = true;
                    }
                    lblTitle.Text = dt.Rows[0]["Title"].ToString();
                    lblFrom.Text = "发布：" + dt.Rows[0]["FullName"].ToString() + "   类型：" + MojoCube.Office.Sys.TypeID.GetTypeName("Calendar_List", dt.Rows[0]["TypeID"].ToString(), "CHS");
                    lblDate.Text = DateTime.Parse(dt.Rows[0]["StartDate"].ToString()).ToString("yyyy-MM-dd HH:mm") + " 至 " + DateTime.Parse(dt.Rows[0]["EndDate"].ToString()).ToString("yyyy-MM-dd HH:mm");
                    lblDescription.Text = dt.Rows[0]["Description"].ToString();
                    this.Title = "日历查看：" + lblTitle.Text;
                }
                else
                {
                    Response.Redirect("~/Commons/Info.aspx?type=1");
                }

                btnEdit.Attributes.Add("onclick", "window.parent.location.href='Edit.aspx?id=" + Request.QueryString["id"] + "&back=Month.aspx&active=" + Request.QueryString["active"] + "'");
            }
            else
            {
                this.Title = "日历查看";
            }
        }
    }
}