public List <PartnerUser2Role> LoadPartnerUser2Roles()
{
string sql = @"SELECT [UserID]
, [RoleID]
FROM [BE_PartnerUser2Role]" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
List <PartnerUser2Role> ret = new List <PartnerUser2Role>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
PartnerUser2Role iret = new PartnerUser2Role();
if (!Convert.IsDBNull(dr["UserID"]))
{
iret.UserID = (Guid)dr["UserID"];
}
if (!Convert.IsDBNull(dr["RoleID"]))
{
iret.RoleID = (Guid)dr["RoleID"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int LoadPartnerUser2RoleByUserID_RoleID(PartnerUser2Role obj)
{
string sql = @"SELECT [UserID]
, [RoleID]
FROM [BE_PartnerUser2Role] WITH(NOLOCK) WHERE [UserID]=@UserID AND [RoleID]=@RoleID" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pUserID = new SqlParameter("UserID", Convert2DBnull(obj.UserID));
pUserID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pUserID);
SqlParameter pRoleID = new SqlParameter("RoleID", Convert2DBnull(obj.RoleID));
pRoleID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pRoleID);
int ret = 0;
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
if (!Convert.IsDBNull(dr["UserID"]))
{
obj.UserID = (Guid)dr["UserID"];
}
if (!Convert.IsDBNull(dr["RoleID"]))
{
obj.RoleID = (Guid)dr["RoleID"];
}
ret += 1;
}
}
finally
{
dr.Close();
}
return(ret);
}
public int InsertPartnerUser2Role(PartnerUser2Role obj)
{
string sql = @"INSERT INTO[BE_PartnerUser2Role]([UserID]
, [RoleID]
) VALUES(@UserID
, @RoleID
)" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pUserID = new SqlParameter("UserID", Convert2DBnull(obj.UserID));
pUserID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pUserID);
SqlParameter pRoleID = new SqlParameter("RoleID", Convert2DBnull(obj.RoleID));
pRoleID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pRoleID);
return(cmd.ExecuteNonQuery());
}
public List <PartnerUser2Role> LoadPartnerUser2RolesByRoleID(Guid roleID)
{
string sql = @"SELECT [UserID]
, [RoleID]
FROM [BE_PartnerUser2Role] WHERE [RoleID]=@RoleID" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pRoleID = new SqlParameter("RoleID", roleID);
pRoleID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pRoleID);
List <PartnerUser2Role> ret = new List <PartnerUser2Role>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
PartnerUser2Role iret = new PartnerUser2Role();
if (!Convert.IsDBNull(dr["UserID"]))
{
iret.UserID = (Guid)dr["UserID"];
}
if (!Convert.IsDBNull(dr["RoleID"]))
{
iret.RoleID = (Guid)dr["RoleID"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
