/// <summary> /// 更新一条数据 /// </summary> public void Update(QH_HistoryEntrustTableInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update QH_HistoryEntrustTable set "); strSql.Append("PortfolioLogo=@PortfolioLogo,"); strSql.Append("EntrustPrice=@EntrustPrice,"); strSql.Append("EntrustAmount=@EntrustAmount,"); strSql.Append("ContractCode=@ContractCode,"); strSql.Append("TradeAmount=@TradeAmount,"); strSql.Append("TradeAveragePrice=@TradeAveragePrice,"); strSql.Append("CancelAmount=@CancelAmount,"); strSql.Append("TradeAccount=@TradeAccount,"); strSql.Append("CapitalAccount=@CapitalAccount,"); strSql.Append("BuySellTypeId=@BuySellTypeId,"); strSql.Append("CurrencyTypeId=@CurrencyTypeId,"); strSql.Append("TradeUnitId=@TradeUnitId,"); strSql.Append("OpenCloseTypeId=@OpenCloseTypeId,"); strSql.Append("OrderStatusId=@OrderStatusId,"); strSql.Append("IsMarketValue=@IsMarketValue,"); strSql.Append("OrderMessage=@OrderMessage,"); strSql.Append("McOrderId=@McOrderId,"); strSql.Append("CloseFloatProfitLoss=@CloseFloatProfitLoss,"); strSql.Append("CloseMarketProfitLoss=@CloseMarketProfitLoss,"); strSql.Append("OfferTime=@OfferTime,"); strSql.Append("EntrustTime=@EntrustTime"); strSql.Append(" where EntrustNumber=@EntrustNumber "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber); db.AddInParameter(dbCommand, "PortfolioLogo", DbType.AnsiString, model.PortfolioLogo); db.AddInParameter(dbCommand, "EntrustPrice", DbType.Decimal, model.EntrustPrice); db.AddInParameter(dbCommand, "EntrustAmount", DbType.Int32, model.EntrustAmount); db.AddInParameter(dbCommand, "ContractCode", DbType.AnsiString, model.ContractCode); db.AddInParameter(dbCommand, "TradeAmount", DbType.Int32, model.TradeAmount); db.AddInParameter(dbCommand, "TradeAveragePrice", DbType.Decimal, model.TradeAveragePrice); db.AddInParameter(dbCommand, "CancelAmount", DbType.Int32, model.CancelAmount); db.AddInParameter(dbCommand, "TradeAccount", DbType.AnsiString, model.TradeAccount); db.AddInParameter(dbCommand, "CapitalAccount", DbType.AnsiString, model.CapitalAccount); db.AddInParameter(dbCommand, "BuySellTypeId", DbType.Int32, model.BuySellTypeId); db.AddInParameter(dbCommand, "CurrencyTypeId", DbType.Int32, model.CurrencyTypeId); db.AddInParameter(dbCommand, "TradeUnitId", DbType.Int32, model.TradeUnitId); db.AddInParameter(dbCommand, "OpenCloseTypeId", DbType.Int32, model.OpenCloseTypeId); db.AddInParameter(dbCommand, "OrderStatusId", DbType.Int32, model.OrderStatusId); db.AddInParameter(dbCommand, "IsMarketValue", DbType.Boolean, model.IsMarketValue); db.AddInParameter(dbCommand, "OrderMessage", DbType.AnsiString, model.OrderMessage); db.AddInParameter(dbCommand, "McOrderId", DbType.AnsiString, model.McOrderId); db.AddInParameter(dbCommand, "CloseFloatProfitLoss", DbType.Decimal, model.CloseFloatProfitLoss); db.AddInParameter(dbCommand, "CloseMarketProfitLoss", DbType.Decimal, model.CloseMarketProfitLoss); db.AddInParameter(dbCommand, "OfferTime", DbType.DateTime, model.OfferTime); db.AddInParameter(dbCommand, "EntrustTime", DbType.DateTime, model.EntrustTime); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 得到一个对象实体 /// </summary> public QH_HistoryEntrustTableInfo GetModel(string EntrustNumber) { StringBuilder strSql = new StringBuilder(); strSql.Append("select EntrustNumber,PortfolioLogo,EntrustPrice,EntrustAmount,ContractCode,TradeAmount,TradeAveragePrice,CancelAmount,TradeAccount,CapitalAccount,BuySellTypeId,CurrencyTypeId,TradeUnitId,OpenCloseTypeId,OrderStatusId,IsMarketValue,OrderMessage,McOrderId,CloseFloatProfitLoss,CloseMarketProfitLoss,OfferTime,EntrustTime from QH_HistoryEntrustTable "); strSql.Append(" where EntrustNumber=@EntrustNumber "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, EntrustNumber); QH_HistoryEntrustTableInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(QH_HistoryEntrustTableInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into QH_HistoryEntrustTable("); strSql.Append("EntrustNumber,PortfolioLogo,EntrustPrice,EntrustAmount,ContractCode,TradeAmount,TradeAveragePrice,CancelAmount,TradeAccount,CapitalAccount,BuySellTypeId,CurrencyTypeId,TradeUnitId,OpenCloseTypeId,OrderStatusId,IsMarketValue,OrderMessage,McOrderId,CloseFloatProfitLoss,CloseMarketProfitLoss,OfferTime,EntrustTime)"); strSql.Append(" values ("); strSql.Append("@EntrustNumber,@PortfolioLogo,@EntrustPrice,@EntrustAmount,@ContractCode,@TradeAmount,@TradeAveragePrice,@CancelAmount,@TradeAccount,@CapitalAccount,@BuySellTypeId,@CurrencyTypeId,@TradeUnitId,@OpenCloseTypeId,@OrderStatusId,@IsMarketValue,@OrderMessage,@McOrderId,@CloseFloatProfitLoss,@CloseMarketProfitLoss,@OfferTime,@EntrustTime)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "EntrustNumber", DbType.AnsiString, model.EntrustNumber); db.AddInParameter(dbCommand, "PortfolioLogo", DbType.AnsiString, model.PortfolioLogo); db.AddInParameter(dbCommand, "EntrustPrice", DbType.Decimal, model.EntrustPrice); db.AddInParameter(dbCommand, "EntrustAmount", DbType.Int32, model.EntrustAmount); db.AddInParameter(dbCommand, "ContractCode", DbType.AnsiString, model.ContractCode); db.AddInParameter(dbCommand, "TradeAmount", DbType.Int32, model.TradeAmount); db.AddInParameter(dbCommand, "TradeAveragePrice", DbType.Decimal, model.TradeAveragePrice); db.AddInParameter(dbCommand, "CancelAmount", DbType.Int32, model.CancelAmount); db.AddInParameter(dbCommand, "TradeAccount", DbType.AnsiString, model.TradeAccount); db.AddInParameter(dbCommand, "CapitalAccount", DbType.AnsiString, model.CapitalAccount); db.AddInParameter(dbCommand, "BuySellTypeId", DbType.Int32, model.BuySellTypeId); db.AddInParameter(dbCommand, "CurrencyTypeId", DbType.Int32, model.CurrencyTypeId); db.AddInParameter(dbCommand, "TradeUnitId", DbType.Int32, model.TradeUnitId); db.AddInParameter(dbCommand, "OpenCloseTypeId", DbType.Int32, model.OpenCloseTypeId); db.AddInParameter(dbCommand, "OrderStatusId", DbType.Int32, model.OrderStatusId); db.AddInParameter(dbCommand, "IsMarketValue", DbType.Boolean, model.IsMarketValue); db.AddInParameter(dbCommand, "OrderMessage", DbType.AnsiString, model.OrderMessage); db.AddInParameter(dbCommand, "McOrderId", DbType.AnsiString, model.McOrderId); db.AddInParameter(dbCommand, "CloseFloatProfitLoss", DbType.Decimal, model.CloseFloatProfitLoss); db.AddInParameter(dbCommand, "CloseMarketProfitLoss", DbType.Decimal, model.CloseMarketProfitLoss); db.AddInParameter(dbCommand, "OfferTime", DbType.DateTime, model.OfferTime); db.AddInParameter(dbCommand, "EntrustTime", DbType.DateTime, model.EntrustTime); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 对象实体绑定数据 /// </summary> public QH_HistoryEntrustTableInfo ReaderBind(IDataReader dataReader) { QH_HistoryEntrustTableInfo model = new QH_HistoryEntrustTableInfo(); object ojb; model.EntrustNumber = dataReader["EntrustNumber"].ToString(); model.PortfolioLogo = dataReader["PortfolioLogo"].ToString(); ojb = dataReader["EntrustPrice"]; if (ojb != null && ojb != DBNull.Value) { model.EntrustPrice = (decimal)ojb; } ojb = dataReader["EntrustAmount"]; if (ojb != null && ojb != DBNull.Value) { model.EntrustAmount = (int)ojb; } model.ContractCode = dataReader["ContractCode"].ToString(); ojb = dataReader["TradeAmount"]; if (ojb != null && ojb != DBNull.Value) { model.TradeAmount = (int)ojb; } ojb = dataReader["TradeAveragePrice"]; if (ojb != null && ojb != DBNull.Value) { model.TradeAveragePrice = (decimal)ojb; } ojb = dataReader["CancelAmount"]; if (ojb != null && ojb != DBNull.Value) { model.CancelAmount = (int)ojb; } model.TradeAccount = dataReader["TradeAccount"].ToString(); model.CapitalAccount = dataReader["CapitalAccount"].ToString(); ojb = dataReader["BuySellTypeId"]; if (ojb != null && ojb != DBNull.Value) { model.BuySellTypeId = (int)ojb; } ojb = dataReader["CurrencyTypeId"]; if (ojb != null && ojb != DBNull.Value) { model.CurrencyTypeId = (int)ojb; } ojb = dataReader["TradeUnitId"]; if (ojb != null && ojb != DBNull.Value) { model.TradeUnitId = (int)ojb; } ojb = dataReader["OpenCloseTypeId"]; if (ojb != null && ojb != DBNull.Value) { model.OpenCloseTypeId = (int)ojb; } ojb = dataReader["OrderStatusId"]; if (ojb != null && ojb != DBNull.Value) { model.OrderStatusId = (int)ojb; } ojb = dataReader["IsMarketValue"]; if (ojb != null && ojb != DBNull.Value) { model.IsMarketValue = (bool)ojb; } model.OrderMessage = dataReader["OrderMessage"].ToString(); model.McOrderId = dataReader["McOrderId"].ToString(); ojb = dataReader["CloseFloatProfitLoss"]; if (ojb != null && ojb != DBNull.Value) { model.CloseFloatProfitLoss = (decimal)ojb; } ojb = dataReader["CloseMarketProfitLoss"]; if (ojb != null && ojb != DBNull.Value) { model.CloseMarketProfitLoss = (decimal)ojb; } ojb = dataReader["OfferTime"]; if (ojb != null && ojb != DBNull.Value) { model.OfferTime = (DateTime)ojb; } ojb = dataReader["EntrustTime"]; if (ojb != null && ojb != DBNull.Value) { model.EntrustTime = (DateTime)ojb; } return(model); }