예제 #1
0
        /// <summary>
        /// 获取用户授权公司
        /// </summary>
        /// <param name="UserID">用户ID</param>
        /// <returns></returns>
        public DataTable GetAuthorizePropertyinfo(int UserID)
        {
            DataTable   dt           = new DataTable();
            UserInfoDAL userinfo_dal = new UserInfoDAL();
            //授权小区列表
            List <AuthCommunityModel> CommunityList = userinfo_dal.GetAuthCommunity(UserID);
            List <int> propertyList = new List <int>();

            if (CommunityList.Count > 0)
            {
                propertyList = CommunityList.Select(x => x.propertyMId).Distinct().ToList <int>();
                PropertyInfoDAL property_dal = new PropertyInfoDAL();
                string          sqlwhere     = " AND propertyID in(" + string.Join(",", propertyList) + ")";
                dt = property_dal.GetAllPropertyinfoList(sqlwhere);
            }
            return(dt);
        }
예제 #2
0
 public List <PropertyInfoModel> GetAllPropertyinfoList()
 {
     return(ppi_dal.GetAllPropertyinfoList());
 }