/// <summary>
/// 获取用户附件列表
/// </summary>
/// <param name="uid">用户ID</param>
/// <param name="typeid">附件类型</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">页面大小</param>
/// <returns>用户附件列表</returns>
public static List <MyAttachmentInfo> GetAttachmentByUid(int uid, int typeid, int pageIndex, int pageSize, string extNamelist)
{
List <MyAttachmentInfo> myattachment = new List <MyAttachmentInfo>();
IDataReader reader;
if (typeid == 0)
{
reader = DatabaseProvider.GetInstance().GetAttachmentByUid(uid, pageIndex, pageSize);
}
else
{
reader = DatabaseProvider.GetInstance().GetAttachmentByUid(uid, extNamelist, pageIndex, pageSize);
}
while (reader.Read())
{
MyAttachmentInfo info = new MyAttachmentInfo();
info.Uid = TypeConverter.ObjectToInt(reader["uid"]);
info.Aid = TypeConverter.ObjectToInt(reader["aid"]);
info.Postdatetime = reader["postdatetime"].ToString();
info.Filename = reader["filename"].ToString().StartsWith("http://") ? reader["filename"].ToString() : "upload/" + reader["filename"].ToString().Replace("\\", "/");
info.Description = reader["description"].ToString();
info.Attachment = reader["attachment"].ToString();
info.SimpleName = Utils.ConvertSimpleFileName(reader["attachment"].ToString(), "...", 6, 3, 15);
info.Downloads = TypeConverter.ObjectToInt(reader["downloads"]);
myattachment.Add(info);
}
reader.Close();
return(myattachment);
}
public static Discuz.Common.Generic.List <MyAttachmentInfo> GetAttachmentByUid(int uid, int typeid, int pageIndex, int pageSize)
{
Discuz.Common.Generic.List <MyAttachmentInfo> myattachment = new Discuz.Common.Generic.List <MyAttachmentInfo>();
if (pageIndex <= 0)
{
return(myattachment);
}
else
{
IDataReader reader;
if (typeid == 0)
{
reader = DatabaseProvider.GetInstance().GetAttachmentByUid(uid, pageIndex, pageSize);
}
else
{
reader = DatabaseProvider.GetInstance().GetAttachmentByUid(uid, SetExtNamelist(typeid), pageIndex, pageSize);
}
while (reader.Read())
{
MyAttachmentInfo info = new MyAttachmentInfo();
info.Uid = Int32.Parse(reader["uid"].ToString());
info.Aid = Int32.Parse(reader["aid"].ToString());
info.Postdatetime = reader["postdatetime"].ToString();
info.Filename = reader["filename"].ToString().StartsWith("http://") ? reader["filename"].ToString() : "upload/" + reader["filename"].ToString().Replace("\\", "/");
info.Description = reader["description"].ToString();
info.Attachment = reader["attachment"].ToString();
info.SimpleName = Utils.ConvertSimpleFileName(reader["attachment"].ToString(), "...", 6, 3, 15);
info.Downloads = Int32.Parse(reader["downloads"].ToString());
myattachment.Add(info);
}
reader.Close();
return(myattachment);
}
}
