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