schaddup.aspx.cs

asp.net办公自动化实例导航——非常经典的OA源代码

using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using qminoa.Common.Data;
using qminoa.DA.Schedule;
namespace qminoa.Webs.Schedule
{
	public class SchAddUp : qminoa.Webs.PageBase
	{
		protected System.Web.UI.WebControls.Image Image1;
		protected System.Web.UI.WebControls.TextBox txtSubject;
		protected System.Web.UI.WebControls.TextBox txtPlace;
		protected System.Web.UI.WebControls.TextBox txtScheType;
		protected System.Web.UI.WebControls.Image Image2;
		protected System.Web.UI.WebControls.Image Image3;
		protected System.Web.UI.WebControls.DropDownList dropPlace;
		protected System.Web.UI.WebControls.DropDownList dropType;
		protected System.Web.UI.WebControls.TextBox txtFDate;
		protected System.Web.UI.WebControls.TextBox txtTDate;
		protected System.Web.UI.WebControls.DropDownList dropFDate;
		protected System.Web.UI.WebControls.DropDownList dropTDate;
		protected System.Web.UI.WebControls.TextBox txtRemind;
		protected System.Web.UI.WebControls.CheckBox chkRemind;
		protected System.Web.UI.WebControls.TextBox txtContent;
		protected System.Web.UI.WebControls.LinkButton cmdType;
		protected System.Web.UI.WebControls.LinkButton cmdPlace;
		protected System.Web.UI.WebControls.CheckBox chkPrivte;
		protected System.Web.UI.WebControls.DropDownList dropRequenCate;
		protected System.Web.UI.WebControls.CheckBox chkRepeat;
		protected System.Web.UI.WebControls.TextBox txtUpToDate;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.Label lblAuthorV;
		protected System.Web.UI.WebControls.Label lblCDateV;
		protected System.Web.UI.WebControls.ImageButton cmdSchedMsgDel;
		protected System.Web.UI.WebControls.TextBox txtOtherMan;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator5;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator6;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator7;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator8;
		protected System.Web.UI.WebControls.ImageButton cmdSaveExi;
		protected System.Web.UI.WebControls.ImageButton cmdDel;
		protected System.Web.UI.WebControls.ImageButton cmdExit;
		protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;
		protected System.Web.UI.HtmlControls.HtmlButton cmdScheOMan;
		protected System.Web.UI.WebControls.CheckBox chkImp;

		private ScheduleDA scheduleDadaAccess = new ScheduleDA();
		private int scheid = 0;
		private static string reurl = "";
		private static DateTime date = new DateTime();

		private void Page_Load(object sender, System.EventArgs e)
		{
			this.PageBegin("我的日程",false);
			reurl = Request.QueryString["reurl"];
			if(Request.QueryString["day"] != null)
			{
				date = DateTime.Parse(Request.QueryString["day"]);
			}
			if(Request.QueryString["id"] != null)
			{
				scheid = Int32.Parse(Request.QueryString["id"]);
			}
			cmdSchedMsgDel.Attributes.Add("onclick", "return confirm('确定要删除吗？');");
			if(!IsPostBack)
			{
				txtRemind.Enabled = chkRemind.Checked;
				txtUpToDate.Enabled = chkRepeat.Checked;
				dropRequenCate.Enabled = chkRepeat.Checked;
				txtFDate.Text = date.ToString("d");
				txtTDate.Text = date.ToString("d");
				dropPlace.DataSource = scheduleDadaAccess.dropPlacebind();
				dropPlace.DataBind();
				dropType.DataSource = scheduleDadaAccess.dropTypebind();
				dropType.DataBind();
				dropPlace.SelectedIndex = 0;
				dropType.SelectedIndex = 0;
				if(Request.QueryString["id"] != null)
				{
					scheid = Int32.Parse(Request.QueryString["id"]);
					FillPage();
					if(scheduleDadaAccess.IsMySchedule(Convert.ToInt16(this.Empid),scheid) == 0)
					{
						cmdDel.Visible = true;
					}
					else
					{
						cmdSaveExi.Visible = false;
						cmdDel.Visible = false;
						ReadOnly();
					}
				}
			}
		}

