/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.newsinfo DataRowToModel(DataRow row) { Maticsoft.Model.newsinfo model=new Maticsoft.Model.newsinfo(); if (row != null) { if(row["newsid"]!=null && row["newsid"].ToString()!="") { model.newsid=int.Parse(row["newsid"].ToString()); } if(row["newsclassify"]!=null) { model.newsclassify=row["newsclassify"].ToString(); } if(row["newstitle"]!=null) { model.newstitle=row["newstitle"].ToString(); } if(row["newscontent"]!=null) { model.newscontent=row["newscontent"].ToString(); } if(row["newstime"]!=null && row["newstime"].ToString()!="") { model.newstime=DateTime.Parse(row["newstime"].ToString()); } if(row["newsowner"]!=null) { model.newsowner=row["newsowner"].ToString(); } if(row["newsdesc"]!=null) { model.newsdesc=row["newsdesc"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.newsinfo GetModel(int newsid) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 newsid,newsclassify,newstitle,newscontent,newstime,newsowner,newsdesc from newsinfo "); strSql.Append(" where newsid=@newsid"); SqlParameter[] parameters = { new SqlParameter("@newsid", SqlDbType.Int,4) }; parameters[0].Value = newsid; Maticsoft.Model.newsinfo model=new Maticsoft.Model.newsinfo(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }