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