/// <summary>
/// 获得数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#region 追加资金历史分页查询
/// <summary>
/// 追加资金历史分页查询
/// </summary>
/// <param name="fundAddQueryEntity"></param>
/// <param name="pageNo"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public DataSet GetPagingFund(ManagementCenter.Model.UserManage.FundAddQueryEntity fundAddQueryEntity, int pageNo, int pageSize,
out int rowCount)
{
try
{
return(dal.GetPagingFund(fundAddQueryEntity, pageNo, pageSize, out rowCount));
}
catch (Exception)
{
rowCount = 0;
return(null);
}
}
/// <summary>
/// 追加资金历史分页查询
/// </summary>
/// <param name="fundAddQueryEntity">追加资金实体</param>
/// <param name="pageNo">当前页</param>
/// <param name="pageSize">显示记录数</param>
/// <param name="rowCount">总行数</param>
/// <returns></returns>
public DataSet GetPagingFund(ManagementCenter.Model.UserManage.FundAddQueryEntity fundAddQueryEntity, int pageNo, int pageSize,
out int rowCount)
{
string SQL_SELECT_Fund =
@" select AddFundID,ManagerID,UM_FundAddInfo.UserID,USNumber,RMBNumber,UM_FundAddInfo.AddTime,
HKNumber,UM_FundAddInfo.Remark,LoginName
FROM UM_FundAddInfo,UM_UserInfo
WHERE UM_FundAddInfo.ManagerID=UM_UserInfo.UserID ";
if (fundAddQueryEntity.UserID != int.MaxValue)
{
SQL_SELECT_Fund += "AND UM_FundAddInfo.UserID=@UserID ";
}
//if (fundAddQueryEntity.ManagerID != int.MaxValue)
//{
// SQL_SELECT_Fund += "AND ManagerID=@ManagerID ";
//}
if (fundAddQueryEntity.loginName != null && !string.IsNullOrEmpty(fundAddQueryEntity.loginName))
{
SQL_SELECT_Fund += "AND LoginName LIKE '%' + @LoginName + '%' ";
}
Database database = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = database.GetSqlStringCommand(SQL_SELECT_Fund);
if (fundAddQueryEntity.UserID != int.MaxValue)
{
database.AddInParameter(dbCommand, "UserID", DbType.Int32, fundAddQueryEntity.UserID);
}
//if (fundAddQueryEntity.ManagerID != int.MaxValue)
//{
// database.AddInParameter(dbCommand, "ManagerID", DbType.Int32, fundAddQueryEntity.ManagerID);
//}
//登陆名称(根据要求把按管理员编号查询改成按管理员登陆名称查询)
if (fundAddQueryEntity.loginName != null && !string.IsNullOrEmpty(fundAddQueryEntity.loginName))
{
database.AddInParameter(dbCommand, "LoginName", DbType.String, fundAddQueryEntity.loginName);
}
return(CommPager.QueryPager(database, dbCommand, SQL_SELECT_Fund, pageNo, pageSize, out rowCount,
"UM_FundAddInfo"));
}
