public List <ProjectUsersEntity> GetProjectSunnetUserList(int projectID)
{
List <ProjectUsersEntity> list = new List <ProjectUsersEntity>();
StringBuilder strSql = new StringBuilder();
strSql.Append(" select A.*,B.RoleID from ProjectUsers A inner join [Users] B on A.UserID=B.UserID ");
strSql.Append(" where ProjectID=@ProjectID and IsClient=0 ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
db.AddInParameter(dbCommand, "ProjectID", DbType.Int32, projectID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
try
{
while (dataReader.Read())
{
list.Add(ProjectUsersEntity.ReaderBind(dataReader));
}
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]", strSql.ToString()
, base.FormatParameters(dbCommand.Parameters), ex.Message));
return(null);
}
}
return(list);
}
}
/// <summary>
/// Get an object entity
/// </summary>
public ProjectUsersEntity Get(int PUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select PUID,ProjectID,UserID,ISClient from ProjectUsers ");
strSql.Append(" where PUID=@PUID ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
db.AddInParameter(dbCommand, "PUID", DbType.Int32, PUID);
ProjectUsersEntity model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
try
{
if (dataReader.Read())
{
model = ProjectUsersEntity.ReaderBind(dataReader);
}
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]", strSql.ToString(), base.FormatParameters(dbCommand.Parameters)
, ex.Message));
return(null);
}
}
return(model);
}
}