public EntrustSecurityItem(EntrustSecurityCombine item)
{
this.RequestId = item.RequestId;
this.SubmitId = item.SubmitId;
this.CommandId = item.CommandId;
this.SecuCode = item.SecuCode;
this.SecuType = item.SecuType;
this.EntrustAmount = item.EntrustAmount;
this.EntrustPrice = item.EntrustPrice;
this.EDirection = item.EntrustDirection;
this.EEntrustStatus = item.EntrustStatus;
this.EPriceType = item.PriceType;
this.EntrustPriceType = item.EntrustPriceType;
this.DEntrustDate = item.EntrustDate;
this.DCreatedDate = item.CreatedDate;
this.DModifiedDate = item.ModifiedDate;
this.EntrustNo = item.EntrustNo;
this.BatchNo = item.BatchNo;
this.EntrustFailCode = item.EntrustFailCode;
this.EntrustFailCause = item.EntrustFailCause;
this.InstanceId = item.InstanceId;
this.InstanceCode = item.InstanceCode;
this.MonitorUnitId = item.MonitorUnitId;
this.PortfolioId = item.PortfolioId;
this.PortfolioCode = item.PortfolioCode;
this.PortfolioName = item.PortfolioName;
this.AccountCode = item.AccountCode;
this.AccountName = item.AccountName;
}
public List <EntrustSecurityCombine> GetCombineBySubmitId(int submitId)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_GetBySubmitId);
_dbHelper.AddInParameter(dbCommand, "@SubmitId", System.Data.DbType.Int32, submitId);
List <EntrustSecurityCombine> items = new List <EntrustSecurityCombine>();
var reader = _dbHelper.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
EntrustSecurityCombine item = ParseData(reader);
if (item.SubmitId == submitId)
{
items.Add(item);
}
}
}
reader.Close();
_dbHelper.Close(dbCommand);
return(items);
}
private EntrustSecurityCombine ParseData(DbDataReader reader)
{
EntrustSecurityCombine item = new EntrustSecurityCombine();
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)reader["EntrustDirection"];
item.EntrustStatus = (EntrustStatus)reader["EntrustStatus"];
item.EntrustPriceType = (EntrustPriceType)reader["EntrustPriceType"];
item.PriceType = (PriceType)reader["PriceType"];
item.EntrustNo = (int)reader["EntrustNo"];
item.DealStatus = (DealStatus)reader["DealStatus"];
item.TotalDealAmount = (int)reader["TotalDealAmount"];
item.TotalDealBalance = (double)(decimal)reader["TotalDealBalance"];
item.TotalDealFee = (double)(decimal)reader["TotalDealFee"];
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"];
}
item.BatchNo = (int)reader["BatchNo"];
item.InstanceId = (int)reader["InstanceId"];
item.InstanceCode = (string)reader["InstanceCode"];
item.MonitorUnitId = (int)reader["MonitorUnitId"];
item.PortfolioId = (int)reader["PortfolioId"];
item.PortfolioCode = (string)reader["PortfolioCode"];
item.PortfolioName = (string)reader["PortfolioName"];
item.AccountCode = (string)reader["AccountCode"];
item.AccountName = (string)reader["AccountName"];
return(item);
}
public EntrustSecurityCombine GetByRequestId(int requestId)
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_GetCombineByRequestId);
_dbHelper.AddInParameter(dbCommand, "@RequestId", System.Data.DbType.Int32, requestId);
var reader = _dbHelper.ExecuteReader(dbCommand);
EntrustSecurityCombine item = new EntrustSecurityCombine();
if (reader.HasRows && reader.Read())
{
item = ParseData(reader);
}
reader.Close();
_dbHelper.Close(dbCommand);
return(item);
}
public List <EntrustSecurityCombine> GetAllCombine()
{
var dbCommand = _dbHelper.GetStoredProcCommand(SP_GetAllCombine);
List <EntrustSecurityCombine> items = new List <EntrustSecurityCombine>();
var reader = _dbHelper.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
EntrustSecurityCombine item = ParseData(reader);
}
}
reader.Close();
_dbHelper.Close(dbCommand);
return(items);
}
