public override IModel CreateModel(SqlDataReader dr) { PledgeApplyDetail pledgeapplydetail = new PledgeApplyDetail(); int indexDetailId = dr.GetOrdinal("DetailId"); pledgeapplydetail.DetailId = Convert.ToInt32(dr[indexDetailId]); int indexPledgeApplyId = dr.GetOrdinal("PledgeApplyId"); pledgeapplydetail.PledgeApplyId = Convert.ToInt32(dr[indexPledgeApplyId]); int indexStockId = dr.GetOrdinal("StockId"); if (dr["StockId"] != DBNull.Value) { pledgeapplydetail.StockId = Convert.ToInt32(dr[indexStockId]); } int indexDetailStatus = dr.GetOrdinal("DetailStatus"); if (dr["DetailStatus"] != DBNull.Value) { pledgeapplydetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexDetailStatus]); } int indexApplyQty = dr.GetOrdinal("ApplyQty"); if (dr["ApplyQty"] != DBNull.Value) { pledgeapplydetail.ApplyQty = Convert.ToDecimal(dr[indexApplyQty]); } int indexUintId = dr.GetOrdinal("UintId"); if (dr["UintId"] != DBNull.Value) { pledgeapplydetail.UintId = Convert.ToInt32(dr[indexUintId]); } int indexPledgePrice = dr.GetOrdinal("PledgePrice"); if (dr["PledgePrice"] != DBNull.Value) { pledgeapplydetail.PledgePrice = Convert.ToDecimal(dr[indexPledgePrice]); } int indexCurrencyId = dr.GetOrdinal("CurrencyId"); if (dr["CurrencyId"] != DBNull.Value) { pledgeapplydetail.CurrencyId = Convert.ToInt32(dr[indexCurrencyId]); } return pledgeapplydetail; }
public ResultModel Load(UserModel user, int pledgeApplyId, Common.StatusEnum status = StatusEnum.已生效) { ResultModel result = new ResultModel(); try { string cmdText = string.Format("select * from dbo.St_PledgeApplyDetail where PledgeApplyId={0} and DetailStatus>={1}", pledgeApplyId, (int)StatusEnum.已生效); DataTable dt = SqlHelper.ExecuteDataTable(SqlHelper.ConnectionStringNFMT, cmdText, null, CommandType.Text); List<PledgeApplyDetail> pledgeApplyDetails = new List<PledgeApplyDetail>(); foreach (DataRow dr in dt.Rows) { PledgeApplyDetail pledgeapplydetail = new PledgeApplyDetail(); pledgeapplydetail.DetailId = Convert.ToInt32(dr["DetailId"]); pledgeapplydetail.PledgeApplyId = Convert.ToInt32(dr["PledgeApplyId"]); if (dr["StockId"] != DBNull.Value) { pledgeapplydetail.StockId = Convert.ToInt32(dr["StockId"]); } if (dr["DetailStatus"] != DBNull.Value) { pledgeapplydetail.DetailStatus = (Common.StatusEnum)Enum.Parse(typeof(Common.StatusEnum), dr["DetailStatus"].ToString()); } if (dr["ApplyQty"] != DBNull.Value) { pledgeapplydetail.ApplyQty = Convert.ToDecimal(dr["ApplyQty"]); } if (dr["UintId"] != DBNull.Value) { pledgeapplydetail.UintId = Convert.ToInt32(dr["UintId"]); } //if (dr["ExclusiveId"] != DBNull.Value) //{ // pledgeapplydetail.ExclusiveId = Convert.ToInt32(dr["ExclusiveId"]); //} pledgeApplyDetails.Add(pledgeapplydetail); } result.AffectCount = dt.Rows.Count; result.Message = "获取列表成功"; result.ResultStatus = 0; result.ReturnValue = pledgeApplyDetails; } catch (Exception ex) { result.Message = ex.Message; } return result; }
public override IModel CreateModel(DataRow dr) { PledgeApplyDetail pledgeapplydetail = new PledgeApplyDetail(); pledgeapplydetail.DetailId = Convert.ToInt32(dr["DetailId"]); pledgeapplydetail.PledgeApplyId = Convert.ToInt32(dr["PledgeApplyId"]); if (dr["StockId"] != DBNull.Value) { pledgeapplydetail.StockId = Convert.ToInt32(dr["StockId"]); } if (dr["DetailStatus"] != DBNull.Value) { pledgeapplydetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr["DetailStatus"]); } if (dr["ApplyQty"] != DBNull.Value) { pledgeapplydetail.ApplyQty = Convert.ToDecimal(dr["ApplyQty"]); } if (dr["UintId"] != DBNull.Value) { pledgeapplydetail.UintId = Convert.ToInt32(dr["UintId"]); } if (dr["PledgePrice"] != DBNull.Value) { pledgeapplydetail.PledgePrice = Convert.ToDecimal(dr["PledgePrice"]); } if (dr["CurrencyId"] != DBNull.Value) { pledgeapplydetail.CurrencyId = Convert.ToInt32(dr["CurrencyId"]); } return pledgeapplydetail; }