public int Create(ArchiveEntrustSecurity item)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_Create);
_dbHelper.AddInParameter(dbCommand, "@ArchiveId", System.Data.DbType.Int32, item.ArchiveId);
_dbHelper.AddInParameter(dbCommand, "@RequestId", System.Data.DbType.Int32, item.RequestId);
_dbHelper.AddInParameter(dbCommand, "@SubmitId", System.Data.DbType.Int32, item.SubmitId);
_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, "@EntrustAmount", System.Data.DbType.Int32, item.EntrustAmount);
_dbHelper.AddInParameter(dbCommand, "@EntrustPrice", System.Data.DbType.Decimal, item.EntrustPrice);
_dbHelper.AddInParameter(dbCommand, "@EntrustDirection", System.Data.DbType.Int32, (int)item.EntrustDirection);
_dbHelper.AddInParameter(dbCommand, "@EntrustStatus", System.Data.DbType.Int32, (int)item.EntrustStatus);
_dbHelper.AddInParameter(dbCommand, "@EntrustPriceType", System.Data.DbType.Int32, (int)item.EntrustPriceType);
_dbHelper.AddInParameter(dbCommand, "@PriceType", System.Data.DbType.Decimal, (int)item.PriceType);
_dbHelper.AddInParameter(dbCommand, "@EntrustNo", System.Data.DbType.Int32, item.EntrustNo);
_dbHelper.AddInParameter(dbCommand, "@BatchNo", System.Data.DbType.Int32, item.BatchNo);
_dbHelper.AddInParameter(dbCommand, "@DealStatus", System.Data.DbType.Int32, (int)item.DealStatus);
_dbHelper.AddInParameter(dbCommand, "@TotalDealAmount", System.Data.DbType.Int32, item.TotalDealAmount);
_dbHelper.AddInParameter(dbCommand, "@TotalDealBalance", System.Data.DbType.Decimal, item.TotalDealBalance);
_dbHelper.AddInParameter(dbCommand, "@TotalDealFee", System.Data.DbType.Decimal, item.TotalDealFee);
_dbHelper.AddInParameter(dbCommand, "@DealTimes", System.Data.DbType.Int32, item.DealTimes);
_dbHelper.AddInParameter(dbCommand, "@EntrustDate", System.Data.DbType.DateTime, item.EntrustDate);
_dbHelper.AddInParameter(dbCommand, "@CreatedDate", System.Data.DbType.DateTime, item.CreatedDate);
_dbHelper.AddInParameter(dbCommand, "@ModifiedDate", System.Data.DbType.DateTime, item.ModifiedDate);
_dbHelper.AddInParameter(dbCommand, "@EntrustFailCode", System.Data.DbType.Int32, item.EntrustFailCode);
_dbHelper.AddInParameter(dbCommand, "@EntrustFailCause", System.Data.DbType.String, item.EntrustFailCause);
return(_dbHelper.ExecuteNonQuery(dbCommand));
}
public int Create(ArchiveEntrustSecurity item)
{
return(_archiveentrustcommanddao.Create(item));
}
public List <ArchiveEntrustSecurity> Get(int archiveId)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_Select);
_dbHelper.AddInParameter(dbCommand, "@ArchiveId", System.Data.DbType.Int32, archiveId);
List <ArchiveEntrustSecurity> items = new List <ArchiveEntrustSecurity>();
var reader = _dbHelper.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
var item = new ArchiveEntrustSecurity();
item.ArchiveId = (int)reader["ArchiveId"];
item.RequestId = (int)reader["RequestId"];
item.SubmitId = (int)reader["SubmitId"];
item.CommandId = (int)reader["CommandId"];
item.SecuCode = (string)reader["SecuCode"];
item.SecuType = (SecurityType)(int)reader["SecuType"];
item.EntrustAmount = (int)reader["EntrustAmount"];
item.EntrustPrice = (double)(decimal)reader["EntrustPrice"];
item.EntrustDirection = (EntrustDirection)(int)reader["EntrustDirection"];
item.EntrustStatus = (EntrustStatus)(int)reader["EntrustStatus"];
item.EntrustPriceType = (EntrustPriceType)(int)reader["EntrustPriceType"];
if (reader["EntrustNo"] != null && reader["EntrustNo"] != DBNull.Value)
{
item.EntrustNo = (int)reader["EntrustNo"];
}
if (reader["BatchNo"] != null && reader["BatchNo"] != DBNull.Value)
{
item.BatchNo = (int)reader["BatchNo"];
}
if (reader["DealStatus"] != null && reader["DealStatus"] != DBNull.Value)
{
item.DealStatus = (DealStatus)(int)reader["DealStatus"];
}
item.TotalDealAmount = (int)reader["TotalDealAmount"];
item.TotalDealBalance = (double)(decimal)reader["TotalDealBalance"];
item.TotalDealFee = (double)(decimal)reader["TotalDealFee"];
item.DealTimes = (int)reader["DealTimes"];
if (reader["EntrustDate"] != null && reader["EntrustDate"] != DBNull.Value)
{
item.EntrustDate = (DateTime)reader["EntrustDate"];
}
if (reader["CreatedDate"] != null && reader["CreatedDate"] != DBNull.Value)
{
item.CreatedDate = (DateTime)reader["CreatedDate"];
}
if (reader["ModifiedDate"] != null && reader["ModifiedDate"] != DBNull.Value)
{
item.ModifiedDate = (DateTime)reader["ModifiedDate"];
}
if (reader["EntrustFailCode"] != null && reader["EntrustFailCode"] != DBNull.Value)
{
item.EntrustFailCode = (int)reader["EntrustFailCode"];
}
if (reader["EntrustFailCause"] != null && reader["EntrustFailCause"] != DBNull.Value)
{
item.EntrustFailCause = (string)reader["EntrustFailCause"];
}
items.Add(item);
}
}
reader.Close();
_dbHelper.Close(dbCommand);
return(items);
}
