public override IModel CreateModel(SqlDataReader dr) { RecAllotDetail recallotdetail = new RecAllotDetail(); int indexDetailId = dr.GetOrdinal("DetailId"); recallotdetail.DetailId = Convert.ToInt32(dr[indexDetailId]); int indexRecId = dr.GetOrdinal("RecId"); if (dr["RecId"] != DBNull.Value) { recallotdetail.RecId = Convert.ToInt32(dr[indexRecId]); } int indexAllotId = dr.GetOrdinal("AllotId"); if (dr["AllotId"] != DBNull.Value) { recallotdetail.AllotId = Convert.ToInt32(dr[indexAllotId]); } int indexAllotBala = dr.GetOrdinal("AllotBala"); if (dr["AllotBala"] != DBNull.Value) { recallotdetail.AllotBala = Convert.ToDecimal(dr[indexAllotBala]); } int indexDetailStatus = dr.GetOrdinal("DetailStatus"); if (dr["DetailStatus"] != DBNull.Value) { recallotdetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexDetailStatus]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) { recallotdetail.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) { recallotdetail.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { recallotdetail.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { recallotdetail.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return recallotdetail; }
public ResultModel Load(UserModel user,int allotId,NFMT.Common.StatusEnum status = StatusEnum.已生效) { ResultModel result = new ResultModel(); try { string cmdText = string.Format("select * from dbo.Fun_RecAllotDetail where AllotId = {0} and DetailStatus >={1}",allotId,(int)status); DataTable dt = SqlHelper.ExecuteDataTable(ConnectString, cmdText, null, CommandType.Text); List<RecAllotDetail> recAllotDetails = new List<RecAllotDetail>(); foreach (DataRow dr in dt.Rows) { RecAllotDetail recallotdetail = new RecAllotDetail(); recallotdetail.DetailId = Convert.ToInt32(dr["DetailId"]); if (dr["RecId"] != DBNull.Value) { recallotdetail.RecId = Convert.ToInt32(dr["RecId"]); } if (dr["AllotId"] != DBNull.Value) { recallotdetail.AllotId = Convert.ToInt32(dr["AllotId"]); } if (dr["AllotBala"] != DBNull.Value) { recallotdetail.AllotBala = Convert.ToDecimal(dr["AllotBala"]); } if (dr["DetailStatus"] != DBNull.Value) { recallotdetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr["DetailStatus"]); } if (dr["CreatorId"] != DBNull.Value) { recallotdetail.CreatorId = Convert.ToInt32(dr["CreatorId"]); } if (dr["CreateTime"] != DBNull.Value) { recallotdetail.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } if (dr["LastModifyId"] != DBNull.Value) { recallotdetail.LastModifyId = Convert.ToInt32(dr["LastModifyId"]); } if (dr["LastModifyTime"] != DBNull.Value) { recallotdetail.LastModifyTime = Convert.ToDateTime(dr["LastModifyTime"]); } recAllotDetails.Add(recallotdetail); } result.AffectCount = dt.Rows.Count; result.Message = "获取列表成功"; result.ResultStatus = 0; result.ReturnValue = recAllotDetails; } catch (Exception ex) { result.Message = ex.Message; } return result; }