public List <P_GROUP_MEMBER> GetGroupMembersByType(GroupTypeEnum GroupType)
{
List <P_GROUP_MEMBER> rtnData;
var sqlServerTemplate = sqlServerTemplFactory.CreateDbTemplate();
using (var conn = sqlServerTemplate.GetSqlConnection())
{
conn.Open();
rtnData = sqlServerTemplate.Load <P_GROUP_MEMBER>(
"SELECT ID, GroupType, UserId, UserName, CreateDate, CreateUserId FROM P_GROUP_MEMBER WHERE (GroupType = @GroupType) ",
new SqlParameter[]
{
SqlParameterFactory.GetSqlParameter("@GroupType", GroupType.ToString("D"))
});
}
return(rtnData);
}
