mycalendar.ascx.cs

本程序基于 asp.net 2.0 +sql server 2

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 ascx_mycalendar : System.Web.UI.UserControl
{
    int year, month;
    int userid;
    SqlDataReader dr;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["userid"] != null)
            this.userid = Convert.ToInt32(Request.QueryString["userid"]);
        else this.userid = 1;


    }


    protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
    {
        this.year = Calendar1.VisibleDate.Year;
        this.month = Calendar1.VisibleDate.Month;
        if (year == 1)
        {
            this.year = DateTime.Now.Year;
            this.month = DateTime.Now.Month;
        }
        getDb(e);
    }

    private void getDb(DayRenderEventArgs e)
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();

        SqlCommand cm = new SqlCommand("caldate", cn);
        cm.CommandType = CommandType.StoredProcedure;

        cm.Parameters.Add("@year", SqlDbType.Int);
        cm.Parameters.Add("@month", SqlDbType.Int);
        cm.Parameters.Add("@userid", SqlDbType.Int);

        cm.Parameters["@year"].Value = this.year;
        cm.Parameters["@month"].Value = this.month;
        cm.Parameters["@userid"].Value = this.userid;

        this.dr = cm.ExecuteReader();

        while (dr.Read())
        {
            DateTime blogdate = Convert.ToDateTime(dr["date"].ToString());
            string blogdate1 = blogdate.ToShortDateString();
            if (blogdate == e.Day.Date)
            {
                e.Cell.Text = "<a href=read.aspx?date=" + blogdate1 + "&userid=" + this.userid + "><b><u>";
                e.Cell.Text += blogdate.Day + "</u></b></a>";
            }
         }

        cn.Close();
    }

}