public List <ArchiveTradeCommandSecurity> Get(int archiveId)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_Select);
_dbHelper.AddInParameter(dbCommand, "@ArchiveId", System.Data.DbType.Int32, archiveId);
List <ArchiveTradeCommandSecurity> items = new List <ArchiveTradeCommandSecurity>();
var reader = _dbHelper.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
ArchiveTradeCommandSecurity item = new ArchiveTradeCommandSecurity();
item.ArchiveId = (int)reader["ArchiveId"];
item.CommandId = (int)reader["CommandId"];
item.SecuCode = (string)reader["SecuCode"];
item.SecuType = (SecurityType)(int)reader["SecuType"];
item.CommandAmount = (int)reader["CommandAmount"];
item.EDirection = (EntrustDirection)(int)reader["CommandDirection"];
item.CommandPrice = (double)(decimal)reader["CommandPrice"];
item.EntrustStatus = (EntrustStatus)(int)reader["EntrustStatus"];
items.Add(item);
}
}
reader.Close();
_dbHelper.Close(dbCommand);
return(items);
}
public int Create(ArchiveTradeCommandSecurity item)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_Create);
_dbHelper.AddInParameter(dbCommand, "@ArchiveId", System.Data.DbType.Int32, item.ArchiveId);
_dbHelper.AddInParameter(dbCommand, "@CommandId", System.Data.DbType.Int32, item.CommandId);
_dbHelper.AddInParameter(dbCommand, "@SecuCode", System.Data.DbType.String, item.SecuCode);
_dbHelper.AddInParameter(dbCommand, "@SecuType", System.Data.DbType.Int32, (int)item.SecuType);
_dbHelper.AddInParameter(dbCommand, "@CommandAmount", System.Data.DbType.Int32, item.CommandAmount);
_dbHelper.AddInParameter(dbCommand, "@CommandDirection", System.Data.DbType.Int32, (int)item.EDirection);
_dbHelper.AddInParameter(dbCommand, "@CommandPrice", System.Data.DbType.Double, item.CommandPrice);
return(_dbHelper.ExecuteNonQuery(dbCommand));
}
