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