My97DatePicker日期控制項是一個非常好用的日期控制項,功能非常優秀的日期控制項.
對實現頁面重新整理完善的很好,用日期控制項時可以有比較好的享受,這次的OA日期記事功能也得益於此控制項,具體效果圖如下:
部分代碼:
Default頁布局一個Calendar日期控制項
<div> <asp:Calendar ID="Calendar1" runat="server" Width="100%" 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='images/add.png' alt='添加議程' onclick='window.open(\"EditPlan.aspx?Action=New&StartDate={0}\",\"\",\"menu=no,tool=no,status=no,width=400,height=500\");' /> <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 onclick='window.open(\"EditPlan.aspx?Action=Edit&PlanID={1}\",\"\",\"menu=no,tool=no,status=no,width=400,height=500\");'>{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="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 id="form1" runat="server"> <h3>議程資訊</h3> <div > 議程主題:<asp:TextBox runat="server" ID="txtTitle" Width="270px" BorderColor="#0066FF" BorderStyle="Solid" BorderWidth="1px" ></asp:TextBox> <br /> 議程內容:<asp:TextBox runat="server" ID="txtContent" TextMode="MultiLine" Height="96px"></asp:TextBox> <br /> 起始日期:<asp:TextBox runat="server" ID="txtStartDate" 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" ID="txtEndDate" CssClass="Wdate" onfocus="WdatePicker({minDate:'%y-%M-01',dateFmt:'yyyy-MM-dd HH:mm',maxDate:'%y-%M-%ld'})" /></asp:TextBox> <asp:Panel runat="server" ID="pnlNew"> <asp:Button runat="server" ID="btnInsertPlan" Text="添加" onclick="btnInsertPlan_Click" /> <input type="reset" id="btnReset" value="重設" /> </asp:Panel> <asp:Panel runat="server" ID="pnlEdit"> <asp:Button runat="server" ID="btnUpdate" Text="更新" onclick="btnUpdate_Click1" /> <asp:Button runat="server" ID="btnDelete" Text="刪除" onclick="btnDelete_Click" /> <asp:HiddenField runat="server" ID="hidPlanID" /> </asp:Panel> <asp:ValidationSummary ID="ValidationSummary1" 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日期記事功能的全部內容,希望大家會喜歡。