public List<Pms> GetPmList(int CurrentPage)
{
string sql;
#region 分页语句
sql = string.Format(
"SELECT * FROM {0}webqq 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<Pms> pmlist = new List<Pms>();
while (dr.Read())
{
Pms objPms = new Pms();
objPms.pmid = Convert.ToInt32(dr["Id"]);
objPms.msgfromid = 1;
objPms.msgfrom = dr["fromname"].ToString();
objPms.msgtoid = 1;
objPms.msgto = dr["toname"].ToString();
objPms.subject = dr["Title"].ToString();
objPms.message = dr["message"].ToString();
objPms.newmessage = Convert.ToInt32(dr["viewed"]);
objPms.postdatetime = Convert.ToDateTime(dr["sendat"]);
if (dr["operation"] != DBNull.Value && dr["operation"].ToString().ToLower()=="send")
{
objPms.folder = 1;
}
pmlist.Add(objPms);
}
dr.Close();
dr.Dispose();
return pmlist;
}
public List<Pms> GetPmList(int CurrentPage)
{
string sql;
#region 分页语句
if (CurrentPage <= 1)
{
sql = string.Format
("SELECT TOP {1} * FROM {0}Message ORDER BY Id", MainForm.srcDbTableProfix, MainForm.PageSize);
}
else
{
sql = string.Format
("SELECT TOP {1} * FROM {0}Message WHERE Id NOT IN (SELECT TOP {2} Id FROM {0}Message) ORDER BY Id", MainForm.srcDbTableProfix, MainForm.PageSize, MainForm.PageSize * (CurrentPage - 1));
}
#endregion
System.Data.Common.DbDataReader dr = MainForm.srcDBH.ExecuteReader(sql);
List<Pms> pmlist = new List<Pms>();
while (dr.Read())
{
Pms objPms = new Pms();
objPms.pmid = Convert.ToInt32(dr["Id"]);
objPms.msgfromid = Convert.ToInt32(dr["SenderId"]);
objPms.msgfrom = dr["SenderName"].ToString();
objPms.msgtoid = Convert.ToInt32(dr["RecipientId"]);
objPms.msgto = dr["RecipientName"].ToString();
objPms.subject = dr["Title"].ToString();
objPms.message = dr["Body"].ToString();
objPms.newmessage = Convert.ToInt32(dr["Readed"]);
objPms.postdatetime = Convert.ToDateTime(dr["SendTime"]);
pmlist.Add(objPms);
}
dr.Close();
dr.Dispose();
return pmlist;
}
