public ResultModel GetModelByApplyId(UserModel user, int applyId)
{
ResultModel result = new ResultModel();
SqlDataReader dr = null;
try
{
string sql = string.Format("select * from dbo.Pri_StopLossApply where ApplyId = {0}", applyId);
dr = SqlHelper.ExecuteReader(ConnectString, CommandType.Text, sql, null);
Model.StopLossApply model = new StopLossApply();
if (dr.Read())
{
model = CreateModel(dr) as StopLossApply;
result.AffectCount = 1;
result.Message = "读取成功";
result.ResultStatus = 0;
result.ReturnValue = model;
}
else
{
result.Message = "读取失败或无数据";
result.AffectCount = 0;
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
finally
{
if (dr != null)
dr.Dispose();
}
return result;
}
public override IModel CreateModel(SqlDataReader dr)
{
StopLossApply stoplossapply = new StopLossApply();
int indexStopLossApplyId = dr.GetOrdinal("StopLossApplyId");
stoplossapply.StopLossApplyId = Convert.ToInt32(dr[indexStopLossApplyId]);
int indexApplyId = dr.GetOrdinal("ApplyId");
if (dr["ApplyId"] != DBNull.Value)
{
stoplossapply.ApplyId = Convert.ToInt32(dr[indexApplyId]);
}
int indexPricingId = dr.GetOrdinal("PricingId");
if (dr["PricingId"] != DBNull.Value)
{
stoplossapply.PricingId = Convert.ToInt32(dr[indexPricingId]);
}
int indexPricingDirection = dr.GetOrdinal("PricingDirection");
if (dr["PricingDirection"] != DBNull.Value)
{
stoplossapply.PricingDirection = Convert.ToInt32(dr[indexPricingDirection]);
}
int indexSubContractId = dr.GetOrdinal("SubContractId");
if (dr["SubContractId"] != DBNull.Value)
{
stoplossapply.SubContractId = Convert.ToInt32(dr[indexSubContractId]);
}
int indexContractId = dr.GetOrdinal("ContractId");
if (dr["ContractId"] != DBNull.Value)
{
stoplossapply.ContractId = Convert.ToInt32(dr[indexContractId]);
}
int indexAssertId = dr.GetOrdinal("AssertId");
if (dr["AssertId"] != DBNull.Value)
{
stoplossapply.AssertId = Convert.ToInt32(dr[indexAssertId]);
}
int indexStopLossPrice = dr.GetOrdinal("StopLossPrice");
if (dr["StopLossPrice"] != DBNull.Value)
{
stoplossapply.StopLossPrice = Convert.ToDecimal(dr[indexStopLossPrice]);
}
int indexCurrencyId = dr.GetOrdinal("CurrencyId");
if (dr["CurrencyId"] != DBNull.Value)
{
stoplossapply.CurrencyId = Convert.ToInt32(dr[indexCurrencyId]);
}
int indexStopLossWeight = dr.GetOrdinal("StopLossWeight");
if (dr["StopLossWeight"] != DBNull.Value)
{
stoplossapply.StopLossWeight = Convert.ToDecimal(dr[indexStopLossWeight]);
}
int indexMUId = dr.GetOrdinal("MUId");
if (dr["MUId"] != DBNull.Value)
{
stoplossapply.MUId = Convert.ToInt32(dr[indexMUId]);
}
return stoplossapply;
}
