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