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