using SSWMS.Common;
using System.Collections;
using System.Collections.Generic;

namespace SSWMS.Server
{
    public class P_SYS_RELATION : P_Base_House<SYS_RELATION>
    {
        public IList<SYS_RELATION> GetListByRole(string sRelationType, int iRoleID)
        {
            return this._sqlMap.QueryForList<SYS_RELATION>("SYS_RELATION_SELECT_BY_ROLE", new Hashtable()
            {
                { "RELATION_ID1", iRoleID },
                { "RELATION_TYPE", sRelationType }
            });
        }

        public IList<SYS_RELATION> GetListByUser(string sRelationType, int iUserID)
        {
            return this._sqlMap.QueryForList<SYS_RELATION>("SYS_RELATION_SELECT_BY_USER", new Hashtable()
            {
                { "RELATION_ID2", iUserID },
                { "RELATION_TYPE", sRelationType },
                { "RELATION_TYPE_USER", SystemCode.RELATION_TYPE.User }
            });
        }
    }
}