/// <summary>
/// 查询用户帐户历史
/// </summary>
/// <param name="account"></param>
/// <param name="transactionType"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="count"></param>
/// <returns></returns>
public List <ITransaction> QueryAccountHistory(string account, int accountType, int transactionType, int pageIndex, int pageSize, out int count, DateTime?startTime, DateTime?endTime)
{
count = 0;
string condition = " 1 = 1 ";
if (startTime != null)
{
condition += " and AddTime > '" + startTime + "' ";
}
if (endTime != null)
{
condition += " and AddTime < '" + endTime + "' ";
}
List <ITransaction> list = new List <ITransaction>();
int accountId = AccountBusiness <TType> .Instance.GetAccountId(account, accountType, transactionType);
if (accountId == 0)
{
return(list);
}
DBExtend helper = dbHelper;
ParameCollection c = new ParameCollection();
c.SetQueryCondition(condition);
c.SetQueryPageIndex(pageIndex);
c.SetQueryPageSize(pageSize);
c["AccountId"] = accountId;
list = helper.QueryListByPage <ITransaction>(c, out count);
return(list);
}
/// <summary>
/// 查询指定项目的评论
/// </summary>
/// <typeparam name="TItem"></typeparam>
/// <param name="type"></param>
/// <param name="_checked"></param>
/// <param name="objId"></param>
/// <param name="userId"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="count"></param>
/// <returns></returns>
public List <TModel> QueryObjComment(int type, bool _checked, int objId, string userId, int pageIndex, int pageSize, out int count)
{
ParameCollection c = new ParameCollection();
c.SetQueryPageIndex(pageIndex);
c.SetQueryPageSize(pageSize);
string where = "type=" + type + " and objId=" + objId + " and checked=" + Convert.ToInt32(_checked);
if (!string.IsNullOrEmpty(userId))
{
where += " and userId=" + userId;
}
c.SetQueryCondition(where);
c.SetQuerySort("id desc");
return(QueryListByPage(c, out count));
}
/// <summary>
/// 查询指定项目的评论
/// </summary>
/// <typeparam name="TItem"></typeparam>
/// <param name="type"></param>
/// <param name="_checked"></param>
/// <param name="objId"></param>
/// <param name="userId"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="count"></param>
/// <returns></returns>
public static List <TItem> QueryObjComment <TItem>(int type, bool _checked, int objId, string userId, int pageIndex, int pageSize, out int count) where TItem : IComment, new()
{
DBExtend helper = dbHelper;
ParameCollection c = new ParameCollection();
c.SetQueryPageIndex(pageIndex);
c.SetQueryPageSize(pageSize);
string where = "type=" + type + " and objId=" + objId + " and checked=" + Convert.ToInt32(_checked);
if (!string.IsNullOrEmpty(userId))
{
where += " and userId=" + userId;
}
c.SetQueryCondition(where);
c.SetQuerySortField("id");
c.SetQuerySortDesc(true);
return(QueryListByPage <TItem>(c, out count));
}
