public CY.HotelBooking.Core.Business.XX_KFFJYDB Select(CY.HotelBooking.Core.Business.OrderItemkey Key)
        {
            SqlServerUtility db = new SqlServerUtility();
            db.AddParameter("@ydh", SqlDbType.Decimal, Key.OrderCode);
            db.AddParameter("@dhlb", SqlDbType.VarChar, Key.dhlb);
            db.AddParameter("@num", SqlDbType.Int, Key.Num);
            SqlDataReader reader = db.ExecuteSqlReader(SqlSelectYDBBYydh);
            if (reader != null && !reader.IsClosed && reader.Read())
            {
                CY.HotelBooking.Core.Business.XX_KFFJYDB KFFJYDB = new CY.HotelBooking.Core.Business.XX_KFFJYDB();
                KFFJYDB.Id = (CY.HotelBooking.Core.Business.OrderItemkey)Key.Clone();
                if (!reader.IsDBNull(3)) KFFJYDB.kfcode = reader.GetString(3);
                KFFJYDB.RoomCate = RoomCate.Load(KFFJYDB.kfcode);
                if (!reader.IsDBNull(4)) KFFJYDB.fh = reader.GetString(4);
                if (!reader.IsDBNull(5)) KFFJYDB.fjs = int.Parse(reader.GetValue(5).ToString());
                if (!reader.IsDBNull(6)) KFFJYDB.zdkyfs = int.Parse(reader.GetValue(6).ToString());
                if (!reader.IsDBNull(7)) KFFJYDB.ffs = int.Parse(reader.GetValue(7).ToString());
                if (!reader.IsDBNull(8)) KFFJYDB.ddrq = DateTime.Parse(reader.GetDateTime(8).ToString());
                if (!reader.IsDBNull(9)) KFFJYDB.zdts = (decimal)reader.GetValue(9);
                if (!reader.IsDBNull(10)) KFFJYDB.ldrq = DateTime.Parse(reader.GetDateTime(10).ToString());
                if (!reader.IsDBNull(11)) KFFJYDB.fj = reader.GetDecimal(11).ToString();
                if (!reader.IsDBNull(11)) KFFJYDB.ffbj = reader.GetString(12);
                reader.Close();

                return KFFJYDB;
            }
            else
            {
                if (reader != null && !reader.IsClosed)
                    reader.Close();

                return null;
            }
        }