public long InnerInfoReceivedCountNoReaded(string strNickName) { long CurrentPage = 0; long PageRows = 0; long lgPageCount = 0; DataView dv; string strReadStatus = " AND IsReaded=0"; dv = dalComm.GetListSet("InnerInfoReceivedTabList", "*", "ReceivedName='" + strNickName + "'" + strReadStatus, "ReceivedTime desc", ref CurrentPage, 0, ref lgPageCount); return(lgPageCount); }
///<summary> /// 信息留言 ///</summary> /// <param name="strNickName"></param> /// <param name="lgPageCount"></param> /// <returns></returns> public DataView dsGetAllMsgToMe(string strNickName, ref long lgPageCount) { long CurrentPage = 0; long PageRows = 0; DataView dv; dv = dalComm.GetListSet("InfoComment_list", "*", "infoowner='" + strNickName + "'", "InfoID desc", ref CurrentPage, 1, ref lgPageCount); return(dv); }
/// <summary> /// 查询列表 /// </summary> /// <param name="SelectCol">选择列</param> /// <param name="Criteria">查询条件</param> /// <param name="OrderBy">排序</param> /// <param name="CurrentPage">显示的当前页号</param> /// <param name="PageSize">页大小</param> /// <param name="PageCount">通过该查询条件,返回的查询记录的页数</param> /// <returns>查询列表</returns> public DataView GetList( string SPName, string SelectCol, string Criteria, string OrderBy, ref long CurrentPage, long PageSize, ref long PageCount) { return(dal.GetListSet( SPName, SelectCol, Criteria, OrderBy, ref CurrentPage, PageSize, ref PageCount)); }
/// <summary> /// 取已发布付费记录数,积分和,点数和 /// </summary> /// <returns>是否操作成功(true成功,false失败)</returns> public bool GetInfoPublishNoFree(string LoginName) { Tz888.Model.MemberManageInfo memberInfo = new Tz888.Model.MemberManageInfo(); bool blReturn = false; long lgCurrentPage = 1; long lgPageCount = 0; DataView dv = dal.GetListSet("ConsumeRecTabList", "COUNT(ID) AS Count,SUM(IntegralNum) AS IntegralSum, SUM(PointCount) AS Point", "LoginName='" + LoginName + "' AND IsPublishItem=1 AND InfoID IS NOT NULL", "", ref lgCurrentPage, -1, ref lgPageCount); if (dv != null && dv.Count == 1) { memberInfo.InfoAllCount = Convert.ToInt32(dv[0]["Count"]); int iTempTest = memberInfo.InfoPublishNoFreeIntegralSum; blReturn = true; } return(blReturn); }