task.cs

除了具有传统OA的邮件、工作流、文档等功能外

			
		}
		#endregion

		#region 获得某用户某日的详细任务
		/// <summary>
		/// 获得某用户某日的任务
		/// </summary>
		public SqlDataReader GetTodayTaskBySomeone(string Date,string Username,int Type)
		{
			
			// 定义数据库操作类及DataReader
			Database data = new Database();
			SqlDataReader dataReader = null;
			// 执行存储过程，并返回SqlDataReader对象
			SqlParameter[] prams = {
									   data.MakeInParam("@Username",  SqlDbType.VarChar, 20, Username),
									   data.MakeInParam("@Date",  SqlDbType.VarChar,30, Date),
									   data.MakeInParam("@Type",  SqlDbType.Int,3, Type)	
								   };

			try 
			{
				data.RunProc("sp_GetTodayTaskBySomeone",prams,out dataReader);
				return dataReader;

			}
			catch(Exception ex)
			{
				Error.Log(ex.ToString());
				throw new Exception("获得某用户某日的任务出错!",ex);
			}
			finally
			{
				data	   = null;
				dataReader = null;
			}
			
		}
		#endregion

		#region 获得某用户所有的任务列务
		/// <summary>
		/// 获得某用户某日的任务
		/// </summary>
		public SqlDataReader GetAllTaskBySomeone(string Date,string Username,int Type)
		{
			
			// 定义数据库操作类及DataReader
			Database data = new Database();
			SqlDataReader dataReader = null;
			// 执行存储过程，并返回SqlDataReader对象
			SqlParameter[] prams = {
									   data.MakeInParam("@Username",  SqlDbType.VarChar, 20, Username),
									   data.MakeInParam("@Date",  SqlDbType.VarChar,30, Date),
									   data.MakeInParam("@Type",  SqlDbType.Int,3, Type)	
								   };

			try 
			{
				data.RunProc("sp_GetAllTaskBySomeone",prams,out dataReader);
				return dataReader;

			}
			catch(Exception ex)
			{
				Error.Log(ex.ToString());
				throw new Exception("获得某用户所有的任务出错!",ex);
			}
			finally
			{
				data	   = null;
				dataReader = null;
			}
			
		}
		#endregion

		#region 获得某用户某日的前5条任务 返回数组记录ID
		/// <summary>
		/// 获得某用户某日的前5条任务
		/// </summary>
		public string[] GetTop5DayTaskList(string Date,string Username)
		{
			
			// 定义数据库操作类及DataReader
			Database data = new Database();
			SqlDataReader dataReader = null;
			String[] a = new String[5]{"0","0","0","0","0"};
			// 执行存储过程，并返回SqlDataReader对象
			SqlParameter[] prams = {
									   data.MakeInParam("@Username",  SqlDbType.VarChar, 20, Username),
									   data.MakeInParam("@Date",  SqlDbType.VarChar,30, Date)
								   };

			try 
			{
				data.RunProc("sp_GetTop5DayTaskList",prams,out dataReader);
				int c=0;
				while(dataReader.Read())
				{
					a[c] = dataReader[0].ToString();	
					c++;
				}
				dataReader = null;
				return a;

			}
			catch(Exception ex)
			{
				Error.Log(ex.ToString());
				throw new Exception("获得某用户某日的前5条任务出错!",ex);
			}
			finally
			{
				data.Dispose();
				dataReader = null;
			}
			
		}
		#endregion

		#region 获得前5条已经全部确认的任务列表
		/// <summary>
		/// 获得前5条已经全部确认的任务列表
		/// </summary>
		public string[] GetTop5ConfirmedTaskList(string Date,string Username)
		{
			
			// 定义数据库操作类及DataReader
			Database data = new Database();
			SqlDataReader dataReader = null;
			String[] a = new String[5]{"0","0","0","0","0"};
			// 执行存储过程，并返回SqlDataReader对象
			SqlParameter[] prams = {
									   data.MakeInParam("@Username",  SqlDbType.VarChar, 20, Username),
									   data.MakeInParam("@Date",  SqlDbType.VarChar,30, Date)
								   };

			try 
			{
				data.RunProc("sp_GetTop5ConfirmedTask",prams,out dataReader);
				int c=0;
				while(dataReader.Read())
				{
					if(dataReader[1].ToString()==dataReader[2].ToString())
					a[c] = dataReader[0].ToString();	
					c++;
				}
				dataReader = null;
				return a;

			}
			catch(Exception ex)
			{
				Error.Log(ex.ToString());
				throw new Exception("获得前5条已经全部确认的任务列表出错!",ex);
			}
			finally
			{
				data.Dispose();
				dataReader = null;
			}
			
		}
		#endregion

		#region 获得某条任务某天的的时间段
		/// <summary>
		/// 获得某条任务某天的的时间段 返回长度为11的int型数组，如果数组的某个原素没有值，则值为0
		/// </summary>
		public int[] GetTaskPeriod(string Date,string Username,int TaskID)
		{
			
			// 定义数据库操作类及DataReader
			Database data = new Database();
			SqlDataReader dataReader = null;
			int[] a = new int[20]{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};
			// 执行存储过程，并返回SqlDataReader对象
			SqlParameter[] prams = {
									   data.MakeInParam("@Username",  SqlDbType.VarChar, 20, Username),
									   data.MakeInParam("@Date",  SqlDbType.VarChar,30, Date),
									   data.MakeInParam("@TaskID",  SqlDbType.Int,8, TaskID)	 
								   };

			try 
			{
				data.RunProc("sp_GetTaskPeriod",prams,out dataReader);
			
				while(dataReader.Read()) 
				{
					a[Int32.Parse(dataReader[0].ToString())-1] = 7+Int32.Parse(dataReader[0].ToString());
					
				}


					dataReader = null;
					data.Dispose();
				return a;

			}
			catch(Exception ex)
			{
				Error.Log(ex.ToString());
				throw new Exception("获得某条任务某天的的时间段出错!",ex);
			}
			finally
			{
				data.Dispose();
				dataReader = null;
			}
			
		}
		#endregion

		#region 获得某条任务的详细信息
		/// <summary>
		/// 获得某条任务的详细信息
		/// </summary>
		public TaskClass GetTaskDetail(int TaskID)
		{
			
			// 定义数据库操作类及DataReader
			Database data = new Database();
			SqlDataReader dataReader = null;
			TaskClass tsk = new TaskClass();
			// 执行存储过程，并返回SqlDataReader对象
			SqlParameter[] prams = {
									   data.MakeInParam("@TaskID",  SqlDbType.Int,8, TaskID)	 
								   };

			try 
			{
				data.RunProc("sp_GetTaskDetail",prams,out dataReader);
				
				if(dataReader.Read())
				{
					tsk.ArrangedBy     = dataReader["ArrangedBy"].ToString();
					tsk.Detail		   = dataReader["Detail"].ToString();
					tsk.StartTime	   = dataReader["StartTime"].ToString();
					tsk.EndTime		   = dataReader["EndTime"].ToString();
					tsk.ProjectID	   = Int32.Parse(dataReader["ProjectID"].ToString());
					tsk.Subject		   = dataReader["Subject"].ToString();
					tsk.CooperatorList = dataReader["CooperatorList"].ToString();
					tsk.Type		   = Int32.Parse(dataReader["Type"].ToString());
					tsk.Attribute	   = dataReader["Attribute"].ToString()=="True"?1:0;
					tsk.ContractList   = dataReader["ContractList"].ToString();
				}


				dataReader = null;
				data.Dispose();
				return tsk;

			}
			catch(Exception ex)
			{
				Error.Log(ex.ToString());
				throw new Exception("获得某条任务某天的的时间段出错!",ex);
			}
			finally
			{
				data.Dispose();
				dataReader = null;
			}
			
		}
		#endregion

		#region 删除某任务
		/// <summary>
		/// 删除某任务
		/// </summary>
		public void DeleteTask(int TaskID)
		{
			
			// 定义数据库操作类及DataReader
			Database data = new Database();
			// 执行存储过程，并返回SqlDataReader对象
			SqlParameter[] prams = {
									   data.MakeInParam("@TaskID",  SqlDbType.Int,8, TaskID)	 
								   };

			try 
			{
				data.RunProc("sp_DeleteTask",prams);
				data.Dispose();
			
			}
			catch(Exception ex)
			{
				Error.Log(ex.ToString());
				throw new Exception("删除某任务!",ex);
			}
			finally
			{
				data.Dispose();
			
			}
			
		}
		#endregion

	}

	public class TaskConflictRecord
	{
		private string m_Username;
		private string m_Period;
		private string m_Date;
		public string Username
		{	
			//冲突者
			get { return m_Username; }
			set { m_Username = value; }
		}

		public string Period
		{	
			//冲突时段
			get { return m_Period; }
			set { m_Period = value; }
		}
		
		public string Date
		{	
			//冲突日期
			get { return m_Date; }
			set { m_Date = value; }
		}
	}
	
	public class TaskClass
	{
		private string m_ArrangedBy;
		private string m_Subject;
		private string m_Detail;
		private int m_Type;
		private int m_ProjectID;
		private string m_StartTime;
		private string m_EndTime;
		private int m_Attribute;
		private int  m_Status;
		private int m_Tag;
		private bool m_IsAwake;
		private string m_AwakeTime;
		private string m_ContractList;
		private string m_CooperatorList;
		
		
		
		public string ArrangedBy
		{	
			//发起人
			get { return m_ArrangedBy; }
			set { m_ArrangedBy = value; }
		}

		public string Subject 
		{	
			//任务主题
			get { return m_Subject; }
			set { m_Subject = value; }
		}
		
		public string Detail 
		{	
			//任务地址
			get { return m_Detail; }
			set { m_Detail = value; }
		}
		
		public int Type 
		{	
			//任务类型
			get { return m_Type; }
			set { m_Type = value; }
		}


		public int ProjectID 
		{	
			//所属项目
			get { return m_ProjectID; }
			set { m_ProjectID = value; }
		}

		public string StartTime 
		{	
			//开始时间
			get { return m_StartTime; }
			set { m_StartTime = value; }
		}

		public string EndTime
		{	
			//结束时间
			get { return m_EndTime; }
			set { m_EndTime = value; }
		}
		
		public int Attribute 
		{	
			//性质
			get { return m_Attribute; }
			set { m_Attribute = value; }
		}
	
		public int Status 
		{	
			//状态
			get { return m_Status; }
			set { m_Status = value; }
		}
				
		public int Tag 
		{	
			//标签
			get { return m_Tag; }
			set { m_Tag = value; }
		}

	
		public bool IsAwake 
		{	
			//是否需要提醒
			get { return m_IsAwake; }
			set { m_IsAwake = value; }
		}

		public string AwakeTime 
		{	
			//提醒时间
			get { return m_AwakeTime; }
			set { m_AwakeTime = value; }
		}

		public string ContractList
		{	
			//联系人列表
			get { return m_ContractList; }
			set { m_ContractList = value; }
		}

		public string CooperatorList
		{	
			//协同人列表
			get { return m_CooperatorList; }
			set { m_CooperatorList = value; }
		}
		
	
	}
}