?? 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;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -