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