personaddmodi.aspx.cs

很不错的公文流转系统

/*******************************************************
 * 作者：吴高发
 * 创建日期：2003-11-13
 * 修改人：
 * 修改日期：
 * 修改模块：
 * ***************************************************/

using System; 
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using OI.DatabaseOper ;


namespace OI.IndividualArrange
{
	/// <summary>
	/// PersonAddModi 的摘要说明。
	/// </summary>
	public class PersonAddModi : OI.PageBase 
	{
		protected System.Web.UI.WebControls.TextBox TextBoxTitle;
		protected System.Web.UI.WebControls.TextBox TextBoxContent;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.Label DispTitle;
		protected System.Web.UI.WebControls.TextBox TextBoxID;
		protected System.Web.UI.WebControls.DropDownList beginY;
		protected System.Web.UI.WebControls.DropDownList beginM;
		protected System.Web.UI.WebControls.DropDownList beginD;
		protected System.Web.UI.WebControls.DropDownList endY;
		protected System.Web.UI.WebControls.DropDownList endM;
		protected System.Web.UI.WebControls.DropDownList endD;
		private DatabaseConnect dc=new DatabaseConnect ();

		private int[] daysCommon={31,28,31,30,31,30,31,31,30,31,30,31};
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected System.Web.UI.WebControls.Label LabelMsg;
		private int[] daysLeap={31,29,31,30,31,30,31,31,30,31,30,31};

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			if(!this.IsPostBack )
			{
				TextBoxID.Text =Request.Params ["id"].ToString ();
				if(Convert.ToInt32 (TextBoxID.Text .Trim ())>-1)
				{
					this.InitData ();
					DispTitle.Text ="<IMG src=\"../images/edit.gif\">修改个人日程";
				}
				else
				{
					this.initDate (DateTime.Today ,DateTime.Today );
					DispTitle.Text ="<IMG src=\"../images/edit.gif\">增加个人日程";
				}
			}			
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.beginY.SelectedIndexChanged += new System.EventHandler(this.beginY_SelectedIndexChanged);
			this.beginM.SelectedIndexChanged += new System.EventHandler(this.beginM_SelectedIndexChanged);
			this.endY.SelectedIndexChanged += new System.EventHandler(this.endY_SelectedIndexChanged);
			this.endM.SelectedIndexChanged += new System.EventHandler(this.endM_SelectedIndexChanged);
			this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void ButtonOK_Click(object sender, System.EventArgs e)
		{
			
		}

		private void InitData()
		{
			if(Session["userid"]==null||Session["userid"].ToString ()=="")
			{
				Page.RegisterStartupScript ("","<script>alert(\"操作时间过长，请重新登录\")</script>");
				return;
			}
			string sql="SELECT Title,Content,BeginDate,EndDate FROM SelfPlan WHERE PlanID='"+TextBoxID.Text .Trim ()+"' ";
			ArrayList al=dc.getData (sql);
			if(al.Count >=4)
			{
				TextBoxTitle.Text =al[0].ToString ();
				TextBoxContent.Text =al[1].ToString ();
				DateTime tempDT1=Convert.ToDateTime (al[2].ToString ().Trim ());								
				DateTime tempDT2 =Convert.ToDateTime (al[3].ToString ().Trim ());
				this.initDate (tempDT1,tempDT2);
			}
		}
		private void EmptyCell()
		{
			TextBoxTitle.Text ="";
			TextBoxContent.Text ="";
		}

		private ArrayList getDays(int year,int month)
		{			
			ArrayList dayArray=new ArrayList ();
			if((year%4==0)&&(year%100==0)||(year%400==0))
				for(int i=0;i<daysLeap[month-1];i++)
					dayArray.Add (i+1);
			else
				for(int i=0;i<daysCommon[month-1];i++)
					dayArray.Add (i+1);
			return dayArray;
		}
		private void initDate(DateTime dtBegin,DateTime dtEnd)
		{			
			beginM.SelectedIndex =dtBegin.Month -1;
			beginY.SelectedIndex =dtBegin.Year -2000;
			beginD.DataSource  =this.getDays (dtBegin.Year ,dtBegin.Month );			
			beginD.DataBind ();			
			beginD.SelectedIndex =dtBegin.Day -1; 
     
			endM.SelectedIndex =dtEnd.Month -1;
			endY.SelectedIndex =dtEnd.Year -2000;
			endD.DataSource  =this.getDays (dtEnd.Year ,dtEnd.Month );			
			endD.DataBind ();			
			endD.SelectedIndex =dtEnd.Day -1; 
			
		}

		private void beginY_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			beginD.DataSource =this.getDays (Convert.ToInt32 (beginY.SelectedItem .Value .Trim ()),
				Convert.ToInt32 (beginM.SelectedItem .Value .Trim ()));
			beginD.DataBind ();
		}

		private void beginM_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			beginD.DataSource =this.getDays (Convert.ToInt32 (beginY.SelectedItem .Value .Trim ()),
				Convert.ToInt32 (beginM.SelectedItem .Value .Trim ()));
			beginD.DataBind ();
		}

		private void endY_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			endD.DataSource =this.getDays (Convert.ToInt32 (endY.SelectedItem .Value .Trim ()),
				Convert.ToInt32 (endM.SelectedItem .Value .Trim ()));
			endD.DataBind ();
		}

		private void endM_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			endD.DataSource =this.getDays (Convert.ToInt32 (endY.SelectedItem .Value .Trim ()),
				Convert.ToInt32 (endM.SelectedItem .Value .Trim ()));
			endD.DataBind ();
		}

		private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e) {
			DateTime tempDtBegin=Convert.ToDateTime (beginY.SelectedValue +"-"+beginM.SelectedValue +"-"+beginD.SelectedValue );
			DateTime tempDtEnd=Convert.ToDateTime (endY.SelectedValue +"-"+endM.SelectedValue +"-"+endD.SelectedValue );

			if(TextBoxID.Text .Trim ()=="-1") {
				string sql="INSERT INTO SelfPlan(Title,Content,BeginDate,EndDate,UserID)"+
					" VALUES('"+TextBoxTitle.Text .Trim ()+"','"+TextBoxContent.Text .Trim ()+"','"+tempDtBegin +"','"+
					tempDtEnd.AddDays (1).AddMinutes (-1)+"','"+Session["userID"].ToString ()+"')";	
				dc.addData (sql);
				LabelMsg.Text="增加成功";
			}
			else {
				string sql="UPDATE SelfPlan SET Title='"+TextBoxTitle.Text .Trim ()+"',Content='"+TextBoxContent.Text .Trim ()+"',"+
					"BeginDate='"+tempDtBegin+"',EndDate='"+tempDtEnd.AddDays(1).AddMinutes(-1)+"' WHERE PlanID='"+TextBoxID.Text .Trim ()+"'";
				dc.updateData (sql);
				LabelMsg.Text="修改成功";
			}
			//Response.Redirect ("personPlan.aspx");
			this.EmptyCell ();
		}
	}
}