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