		private void ReadOnly()
		{
			txtSubject.ReadOnly = true;
			txtPlace.ReadOnly = true;
			txtScheType.ReadOnly = true;
			txtFDate.ReadOnly = true;
			txtTDate.ReadOnly = true;
			txtContent.ReadOnly = true;
			txtOtherMan.ReadOnly = true;
			txtUpToDate.ReadOnly = true;
			txtRemind.ReadOnly = true;
			dropPlace.Enabled = false;
			dropType.Enabled = false;
			dropFDate.Enabled = false;
			dropTDate.Enabled = false;
			chkRemind.Enabled = false;
			chkPrivte.Enabled = false;
			chkRepeat.Enabled = false;
			dropRequenCate.Enabled = false;
			cmdPlace.Enabled = false;
			cmdType.Enabled = false;
			cmdScheOMan.Disabled = false;
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.cmdSaveExi.Click += new System.Web.UI.ImageClickEventHandler(this.cmdSaveExi_Click);
			this.cmdDel.Click += new System.Web.UI.ImageClickEventHandler(this.cmdDel_Click);
			this.cmdExit.Click += new System.Web.UI.ImageClickEventHandler(this.cmdExit_Click);
			this.dropPlace.SelectedIndexChanged += new System.EventHandler(this.dropPlace_SelectedIndexChanged);
			this.dropType.SelectedIndexChanged += new System.EventHandler(this.dropType_SelectedIndexChanged);
			this.dropFDate.SelectedIndexChanged += new System.EventHandler(this.dropFDate_SelectedIndexChanged);
			this.chkRemind.CheckedChanged += new System.EventHandler(this.chkRemind_CheckedChanged);
			this.cmdType.Click += new System.EventHandler(this.cmdType_Click);
			this.cmdPlace.Click += new System.EventHandler(this.cmdPlace_Click);
			this.chkRepeat.CheckedChanged += new System.EventHandler(this.chkRepeat_CheckedChanged);
			this.cmdSchedMsgDel.Click += new System.Web.UI.ImageClickEventHandler(this.cmdSchedMsgDel_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void FillPage()
		{
			DataTable empTB = (new ScheduleDA()).cpMySch(scheid).Tables[0];
			DataRow row = empTB.Rows[0];
			txtSubject.Text = row[ScheduleData.SUBJECT_FIELD].ToString();
			txtScheType.Text = row[ScheduleData.SCHTYPE_FIELD].ToString();
			txtPlace.Text = row[ScheduleData.PLACE_FIELD].ToString();
			txtFDate.Text = DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).ToString("d");
			txtTDate.Text = DateTime.Parse(row[ScheduleData.TDATE_FIELD].ToString()).ToString("d");
			string txtfdate_time = DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).Hour + ":" + DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).Minute;
			string txttdate_time = DateTime.Parse(row[ScheduleData.TDATE_FIELD].ToString()).Hour + ":" + DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).Minute;
			for(int i = 0;i < dropFDate.Items.Count;i ++)
			{
				if(dropFDate.Items[i].Text.Trim('0') == txtfdate_time.Trim('0'))
				{
					dropFDate.SelectedIndex = i;
				}
			}
			for(int j = 0;j < dropTDate.Items.Count;j ++)
			{
				if(dropTDate.Items[j].Text.Trim('0') == txttdate_time.Trim('0'))
				{
					dropTDate.SelectedIndex = j;
				}
			}
			chkRemind.Checked = bool.Parse(row[ScheduleData.REMINDFLAG_FIELD].ToString());
			txtRemind.Text = row[ScheduleData.REMINDDAY_FIELD].ToString();
			txtContent.Text = row[ScheduleData.CONTENT_FIELD].ToString();
			lblAuthorV.Text = row["EmpName"].ToString();
			lblCDateV.Text = DateTime.Parse(row[ScheduleData.CDATE_FIELD].ToString()).ToString("g");
			chkPrivte.Checked = bool.Parse(row[ScheduleData.PRIVFLAG_FIELD].ToString());
			chkRepeat.Checked = bool.Parse(row[ScheduleData.REPEATFLAG_FIELD].ToString());
			if(row[ScheduleData.REQUENCATE_FIELD] != DBNull.Value)
				dropRequenCate.SelectedIndex = Convert.ToInt16(row[ScheduleData.REQUENCATE_FIELD].ToString());
			if(row[ScheduleData.UPTODATE_FIELD] != DBNull.Value)
				txtUpToDate.Text = DateTime.Parse(row[ScheduleData.UPTODATE_FIELD].ToString()).ToString("d");
			txtRemind.Enabled = chkRemind.Checked;
			txtUpToDate.Enabled = chkRepeat.Checked;
			dropRequenCate.Enabled = chkRepeat.Checked;

