public override IModel CreateModel(SqlDataReader dr)
{
Pricing pricing = new Pricing();
int indexPricingId = dr.GetOrdinal("PricingId");
pricing.PricingId = Convert.ToInt32(dr[indexPricingId]);
int indexPricingApplyId = dr.GetOrdinal("PricingApplyId");
if (dr["PricingApplyId"] != DBNull.Value)
{
pricing.PricingApplyId = Convert.ToInt32(dr[indexPricingApplyId]);
}
int indexPricingWeight = dr.GetOrdinal("PricingWeight");
if (dr["PricingWeight"] != DBNull.Value)
{
pricing.PricingWeight = Convert.ToDecimal(dr[indexPricingWeight]);
}
int indexMUId = dr.GetOrdinal("MUId");
if (dr["MUId"] != DBNull.Value)
{
pricing.MUId = Convert.ToInt32(dr[indexMUId]);
}
int indexExchangeId = dr.GetOrdinal("ExchangeId");
if (dr["ExchangeId"] != DBNull.Value)
{
pricing.ExchangeId = Convert.ToInt32(dr[indexExchangeId]);
}
int indexFuturesCodeId = dr.GetOrdinal("FuturesCodeId");
if (dr["FuturesCodeId"] != DBNull.Value)
{
pricing.FuturesCodeId = Convert.ToInt32(dr[indexFuturesCodeId]);
}
int indexFuturesCodeEndDate = dr.GetOrdinal("FuturesCodeEndDate");
if (dr["FuturesCodeEndDate"] != DBNull.Value)
{
pricing.FuturesCodeEndDate = Convert.ToDateTime(dr[indexFuturesCodeEndDate]);
}
int indexSpotQP = dr.GetOrdinal("SpotQP");
if (dr["SpotQP"] != DBNull.Value)
{
pricing.SpotQP = Convert.ToDateTime(dr[indexSpotQP]);
}
int indexDelayFee = dr.GetOrdinal("DelayFee");
if (dr["DelayFee"] != DBNull.Value)
{
pricing.DelayFee = Convert.ToDecimal(dr[indexDelayFee]);
}
int indexSpread = dr.GetOrdinal("Spread");
if (dr["Spread"] != DBNull.Value)
{
pricing.Spread = Convert.ToDecimal(dr[indexSpread]);
}
int indexOtherFee = dr.GetOrdinal("OtherFee");
if (dr["OtherFee"] != DBNull.Value)
{
pricing.OtherFee = Convert.ToDecimal(dr[indexOtherFee]);
}
int indexAvgPrice = dr.GetOrdinal("AvgPrice");
if (dr["AvgPrice"] != DBNull.Value)
{
pricing.AvgPrice = Convert.ToDecimal(dr[indexAvgPrice]);
}
int indexPricingTime = dr.GetOrdinal("PricingTime");
if (dr["PricingTime"] != DBNull.Value)
{
pricing.PricingTime = Convert.ToDateTime(dr[indexPricingTime]);
}
int indexCurrencyId = dr.GetOrdinal("CurrencyId");
if (dr["CurrencyId"] != DBNull.Value)
{
pricing.CurrencyId = Convert.ToInt32(dr[indexCurrencyId]);
}
int indexPricinger = dr.GetOrdinal("Pricinger");
if (dr["Pricinger"] != DBNull.Value)
{
pricing.Pricinger = Convert.ToInt32(dr[indexPricinger]);
}
int indexAssertId = dr.GetOrdinal("AssertId");
if (dr["AssertId"] != DBNull.Value)
{
pricing.AssertId = Convert.ToInt32(dr[indexAssertId]);
}
int indexPricingDirection = dr.GetOrdinal("PricingDirection");
if (dr["PricingDirection"] != DBNull.Value)
{
pricing.PricingDirection = Convert.ToInt32(dr[indexPricingDirection]);
}
int indexPricingStatus = dr.GetOrdinal("PricingStatus");
if (dr["PricingStatus"] != DBNull.Value)
{
pricing.PricingStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexPricingStatus]);
}
int indexFinalPrice = dr.GetOrdinal("FinalPrice");
if (dr["FinalPrice"] != DBNull.Value)
{
pricing.FinalPrice = Convert.ToDecimal(dr[indexFinalPrice]);
}
int indexCreatorId = dr.GetOrdinal("CreatorId");
if (dr["CreatorId"] != DBNull.Value)
{
pricing.CreatorId = Convert.ToInt32(dr[indexCreatorId]);
}
int indexCreateTime = dr.GetOrdinal("CreateTime");
if (dr["CreateTime"] != DBNull.Value)
{
pricing.CreateTime = Convert.ToDateTime(dr[indexCreateTime]);
}
int indexLastModifyId = dr.GetOrdinal("LastModifyId");
if (dr["LastModifyId"] != DBNull.Value)
{
pricing.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]);
}
int indexLastModifyTime = dr.GetOrdinal("LastModifyTime");
if (dr["LastModifyTime"] != DBNull.Value)
{
pricing.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]);
}
return pricing;
}
public override IModel CreateModel(DataRow dr)
{
Pricing pricing = new Pricing();
pricing.PricingId = Convert.ToInt32(dr["PricingId"]);
if (dr["PricingApplyId"] != DBNull.Value)
{
pricing.PricingApplyId = Convert.ToInt32(dr["PricingApplyId"]);
}
if (dr["PricingWeight"] != DBNull.Value)
{
pricing.PricingWeight = Convert.ToDecimal(dr["PricingWeight"]);
}
if (dr["MUId"] != DBNull.Value)
{
pricing.MUId = Convert.ToInt32(dr["MUId"]);
}
if (dr["ExchangeId"] != DBNull.Value)
{
pricing.ExchangeId = Convert.ToInt32(dr["ExchangeId"]);
}
if (dr["FuturesCodeId"] != DBNull.Value)
{
pricing.FuturesCodeId = Convert.ToInt32(dr["FuturesCodeId"]);
}
if (dr["FuturesCodeEndDate"] != DBNull.Value)
{
pricing.FuturesCodeEndDate = Convert.ToDateTime(dr["FuturesCodeEndDate"]);
}
if (dr["SpotQP"] != DBNull.Value)
{
pricing.SpotQP = Convert.ToDateTime(dr["SpotQP"]);
}
if (dr["DelayFee"] != DBNull.Value)
{
pricing.DelayFee = Convert.ToDecimal(dr["DelayFee"]);
}
if (dr["Spread"] != DBNull.Value)
{
pricing.Spread = Convert.ToDecimal(dr["Spread"]);
}
if (dr["OtherFee"] != DBNull.Value)
{
pricing.OtherFee = Convert.ToDecimal(dr["OtherFee"]);
}
if (dr["AvgPrice"] != DBNull.Value)
{
pricing.AvgPrice = Convert.ToDecimal(dr["AvgPrice"]);
}
if (dr["PricingTime"] != DBNull.Value)
{
pricing.PricingTime = Convert.ToDateTime(dr["PricingTime"]);
}
if (dr["CurrencyId"] != DBNull.Value)
{
pricing.CurrencyId = Convert.ToInt32(dr["CurrencyId"]);
}
if (dr["Pricinger"] != DBNull.Value)
{
pricing.Pricinger = Convert.ToInt32(dr["Pricinger"]);
}
if (dr["AssertId"] != DBNull.Value)
{
pricing.AssertId = Convert.ToInt32(dr["AssertId"]);
}
if (dr["PricingDirection"] != DBNull.Value)
{
pricing.PricingDirection = Convert.ToInt32(dr["PricingDirection"]);
}
if (dr["PricingStatus"] != DBNull.Value)
{
pricing.PricingStatus = (Common.StatusEnum)Convert.ToInt32(dr["PricingStatus"]);
}
if (dr["FinalPrice"] != DBNull.Value)
{
pricing.FinalPrice = Convert.ToDecimal(dr["FinalPrice"]);
}
if (dr["CreatorId"] != DBNull.Value)
{
pricing.CreatorId = Convert.ToInt32(dr["CreatorId"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
pricing.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["LastModifyId"] != DBNull.Value)
{
pricing.LastModifyId = Convert.ToInt32(dr["LastModifyId"]);
}
if (dr["LastModifyTime"] != DBNull.Value)
{
pricing.LastModifyTime = Convert.ToDateTime(dr["LastModifyTime"]);
}
return pricing;
}