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