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; }