用日历存储信息

日历显示主界面

</asp:Calendar>
</div>
</form>
</body>

显示界面后端代码

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

public partial class Show : System.Web.UI.Page
{
private MydbDataContext _Context = new MydbDataContext();
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
e.Cell.Controls.Clear();
//造一个Label 对象给每个格加上日期标题
Label lab = new Label();
lab.Text = e.Day.Date.Day.ToString();
//修改标签样式

lab.Width = Unit.Percentage(100);
lab.BackColor = Color.Maroon;
lab.ForeColor = Color.White;
lab.Font.Italic =true;
lab.Font.Bold = true;

//给标题栏标题添加双击弹出添加窗口的JS
lab.Attributes.Add("ondblclick", "window.open('Add.aspx?dt="+e.Day.Date.Date.ToString("yyyy-MM-dd")+"','_blank','top=200 left=300 width=350 height=350 tolbar=no location=no')");
e.Cell.Controls.Add(lab);

//加载日程
//2个date 是取年月日不要时分秒
var var1 = _Context.RiLi.Where(p => p.Date == e.Day.Date.Date);
if(var1.Count()>0)
{
foreach(RiLi data in var1)
{
//造日程项，加到日历的单元格中
Label lblItem = new Label();
lblItem.Text = data.Title;
lblItem.Width = Unit.Percentage(100);
lblItem.BackColor = Color.FromName(data.Color);
lblItem.Attributes.Add("ondblclick", "window.open('Eidt.aspx?id="+data.Ids+"','_blank','top=200 left=300 width=350 height=350 toolbar=no location=no')");
lblItem.ToolTip = data.Content;
e.Cell.Controls.Add(lblItem);
}
}

}

添加日历进程界面

</head>
<body>
<form id="form1" runat="server">
<h1 align="center">添加日程</h1>
<div align="center" style="background-color:#98a5d7">

日期：<asp:Label ID="txtriqi" runat="server" Text="Label"></asp:Label>
<br />
标题<asp:TextBox ID="txtbiaoti" runat="server" Width="186px"></asp:TextBox>
<br />
内容：<br />
<asp:TextBox ID="txtneirong" runat="server" Height="97px" TextMode="MultiLine" Width="287px"></asp:TextBox>
<br />
颜色<asp:RadioButtonList ID="txtcolor" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow">
<asp:ListItem Value="#ffcccc"><font color=red>红色</font></asp:ListItem>
<asp:ListItem Value="#ffffcc"><font color=#ffffcc>黄色</font></asp:ListItem>
<asp:ListItem Value="#ccffcc"><font color=#ccffcc>绿色</font></asp:ListItem>
<asp:ListItem Value="#ccccff"><font color=#ccccff>蓝色</font></asp:ListItem>
<asp:ListItem Selected="True" Value="#ffffff">白色</asp:ListItem>
</asp:RadioButtonList>

<br />
<asp:Button ID="butAdd" runat="server" Text="添加日程" OnClick="butAdd_Click" />
<input id="Reset1" type="reset" value="重置" /><asp:Literal ID="Literal1" runat="server"></asp:Literal>
</div>
</form>
</body>

添加日历进程后端代码

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

public partial class Add : System.Web.UI.Page
{
private MydbDataContext _Context = new MydbDataContext();
protected void Page_Load(object sender, EventArgs e)
{
if(Request["dt"]!=null)
{
txtriqi.Text = Request["dt"].ToString();
}
}
protected void butAdd_Click(object sender, EventArgs e)
{
//取界面数据
DateTime date = Convert.ToDateTime(txtriqi.Text);
string title = txtbiaoti.Text;
string content = txtneirong.Text;
string color = txtcolor.SelectedValue;
//送到数据库中区
RiLi data = new RiLi();
data.Date = date;
data.Title = title;
data.Content = content;
data.Color = color;

_Context.RiLi.InsertOnSubmit(data);
_Context.SubmitChanges();
//关闭当前窗口，刷新原窗口。

Literal1.Text = "<script language=javascript>opener.location.reload();window.close();</script>";
}
}

修改删除界面

修改删除后端代码

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

public partial class Eidt : System.Web.UI.Page
{
private MydbDataContext _Context = new MydbDataContext();

//把数据库中的值取出来放在页面上显示
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
if(Request["id"]!=null)
{
var var = _Context.RiLi.Where(p => p.Ids == Convert.ToInt32(Request["id"]));
if(var.Count()>0)
{
RiLi data = var.First();
labdate.Text = data.Date.Value.ToString("yyyy-MM-dd");
txtbiaoti.Text = data.Title;
txtneirong.Text = data.Content;
txtcolor.SelectedValue = data.Color;
}
}
}
}

//修改按钮
protected void OK_Click(object sender, EventArgs e)
{
DateTime date =Convert.ToDateTime (labdate.Text);
string title = txtbiaoti.Text;
string content = txtneirong.Text;
string color = txtcolor.Text;

//查数据
var query = _Context.RiLi.Where(p=>p.Ids == Convert.ToInt32(Request["id"]));

//把值改一下
if (query.Count() > 0)
{
RiLi data = query.First();
data.Date = date;
data.Title = title;
data.Content = content;
data.Color = color;

//送到数据库中去

_Context.SubmitChanges();
}
Literal1.Text = "<script language='javascript'>opener.location.reload();window.close();</script>";

}
protected void Button1_Click(object sender, EventArgs e)
{
//删除
var var = _Context.RiLi.Where(p => p.Ids ==Convert.ToInt32 (Request["id"]));
if(var.Count()>0)
{
RiLi data = var.First();

_Context.RiLi.DeleteOnSubmit(data);
_Context.SubmitChanges();

//关闭当前页面刷新显示页面

Literal1.Text = "<script language='javascript'>opener.location.reload();window.close();</script>";

}
}
}