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); } }