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