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