public ResultModel Load(StyleEnum style) { ResultModel result = new ResultModel(); SqlDataReader dr = null; try { string sql = string.Format("select * from dbo.BDStyleDetail where BDStyleId = {0}", (int)style); dr = SqlHelper.ExecuteReader(this.ConnectString, CommandType.Text, sql, null); DetailCollection detailCollection = new DetailCollection(); while (dr.Read()) { Model.BDStyleDetail detail = new BDStyleDetail(); if (dr["StyleDetailId"] != DBNull.Value) { detail.StyleDetailId = Convert.ToInt32(dr["StyleDetailId"]); } if (dr["BDStyleId"] != DBNull.Value) { detail.BDStyleId = Convert.ToInt32(dr["BDStyleId"]); } if (dr["DetailCode"] != DBNull.Value) { detail.DetailCode = dr["DetailCode"].ToString(); } if (dr["DetailName"] != DBNull.Value) { detail.DetailName = dr["DetailName"].ToString(); } if (dr["DetailStatus"] != DBNull.Value) { detail.DetailStatus = (NFMT.Common.StatusEnum)Convert.ToInt32(dr["DetailStatus"]); } if (dr["CreatorId"] != DBNull.Value) { detail.CreatorId = Convert.ToInt32(dr["CreatorId"]); } if (dr["LastModifyId"] != DBNull.Value) { detail.LastModifyId = Convert.ToInt32(dr["LastModifyId"]); } if (dr["CreateTime"] != DBNull.Value) { detail.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } if (dr["LastModifyTime"] != DBNull.Value) { detail.LastModifyTime = Convert.ToDateTime(dr["LastModifyTime"]); } detailCollection.Add(detail); } result.AffectCount = detailCollection.Count; result.Message = "获取列表成功"; result.ResultStatus = 0; result.ReturnValue = detailCollection; } catch (Exception ex) { result.Message = ex.Message; } finally { if (dr != null) dr.Dispose(); } return result; }
public override IModel CreateModel(SqlDataReader dr) { BDStyleDetail bdstyledetail = new BDStyleDetail(); int indexStyleDetailId = dr.GetOrdinal("StyleDetailId"); bdstyledetail.StyleDetailId = Convert.ToInt32(dr[indexStyleDetailId]); int indexBDStyleId = dr.GetOrdinal("BDStyleId"); bdstyledetail.BDStyleId = Convert.ToInt32(dr[indexBDStyleId]); int indexDetailCode = dr.GetOrdinal("DetailCode"); bdstyledetail.DetailCode = Convert.ToString(dr[indexDetailCode]); int indexDetailName = dr.GetOrdinal("DetailName"); bdstyledetail.DetailName = Convert.ToString(dr[indexDetailName]); int indexDetailStatus = dr.GetOrdinal("DetailStatus"); bdstyledetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexDetailStatus]); int indexCreatorId = dr.GetOrdinal("CreatorId"); bdstyledetail.CreatorId = Convert.ToInt32(dr[indexCreatorId]); int indexCreateTime = dr.GetOrdinal("CreateTime"); bdstyledetail.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { bdstyledetail.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { bdstyledetail.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return bdstyledetail; }