public GetItemListResult <NormalMaterialEntity> GetNormalMaterialList(Guid domainId, string appId, GetMaterialListArgs args) { GetItemListResult <NormalMaterialEntity> result = new GetItemListResult <NormalMaterialEntity>(); List <AttachedWhereItem> attachedWhere = new List <AttachedWhereItem>(); attachedWhere.Add(new AttachedWhereItem("Domain", domainId)); attachedWhere.Add(new AttachedWhereItem("AppId", appId)); attachedWhere.Add(new AttachedWhereItem("Type", EnumHelper.GetEnumMemberValue(args.Type))); SqlExpressionPagingArgs pagingArgs = new SqlExpressionPagingArgs(); pagingArgs.Page = args.Page; pagingArgs.PageSize = args.PageSize; result.ItemList = _dataBase.Select <NormalMaterialEntity>(attachedWhere, pagingArgs); result.TotalPage = pagingArgs.TotalPage; result.Page = pagingArgs.Page; if (result.ItemList.Count == 0 && result.Page > 1) { args.Page--; return(GetNormalMaterialList(domainId, appId, args)); } else { return(result); } }
public ActionResult GetShoppingCartItemList() { GetItemListResult result = _pointCommodityManager.GetShoppingCartItemList(MemberContext.Member.Id); return(RespondDataResult(result)); }
/// <summary> /// 模版摘要列表 /// </summary> /// <param name="args"></param> /// <returns></returns> public GetItemListResult GetTemplateDigestList(GetItemListArgs args) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@page", args.Page)); parameterList.Add(new CommandParameter("@pageSize", args.PageSize)); DataSet dsResult = _dataBase.ExecuteDataSet(CommandType.StoredProcedure, "GetPortalPresetTemplateDigestList", parameterList, new string[] { "result" }); if (dsResult.Tables[0].Rows.Count == 0 && args.Page > 1) { args.Page--; return(GetTemplateDigestList(args)); } GetItemListResult result = new GetItemListResult(); result.ItemList = dsResult.Tables[0]; int totalCount = int.Parse(dsResult.Tables[1].Rows[0][0].ToString()); result.TotalPage = totalCount / args.PageSize; if (totalCount % args.PageSize > 0) { result.TotalPage++; } result.Page = args.Page; return(result); }
/// <summary> /// 我参与的 /// </summary> /// <param name="args"></param> /// <returns></returns> public GetItemListResult GetParticipatedList(GetOneDollarBuyingCommodityParticipatedListArgs args) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@page", args.Page)); parameterList.Add(new CommandParameter("@pageSize", args.PageSize)); parameterList.Add(new CommandParameter("@memberId", args.Member)); parameterList.Add(new CommandParameter("@lucky", args.Lucky)); DataSet dsResult = _dataBase.ExecuteDataSet(CommandType.StoredProcedure, "GetOneDollarBuyingCommodityParticipatedList", parameterList, new string[] { "result" }); if (dsResult.Tables[0].Rows.Count == 0 && args.Page > 1) { args.Page--; return(GetParticipatedList(args)); } GetItemListResult result = new GetItemListResult(); result.ItemList = dsResult.Tables[0]; int totalCount = int.Parse(dsResult.Tables[1].Rows[0][0].ToString()); result.TotalCount = totalCount; result.TotalPage = totalCount / args.PageSize; if (totalCount % args.PageSize > 0) { result.TotalPage++; } result.Page = args.Page; return(result); }
public ActionResult GetLuckyTicketLogList() { GetCampaign_LuckyTicketLogListByMemberArgs args = RequestArgs <GetCampaign_LuckyTicketLogListByMemberArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } args.MemberId = MemberContext.Member.Id; args.DomainId = DomainContext.Domain.Id; args.AppId = DomainContext.AppId; GetItemListResult result = _campaignManager.LuckyTicket.GetMemberLuckyTicketLogList(args); //为自己生成一个 if (result.Page == 1 && result.TotalCount == 0) { Campaign_LuckyTicketLogEntity createLuckyTicketLogArgs = new Campaign_LuckyTicketLogEntity(); createLuckyTicketLogArgs.CampaignId = args.CampaignId; createLuckyTicketLogArgs.Domain = DomainContext.Domain.Id; createLuckyTicketLogArgs.Member = MemberContext.Member.Id; createLuckyTicketLogArgs.FromOpenId = MemberContext.Member.OpenId; _campaignManager.LuckyTicket.CreateLuckyTicketLog(createLuckyTicketLogArgs); result = _campaignManager.LuckyTicket.GetMemberLuckyTicketLogList(args); } return(RespondDataResult(result)); }
public GetItemListResult GetCampaign_LotteryList(Guid domainId, string appId, GetCampaign_LotteryListArgs args) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domainId", domainId)); parameterList.Add(new CommandParameter("@appId", appId)); parameterList.Add(new CommandParameter("@page", args.Page)); parameterList.Add(new CommandParameter("@pageSize", args.PageSize)); parameterList.Add(new CommandParameter("@status", args.Status)); DataSet dsResult = _campaignManager.DataBase.ExecuteDataSet(CommandType.StoredProcedure, "GetCampaign_LotteryList", parameterList, new string[] { "result" }); if (dsResult.Tables[0].Rows.Count == 0 && args.Page > 1) { args.Page--; return(GetCampaign_LotteryList(domainId, appId, args)); } GetItemListResult result = new GetItemListResult(); result.ItemList = dsResult.Tables[0]; int totalCount = int.Parse(dsResult.Tables[1].Rows[0][0].ToString()); result.TotalPage = totalCount / args.PageSize; if (totalCount % args.PageSize > 0) { result.TotalPage++; } result.Page = args.Page; return(result); }
public GetItemListResult GetLevel2DownlineList(GetRecommendDownlineListArgs args) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domainId", args.DomainId)); parameterList.Add(new CommandParameter("@appId", args.AppId)); parameterList.Add(new CommandParameter("@memberId", args.MemberId)); parameterList.Add(new CommandParameter("@level", 2)); parameterList.Add(new CommandParameter("@page", args.Page)); parameterList.Add(new CommandParameter("@pageSize", args.PageSize)); DataSet dsResult = _dataBase.ExecuteDataSet(CommandType.StoredProcedure, "GetRecommendSubLevelDownlineList", parameterList, new string[] { "result" }); if (dsResult.Tables[0].Rows.Count == 0 && args.Page > 1) { args.Page--; return(GetLevel2DownlineList(args)); } GetItemListResult result = new GetItemListResult(); result.ItemList = dsResult.Tables[0]; int totalCount = int.Parse(dsResult.Tables[1].Rows[0][0].ToString()); result.TotalPage = totalCount / args.PageSize; if (totalCount % args.PageSize > 0) { result.TotalPage++; } result.Page = args.Page; return(result); }
/// <summary> /// 通过结束日期查找正在进行中的活动 /// </summary> /// <param name="args"></param> /// <returns></returns> public GetItemListResult GetLotteryEndedPeriodList(GetLotteryPeriodListArgs args) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@campaignId", args.CampaignId)); parameterList.Add(new CommandParameter("@page", args.Page)); parameterList.Add(new CommandParameter("@pageSize", args.PageSize)); parameterList.Add(new CommandParameter("@endTime", args.EndTime)); parameterList.Add(new CommandParameter("@type", 2)); DataSet dsResult = _campaignManager.DataBase.ExecuteDataSet(CommandType.StoredProcedure, "GetCampaign_LotteryPeriodListByEndTime", parameterList, new string[] { "result" }); if (dsResult.Tables[0].Rows.Count == 0 && args.Page > 1) { args.Page--; return(GetLotteryEndedPeriodList(args)); } GetItemListResult result = new GetItemListResult(); result.ItemList = dsResult.Tables[0]; int totalCount = int.Parse(dsResult.Tables[1].Rows[0][0].ToString()); result.TotalPage = totalCount / args.PageSize; if (totalCount % args.PageSize > 0) { result.TotalPage++; } result.Page = args.Page; return(result); }
public GetItemListResult <ArticleMaterialEntity> GetArticleMaterialList(Guid domainId, string appId, GetArticleMaterialListArgs args) { GetItemListResult <ArticleMaterialEntity> result = new GetItemListResult <ArticleMaterialEntity>(); List <AttachedWhereItem> attachedWhere = new List <AttachedWhereItem>(); attachedWhere.Add(new AttachedWhereItem("Domain", domainId)); attachedWhere.Add(new AttachedWhereItem("AppId", appId)); if (args.ExceptUnpublished) { attachedWhere.Add(new AttachedWhereItem("WeixinStatus", 2)); } SqlExpressionPagingArgs pagingArgs = new SqlExpressionPagingArgs(); pagingArgs.Page = args.Page; pagingArgs.PageSize = args.PageSize; result.ItemList = _dataBase.Select <ArticleMaterialEntity>(attachedWhere, pagingArgs); result.TotalPage = pagingArgs.TotalPage; result.Page = pagingArgs.Page; if (result.ItemList.Count == 0 && result.Page > 1) { args.Page--; return(GetArticleMaterialList(domainId, appId, args)); } else { if (result.ItemList.Count > 0) { string sql = "SELECT [Id],[ArticleMaterial],[Title],[ThumbMediaId],[ThumbUrl],[ThumbName],[Url],[Index] FROM [ArticleMaterialItem] WHERE "; List <CommandParameter> parameterList = new List <CommandParameter>(); for (int i = 0; i < result.ItemList.Count; i++) { parameterList.Add(new CommandParameter("@id" + i, result.ItemList[i].Id)); sql += " [ArticleMaterial] = @id" + i; if (i < result.ItemList.Count - 1) { sql += " OR "; } } sql += " ORDER BY [Index]"; List <ArticleMaterialItemEntity> itemList = _dataBase.Select <ArticleMaterialItemEntity>(sql, parameterList); foreach (ArticleMaterialEntity item in result.ItemList) { item.ArticleList = (from c in itemList where c.ArticleMaterial == item.Id select c).ToList(); } } return(result); } }
public ActionResult GetTemplateDigestList() { GetItemListArgs args = RequestArgs <GetItemListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } GetItemListResult result = _portalPresetTemplateManager.GetTemplateDigestList(args); return(RespondDataResult(result)); }
public ActionResult GetInformationItemList() { GetInformationItemListArgs args = RequestArgs <GetInformationItemListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } GetItemListResult result = _informationManager.GetInformationItemList(args); return(RespondDataResult(result)); }
public ActionResult GetLotteryOngoingPeriodList() { GetLotteryPeriodListArgs args = RequestArgs<GetLotteryPeriodListArgs>(); if (args == null) { return RespondResult(false, "参数无效。"); } args.EndTime = DateTime.Now; GetItemListResult result = _campaignManager.Lottery.GetLotteryOngoingPeriodList(args); return RespondDataResult(result); }
public ActionResult GetUserList() { GetUserListArgs getUserListArgs = RequestArgs <GetUserListArgs>(); if (getUserListArgs == null) { return(RespondResult(false, "参数无效。")); } getUserListArgs.DomainId = UserContext.Domain.Id; GetItemListResult userList = _userManager.GetUserList(getUserListArgs); return(RespondDataResult(userList)); }
public ActionResult GetArticleMaterialList() { GetArticleMaterialListArgs args = RequestArgs <GetArticleMaterialListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } GetItemListResult <ArticleMaterialEntity> result = _materialManager.GetArticleMaterialList(UserContext.User.Domain, DomainContext.AppId, args); return(RespondDataResult(result)); }
public ActionResult GetSentGroupMessageList() { GetItemListArgs args = RequestArgs <GetItemListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } GetItemListResult result = _groupMessageManager.GetSentGroupMessageList(UserContext.User.Domain, DomainContext.AppId, args); return(RespondDataResult(result)); }
public ActionResult GetLuckyTicketWinLogList() { GetCampaign_LuckyTicketWinLogListArgs args = RequestArgs<GetCampaign_LuckyTicketWinLogListArgs>(); if (args == null) { return RespondResult(false, "参数无效。"); } args.DomainId = DomainContext.Domain.Id; args.AppId = DomainContext.AppId; GetItemListResult result = _campaignManager.LuckyTicket.GetLuckyTicketWinLogList(args); return RespondDataResult(result); }
public ActionResult GetPointAccount() { GetPointAccountArgs args = RequestArgs <GetPointAccountArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } args.MemberId = MemberContext.Member.Id; GetItemListResult result = _memberManager.GetPointAccount(args); return(RespondDataResult(result)); }
public ActionResult GetPointCommodityList() { GetPointCommodityListArgs args = RequestArgs <GetPointCommodityListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } //只取上架的商品 args.ForSale = true; GetItemListResult <PointCommodityEntity> result = _pointCommodityManager.GetPointCommodityList(DomainContext.Domain.Id, DomainContext.AppId, args); return(RespondDataResult(result)); }
public ActionResult GetOperatedLogList() { GetItemListArgs args = RequestArgs <GetItemListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } args.DomainId = UserContext.User.Domain; args.AppId = DomainContext.AppId; GetItemListResult result = _operatedLogManager.GetOperatedLogList(args); return(RespondDataResult(result)); }
public ActionResult GetPictureVoteItemList() { GetCampaign_PictureVoteItemListArgs args = RequestArgs<GetCampaign_PictureVoteItemListArgs>(); if (args == null) { return RespondResult(false, "参数无效。"); } string campaignId = Request.QueryString["campaignId"]; args.CampaignId = Guid.Parse(campaignId); args.ApproveStatus = EnumCampaignPictureVoteItemApproveStatus.Approved; GetItemListResult result = _campaignManager.PictureVote.GetPictureVoteItemList(args); return RespondDataResult(result); }
public ActionResult GetCommodityList() { GetOneDollarBuyingCommodityListArgs args = RequestArgs <GetOneDollarBuyingCommodityListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } args.DomainId = UserContext.User.Domain; args.AppId = DomainContext.AppId; GetItemListResult result = _oneDollarBuyingManager.GetCommodityList(args); return(RespondDataResult(result)); }
public GetItemListResult GetShoppingCartItemList(Guid memberId) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@memberId", memberId)); DataSet dsResult = _dataBase.ExecuteDataSet(CommandType.StoredProcedure, "GetPointCommodityCartItemList", parameterList, new string[] { "result" }); GetItemListResult result = new GetItemListResult(); result.ItemList = dsResult.Tables[0]; return(result); }
public ActionResult GetPointCommodityOrderList() { GetPointCommodityOrderListArgs args = RequestArgs <GetPointCommodityOrderListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } args.DomainId = DomainContext.Domain.Id; args.AppId = DomainContext.AppId; GetItemListResult result = _pointCommodityManager.GetOrderList(args); return(RespondDataResult(result)); }
public ActionResult GetPointCommodityList() { //domainId,如果是微信端,则微信端的WEB页面要自动完成一个login操作 //在SESSION中记录用户信息 GetPointCommodityListArgs args = RequestArgs <GetPointCommodityListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } GetItemListResult <PointCommodityEntity> result = _pointCommodityManager.GetPointCommodityList(UserContext.User.Domain, DomainContext.AppId, args); return(RespondDataResult(result)); }
public ActionResult GetInformationList() { GetItemListArgs args = RequestArgs <GetItemListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } args.DomainId = DomainContext.Domain.Id; args.AppId = DomainContext.AppId; GetItemListResult result = _informationManager.GetInformationList(args); return(RespondDataResult(result)); }
public ActionResult GetDonationLogList() { GetCampaign_DonationLogListArgs args = RequestArgs<GetCampaign_DonationLogListArgs>(); if (args == null) { return RespondResult(false, "参数无效。"); } args.DomainId = DomainContext.Domain.Id; args.AppId = DomainContext.AppId; args.Member = MemberContext.Member.Id; args.Finished = false; GetItemListResult result = _campaignManager.Donation.GetDonationLogList(args); return RespondDataResult(result); }
public ActionResult GetForSaleCommodityMemberPartNumber() { GetOneDollarBuyingCommodityMemberPartNumberArgs args = RequestArgs <GetOneDollarBuyingCommodityMemberPartNumberArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } args.DomainId = DomainContext.Domain.Id; args.AppId = DomainContext.AppId; GetItemListResult result = _oneDollarBuyingManager.GetForSaleCommodityMemberPartNumber(args); return(RespondDataResult(result)); }
public ActionResult GetCampaignList() { GetCampaignListArgs args = RequestArgs<GetCampaignListArgs>(); if (args == null) { return RespondResult(false, "参数无效。"); } args.DomainId = DomainContext.Domain.Id; args.AppId = DomainContext.AppId; //args.Status = EnumCampaignStatus.Ongoing; args.OrderBy = "StartTime"; args.Sort = EnumSort.DESC; GetItemListResult result = _campaignManager.GetCampaignList(args); return RespondDataResult(result); }
public ActionResult GetCashAccountTrackList() { GetCashAccountTrackListArgs args = RequestArgs <GetCashAccountTrackListArgs>(); if (args == null) { return(RespondResult(false, "参数无效。")); } args.DomainId = DomainContext.Domain.Id; args.AppId = DomainContext.AppId; args.Member = MemberContext.Member.Id; GetItemListResult result = _payManager.GetCashAccountTrackList(args); return(RespondDataResult(result)); }
public GetItemListResult GetDistributedCouponList(GetDistributedCouponListArgs args) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domainId", args.DomainId)); parameterList.Add(new CommandParameter("@appId", args.AppId)); parameterList.Add(new CommandParameter("@page", args.Page)); parameterList.Add(new CommandParameter("@pageSize", args.PageSize)); parameterList.Add(new CommandParameter("@couponId", args.CouponId)); parameterList.Add(new CommandParameter("@serialNumber", args.SerialNumber)); parameterList.Add(new CommandParameter("@memberNickName", args.MemberNickName)); if (args.Status.HasValue) { parameterList.Add(new CommandParameter("@status", args.Status.Value)); } else { parameterList.Add(new CommandParameter("@status", DBNull.Value)); } DataSet dsResult = _dataBase.ExecuteDataSet(CommandType.StoredProcedure, "GetDistributedCouponList", parameterList, new string[] { "result" }); if (dsResult.Tables[0].Rows.Count == 0 && args.Page > 1) { args.Page--; return(GetDistributedCouponList(args)); } GetItemListResult result = new GetItemListResult(); result.ItemList = dsResult.Tables[0]; int totalCount = int.Parse(dsResult.Tables[1].Rows[0][0].ToString()); result.TotalCount = totalCount; result.TotalPage = totalCount / args.PageSize; if (totalCount % args.PageSize > 0) { result.TotalPage++; } result.Page = args.Page; return(result); }