public UserQueryInfoCollection QueryUserList_AdminCPS(DateTime regFrom, DateTime regTo, string keyType, string keyValue, bool?isEnable, bool?isFillMoney, bool?isAgent , string commonBlance, string bonusBlance, string freezeBlance, string vipRange, string comeFrom, string agentId, int ocAgentCategory, int pageIndex, int pageSize, string strOrderBy) { using (var manager = new LoginLocalManager()) { int totalCount; decimal totalFillMoneyBalance; decimal totalBonusBalance; decimal totalCommissionBalance; decimal totalExpertsBalance; decimal totalFreezeBalance; decimal totalRedBagBalance; decimal totalCPSBalance; int totalDouDou; var list = manager.QueryUserList_AdminCPS(regFrom, regTo, keyType, keyValue, isEnable, isFillMoney, isAgent, commonBlance, bonusBlance, freezeBlance, vipRange, comeFrom, agentId, ocAgentCategory, pageIndex, pageSize, out totalCount, out totalFillMoneyBalance, out totalBonusBalance, out totalCommissionBalance, out totalExpertsBalance, out totalFreezeBalance, out totalRedBagBalance, out totalDouDou, out totalCPSBalance, strOrderBy); var collection = new UserQueryInfoCollection { TotalCount = totalCount, TotalFillMoneyBalance = totalFillMoneyBalance, TotalBonusBalance = totalBonusBalance, TotalCommissionBalance = totalCommissionBalance, TotalExpertsBalance = totalExpertsBalance, TotalFreezeBalance = totalFreezeBalance, TotalRedBagBalance = totalRedBagBalance, TotalDouDou = totalDouDou, TotalCPSBalance = totalCPSBalance }; collection.LoadList(list); return(collection); } }
public UserQueryInfoCollection QueryAgentLowerUserList(string agentId, int pageIndex, int pageSize) { Session.Clear(); UserQueryInfoCollection collection = new UserQueryInfoCollection(); collection.TotalCount = 0; //string strSql = "select u.UserId,u.DisplayName,isnull(r.RealName,'')RealName,isnull(m.Mobile,'')Mobile,isnull(u.RegisterIp,'')RegisterIp,u.CreateTime,isnull(u.AgentId,'')AgentId,isnull(b.CommissionBalance,0)CommissionBalance,isnull(b.BonusBalance,0)BonusBalance,isnull(b.FreezeBalance,0)FreezeBalance from C_User_Register u left join E_Authentication_RealName r on u.UserId=r.UserId left join E_Authentication_Mobile m on r.UserId=m.UserId left join C_User_Balance b on u.UserId=b.UserId where u.ParentPath like '%" + agentId + "%'"; string strSql = "select u.UserId,u.DisplayName,isnull(r.RealName,'')RealName,isnull(m.Mobile,'')Mobile,isnull(u.RegisterIp,'')RegisterIp,u.CreateTime,isnull(u.AgentId,'')AgentId,isnull(b.CommissionBalance,0)CommissionBalance,isnull(b.BonusBalance,0)BonusBalance,isnull(b.FreezeBalance,0)FreezeBalance,isnull(b.FillMoneyBalance,0)FillMoneyBalance from C_User_Register u left join E_Authentication_RealName r on u.UserId=r.UserId left join E_Authentication_Mobile m on r.UserId=m.UserId left join C_User_Balance b on u.UserId=b.UserId where u.AgentId=:agentId"; var result = Session.CreateSQLQuery(strSql).SetString("agentId", agentId).List(); if (result != null) { collection.TotalCount = result.Count; foreach (var item in result) { var array = item as object[]; UserQueryInfo info = new UserQueryInfo(); info.UserId = array[0].ToString(); info.DisplayName = array[1].ToString(); info.RealName = array[2].ToString(); info.Mobile = array[3].ToString(); info.RegisterIp = array[4].ToString(); info.RegTime = Convert.ToDateTime(array[5]); info.AgentId = array[6].ToString(); info.CommissionBalance = Convert.ToDecimal(array[7]) + Convert.ToDecimal(array[10]); info.BonusBalance = Convert.ToDecimal(array[8]); info.FreezeBalance = Convert.ToDecimal(array[9]); collection.UserList.Add(info); } } collection.UserList = collection.UserList.Skip(pageIndex * pageSize).Take(pageSize).ToList(); return(collection); }
public UserQueryInfoCollection QueryAgentUserManagerList(DateTime createFrom, DateTime createTo, string keyType, string keyValue, int pageIndex, int pageSize) { using (var manager = new AgentManager()) { int totalCount; var list = manager.QueryAgentUserManagerList(createFrom, createTo, keyType, keyValue, pageIndex, pageSize, out totalCount); var collection = new UserQueryInfoCollection { TotalCount = totalCount }; collection.LoadList(list); return(collection); } }