/// <summary>
/// 得到一个对象实体
/// </summary>
public ManagementCenter.Model.XH_SpotCosts GetModel(int BreedClassID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(
"select GetValueTypeID,StampDuty,StampDutyStartingpoint,Commision,TransferToll,MonitoringFee,TransferTollStartingpoint,TransferTollTypeID,ClearingFees,CommisionStartingpoint,PoundageSingleValue,SystemToll,BreedClassID,CurrencyTypeID,StampDutyTypeID from XH_SpotCosts ");
strSql.Append(" where BreedClassID=@BreedClassID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, BreedClassID);
ManagementCenter.Model.XH_SpotCosts model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ManagementCenter.Model.XH_SpotCosts model, DbTransaction tran, Database db)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XH_SpotCosts(");
strSql.Append(
"GetValueTypeID,StampDuty,StampDutyStartingpoint,Commision,TransferToll,MonitoringFee,TransferTollStartingpoint,TransferTollTypeID,ClearingFees,CommisionStartingpoint,PoundageSingleValue,SystemToll,BreedClassID,CurrencyTypeID,StampDutyTypeID)");
strSql.Append(" values (");
strSql.Append(
"@GetValueTypeID,@StampDuty,@StampDutyStartingpoint,@Commision,@TransferToll,@MonitoringFee,@TransferTollStartingpoint,@TransferTollTypeID,@ClearingFees,@CommisionStartingpoint,@PoundageSingleValue,@SystemToll,@BreedClassID,@CurrencyTypeID,@StampDutyTypeID)");
if (db == null)
{
db = DatabaseFactory.CreateDatabase();
}
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "GetValueTypeID", DbType.Int32, model.GetValueTypeID);
db.AddInParameter(dbCommand, "StampDuty", DbType.Decimal, model.StampDuty);
db.AddInParameter(dbCommand, "StampDutyStartingpoint", DbType.Decimal, model.StampDutyStartingpoint);
if (model.Commision == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "Commision", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "Commision", DbType.Decimal, model.Commision);
}
db.AddInParameter(dbCommand, "TransferToll", DbType.Decimal, model.TransferToll);
db.AddInParameter(dbCommand, "MonitoringFee", DbType.Decimal, model.MonitoringFee);
db.AddInParameter(dbCommand, "TransferTollStartingpoint", DbType.Decimal,
model.TransferTollStartingpoint);
db.AddInParameter(dbCommand, "TransferTollTypeID", DbType.Int32, model.TransferTollTypeID);
db.AddInParameter(dbCommand, "ClearingFees", DbType.Decimal, model.ClearingFees);
db.AddInParameter(dbCommand, "CommisionStartingpoint", DbType.Decimal, model.CommisionStartingpoint);
if (model.PoundageSingleValue == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "PoundageSingleValue", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "PoundageSingleValue", DbType.Decimal, model.PoundageSingleValue);
}
if (model.SystemToll == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "SystemToll", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "SystemToll", DbType.Decimal, model.SystemToll);
}
db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, model.BreedClassID);
db.AddInParameter(dbCommand, "CurrencyTypeID", DbType.Int32, model.CurrencyTypeID);
db.AddInParameter(dbCommand, "StampDutyTypeID", DbType.Int32, model.StampDutyTypeID);
//db.ExecuteNonQuery(dbCommand);
//object obj;
if (tran == null)
{
//obj = db.ExecuteNonQuery(dbCommand);
db.ExecuteNonQuery(dbCommand);
}
else
{
//obj = db.ExecuteNonQuery(dbCommand, tran);
db.ExecuteNonQuery(dbCommand, tran);
}
return(true);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public ManagementCenter.Model.XH_SpotCosts ReaderBind(IDataReader dataReader)
{
ManagementCenter.Model.XH_SpotCosts model = new ManagementCenter.Model.XH_SpotCosts();
object ojb;
ojb = dataReader["GetValueTypeID"];
if (ojb != null && ojb != DBNull.Value)
{
model.GetValueTypeID = (int)ojb;
}
ojb = dataReader["StampDuty"];
if (ojb != null && ojb != DBNull.Value)
{
model.StampDuty = (decimal)ojb;
}
ojb = dataReader["StampDutyStartingpoint"];
if (ojb != null && ojb != DBNull.Value)
{
model.StampDutyStartingpoint = (decimal)ojb;
}
ojb = dataReader["Commision"];
if (ojb != null && ojb != DBNull.Value)
{
model.Commision = (decimal)ojb;
}
ojb = dataReader["TransferToll"];
if (ojb != null && ojb != DBNull.Value)
{
model.TransferToll = (decimal)ojb;
}
ojb = dataReader["MonitoringFee"];
if (ojb != null && ojb != DBNull.Value)
{
model.MonitoringFee = (decimal?)ojb;
}
ojb = dataReader["TransferTollStartingpoint"];
if (ojb != null && ojb != DBNull.Value)
{
model.TransferTollStartingpoint = (decimal?)ojb;
}
ojb = dataReader["TransferTollTypeID"];
if (ojb != null && ojb != DBNull.Value)
{
model.TransferTollTypeID = (int)ojb;
}
ojb = dataReader["ClearingFees"];
if (ojb != null && ojb != DBNull.Value)
{
model.ClearingFees = (decimal?)ojb;
}
ojb = dataReader["CommisionStartingpoint"];
if (ojb != null && ojb != DBNull.Value)
{
model.CommisionStartingpoint = (decimal)ojb;
}
ojb = dataReader["PoundageSingleValue"];
if (ojb != null && ojb != DBNull.Value)
{
model.PoundageSingleValue = (decimal?)ojb;
}
ojb = dataReader["SystemToll"];
if (ojb != null && ojb != DBNull.Value)
{
model.SystemToll = (decimal?)ojb;
}
ojb = dataReader["BreedClassID"];
if (ojb != null && ojb != DBNull.Value)
{
model.BreedClassID = (int)ojb;
}
ojb = dataReader["CurrencyTypeID"];
if (ojb != null && ojb != DBNull.Value)
{
model.CurrencyTypeID = (int)ojb;
}
ojb = dataReader["StampDutyTypeID"];
if (ojb != null && ojb != DBNull.Value)
{
model.StampDutyTypeID = (int)ojb;
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ManagementCenter.Model.XH_SpotCosts model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XH_SpotCosts set ");
strSql.Append("GetValueTypeID=@GetValueTypeID,");
strSql.Append("StampDuty=@StampDuty,");
strSql.Append("StampDutyStartingpoint=@StampDutyStartingpoint,");
strSql.Append("Commision=@Commision,");
strSql.Append("TransferToll=@TransferToll,");
strSql.Append("MonitoringFee=@MonitoringFee,");
strSql.Append("TransferTollStartingpoint=@TransferTollStartingpoint,");
strSql.Append("TransferTollTypeID=@TransferTollTypeID,");
strSql.Append("ClearingFees=@ClearingFees,");
strSql.Append("CommisionStartingpoint=@CommisionStartingpoint,");
strSql.Append("PoundageSingleValue=@PoundageSingleValue,");
strSql.Append("SystemToll=@SystemToll,");
strSql.Append("CurrencyTypeID=@CurrencyTypeID,");
strSql.Append("StampDutyTypeID=@StampDutyTypeID");
strSql.Append(" where BreedClassID=@BreedClassID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "GetValueTypeID", DbType.Int32, model.GetValueTypeID);
if (model.StampDuty == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "StampDuty", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "StampDuty", DbType.Decimal, model.StampDuty);
}
if (model.StampDutyStartingpoint == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "StampDutyStartingpoint", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "StampDutyStartingpoint", DbType.Decimal, model.StampDutyStartingpoint);
}
if (model.Commision == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "Commision", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "Commision", DbType.Decimal, model.Commision);
}
if (model.TransferToll == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "TransferToll", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "TransferToll", DbType.Decimal, model.TransferToll);
}
if (model.MonitoringFee == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "MonitoringFee", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "MonitoringFee", DbType.Decimal, model.MonitoringFee);
}
if (model.TransferTollStartingpoint == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "TransferTollStartingpoint", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "TransferTollStartingpoint", DbType.Decimal,
model.TransferTollStartingpoint);
}
db.AddInParameter(dbCommand, "TransferTollTypeID", DbType.Int32, model.TransferTollTypeID);
if (model.ClearingFees == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "ClearingFees", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "ClearingFees", DbType.Decimal, model.ClearingFees);
}
if (model.CommisionStartingpoint == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "CommisionStartingpoint", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "CommisionStartingpoint", DbType.Decimal, model.CommisionStartingpoint);
}
if (model.PoundageSingleValue == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "PoundageSingleValue", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "PoundageSingleValue", DbType.Decimal, model.PoundageSingleValue);
}
if (model.SystemToll == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "SystemToll", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "SystemToll", DbType.Decimal, model.SystemToll);
}
db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, model.BreedClassID);
db.AddInParameter(dbCommand, "CurrencyTypeID", DbType.Int32, model.CurrencyTypeID);
db.AddInParameter(dbCommand, "StampDutyTypeID", DbType.Int32, model.StampDutyTypeID);
db.ExecuteNonQuery(dbCommand);
return(true);
}
/// <summary>
/// 添加现货交易费用
/// </summary>
/// <param name="model">现货交易费用实体</param>
/// <returns></returns>
public bool Add(ManagementCenter.Model.XH_SpotCosts model)
{
return(Add(model, null, null));
}
