/// <summary>
/// 添加港股交易费用
/// </summary>
/// <param name="model">港股交易费用实体</param>
/// <param name="tran">事务</param>
/// <param name="db">db</param>
/// <returns></returns>
public bool Add(ManagementCenter.Model.HK_SpotCosts model, DbTransaction tran, Database db)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HK_SpotCosts(");
strSql.Append("StampDuty,StampDutyStartingpoint,Commision,MonitoringFee,CommisionStartingpoint,PoundageValue,SystemToll,StampDutyTypeID,BreedClassID,CurrencyTypeID,TransferToll)");
strSql.Append(" values (");
strSql.Append("@StampDuty,@StampDutyStartingpoint,@Commision,@MonitoringFee,@CommisionStartingpoint,@PoundageValue,@SystemToll,@StampDutyTypeID,@BreedClassID,@CurrencyTypeID,@TransferToll)");
if (db == null)
{
db = DatabaseFactory.CreateDatabase();
}
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "StampDuty", DbType.Decimal, model.StampDuty);
//db.AddInParameter(dbCommand, "StampDutyStartingpoint", DbType.Decimal, model.StampDutyStartingpoint);
//if (model.StampDutyStartingpoint == AppGlobalVariable.INIT_DECIMAL)
//{
// db.AddInParameter(dbCommand, "StampDutyStartingpoint", DbType.Decimal, DBNull.Value);
//}
//else
//{
db.AddInParameter(dbCommand, "StampDutyStartingpoint", DbType.Decimal, model.StampDutyStartingpoint);//界面上传值默认为0
//}
db.AddInParameter(dbCommand, "Commision", DbType.Decimal, model.Commision);
db.AddInParameter(dbCommand, "MonitoringFee", DbType.Decimal, model.MonitoringFee);
db.AddInParameter(dbCommand, "CommisionStartingpoint", DbType.Decimal, model.CommisionStartingpoint);//界面上传值默认为0
db.AddInParameter(dbCommand, "PoundageValue", DbType.Decimal, model.PoundageValue);
db.AddInParameter(dbCommand, "SystemToll", DbType.Decimal, model.SystemToll);
db.AddInParameter(dbCommand, "StampDutyTypeID", DbType.Int32, model.StampDutyTypeID);
db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, model.BreedClassID);
db.AddInParameter(dbCommand, "CurrencyTypeID", DbType.Int32, model.CurrencyTypeID);
// db.AddInParameter(dbCommand, "TransferToll", DbType.Decimal, model.TransferToll);
if (model.TransferToll == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "TransferToll", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "TransferToll", DbType.Decimal, model.TransferToll);
}
// db.ExecuteNonQuery(dbCommand);
if (tran == null)
{
db.ExecuteNonQuery(dbCommand);
}
else
{
db.ExecuteNonQuery(dbCommand, tran);
}
return(true);
}
/// <summary>
/// 更新港股交易费用
/// </summary>
/// <param name="model">港股交易费用实体</param>
/// <returns></returns>
public bool Update(ManagementCenter.Model.HK_SpotCosts model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HK_SpotCosts set ");
strSql.Append("StampDuty=@StampDuty,");
strSql.Append("StampDutyStartingpoint=@StampDutyStartingpoint,");
strSql.Append("Commision=@Commision,");
strSql.Append("MonitoringFee=@MonitoringFee,");
strSql.Append("CommisionStartingpoint=@CommisionStartingpoint,");
strSql.Append("PoundageValue=@PoundageValue,");
strSql.Append("SystemToll=@SystemToll,");
strSql.Append("StampDutyTypeID=@StampDutyTypeID,");
strSql.Append("CurrencyTypeID=@CurrencyTypeID,");
strSql.Append("TransferToll=@TransferToll");
strSql.Append(" where BreedClassID=@BreedClassID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "StampDuty", DbType.Decimal, model.StampDuty);
//db.AddInParameter(dbCommand, "StampDutyStartingpoint", DbType.Decimal, model.StampDutyStartingpoint);
db.AddInParameter(dbCommand, "StampDutyStartingpoint", DbType.Decimal, model.StampDutyStartingpoint);//界面上传值默认为0
db.AddInParameter(dbCommand, "Commision", DbType.Decimal, model.Commision);
db.AddInParameter(dbCommand, "MonitoringFee", DbType.Decimal, model.MonitoringFee);
//db.AddInParameter(dbCommand, "CommisionStartingpoint", DbType.Decimal, model.CommisionStartingpoint);
db.AddInParameter(dbCommand, "CommisionStartingpoint", DbType.Decimal, model.CommisionStartingpoint);//界面上传值默认为0
db.AddInParameter(dbCommand, "PoundageValue", DbType.Decimal, model.PoundageValue);
db.AddInParameter(dbCommand, "SystemToll", DbType.Decimal, model.SystemToll);
db.AddInParameter(dbCommand, "StampDutyTypeID", DbType.Int32, model.StampDutyTypeID);
db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, model.BreedClassID);
db.AddInParameter(dbCommand, "CurrencyTypeID", DbType.Int32, model.CurrencyTypeID);
//db.AddInParameter(dbCommand, "TransferToll", DbType.Decimal, model.TransferToll);
if (model.TransferToll == AppGlobalVariable.INIT_DECIMAL)
{
db.AddInParameter(dbCommand, "TransferToll", DbType.Decimal, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "TransferToll", DbType.Decimal, model.TransferToll);
}
db.ExecuteNonQuery(dbCommand);
return(true);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ManagementCenter.Model.HK_SpotCosts GetModel(int BreedClassID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select StampDuty,StampDutyStartingpoint,Commision,MonitoringFee,CommisionStartingpoint,PoundageValue,SystemToll,StampDutyTypeID,BreedClassID,CurrencyTypeID,TransferToll from HK_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.HK_SpotCosts model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public ManagementCenter.Model.HK_SpotCosts ReaderBind(IDataReader dataReader)
{
ManagementCenter.Model.HK_SpotCosts model = new ManagementCenter.Model.HK_SpotCosts();
object 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["MonitoringFee"];
if (ojb != null && ojb != DBNull.Value)
{
model.MonitoringFee = (decimal)ojb;
}
ojb = dataReader["CommisionStartingpoint"];
if (ojb != null && ojb != DBNull.Value)
{
model.CommisionStartingpoint = (decimal)ojb;
}
ojb = dataReader["PoundageValue"];
if (ojb != null && ojb != DBNull.Value)
{
model.PoundageValue = (decimal)ojb;
}
ojb = dataReader["SystemToll"];
if (ojb != null && ojb != DBNull.Value)
{
model.SystemToll = (decimal)ojb;
}
ojb = dataReader["StampDutyTypeID"];
if (ojb != null && ojb != DBNull.Value)
{
model.StampDutyTypeID = (int)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["TransferToll"];
if (ojb != null && ojb != DBNull.Value)
{
model.TransferToll = (decimal)ojb;
}
return(model);
}
/// <summary>
/// 添加港股交易费用
/// </summary>
/// <param name="model">港股交易费用实体</param>
/// <returns></returns>
public bool Add(ManagementCenter.Model.HK_SpotCosts model)
{
return(Add(model, null, null));
}
