/// <summary> /// 得到一个对象实体 /// </summary> public VipSoft.Model.PointLog DataRowToModel(DataRow row) { VipSoft.Model.PointLog model=new VipSoft.Model.PointLog(); if (row != null) { if(row["id"]!=null && row["id"].ToString()!="") { model.id=int.Parse(row["id"].ToString()); } if(row["CardID"]!=null) { model.CardID=row["CardID"].ToString(); } if(row["MemName"]!=null) { model.MemName=row["MemName"].ToString(); } if(row["Point"]!=null && row["Point"].ToString()!="") { model.Point=int.Parse(row["Point"].ToString()); } if(row["Type"]!=null && row["Type"].ToString()!="") { model.Type=int.Parse(row["Type"].ToString()); } if(row["CreateDateTime"]!=null && row["CreateDateTime"].ToString()!="") { model.CreateDateTime=DateTime.Parse(row["CreateDateTime"].ToString()); } if(row["ShopID"]!=null && row["ShopID"].ToString()!="") { model.ShopID=int.Parse(row["ShopID"].ToString()); } if(row["ShopName"]!=null) { model.ShopName=row["ShopName"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public VipSoft.Model.PointLog GetModel(int id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 id,CardID,MemName,Point,Type,CreateDateTime,ShopID,ShopName from PointLog "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4) }; parameters[0].Value = id; VipSoft.Model.PointLog model=new VipSoft.Model.PointLog(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }