/// <summary>
/// 获取单个附件
/// </summary>
/// <param name="itemId">关联编号</param>
/// <param name="itemType">关联类型</param>
/// <returns>附件实体</returns>
public IList <MComAttach> GetModelList(string itemId, EyouSoft.Model.EnumType.ComStructure.AttachItemType itemType)
{
IList <MComAttach> list = new List <MComAttach>();
string sql = "SELECT ItemId,ItemType,[Name],FilePath,Size,Downloads FROM tbl_ComAttach WHERE ItemId = @ItemId AND ItemType = @ItemType";
DbCommand comm = this._db.GetSqlStringCommand(sql);
this._db.AddInParameter(comm, "@ItemId", DbType.AnsiStringFixedLength, itemId);
this._db.AddInParameter(comm, "@ItemType", DbType.Byte, (int)itemType);
using (IDataReader reader = DbHelper.ExecuteReader(comm, this._db))
{
while (reader.Read())
{
list.Add(new MComAttach()
{
ItemId = reader["ItemId"].ToString(),
ItemType = (AttachItemType)Enum.Parse(typeof(AttachItemType), reader["ItemType"].ToString()),
Name = reader.IsDBNull(reader.GetOrdinal("Name")) ? string.Empty : reader["Name"].ToString(),
FilePath = reader.IsDBNull(reader.GetOrdinal("FilePath")) ? string.Empty : reader["FilePath"].ToString(),
Size = (int)reader["Size"],
Downloads = (int)reader["Downloads"]
});
}
}
return(list);
}
/// <summary>
/// 增加附件下载次数
/// </summary>
/// <param name="itemId">关联编号</param>
/// <param name="itemType">关联类型</param>
public void AddDownloads(string itemId, EyouSoft.Model.EnumType.ComStructure.AttachItemType itemType)
{
string sql = "UPDATE tbl_ComAttach SET Downloads = Downloads + 1 WHERE ItemId = @ItemId AND ItemType = @ItemType";
DbCommand comm = this._db.GetSqlStringCommand(sql);
this._db.AddInParameter(comm, "@ItemId", DbType.AnsiStringFixedLength, itemId);
this._db.AddInParameter(comm, "@ItemType", DbType.Byte, (int)itemType);
DbHelper.ExecuteSql(comm, this._db);
}
