public DbQueryResult GetMembersAddress(MemberQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" 1=1 "); //IsDefault= 1 为默认地址 if (query.IsDefault == 1) { stringBuilder.AppendFormat(" AND IsDefault = {0}", query.IsDefault); } if (!string.IsNullOrEmpty(query.Username)) { stringBuilder.AppendFormat(" AND UserName LIKE '%{0}%'", DataHelper.CleanSearchString(query.Username)); } if (!string.IsNullOrEmpty(query.Realname)) { stringBuilder.AppendFormat(" AND Realname LIKE '%{0}%'", DataHelper.CleanSearchString(query.Realname)); } if (!string.IsNullOrEmpty(query.CellPhone)) { stringBuilder.AppendFormat(" AND CellPhone LIKE '%{0}%'", DataHelper.CleanSearchString(query.CellPhone)); } string selectFields = "RegionId,ShippingId,UserId,ShipTo,[Address],Zipcode,TelPhone,CellPhone,IdentityCard,Realname,UserName,IsDefault,Email"; return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Ecshop_MembersAddress", "UserId", stringBuilder.ToString(), selectFields)); }
// GET: Member/Delete/5 public ActionResult Delete(int id) { Member member = MemberManager.Find(x => x.Id == id); MemberQuery model = Mapper.Map <MemberQuery>(member); return(View(model)); }
public void ExportToExcel(HttpContext context) { MemberQuery dataQuery = this.GetDataQuery(context); string safeIDList = Globals.GetSafeIDList(base.GetParameter(context, "Ids", false), ',', true); IList <PointMemberModel> pointMembersNoPage = MemberHelper.GetPointMembersNoPage(dataQuery, safeIDList); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("<table border='1'>"); stringBuilder.Append("<thead><tr>"); stringBuilder.Append("<th>会员名</th>"); stringBuilder.Append("<th>用户积分</th>"); stringBuilder.Append("<th>历史积分</th>"); stringBuilder.Append("<th>会员等级</th>"); stringBuilder.Append("</tr></thead>"); StringBuilder stringBuilder2 = new StringBuilder(); foreach (PointMemberModel item in pointMembersNoPage) { stringBuilder2.Append("<tr>"); stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.UserName, true)); stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.Points, false)); stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.HistoryPoint, false)); stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.GradeName, true)); stringBuilder2.Append("</tr>"); } stringBuilder.AppendFormat("<tbody>{0}</tbody></table>", stringBuilder2.ToString()); StringWriter stringWriter = new StringWriter(); stringWriter.Write(stringBuilder); DownloadHelper.DownloadFile(context.Response, stringWriter.GetStringBuilder(), "MemberPointList" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls"); stringWriter.Close(); context.Response.End(); }
public BindingOperation Make(Tree <Cell> nameCell) { var name = nameCell.Value.Text.Trim(); if (NoOperationIsImpliedBy(name)) { return(new NoBinding()); } if (CheckIsImpliedBy(name)) { return(new CheckBinding(processor, targetProvider, nameCell)); } var memberName = processor.ParseTree <Cell, MemberName>(nameCell); var member = MemberQuery.FindInstance(processor.FindMember, targetProvider, new MemberSpecification(memberName, 1)); if (member == null && newIdentifier.IsStartOf(name)) { string newMemberName = name.Substring(4); return(new CreateBinding(processor, adapter, newMemberName)); } return(new InputBinding(processor, targetProvider, nameCell)); }
protected MemberQuery SetClient(MemberQuery query) { if (!string.IsNullOrEmpty(base.Request.QueryString["type"])) { System.Collections.Generic.Dictionary <int, MemberClientSet> memberClientSet = MemberHelper.GetMemberClientSet(); int[] array = new int[memberClientSet.Count]; memberClientSet.Keys.CopyTo(array, 0); if (memberClientSet.Count > 0) { MemberClientSet memberClientSet2 = new MemberClientSet(); string text = base.Request.QueryString["type"]; query.ClientType = text; string a; if ((a = text) != null) { if (!(a == "new")) { if (a == "activy") { memberClientSet2 = memberClientSet[array[1]]; this.litType.Text = "活跃客户"; if (!(memberClientSet2.ClientValue > 0m)) { return(query); } query.StartTime = new System.DateTime?(System.DateTime.Now.AddDays((double)(-(double)memberClientSet2.LastDay))); query.EndTime = new System.DateTime?(System.DateTime.Now); query.CharSymbol = memberClientSet2.ClientChar; if (memberClientSet2.ClientTypeId == 6) { query.OrderNumber = new int?((int)memberClientSet2.ClientValue); return(query); } query.OrderMoney = new decimal?(memberClientSet2.ClientValue); return(query); } } else { memberClientSet2 = memberClientSet[array[0]]; this.litType.Text = "新客户"; query.StartTime = memberClientSet2.StartTime; query.EndTime = memberClientSet2.EndTime; if (memberClientSet2.LastDay > 0) { query.StartTime = new System.DateTime?(System.DateTime.Now.AddDays((double)(-(double)memberClientSet2.LastDay))); query.EndTime = new System.DateTime?(System.DateTime.Now); return(query); } return(query); } } memberClientSet2 = memberClientSet[array[2]]; this.litType.Text = "睡眠客户"; query.StartTime = new System.DateTime?(System.DateTime.Now.AddDays((double)(-(double)memberClientSet2.LastDay))); query.EndTime = new System.DateTime?(System.DateTime.Now); } } return(query); }
public JsonResult List(int page, int rows, string CompanyName, bool?status = null) { MemberQuery memberQuery = new MemberQuery() { UserType = 3, keyWords = CompanyName, PageNo = page, PageSize = rows }; PageModel <UserMemberInfo> members = ServiceHelper.Create <IMemberService>().GetMembers(memberQuery); IEnumerable <UserMemberInfo> models = from item in members.Models.ToArray() select new UserMemberInfo() { Id = item.Id, UserName = item.UserName, CreateDate = item.CreateDate, Email = item.Email, CompanyName = ServiceHelper.Create <IMemberDetailService>().GetMemberDetailByUid(item.Id) == null ? "" : ServiceHelper.Create <IMemberDetailService>().GetMemberDetailByUid(item.Id).CompanyName }; DataGridModel <UserMemberInfo> dataGridModel = new DataGridModel <UserMemberInfo>() { rows = models, total = members.Total }; return(Json(dataGridModel)); }
protected void BindData() { MemberQuery query = new MemberQuery { Username = this.searchKey, UserBindName = this.realName, GradeId = this.rankId, PageIndex = this.pager.PageIndex, IsApproved = this.approved, SortBy = this.grdMemberList.SortOrderBy, PageSize = this.pager.PageSize, Stutas = new UserStatus?((UserStatus)System.Enum.Parse(typeof(UserStatus), this.mstatus)), EndTime = new DateTime?(DateTime.Now), StartTime = new DateTime?(DateTime.Now.AddDays((double)-this.GetSiteSetting().ActiveDay)), CellPhone = (base.Request.QueryString["phone"] != null) ? base.Request.QueryString["phone"] : "", ClientType = (base.Request.QueryString["clientType"] != null) ? base.Request.QueryString["clientType"] : "", StoreName = this.storeName }; if (this.grdMemberList.SortOrder.ToLower() == "desc") { query.SortOrder = SortAction.Desc; } if (this.vipCard.HasValue && (this.vipCard.Value != 0)) { query.HasVipCard = new bool?(this.vipCard.Value == 1); } DbQueryResult members = MemberHelper.GetMembers(query, false); this.grdMemberList.DataSource = members.Data; this.grdMemberList.DataBind(); this.pager1.TotalRecords = this.pager.TotalRecords = members.TotalRecords; }
/// <summary> /// 根据查询条件分页获取会员信息 /// </summary> /// <param name="query"></param> /// <returns></returns> public static QueryPageModel <DTO.Members> GetMemberList(MemberQuery query) { if (query.GradeId.HasValue) { var expenditureRange = MemberApplication.GetMemberGradeRange(query.GradeId.Value); query.MinIntegral = expenditureRange.MinIntegral; query.MaxIntegral = expenditureRange.MaxIntegral; } var list = _iMemberService.GetMembers(query); var members = Mapper.Map <QueryPageModel <DTO.Members> >(list); var grades = MemberGradeApplication.GetMemberGradeList(); foreach (var m in members.Models) { var memberIntegral = MemberIntegralApplication.GetMemberIntegral(m.Id); //获取等级 m.GradeName = MemberGradeApplication.GetMemberGradeByIntegral(grades, memberIntegral.HistoryIntegrals).GradeName; if (memberIntegral != null) { m.AvailableIntegral = memberIntegral.AvailableIntegrals; m.HistoryIntegral = memberIntegral.HistoryIntegrals; } } return(members); }
private MemberQuery GetMemberQuery() { MemberQuery memberQuery = new MemberQuery(); if (!string.IsNullOrEmpty(this.Page.Request.QueryString["GradeId"])) { int value = 0; if (int.TryParse(this.Page.Request.QueryString["GradeId"], out value)) { memberQuery.GradeId = new int?(value); } } if (!string.IsNullOrEmpty(this.Page.Request.QueryString["Username"])) { memberQuery.Username = base.Server.UrlDecode(this.Page.Request.QueryString["Username"]); } if (!string.IsNullOrEmpty(this.Page.Request.QueryString["Realname"])) { memberQuery.Realname = base.Server.UrlDecode(this.Page.Request.QueryString["Realname"]); } if (!string.IsNullOrEmpty(this.Page.Request.QueryString["Approved"])) { memberQuery.IsApproved = new bool?(System.Convert.ToBoolean(this.Page.Request.QueryString["Approved"])); } memberQuery.PageSize = this.pager.PageSize; memberQuery.PageIndex = this.pager.PageIndex; return(memberQuery); }
public TypedValue FindMember(TypedValue instance, MemberQuery query) { var member = query.FindMatchingMember(instance.Type, new PatternMemberMatcher(Processor, instance.Value, query.Specification)) .OrMaybe(() => query.FindMember(instance.Value)); return(member.TypedValue); }
public override DataTable GetMembersNopage(MemberQuery query, IList <string> fields) { if (fields.Count == 0) { return(null); } DataTable table = null; string str = string.Empty; foreach (string str2 in fields) { str = str + str2 + ","; } str = str.Substring(0, str.Length - 1); StringBuilder builder = new StringBuilder(); builder.AppendFormat("SELECT {0} FROM vw_aspnet_Members WHERE 1=1 ", str); if (!string.IsNullOrEmpty(query.Username)) { builder.AppendFormat(" AND UserName LIKE '%{0}%'", query.Username); } if (query.GradeId.HasValue) { builder.AppendFormat(" AND GradeId={0}", query.GradeId); } DbCommand sqlStringCommand = database.GetSqlStringCommand(builder.ToString()); using (IDataReader reader = database.ExecuteReader(sqlStringCommand)) { table = DataHelper.ConverDataReaderToDataTable(reader); reader.Close(); } return(table); }
private void BindData(string title) { MemberQuery query = new MemberQuery { Username = title, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, Stutas = (UserStatus)1, EndTime = new DateTime?(DateTime.Now), StartTime = new DateTime?(DateTime.Now.AddDays((double)-SettingsManager.GetMasterSettings(false).ActiveDay)), CellPhone = (base.Request.QueryString["phone"] != null) ? base.Request.QueryString["phone"] : "", ClientType = (base.Request.QueryString["clientType"] != null) ? base.Request.QueryString["clientType"] : "" }; DbQueryResult members = MemberHelper.GetMembers(query, false); int totalRecords = members.TotalRecords; if (totalRecords > 0) { this.rptList.DataSource = members.Data; this.rptList.DataBind(); this.pager.TotalRecords = this.pager.TotalRecords = totalRecords; if (this.pager.TotalRecords <= this.pager.PageSize) { this.pager.Visible = false; } } else { this.divEmpty.Visible = true; } }
private MemberQuery getQuery(HttpContext context) { int num = 1; int num2 = 10; num = base.GetIntParam(context, "page", false).Value; if (num < 1) { num = 1; } num2 = base.GetIntParam(context, "rows", false).Value; if (num2 < 1) { num2 = 10; } MemberQuery memberQuery = new MemberQuery(); memberQuery.UserName = context.Request["StoreName"]; memberQuery.UserName = memberQuery.UserName.Trim(); memberQuery.StoreId = base.GetIntParam(context, "storeId", false).Value; memberQuery.ShoppingGuiderId = base.GetIntParam(context, "ManagerId", false).Value; memberQuery.StartTime = base.GetDateTimeParam(context, "startDate"); memberQuery.EndTime = base.GetDateTimeParam(context, "endDate"); memberQuery.SortOrder = SortAction.Desc; memberQuery.PageIndex = num; memberQuery.PageSize = num2; return(memberQuery); }
public override DbQueryResult GetMembers(MemberQuery query) { StringBuilder builder = new StringBuilder(); if (query.GradeId.HasValue) { builder.AppendFormat("GradeId = {0}", query.GradeId.Value); } if (query.IsApproved.HasValue) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("IsApproved = '{0}'", query.IsApproved.Value); } if (!string.IsNullOrEmpty(query.Username)) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat("UserName LIKE '%{0}%'", DataHelper.CleanSearchString(query.Username)); } if (!string.IsNullOrEmpty(query.Realname)) { if (builder.Length > 0) { builder.AppendFormat("AND", new object[0]); } builder.AppendFormat("RealName LIKE '%{0}%'", DataHelper.CleanSearchString(query.Realname)); } return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_aspnet_Members", "UserId", (builder.Length > 0) ? builder.ToString() : null, "*")); }
private MemberQuery GetMemberQuery() { MemberQuery query = new MemberQuery(); if (!string.IsNullOrEmpty(Page.Request.QueryString["GradeId"])) { int result = 0; if (int.TryParse(Page.Request.QueryString["GradeId"], out result)) { query.GradeId = new int?(result); } } if (!string.IsNullOrEmpty(Page.Request.QueryString["Username"])) { query.Username = base.Server.UrlDecode(Page.Request.QueryString["Username"]); } if (!string.IsNullOrEmpty(Page.Request.QueryString["Realname"])) { query.Realname = base.Server.UrlDecode(Page.Request.QueryString["Realname"]); } if (!string.IsNullOrEmpty(Page.Request.QueryString["Approved"])) { query.IsApproved = new bool?(Convert.ToBoolean(Page.Request.QueryString["Approved"])); } query.PageSize = pager.PageSize; query.PageIndex = pager.PageIndex; return(query); }
/*账户查询*/ public JsonResult AccountList(int page, int rows, int disabled, string username) { MemberQuery memberQuery = new MemberQuery() { Disabled = disabled, UserType = 0, keyWords = username, PageNo = page, PageSize = rows }; PageModel <UserMemberInfo> members = ServiceHelper.Create <IMemberService>().GetMembers(memberQuery); IEnumerable <UserMemberInfo> models = from item in members.Models.ToArray() select new UserMemberInfo() { Id = item.Id, UserName = item.UserName, CreateDate = item.CreateDate, Email = item.Email, Disabled = item.Disabled }; DataGridModel <UserMemberInfo> dataGridModel = new DataGridModel <UserMemberInfo>() { rows = models, total = members.Total }; return(Json(dataGridModel)); }
/// <summary> /// 导出会员数据 /// </summary> /// <param name="keywords">会员名</param> /// <param name="weChatNick">微信昵称</param> /// <param name="mobile">手机号码</param> /// <param name="gradeId">会员等级</param> /// <param name="status">会员状态</param> /// <param name="platform">会员来源</param> /// <param name="labels">会员标签</param> /// <param name="registTimeStart">注册时间开始时间</param> /// <param name="registTimeEnd">注册时间结束时间</param> /// <param name="isFocusWeiXin">是否关注微信</param> /// <param name="isSeller">是否为入驻商家</param> /// <param name="logintimeStart">登录时间开始</param> /// <param name="logintimeEnd">登录时间结束</param> /// <returns></returns> public ActionResult ExportToExcel(string keywords = "", string weChatNick = null, string mobile = null, long?gradeId = null, bool?status = null, int?platform = null, long?labels = null, string registTimeStart = null, string registTimeEnd = null, bool?isFocusWeiXin = null, bool?isSeller = null, string logintimeStart = null, string logintimeEnd = null) { #region 获取查询结果 DateTime?rtstart = null; DateTime?rtend = null; DateTime?ltstart = null; DateTime?ltend = null; if (!string.IsNullOrWhiteSpace(registTimeStart)) { rtstart = DateTime.Parse(registTimeStart); } if (!string.IsNullOrWhiteSpace(registTimeEnd)) { rtend = DateTime.Parse(registTimeEnd); } if (!string.IsNullOrWhiteSpace(logintimeStart)) { ltstart = DateTime.Parse(logintimeStart); } if (!string.IsNullOrWhiteSpace(logintimeEnd)) { ltend = DateTime.Parse(logintimeEnd); } var query = new MemberQuery() { PageNo = 1, PageSize = int.MaxValue, keyWords = keywords, weChatNick = weChatNick, Mobile = mobile, GradeId = gradeId, Status = status, Platform = platform, Labels = labels.HasValue ? new long[] { labels.Value } : null, RegistTimeStart = rtstart, RegistTimeEnd = rtend, IsFocusWeiXin = isFocusWeiXin, IsSeller = isSeller, LoginTimeStart = ltstart, LoginTimeEnd = ltend, }; if (gradeId.HasValue) { var expenditureRange = MemberApplication.GetMemberGradeRange(gradeId.Value); query.MinIntegral = expenditureRange.MinIntegral; query.MaxIntegral = expenditureRange.MaxIntegral; } var result = MemberApplication.GetMemberList(query); #endregion return(ExcelView("ExportMemberinfo", "会员信息", result.Models.ToList())); #region 构建Excel文档 // ViewData.Model = result.Models; // string viewHtml = RenderPartialViewToString(this, "ExportMemberinfo"); // return File(System.Text.Encoding.UTF8.GetBytes(viewHtml), "application/ms-excel", string.Format("会员信息_{0}.xls", DateTime.Now.ToString("yyyy-MM-dd"))); #endregion }
public JsonResult List(int page, string keywords, int rows, bool?status = null) { IMemberService memberService = ServiceHelper.Create <IMemberService>(); MemberQuery memberQuery = new MemberQuery() { keyWords = keywords, Status = status, PageNo = page, PageSize = rows }; PageModel <UserMemberInfo> members = memberService.GetMembers(memberQuery); IQueryable <MemberModel> models = from item in members.Models select new MemberModel() { Id = item.Id, UserName = item.UserName, LastLoginDate = item.LastLoginDate, CreateDate = item.CreateDate, QQ = item.QQ, Points = item.Points, RealName = item.RealName, Email = item.Email, CellPhone = item.CellPhone, Disabled = item.Disabled }; DataGridModel <MemberModel> dataGridModel = new DataGridModel <MemberModel>() { rows = models, total = members.Total }; return(Json(dataGridModel)); }
private static void GoToDefinition(PackageDatabase db, MemberQuery[] searches, int iterations = 1) { PartialArray <Symbol> lastSuccessfulResults = new PartialArray <Symbol>(); PartialArray <Symbol> results = new PartialArray <Symbol>(10); using (new TraceWatch("Go To Definition {0:n0} times across {1:n0} values...", iterations, searches.Length)) { for (int iteration = 0; iteration < iterations; ++iteration) { MemberQuery query = searches[iteration % searches.Length]; query.TryFindMembers(db, ref results); if (results.Count > 0) { results.CopyTo(ref lastSuccessfulResults); } } } if (lastSuccessfulResults.Count > 0) { lastSuccessfulResults[0].WriteLocation(Console.Out); Console.WriteLine(); } else { Console.WriteLine("NOT FOUND."); } Console.WriteLine(); }
protected void BindData() { MemberQuery query = new MemberQuery { Username = this.searchKey, Realname = this.realName, GradeId = this.rankId, PageIndex = this.pager.PageIndex, IsApproved = this.approved, SortBy = this.grdMemberList.SortOrderBy, PageSize = this.pager.PageSize }; if (this.grdMemberList.SortOrder.ToLower() == "desc") { query.SortOrder = SortAction.Desc; } if (this.vipCard.HasValue && this.vipCard.Value != 0) { query.HasVipCard = new bool?(this.vipCard.Value == 1); } DbQueryResult members = MemberHelper.GetMembers(query); this.grdMemberList.DataSource = members.Data; this.grdMemberList.DataBind(); this.pager1.TotalRecords = (this.pager.TotalRecords = members.TotalRecords); }
public async Task MemberClient_GetPoints_ToUserThatExists_ReturnsSamePoints() { // arrange var amount = Rng.Next(); var channel = GetChannel(); var client = new Member.MemberClient(channel); const string guildId = "1"; const string userId = "1"; var getQuery = new MemberQuery { GuildId = guildId, UserId = userId }; var addQuery = new MemberQueryWithPoints { GuildId = guildId, UserId = userId, Amount = amount }; // act var addResult = await client.AddPointsAsync(addQuery); var getResult = await client.GetPointsAsync(getQuery); // assert Assert.AreEqual(Status.Success, addResult.Status, "AddPointsAsync() failed."); Assert.AreEqual(amount, addResult.Experience); Assert.AreEqual(Status.Success, getResult.Status, "GetPointsAsync() failed."); Assert.AreEqual(amount, getResult.Experience); }
public async Task MemberClient_ResetPoints_ToUserThatDoesNotExist_ReturnsZero() { // arrange var channel = GetChannel(); var client = new Member.MemberClient(channel); const string guildId = "1"; const string userId = "1"; var getQuery = new MemberQuery { GuildId = guildId, UserId = userId }; var resetQuery = new MemberQuery { GuildId = guildId, UserId = userId }; // act var resetResult = await client.ResetPointsAsync(resetQuery); var getResult = await client.GetPointsAsync(getQuery); // assert Assert.AreEqual(Status.Success, resetResult.Status, "ResetPointsAsync() failed."); Assert.AreEqual(Status.Success, getResult.Status, "GetPointsAsync() failed."); Assert.AreEqual(0, getResult.Experience); }
private void BindData() { MemberQuery query = new MemberQuery { PageIndex = this.pager.PageIndex, SortBy = this.grdMemberList.SortOrderBy, PageSize = this.pager.PageSize, Stutas = (UserStatus)1, EndTime = new DateTime?(DateTime.Now), Username = this.txtUserName.Text.Trim(), CellPhone = this.txtPhone.Text.Trim() }; if (this.grdMemberList.SortOrder.ToLower() == "desc") { query.SortOrder = SortAction.Desc; } DbQueryResult members = MemberHelper.GetMembers(query, true); this.grdMemberList.DataSource = members.Data; this.grdMemberList.DataBind(); if (members.TotalRecords == 0) { base.Response.Redirect("WXConfigBindOK.aspx"); base.Response.End(); } this.pager1.TotalRecords = this.pager.TotalRecords = members.TotalRecords; this.BindOpenIDAndNoUserNameCount = this.pager1.TotalRecords; this.ViewState["BindOpenIDAndNoUserNameCount"] = this.BindOpenIDAndNoUserNameCount; }
static RuntimeMember GetMethodFromProcessor(object targetInstance, string memberName, int parameterCount) { var processor = Builder.CellProcessor(); return(MemberQuery.FindInstance(processor.FindMember, targetInstance, new MemberSpecification(new MemberName(memberName), parameterCount))); }
public JsonResult SetResultMembersLabel(MemberQuery query, string labels) { var lids = labels.Split(',').Select(s => long.Parse(s)); // MemberApplication.SetResultMembersLabel(query, lids); return(Json(new { Success = true })); }
protected void BindData() { MemberQuery memberQuery = new MemberQuery(); memberQuery.Username = this.searchKey; memberQuery.Realname = this.realName; memberQuery.GradeId = this.rankId; memberQuery.PageIndex = this.pager.PageIndex; memberQuery.IsApproved = this.approved; memberQuery.SortBy = this.grdMemberList.SortOrderBy; memberQuery.PageSize = this.pager.PageSize; memberQuery.Stutas = new UserStatus?(UserStatus.Normal); memberQuery.EndTime = new System.DateTime?(System.DateTime.Now); memberQuery.StartTime = new System.DateTime?(System.DateTime.Now.AddDays((double)(-(double)this.GetSiteSetting().ActiveDay))); memberQuery.CellPhone = ((base.Request.QueryString["phone"] != null) ? base.Request.QueryString["phone"] : ""); memberQuery.ClientType = ((base.Request.QueryString["clientType"] != null) ? base.Request.QueryString["clientType"] : ""); if (this.grdMemberList.SortOrder.ToLower() == "desc") { memberQuery.SortOrder = SortAction.Desc; } if (this.vipCard.HasValue && this.vipCard.Value != 0) { memberQuery.HasVipCard = new bool?(this.vipCard.Value == 1); } DbQueryResult members = MemberHelper.GetMembers(memberQuery, false); this.grdMemberList.DataSource = members.Data; this.grdMemberList.DataBind(); this.pager1.TotalRecords = (this.pager.TotalRecords = members.TotalRecords); }
public PageModel <UserMemberInfo> GetMembers(MemberQuery query) { int num = 0; IQueryable <UserMemberInfo> disabled = context.UserMemberInfo.AsQueryable <UserMemberInfo>(); if (!string.IsNullOrWhiteSpace(query.keyWords)) { disabled = from d in disabled where d.UserName.Equals(query.keyWords) select d; } if (query.Status.HasValue) { disabled = from d in disabled where d.Disabled select d; } disabled = disabled.GetPage(out num, query.PageNo, query.PageSize, (IQueryable <UserMemberInfo> d) => from o in d orderby o.LastLoginDate descending, o.CreateDate descending select o); return(new PageModel <UserMemberInfo>() { Models = disabled, Total = num }); }
public override async Task <Result> ResetPoints(MemberQuery request, ServerCallContext context) { var result = await _database.ResetMemberPointsAsync(request.GuildId, request.UserId); return(new Result { Status = result.Success ? Status.Success : Status.Failed }); }
internal static string SearchToString(IMemberDatabase db, string memberName) { MemberQuery query = new MemberQuery(memberName, false, false); PartialArray <Symbol> results = new PartialArray <Symbol>(10); query.TryFindMembers(db, ref results); return(ResultToString(results)); }
public TypedValue Invoke(TypedValue instance, MemberName memberName, Tree <Cell> parameters) { var member = MemberQuery.FindDirectInstance(instance.Value, new MemberSpecification(memberName)); return(member.ForValue( v => v.Invoke(new object[] {}), () => TypedValue.MakeInvalid(new MemberMissingException(instance.Type, memberName.Name, 0)))); }
public IEnumerable<ReferenceAssemblyWithTypeResult> FindReferenceAssembliesWithType( string name, int arity, CancellationToken cancellationToken) { // Our reference assembly data is stored in the nuget.org DB. IAddReferenceDatabaseWrapper databaseWrapper; if (!_sourceToDatabase.TryGetValue(NugetOrgSource, out databaseWrapper)) { // Don't have a database to search. yield break; } var database = databaseWrapper.Database; if (name == "var") { // never find anything named 'var'. yield break; } var query = new MemberQuery(name, isFullSuffix: true, isFullNamespace: false); var symbols = new PartialArray<Symbol>(100); if (query.TryFindMembers(database, ref symbols)) { var types = FilterToViableTypes(symbols); foreach (var type in types) { // Only look at reference assembly results. if (type.PackageName.ToString() == MicrosoftAssemblyReferencesName) { var nameParts = new List<string>(); GetFullName(nameParts, type.FullName.Parent); yield return new ReferenceAssemblyWithTypeResult( type.AssemblyName.ToString(), type.Name.ToString(), containingNamespaceNames: nameParts); } } } }
public IEnumerable<PackageWithTypeResult> FindPackagesWithType( string source, string name, int arity, CancellationToken cancellationToken) { //if (!StringComparer.OrdinalIgnoreCase.Equals(source, NugetOrgSource)) //{ // // We only support searching nuget.org // yield break; //} AddReferenceDatabase database; if (!_sourceToDatabase.TryGetValue(source, out database)) { // Don't have a database to search. yield break; } if (name == "var") { // never find anything named 'var'. yield break; } var query = new MemberQuery(name, isFullSuffix: true, isFullNamespace: false); var symbols = new PartialArray<Symbol>(100); if (query.TryFindMembers(database, ref symbols)) { // Don't return nested types. Currently their value does not seem worth // it given all the extra stuff we'd have to plumb through. Namely // going down the "using static" code path and whatnot. var types = new List<Symbol>( from symbol in symbols where this.IsType(symbol) && !this.IsType(symbol.Parent()) select symbol); var typesFromPackagesUsedInOtherProjects = new List<Symbol>(); var typesFromPackagesNotUsedInOtherProjects = new List<Symbol>(); foreach (var type in types) { var packageName = type.PackageName.ToString(); if (_installerService.GetInstalledVersions(packageName).Any()) { typesFromPackagesUsedInOtherProjects.Add(type); } else { typesFromPackagesNotUsedInOtherProjects.Add(type); } } var result = new List<Symbol>(); // We always returm types from packages that we've use elsewhere in the project. int? bestRank = null; foreach (var type in typesFromPackagesUsedInOtherProjects) { if (type.PackageName.ToString() != MicrosoftAssemblyReferencesName) { var rank = GetRank(type); bestRank = bestRank == null ? rank : Math.Max(bestRank.Value, rank); } yield return CreateResult(database, type); } // For all other hits include as long as the popularity is high enough. // Popularity ranks are in powers of two. So if two packages differ by // one rank, then one is at least twice as popular as the next. Two // ranks would be four times as popular. Three ranks = 8 times, etc. // etc. We keep packages that within 1 rank of the best package we find. // // Note: we only do rankings for nuget packages. Results from reference // assemblies are always returned. foreach (var type in typesFromPackagesNotUsedInOtherProjects) { if (type.PackageName.ToString() != MicrosoftAssemblyReferencesName) { var rank = GetRank(type); bestRank = bestRank == null ? rank : Math.Max(bestRank.Value, rank); if (Math.Abs(bestRank.Value - rank) > 1) { yield break; } } yield return CreateResult(database, type); } } }
public Task<ImmutableArray<PackageWithTypeResult>> FindPackagesWithTypeAsync( string source, string name, int arity) { if (!_sourceToDatabase.TryGetValue(source, out var databaseWrapper)) { // Don't have a database to search. return SpecializedTasks.EmptyImmutableArray<PackageWithTypeResult>(); } var database = databaseWrapper.Database; if (name == "var") { // never find anything named 'var'. return SpecializedTasks.EmptyImmutableArray<PackageWithTypeResult>(); } var query = new MemberQuery(name, isFullSuffix: true, isFullNamespace: false); var symbols = new PartialArray<Symbol>(100); var result = ArrayBuilder<PackageWithTypeResult>.GetInstance(); if (query.TryFindMembers(database, ref symbols)) { var types = FilterToViableTypes(symbols); foreach (var type in types) { // Ignore any reference assembly results. if (type.PackageName.ToString() != MicrosoftAssemblyReferencesName) { result.Add(CreateResult(database, type)); } } } return Task.FromResult(result.ToImmutableAndFree()); }
public IEnumerable<PackageWithTypeResult> FindPackagesWithType( string source, string name, int arity, CancellationToken cancellationToken) { IAddReferenceDatabaseWrapper databaseWrapper; if (!_sourceToDatabase.TryGetValue(source, out databaseWrapper)) { // Don't have a database to search. yield break; } var database = databaseWrapper.Database; if (name == "var") { // never find anything named 'var'. yield break; } var query = new MemberQuery(name, isFullSuffix: true, isFullNamespace: false); var symbols = new PartialArray<Symbol>(100); if (query.TryFindMembers(database, ref symbols)) { var types = FilterToViableTypes(symbols); var typesFromPackagesUsedInOtherProjects = new List<Symbol>(); var typesFromPackagesNotUsedInOtherProjects = new List<Symbol>(); foreach (var type in types) { // Ignore any reference assembly results. if (type.PackageName.ToString() != MicrosoftAssemblyReferencesName) { var packageName = type.PackageName.ToString(); if (_installerService.GetInstalledVersions(packageName).Any()) { typesFromPackagesUsedInOtherProjects.Add(type); } else { typesFromPackagesNotUsedInOtherProjects.Add(type); } } } var result = new List<Symbol>(); // We always returm types from packages that we've use elsewhere in the project. int? bestRank = null; foreach (var type in typesFromPackagesUsedInOtherProjects) { yield return CreateResult(database, type); } // For all other hits include as long as the popularity is high enough. // Popularity ranks are in powers of two. So if two packages differ by // one rank, then one is at least twice as popular as the next. Two // ranks would be four times as popular. Three ranks = 8 times, etc. // etc. We keep packages that within 1 rank of the best package we find. foreach (var type in typesFromPackagesNotUsedInOtherProjects) { var rank = GetRank(type); bestRank = bestRank == null ? rank : Math.Max(bestRank.Value, rank); if (Math.Abs(bestRank.Value - rank) > 1) { yield break; } yield return CreateResult(database, type); } } }
public Task<ImmutableArray<ReferenceAssemblyWithTypeResult>> FindReferenceAssembliesWithTypeAsync( string name, int arity) { // Our reference assembly data is stored in the nuget.org DB. if (!_sourceToDatabase.TryGetValue(NugetOrgSource, out var databaseWrapper)) { // Don't have a database to search. return SpecializedTasks.EmptyImmutableArray<ReferenceAssemblyWithTypeResult>(); } var database = databaseWrapper.Database; if (name == "var") { // never find anything named 'var'. return SpecializedTasks.EmptyImmutableArray<ReferenceAssemblyWithTypeResult>(); } var query = new MemberQuery(name, isFullSuffix: true, isFullNamespace: false); var symbols = new PartialArray<Symbol>(100); var results = ArrayBuilder<ReferenceAssemblyWithTypeResult>.GetInstance(); if (query.TryFindMembers(database, ref symbols)) { var types = FilterToViableTypes(symbols); foreach (var type in types) { // Only look at reference assembly results. if (type.PackageName.ToString() == MicrosoftAssemblyReferencesName) { var nameParts = new List<string>(); GetFullName(nameParts, type.FullName.Parent); var result = new ReferenceAssemblyWithTypeResult( type.AssemblyName.ToString(), type.Name.ToString(), containingNamespaceNames: nameParts); results.Add(result); } } } return Task.FromResult(results.ToImmutableAndFree()); }