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; }