manageproject.aspx.cs

一套OA系统,使用SQL Server为后台数据库ASP.NET C#语言开发

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 System.Data.SqlClient;
using UDS.Components;

namespace UDS.SubModule.UnitiveDocument
{
	/// <summary>
	/// ManagerProject 的摘要说明。
	/// </summary>
	public class ManagerProject : System.Web.UI.Page
	{
		public static string ClassID="";
		protected System.Web.UI.WebControls.Label lblCreate;
		protected System.Web.UI.WebControls.Label lblDelete;
		protected System.Web.UI.WebControls.Label lblRevise;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfv1;
		protected System.Web.UI.WebControls.Button btnSubmit;
		protected System.Web.UI.HtmlControls.HtmlInputText txtClassName;
		protected System.Web.UI.HtmlControls.HtmlInputText txtScale;
		protected System.Web.UI.HtmlControls.HtmlTextArea txtBrief;
		protected System.Web.UI.WebControls.TextBox txtStartDate;
		protected System.Web.UI.WebControls.TextBox txtEndDate;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfv2;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfv3;
		protected System.Web.UI.WebControls.Button btnRevise;
		protected System.Web.UI.WebControls.Button btnDelete;
		protected System.Web.UI.WebControls.RadioButtonList Status;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfv4;
		public string Action="";
		private void Page_Load(object sender, System.EventArgs e)
		{
			ClassID = (Request.QueryString["ClassID"]!=null)?Request.QueryString["ClassID"].ToString():"";
			Action  = (Request.QueryString["Action"]!=null)?Request.QueryString["Action"].ToString():"";
			
			if(!Page.IsPostBack)
			{	
				PopulateRadioList();
				if(Action=="1")
				{
					this.lblCreate.BackColor = Color.FromName("#1ED2CA");
					this.btnRevise.Visible = false;
					this.btnDelete.Visible = false;
				}
				if(Action=="2")
				{
					UDS.Components .ProjectClass prj = new ProjectClass();
					this.lblDelete.BackColor = Color.FromName("#1ED2CA");
					this.btnRevise .Visible = false;
					this.btnDelete.Visible = true;
					this.btnSubmit .Visible = false;
					PopulateReviseData();
					if(ClassID!="1")
					{
						if(prj.IsExistSubClass(Int32.Parse(ClassID)))
							this.btnDelete.Attributes["onClick"] = "javascript:alert('此项目还存在子节点，不能删除!!');return false;";
						else
							this.btnDelete.Attributes["onClick"] = "javascript:return confirm('您确认吗?');";
					}
					else
					{
						this.btnDelete.Attributes["onClick"] = "javascript:alert('根节点不能被删除!');return false;";
					}
					
				}
				if(Action=="3")
				{
					this.lblRevise.BackColor = Color.FromName("#1ED2CA");
					this.btnSubmit.Visible = false;
					this.btnDelete .Visible = false;
					PopulateReviseData();
				}
			 }
		}


		#region 添加项目
		/// <summary>
		/// 添加项目
		/// </summary>
		private void AddProject() 
		{
			ProjectClass prj = new ProjectClass();
			HttpCookie UserCookie = Request.Cookies["Username"];
			String Username = UserCookie.Value.ToString();
			if(DateTime.Parse(this.txtStartDate.Text.ToString())>DateTime.Parse(this.txtEndDate.Text.ToString()))
			{
				Response.Write("<script language=javascript>alert('开始时间不能大于结束时间!');</script>");
			}
			else
			{
				try
				{
				
					prj.Add(Int32.Parse(ClassID),this.txtClassName.Value.ToString(),this.txtBrief.Value.ToString(),
						Username,Int32.Parse(this.Status.SelectedIndex.ToString()),Int32.Parse(this.txtScale.Value.ToString()),
						DateTime.Parse(this.txtStartDate.Text.ToString()),DateTime.Parse(this.txtEndDate.Text.ToString()));
			
					prj = null;
					Response.Write("<script language=javascript>alert('添加成功!');parent.LeftFrame.location='ProjectTreeView.aspx?classID="+ClassID+"';</script>");
		
				}
				catch(Exception ex)
				{
					UDS.Components.Error.Log(ex.ToString());
					Server.Transfer("../Error.aspx");

				}
			}	
			
		}
		#endregion

