/// <summary> /// 得到一个对象实体 /// </summary> public Danyl.SnnuURP.Model.FileInfo DataRowToModel(DataRow row) { Danyl.SnnuURP.Model.FileInfo model=new Danyl.SnnuURP.Model.FileInfo(); if (row != null) { if(row["Guid"]!=null && row["Guid"].ToString()!="") { model.Guid=int.Parse(row["Guid"].ToString()); } if(row["FileName"]!=null) { model.FileName=row["FileName"].ToString(); } if(row["FileExtension"]!=null) { model.FileExtension=row["FileExtension"].ToString(); } if(row["Uploader"]!=null && row["Uploader"].ToString()!="") { model.Uploader=int.Parse(row["Uploader"].ToString()); } if(row["DownloadCount"]!=null && row["DownloadCount"].ToString()!="") { model.DownloadCount=int.Parse(row["DownloadCount"].ToString()); } if(row["Comment"]!=null) { model.Comment=row["Comment"].ToString(); } if(row["IsAssignmentFile"]!=null && row["IsAssignmentFile"].ToString()!="") { if((row["IsAssignmentFile"].ToString()=="1")||(row["IsAssignmentFile"].ToString().ToLower()=="true")) { model.IsAssignmentFile=true; } else { model.IsAssignmentFile=false; } } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Danyl.SnnuURP.Model.FileInfo GetModel(int Guid) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 Guid,FileName,FileExtension,Uploader,DownloadCount,Comment,IsAssignmentFile from FileInfo "); strSql.Append(" where Guid=@Guid "); SqlParameter[] parameters = { new SqlParameter("@Guid", SqlDbType.Int,4) }; parameters[0].Value = Guid; Danyl.SnnuURP.Model.FileInfo model=new Danyl.SnnuURP.Model.FileInfo(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }