resourcereportuser.cs

办公自动化全套源程序,北大青鸟教材,适合学习啊

using System;
using System.Data;
using qminoa.DA;
using System.Configuration;

namespace qminoa.BLL.PM
{
	public class ResourceReportUser
	{
		private string	_fullName;
		private int		_userID;
		private string	_userName;
		private decimal _totalHours;

		public ResourceReportUser()
		{
			_userID = 0;
			_userName = string.Empty;
			_totalHours = 0M;
			_fullName = string.Empty;
		}

		public string FullName
		{
			get { return _fullName; }
			set { _fullName = value; }
		}
		
		public int UserID 
		{
			get {return _userID;}
			set { _userID = value; }
		}

		public string UserName 
		{
			get { return _userName; }
			set { _userName = value; }
		}

		public decimal TotalHours
		{
			get { return _totalHours; }
			set { _totalHours = value; }
		}

		public static ResourceReportUserCollection GetUserSummary(int mgrUserID, string userIdList, DateTime startDate, DateTime endDate)
		{
			DataSet dsUsers = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings["ConnectionString"], 
				"PM_ListUserTimeSummary", mgrUserID, userIdList, startDate, endDate);
			ResourceReportUserCollection userList = new ResourceReportUserCollection();
			
			string firstName = string.Empty;
			string lastName = string.Empty;

			foreach(DataRow row in dsUsers.Tables[0].Rows)
			{
				ResourceReportUser usr = new ResourceReportUser();
				usr.UserID = Convert.ToInt32(row["UserID"]);
				usr.UserName = row["UserName"].ToString();
				usr.TotalHours = Convert.ToDecimal(row["TotalHours"]);
				usr.FullName = usr.UserName;
		
				userList.Add(usr);
			}
			return userList;
		}
	}
}