			SqlCommand objcommand = new SqlCommand();
			SqlDataReader cpread;
			objcommand = scheduleDadaAccess.cpOtherManRead(scheid);
			objcommand.Connection.Open();
			cpread = objcommand.ExecuteReader();
			while(cpread.Read())
			{
				txtOtherMan.Text += cpread.GetValue(0).ToString() + ";";
			}
			cpread.Close();
			objcommand.Connection.Close();
		}

		private void cmdPlace_Click(object sender, System.EventArgs e)
		{
			txtPlace.Text = dropPlace.SelectedItem.Text;

			if (txtPlace.Visible == true)
			{
				txtPlace.Visible = false;
				dropPlace.Visible = true;
			}
			else
			{
				txtPlace.Visible = true;
				dropPlace.Visible = false;
			}
		}

		private void cmdType_Click(object sender, System.EventArgs e)
		{
			txtScheType.Text = dropType.SelectedItem.Text;

			if (txtScheType.Visible == true)
			{
				txtScheType.Visible = false;
				dropType.Visible = true;
			}
			else
			{
				txtScheType.Visible = true;
				dropType.Visible = false;
			}
		}

		private void dropFDate_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			dropTDate.SelectedIndex = dropFDate.SelectedIndex;
		}

		private void cmdSaveExi_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			ScheduleData scheData = new ScheduleData();
			DataTable scheTB = scheData.Tables[ScheduleData.SCHEDULE_TABLE];
			DataRow row = scheTB.NewRow();
			scheTB.Rows.Add(row);
			scheTB.AcceptChanges();
			row[ScheduleData.SUBJECT_FIELD] = txtSubject.Text;
			row[ScheduleData.PLACE_FIELD] = txtPlace.Text;
			row[ScheduleData.SCHTYPE_FIELD] = txtScheType.Text;
			row[ScheduleData.FDATE_FIELD] = DateTime.Parse(txtFDate.Text + " " + dropFDate.SelectedItem.Text);
			row[ScheduleData.TDATE_FIELD] = DateTime.Parse(txtTDate.Text + " " + dropTDate.SelectedItem.Text);
			row[ScheduleData.CONTENT_FIELD] = txtContent.Text;
			row[ScheduleData.REMINDFLAG_FIELD] = chkRemind.Checked;
			row[ScheduleData.PRIVFLAG_FIELD] = chkPrivte.Checked;
			row[ScheduleData.REPEATFLAG_FIELD] = chkRepeat.Checked;
			if(chkRemind.Checked == true)
			{
				row[ScheduleData.REMINDDAY_FIELD] = Int16.Parse(txtRemind.Text);
			}
			if(chkRepeat.Checked ==true)
			{
				row[ScheduleData.REQUENCATE_FIELD] = dropRequenCate.SelectedIndex;
				if(txtUpToDate.Text != "")
				{
					row[ScheduleData.UPTODATE_FIELD] = DateTime.Parse(txtUpToDate.Text);
				}
			}
			row[ScheduleData.EMPID_FIELD] = Convert.ToInt16(this.Empid);
			if(scheid == 0)
			{
				int _schid = scheduleDadaAccess.ScheduleAdd(scheData);
				SaveOtherSchedule(_schid);
			}
			else
			{
				row[ScheduleData.SCHID_FIELD] = scheid;
				scheduleDadaAccess.ScheduleUpdate(scheData);
				SaveOtherSchedule(scheid);
			}
			Response.Redirect(reurl+"?date="+date);
		}

		private void cmdDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{		   
			scheduleDadaAccess.cpSchDel(scheid);
			Response.Redirect(reurl+"?date="+date);
		}

		private void cmdExit_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			Response.Redirect(reurl+"?date="+date);
		}

		private void SaveOtherSchedule(int schid)
		{
			scheduleDadaAccess.cpDelOtherMan(schid);
			string txtotherman;
			txtotherman = txtOtherMan.Text;
			string[] otherman = txtotherman.Split(new char[] {';'});
			for(int i = 0;i < otherman.Length - 1;i ++)
			{
				scheduleDadaAccess.cpOtherManAddUp(schid,otherman[i]);
			}
		}

		private void chkRepeat_CheckedChanged(object sender, System.EventArgs e)
		{
			dropRequenCate.Enabled = chkRepeat.Checked;
			txtUpToDate.Enabled = chkRepeat.Checked;
		}

		private void chkRemind_CheckedChanged(object sender, System.EventArgs e)
		{
			txtRemind.Enabled = chkRemind.Checked;
		}

		private void dropPlace_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			dropPlace.Visible = false;
			txtPlace.Visible = true;
			txtPlace.Text = dropPlace.SelectedItem.Text;
		}

		private void dropType_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			dropType.Visible = false;
			txtScheType.Visible = true;
			txtScheType.Text = dropType.SelectedItem.Text;
		}

		private void cmdSchedMsgDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			scheduleDadaAccess.cpDelOtherMan(scheid);
			txtOtherMan.Text = "";
		}
	}
}