/// <summary>
/// 更新一条数据
/// </summary>
public void Update(QH_TradeCapitalFlowDetailInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update QH_TradeCapitalFlowDetail set ");
strSql.Append("UserCapitalAccount=@UserCapitalAccount,");
strSql.Append("FlowTypes=@FlowTypes,");
strSql.Append("Margin=@Margin,");
strSql.Append("TradeProceduresFee=@TradeProceduresFee,");
strSql.Append("ProfitLoss=@ProfitLoss,");
strSql.Append("OtherCose=@OtherCose,");
strSql.Append("CurrencyType=@CurrencyType,");
strSql.Append("FlowTotal=@FlowTotal");
strSql.Append(" where TradeID=@TradeID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "TradeID", DbType.String, model.TradeID);
db.AddInParameter(dbCommand, "UserCapitalAccount", DbType.AnsiString, model.UserCapitalAccount);
db.AddInParameter(dbCommand, "FlowTypes", DbType.Int32, model.FlowTypes);
db.AddInParameter(dbCommand, "Margin", DbType.Decimal, model.Margin);
db.AddInParameter(dbCommand, "TradeProceduresFee", DbType.Decimal, model.TradeProceduresFee);
db.AddInParameter(dbCommand, "ProfitLoss", DbType.Decimal, model.ProfitLoss);
db.AddInParameter(dbCommand, "OtherCose", DbType.Decimal, model.OtherCose);
db.AddInParameter(dbCommand, "CurrencyType", DbType.Int32, model.CurrencyType);
db.AddInParameter(dbCommand, "FlowTotal", DbType.Decimal, model.FlowTotal);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(QH_TradeCapitalFlowDetailInfo model, Database db, DbTransaction transaction)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into QH_TradeCapitalFlowDetail(");
strSql.Append("TradeID,UserCapitalAccount,FlowTypes,Margin,TradeProceduresFee,ProfitLoss,OtherCose,CurrencyType,CreateDateTime)");
strSql.Append(" values (");
strSql.Append("@TradeID,@UserCapitalAccount,@FlowTypes,@Margin,@TradeProceduresFee,@ProfitLoss,@OtherCose,@CurrencyType,@CreateDateTime)");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "TradeID", DbType.String, model.TradeID);
db.AddInParameter(dbCommand, "UserCapitalAccount", DbType.AnsiString, model.UserCapitalAccount);
db.AddInParameter(dbCommand, "FlowTypes", DbType.Int32, model.FlowTypes);
db.AddInParameter(dbCommand, "Margin", DbType.Decimal, model.Margin);
db.AddInParameter(dbCommand, "TradeProceduresFee", DbType.Decimal, model.TradeProceduresFee);
db.AddInParameter(dbCommand, "ProfitLoss", DbType.Decimal, model.ProfitLoss);
db.AddInParameter(dbCommand, "OtherCose", DbType.Decimal, model.OtherCose);
db.AddInParameter(dbCommand, "CurrencyType", DbType.Int32, model.CurrencyType);
db.AddInParameter(dbCommand, "CreateDateTime", DbType.DateTime, model.CreateDateTime);
try
{
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 增加期货成交资金流水记录
/// </summary>
/// <param name="flowType">流水类型 0-交易 ,1-结算</param>
/// <param name="margin">保证金</param>
/// <param name="otherCose">其他费用(用于预留可能用）</param>
/// <param name="profitLosss">盯市盈亏(流水类型为交易时是每笔成交平仓盯市盈亏，为结算时持仓盯市盈亏)</param>
/// <param name="tradeID">成交记录编号ID（如果是清算没有ID自动生成一个GUID）</param>
/// <param name="tradeProceduresFee">交易费用</param>
/// <param name="userAccount">用户资金账号</param>
/// <param name="currencyType">币种</param>
/// <returns></returns>
public static bool AddQH_CapitalFlow(int flowType, decimal margin, decimal otherCose, decimal profitLosss,
string tradeID, decimal tradeProceduresFee, string userAccount, int currencyType)
{
try
{
QH_TradeCapitalFlowDetailInfo detailInfo = new QH_TradeCapitalFlowDetailInfo();
detailInfo.FlowTypes = flowType;
detailInfo.Margin = margin;
detailInfo.OtherCose = otherCose;
detailInfo.ProfitLoss = profitLosss;
if (string.IsNullOrEmpty(tradeID))
{
detailInfo.TradeID = Guid.NewGuid().ToString();
}
else
{
detailInfo.TradeID = tradeID;
}
detailInfo.TradeProceduresFee = tradeProceduresFee;
detailInfo.CurrencyType = currencyType;
detailInfo.UserCapitalAccount = userAccount;
detailInfo.CreateDateTime = DateTime.Now;
return(AddQH_CapitalFlow(detailInfo));
}
catch (Exception ex)
{
LogHelper.WriteError(ex.Message, ex);
return(false);
}
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public QH_TradeCapitalFlowDetailInfo ReaderBind(IDataReader dataReader)
{
QH_TradeCapitalFlowDetailInfo model = new QH_TradeCapitalFlowDetailInfo();
object ojb;
model.TradeID = dataReader["TradeID"].ToString();
model.UserCapitalAccount = dataReader["UserCapitalAccount"].ToString();
ojb = dataReader["FlowTypes"];
if (ojb != null && ojb != DBNull.Value)
{
model.FlowTypes = (int)ojb;
}
ojb = dataReader["Margin"];
if (ojb != null && ojb != DBNull.Value)
{
model.Margin = (decimal)ojb;
}
ojb = dataReader["TradeProceduresFee"];
if (ojb != null && ojb != DBNull.Value)
{
model.TradeProceduresFee = (decimal)ojb;
}
ojb = dataReader["ProfitLoss"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProfitLoss = (decimal)ojb;
}
ojb = dataReader["OtherCose"];
if (ojb != null && ojb != DBNull.Value)
{
model.OtherCose = (decimal)ojb;
}
ojb = dataReader["FlowTotal"];
if (ojb != null && ojb != DBNull.Value)
{
model.FlowTotal = (decimal)ojb;
}
ojb = dataReader["CurrencyType"];
if (ojb != null && ojb != DBNull.Value)
{
model.CurrencyType = (int)ojb;
}
ojb = dataReader["CreateDateTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateDateTime = (DateTime)ojb;
}
return(model);
}
/// <summary>
/// 增加期货成交资金流水记录
/// </summary>
/// <param name="tet">期货资金流水实体</param>
/// <returns></returns>
public static bool AddQH_CapitalFlow(QH_TradeCapitalFlowDetailInfo tet)
{
try
{
QH_TradeCapitalFlowDetailDal dal = new QH_TradeCapitalFlowDetailDal();
tet.CreateDateTime = DateTime.Now;
dal.Add(tet);
}
catch (Exception ex)
{
LogHelper.WriteError(ex.Message, ex);
return(false);
}
return(true);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public QH_TradeCapitalFlowDetailInfo GetModel(string TradeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TradeID,UserCapitalAccount,FlowTypes,Margin,TradeProceduresFee,ProfitLoss,OtherCose,FlowTotal,CurrencyType,CreateDateTime from QH_TradeCapitalFlowDetail ");
strSql.Append(" where TradeID=@TradeID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "TradeID", DbType.String, TradeID);
QH_TradeCapitalFlowDetailInfo model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
