Пример #1
0
        /// <summary>
        /// 获取楼盘照片个数
        /// </summary>
        /// <param name="projectId"></param>
        /// <param name="cityId"></param>
        /// <param name="companyId"></param>
        /// <param name="_db"></param>
        /// <returns></returns>
        public static int GetLNKPPhotoCountByProjectId(int projectId, int cityId, int companyId, DataBase _db = null)
        {
            DataBase db    = new DataBase(_db);
            int      count = 0;

            try
            {
                string sql = "{0} Valid=1 and CityId={1} and ProjectId={2} and FxtCompanyId={3} ";
                sql = string.Format(sql, NHibernateUtility.GetMSSQL_SQL_COUNT(NHibernateUtility.TableName_LNKPPhoto), cityId, projectId, companyId);
                object obj = db.DB.GetCustomSQLQueryUniqueResult <object>(sql, null);
                count = Convert.ToInt32(obj);
            }
            catch (Exception ex)
            {
                log.Error("获取照片个数", ex);
            }
            db.Close();
            return(count);
        }