public List<Attachments> GetAttachmentList(int CurrentPage)
{
string sql;
#region 分页语句
if (CurrentPage <= 1)
{
sql = string.Format
("SELECT TOP {1} * FROM {0}Attach ORDER BY Id", MainForm.cic.SrcDbTablePrefix, MainForm.PageSize);
}
else
{
sql = string.Format
("SELECT TOP {1} * FROM {0}Attach WHERE Id NOT IN (SELECT TOP {2} Id FROM {0}Attach) ORDER BY Id", MainForm.cic.SrcDbTablePrefix, MainForm.PageSize, MainForm.PageSize * (CurrentPage - 1));
}
#endregion
System.Data.Common.DbDataReader dr = MainForm.srcDBH.ExecuteReader(sql);
List<Attachments> attachmentlist = new List<Attachments>();
while (dr.Read())
{
Attachments objAttachment = new Attachments();
objAttachment.aid = Convert.ToInt32(dr["Id"]);
objAttachment.pid = Convert.ToInt32(dr["ReplyId"]);
objAttachment.tid = Convert.ToInt32(dr["TopicId"]);
objAttachment.uid = dr["UID"] == DBNull.Value ? -1 : Convert.ToInt32(dr["UID"]);
objAttachment.attachment = dr["AttachName"] == DBNull.Value ? "无标题" : dr["AttachName"].ToString();
objAttachment.filename = dr["AttachName"] == DBNull.Value ? "nothing.zip" : dr["AttachPath"].ToString();
objAttachment.description = objAttachment.attachment;
objAttachment.filesize = dr["AttachSize"] == DBNull.Value ? -1 : Convert.ToInt32(dr["AttachSize"]);
objAttachment.filetype = Utils.Attachments.GetFileType(objAttachment.filename);
objAttachment.downloads = Convert.ToInt32(dr["Downloads"]);
objAttachment.readperm = Convert.ToInt32(dr["DownloadRequire"]);
objAttachment.postdatetime = Convert.ToDateTime(dr["UploadTime"]);
attachmentlist.Add(objAttachment);
}
dr.Close();
dr.Dispose();
return attachmentlist;
}
public List<Attachments> GetAttachmentList(int CurrentPage)
{
string sql;
#region 分页语句
sql = string.Format(
"SELECT * FROM {0}uploadinfo ORDER BY Id LIMIT {1},{2}",
MainForm.cic.SrcDbTablePrefix,
MainForm.PageSize * (CurrentPage - 1),
MainForm.PageSize
);
#endregion
System.Data.Common.DbDataReader dr = MainForm.srcDBH.ExecuteReader(sql);
List<Attachments> attachmentlist = new List<Attachments>();
while (dr.Read())
{
Attachments objAttachment = new Attachments();
objAttachment.aid = Convert.ToInt32(dr["Id"]);
objAttachment.pid = Convert.ToInt32(dr["postsid"]);
objAttachment.tid = Convert.ToInt32(dr["parentid"]);
objAttachment.uid = dr["authorid"] == DBNull.Value ? -1 : Convert.ToInt32(dr["authorid"]);
objAttachment.attachment = dr["filerealname"] == DBNull.Value ? "无标题" : dr["filerealname"].ToString();
objAttachment.filename = dr["filepath"] == DBNull.Value ? "nothing.zip" : dr["filepath"].ToString();
objAttachment.description = objAttachment.attachment;
objAttachment.filesize = dr["filesize"] == DBNull.Value ? -1 : Convert.ToInt32(dr["filesize"]);
objAttachment.filetype = Utils.Attachments.GetFileType(objAttachment.filename);
//objAttachment.downloads = Convert.ToInt32(dr["Downloads"]);
//objAttachment.readperm = Convert.ToInt32(dr["DownloadRequire"]);
objAttachment.postdatetime = Convert.ToDateTime(dr["uploaddate"]);
attachmentlist.Add(objAttachment);
}
dr.Close();
dr.Dispose();
return attachmentlist;
}