/// <summary>
/// 得到一个对象实体
/// </summary>
public FileContentModel GetSimpleModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [" + databaseprefix + "DetailContent] ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
FileContentModel model = new FileContentModel();
DataSet ds = DbHelperFileContentSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model = ChangeSimpleRowToFile(ds.Tables[0].Rows[0]);
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 获取文件内容
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public byte[] GetContent(string id)
{
id = "'" + id + "'";
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 File_Content from [" + databaseprefix + "DetailContent] ");
strSql.Append(" where id=" + id);
DataSet ds = DbHelperFileContentSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return((byte[])ds.Tables[0].Rows[0]["File_Content"]);
}
else
{
return(null);
}
}