		#region 修改项目
		/// <summary>
		/// 修改项目
		/// </summary>
		private void ReviseProject() 
		{
			ProjectClass prj = new ProjectClass();
			HttpCookie UserCookie = Request.Cookies["Username"];
			String Username = UserCookie.Value.ToString();
			if(DateTime.Parse(this.txtStartDate.Text.ToString())>DateTime.Parse(this.txtEndDate.Text.ToString()))
			{
				Response.Write("<script language=javascript>alert('开始时间不能大于结束时间!');</script>");
			}
			else
			{
				try
				{
				
					prj.Revise(Int32.Parse(ClassID),this.txtClassName.Value.ToString(),this.txtBrief.Value.ToString(),
						Int32.Parse(this.Status.SelectedIndex.ToString()),Int32.Parse(this.txtScale.Value.ToString()),
						DateTime.Parse(this.txtStartDate.Text.ToString()),DateTime.Parse(this.txtEndDate.Text.ToString()));
			
					prj = null;
					Response.Write("<script language=javascript>alert('修改成功!');parent.LeftFrame.location='ProjectTreeView.aspx?classID="+ClassID+"';</script>");
		
				}
				catch(Exception ex)
				{
					UDS.Components.Error.Log(ex.ToString());
					Server.Transfer("../Error.aspx");

				}
			}
						
			
		}
		#endregion

		#region 删除项目
		/// <summary>
		/// 删除项目
		/// </summary>
		private void DeleteProject() 
		{
			ProjectClass prj = new ProjectClass();
			HttpCookie UserCookie = Request.Cookies["Username"];
			String Username = UserCookie.Value.ToString();
			try
			{
				prj.Delete(Int32.Parse(ClassID));
				prj = null;
				Response.Write("<script language=javascript>alert('删除成功!');parent.location.reload();</script>");
		
			}
			catch(Exception ex)
			{
				UDS.Components.Error.Log(ex.ToString());
				Server.Transfer("../Error.aspx");

			}
						
			
		}
		#endregion

		#region 绑定修改时数据
		/// <summary>
		/// 绑定修改时数据
		/// </summary>
		private void PopulateReviseData() 
		{
			SqlDataReader dataReader = null; 
			ProjectClass prj = new ProjectClass();
			try
			{
                dataReader = prj.GetProjectDetail(Int32.Parse(ClassID));		
				dataReader.Read();
				this.txtClassName.Value = dataReader[0].ToString();
				this.txtBrief.Value     = dataReader[7].ToString();
				this.txtScale .Value    = dataReader[6].ToString();
				this.txtStartDate.Text  = ProjectClass.changeString(dataReader[3].ToString());
				this.txtEndDate.Text    = ProjectClass.changeString(dataReader[4].ToString());
				this.Status.SelectedIndex = Int32.Parse(dataReader[5].ToString());
				prj = null;
				dataReader = null;
			}
			catch(Exception ex)
			{
				UDS.Components.Error.Log(ex.ToString());
				Server.Transfer("../Error.aspx");

			}
						
			
		}
		#endregion

		#region 初始化单选框
		/// <summary>
		/// 对单选框进行初始化
		/// </summary>
		private void PopulateRadioList() 
		{
			
			this.Status.Items.Add(new ListItem("运行中","1"));
			this.Status.Items.Add(new ListItem("等待运行","2"));
			this.Status.Items.Add(new ListItem("挂起","3"));
			this.Status.Items.Add(new ListItem("取消","4"));
			this.Status.Items.Add(new ListItem("完成","5"));
			this.Status.SelectedIndex = 0;
			
		}
		#endregion
		
		
		#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.btnSubmit.Click += new System.EventHandler(this.btnSubmit_Click);
			this.btnRevise.Click += new System.EventHandler(this.btnRevise_Click);
			this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnSubmit_Click(object sender, System.EventArgs e)
		{
			AddProject();
		}

		private void btnRevise_Click(object sender, System.EventArgs e)
		{
			ReviseProject();
		}

		private void btnDelete_Click(object sender, System.EventArgs e)
		{
			DeleteProject();
		}

	
		

		

		

		
	}
}