ASP.NET My97DatePicker日期控件实现OA日期记事功能

My97DatePicker日期控件是一个非常好用的日期控件,功能非常优秀的日期控件.
对实现页面刷新完善的很好,用日期控件时可以有比较好的享受,这次的OA日期记事功能也得益于此控件,具体效果图如下:

ASP.NET My97DatePicker日期控件实现OA日期记事功能

部分代码:
Default页布局一个Calendar日期控件

<div> <asp:Calendar runat="server" ShowGridLines="True" ondayrender="Calendar1_DayRender" > </asp:Calendar> </div>

Default页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.Text; public partial class _Default : System.Web.UI.Page { private DataTable table ; protected void Page_Load(object sender, EventArgs e) { } protected void Calendar1_DayRender(object sender, DayRenderEventArgs e) { //获取现在绑定的日期 CalendarDay day = e.Day; //获取当前日期的单元格 TableCell cell = e.Cell; int currentMonth = DateTime.Now.Month ; cell.Controls.Clear(); table = PlanOperator.SelectPlanByMonth(day.Date); if (day.Date.Month >= currentMonth) { StringBuilder builder = new StringBuilder(); builder.AppendFormat("<font color='Blue'><h5>{0}</h5></font><img src='https://www.jb51.net/images/add.png' alt='添加日程' /> <br/>", day.Date.ToShortDateString()); DataRow[] planRows = table.Select(string.Format("StartDate<='{0}' AND EndDate>='{1}' ", day.Date, day.Date.AddDays(1))); cell.Style["background-color"] = planRows.Length <= 0 ? "#E9E9E9" : "#FFFFFF"; int index = 1; foreach (DataRow row in planRows) { string title = row["Title"].ToString().Length > 10 ? row["Title"].ToString().Substring(0, 10) + "..." : row["Title"].ToString(); builder.AppendFormat("<a>{0}.{2}</a><br/>", index, row["PlanID"], title); index++; continue; } cell.Controls.Add(new LiteralControl(builder.ToString())); } else { cell.Style["background-color"] = "#E9E9E9"; } } }

控件编辑前台代码:

<head runat="server"> <title></title> <script type="text/javascript" language="javascript" src="https://www.jb51.net/My97DatePicker/WdatePicker.js"> </script> <script type="text/javascript" language="javascript"> function valiStartDate(source, clientside_arguments) { if (clientside_arguments.Value > new Date()) { clientside_arguments.IsValid = true; } else { clientside_arguments.IsValid = false; } } </script> </head> <body> <form runat="server"> <h3>日程信息</h3> <div > 日程主题:<asp:TextBox runat="server" BorderColor="#0066FF" BorderStyle="Solid" BorderWidth="1px" ></asp:TextBox> <br /> 日程内容:<asp:TextBox runat="server" TextMode="MultiLine"></asp:TextBox> <br /> 起始日期:<asp:TextBox runat="server" CssClass="Wdate" onfocus="WdatePicker({minDate:'%y-%M-01',dateFmt:'yyyy-MM-dd HH:mm',maxDate:'%y-%M-%ld'})" /></asp:TextBox> <br /> 结束日期:<asp:TextBox runat="server" CssClass="Wdate" onfocus="WdatePicker({minDate:'%y-%M-01',dateFmt:'yyyy-MM-dd HH:mm',maxDate:'%y-%M-%ld'})" /></asp:TextBox> <asp:Panel runat="server"> <asp:Button runat="server" Text="添加" /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <input type="reset" value="重置" /> </asp:Panel> <asp:Panel runat="server"> <asp:Button runat="server" Text="更新" /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <asp:Button runat="server" Text="删除" /> <asp:HiddenField runat="server" /> </asp:Panel> <asp:ValidationSummary runat="server" HeaderText="提交对日程的修改中出现了以下问题:" /><br /> </div> </form> </body>

控件编辑后台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; public partial class EditPlan : System.Web.UI.Page { public DateTime StartDate { get { return (DateTime)this.ViewState["StartDate"]; } set { this.ViewState["StartDate"] = value; } } public DateTime EndDate { get { return (DateTime)this.ViewState["EndDate"]; } set { this.ViewState["EndDate"] = value; } } protected void Page_Load(object sender, EventArgs e) { if (this.Request.QueryString.Count != 2) { this.Response.End(); return; } if (!this.IsPostBack) { string action = this.Request.QueryString["Action"]; switch (action) { case "New": this.StartDate = Convert.ToDateTime(this.Request.QueryString["StartDate"]); this.EndDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, (DateTime.Now.AddMonths(1) - DateTime.Now).Days); this.pnlNew.Visible = true; this.pnlEdit.Visible = false; break; case "Edit": int planID = Convert.ToInt32(this.Request.QueryString["PlanID"]); DataTable table = PlanOperator.SelectPlanById(planID); this.txtTitle.Text = table.Rows[0]["Title"].ToString(); this.txtContent.Text = table.Rows[0]["PlanContent"].ToString(); this.txtStartDate.Text = table.Rows[0]["StartDate"].ToString(); this.txtEndDate.Text = table.Rows[0]["EndDate"].ToString(); this.hidPlanID.Value = table.Rows[0]["PlanID"].ToString(); this.pnlNew.Visible = false; this.pnlEdit.Visible = true; break; default: break; } } } protected void btnInsertPlan_Click(object sender, EventArgs e) { int i=PlanOperator.InsertPlan(this.txtTitle.Text, this.txtContent.Text,this.txtStartDate.Text, this.txtEndDate.Text); if (i == 1) { this.Response.Write("<script type='text/javascript' language='javascript'>alert('添加日程成功!'); window.opener.location=window.opener.location+'?'+Math.random();window.opener='';window.close();</script>"); return; } this.Response.Write("<script type='text/javascript' language='javascript'>alert('添加日程失败!'); window.opener.location=window.opener.location+'?'+Math.random();window.opener='';window.close();</script>"); return; } protected void btnUpdate_Click1(object sender, EventArgs e) { int i = PlanOperator.UpdatePlan(Convert.ToInt32(this.hidPlanID.Value),this.txtTitle.Text, this.txtContent.Text, this.txtStartDate.Text, this.txtEndDate.Text); if (i == 1) { this.Response.Write("<script type='text/javascript' language='javascript'>alert('更新日程成功!'); window.opener.location=window.opener.location+'?'+Math.random();window.opener='';window.close();</script>"); return; } this.Response.Write("<script type='text/javascript' language='javascript'>alert('更新日程失败!'); window.opener.location=window.opener.location+'?'+Math.random();window.opener='';window.close();</script>"); return; } protected void btnDelete_Click(object sender, EventArgs e) { int i = PlanOperator.DeletePlan(Convert.ToInt32(this.hidPlanID.Value)); if (i == 1) { this.Response.Write("<script type='text/javascript' language='javascript'>alert('删除日程成功!'); window.opener.location=window.opener.location+'?'+Math.random();window.opener='';window.close();</script>"); return; } this.Response.Write("<script type='text/javascript' language='javascript'>alert('删除日程失败!'); window.opener.location=window.opener.location+'?'+Math.random();window.opener='';window.close();</script>"); return; } }

以上就是关于My97DatePicker日期控件实现OA日期记事功能的全部内容,希望大家会喜欢。

您可能感兴趣的文章:

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/wjwzsg.html