/// <summary>
/// 更新一条数据
/// </summary>
public void Update(HK_HistoryModifyOrderRequestInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HK_HistoryModifyOrderRequest set ");
strSql.Append("ChannelID=@ChannelID,");
strSql.Append("TraderId=@TraderId,");
strSql.Append("FundAccountId=@FundAccountId,");
strSql.Append("TraderPassword=@TraderPassword,");
strSql.Append("Code=@Code,");
strSql.Append("EntrustNubmer=@EntrustNubmer,");
strSql.Append("OrderPrice=@OrderPrice,");
strSql.Append("OrderAmount=@OrderAmount,");
strSql.Append("Message=@Message,");
strSql.Append("ModifyOrderDateTime=@ModifyOrderDateTime");
strSql.Append(" where ID=@ID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ID", DbType.AnsiString, model.ID);
db.AddInParameter(dbCommand, "ChannelID", DbType.AnsiString, model.ChannelID);
db.AddInParameter(dbCommand, "TraderId", DbType.AnsiString, model.TraderId);
db.AddInParameter(dbCommand, "FundAccountId", DbType.AnsiString, model.FundAccountId);
db.AddInParameter(dbCommand, "TraderPassword", DbType.AnsiString, model.TraderPassword);
db.AddInParameter(dbCommand, "Code", DbType.AnsiString, model.Code);
db.AddInParameter(dbCommand, "EntrustNubmer", DbType.AnsiString, model.EntrustNubmer);
db.AddInParameter(dbCommand, "OrderPrice", DbType.Decimal, model.OrderPrice);
db.AddInParameter(dbCommand, "OrderAmount", DbType.Int32, model.OrderAmount);
db.AddInParameter(dbCommand, "Message", DbType.AnsiString, model.Message);
db.AddInParameter(dbCommand, "ModifyOrderDateTime", DbType.DateTime, model.ModifyOrderDateTime);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public HK_HistoryModifyOrderRequestInfo ReaderBind(IDataReader dataReader)
{
HK_HistoryModifyOrderRequestInfo model = new HK_HistoryModifyOrderRequestInfo();
object ojb;
model.ID = dataReader["ID"].ToString();
model.ChannelID = dataReader["ChannelID"].ToString();
model.TraderId = dataReader["TraderId"].ToString();
model.FundAccountId = dataReader["FundAccountId"].ToString();
model.TraderPassword = dataReader["TraderPassword"].ToString();
model.Code = dataReader["Code"].ToString();
model.EntrustNubmer = dataReader["EntrustNubmer"].ToString();
ojb = dataReader["OrderPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrderPrice = float.Parse(ojb.ToString());
}
ojb = dataReader["OrderAmount"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrderAmount = float.Parse(ojb.ToString());
}
model.Message = dataReader["Message"].ToString();
ojb = dataReader["ModifyOrderDateTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.ModifyOrderDateTime = (DateTime)ojb;
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(HK_HistoryModifyOrderRequestInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HK_HistoryModifyOrderRequest(");
strSql.Append("ID,ChannelID,TraderId,FundAccountId,TraderPassword,Code,EntrustNubmer,OrderPrice,OrderAmount,Message,ModifyOrderDateTime)");
strSql.Append(" values (");
strSql.Append("@ID,@ChannelID,@TraderId,@FundAccountId,@TraderPassword,@Code,@EntrustNubmer,@OrderPrice,@OrderAmount,@Message,@ModifyOrderDateTime)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ID", DbType.AnsiString, model.ID);
db.AddInParameter(dbCommand, "ChannelID", DbType.AnsiString, model.ChannelID);
db.AddInParameter(dbCommand, "TraderId", DbType.AnsiString, model.TraderId);
db.AddInParameter(dbCommand, "FundAccountId", DbType.AnsiString, model.FundAccountId);
db.AddInParameter(dbCommand, "TraderPassword", DbType.AnsiString, model.TraderPassword);
db.AddInParameter(dbCommand, "Code", DbType.AnsiString, model.Code);
db.AddInParameter(dbCommand, "EntrustNubmer", DbType.AnsiString, model.EntrustNubmer);
db.AddInParameter(dbCommand, "OrderPrice", DbType.Decimal, model.OrderPrice);
db.AddInParameter(dbCommand, "OrderAmount", DbType.Int32, model.OrderAmount);
db.AddInParameter(dbCommand, "Message", DbType.AnsiString, model.Message);
db.AddInParameter(dbCommand, "ModifyOrderDateTime", DbType.DateTime, model.ModifyOrderDateTime);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HK_HistoryModifyOrderRequestInfo GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,ChannelID,TraderId,FundAccountId,TraderPassword,Code,EntrustNubmer,OrderPrice,OrderAmount,Message,ModifyOrderDateTime from HK_HistoryModifyOrderRequest ");
strSql.Append(" where ID=@ID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ID", DbType.AnsiString, ID);
HK_HistoryModifyOrderRequestInfo model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
