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