/// <summary>
/// 删除导入错误的数据
/// </summary>
/// <param name="rowId"></param>
/// <param name="actId"></param>
public void DeleteActData(int rowId, string actId)
{
_signActRepositoryMongo.Delete(actId);
//time.Marke("20.脏数据查询开始", actId);
IEnumerable <string> openIdList = _signRecordsRepository
.Query <string>("select distinct openid from SignRecords where ActivityID=@actID ",
new { actID = rowId });
//time.Marke("21.脏数据查询结束", actId);
foreach (var openId in openIdList)
{
//time.Marke("22.脏数据删除开始", actId);
_userSignActRepositoryMongo.Delete(UserSignActivity.GetId(openId, actId));
//time.Marke("23.脏数据删除结束", actId);
}
}
/// <summary>
/// 导出用户签到数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool ExportUserSign(int id, string guid)
{
//time.Marke("46.执行 select distinct openid from SignRecords where ActivityID=@actID ", id.ToString());
IEnumerable <string> openIdList = _signRecordsRepository
.Query <string>("select distinct openid from SignRecords where ActivityID=@actID ", new { actID = id });
//time.Marke("47.执行结束 select distinct openid from SignRecords where ActivityID=@actID ", id.ToString());
if (openIdList == null || !openIdList.Any())
{
return(true); //无人参加
}
int index = 0;
List <UserSignActivity> userSignList = new List <UserSignActivity>();
//time.Marke("48.判断是否包含这条用户签到数据", id.ToString());
if (_userSignActRepositoryMongo.FirstOrDefault(UserSignActivity.GetId(openIdList.FirstOrDefault(), guid)) == null)
{
//time.Marke("49.结束判断是否包含这条用户签到数据", id.ToString());
int cindex = 0;
foreach (var openid in openIdList)
{
cindex++;
#region MultipQuery
////time.Marke("50." + cindex + ".循环查询用户数据", id.ToString());
//List<IEnumerable<object>> queryList = _signPointActivityRepository.QueryMultiple(
// "select * from SignRecords where ActivityID=@actID and Openid=@openId order by ID desc; " +
// "select * from SignSpecialRecords where ActivityID=@actID and Openid=@openId; " +
// "select * from MemberSignatureCard where ActivityID=@actID and Openid=@openId; " +
// //"select * from EventAwardRecords where ActivityID=@actID and Openid=@openId and (ActivityType=@actType or ActivityType=@actSpecialType ",
// "select * from EventAwardRecords where ActivityID=@actID and Openid=@openId and ActivityType=@actType union select * from EventAwardRecords where ActivityID=@actID and Openid=@openId and ActivityType=@actSpecialType ",
// new { actID = id, openId = openid, actType = 2, actSpecialType = 3 }, new Type[] { typeof(SignRecordsDto), typeof(SignSpecialRecordsDto), typeof(MemberSignatureCardDto), typeof(EventAwardRecordsDto) });
////time.Marke("51." + cindex + ".循环查询用户数据", id.ToString());
////time.Marke("52." + cindex + ".数据赋值", id.ToString());
//List<SignRecordsEntity> recordEntityList = GetUserRecords(queryList[0], guid);//时间先后倒叙排序，最新的在最前面
//List<SignSpecialRecordsEntity> specialRecordEntityList = GetUserSpecialRecords(queryList[1], guid);
//List<MemberSignatureCardEntity> cardEntityList = GetUserCardList(queryList[2], guid, id);
//List<EventAwardRecordsEntity> eventAwardEntityList = GetEventAwardList(guid, queryList[3]);
#endregion
#region SingleQuery
IEnumerable <SignRecordsDto> recordTempList = _signRecordsRepository
.Query <SignRecordsDto>("select * from SignRecords where ActivityID=@actID and Openid=@openId order by ID desc", new { actID = id, openId = openid });
IEnumerable <SignSpecialRecordsDto> specialTempList = _signRecordsRepository
.Query <SignSpecialRecordsDto>("select * from SignSpecialRecords where ActivityID=@actID and Openid=@openId", new { actID = id, openId = openid });
IEnumerable <MemberSignatureCardDto> cardTempList = _signRecordsRepository
.Query <MemberSignatureCardDto>("select * from MemberSignatureCard where ActivityID=@actID and Openid=@openId", new { actID = id, openId = openid });
IEnumerable <EventAwardRecordsDto> awardTempList = _signRecordsRepository
.Query <EventAwardRecordsDto>("select * from EventAwardRecords where ActivityID=@actID and Openid=@openId and ActivityType=@actType union select * from EventAwardRecords where ActivityID=@actID and Openid=@openId and ActivityType=@actSpecialType ",
new { actID = id, openId = openid, actType = 2, actSpecialType = 3 });
List <SignRecordsEntity> recordEntityList = GetUserRecords(recordTempList, guid);//时间先后倒叙排序，最新的在最前面
List <SignSpecialRecordsEntity> specialRecordEntityList = GetUserSpecialRecords(specialTempList, guid);
List <MemberSignatureCardEntity> cardEntityList = GetUserCardList(cardTempList, guid, id);
List <EventAwardRecordsEntity> eventAwardEntityList = GetEventAwardList(guid, awardTempList);
#endregion
UserSignActivity userSign = new UserSignActivity(openid, guid)
{
LastSignTime = getLastSignTime(recordEntityList),
MaxTotalNumber = recordEntityList.Max(t => t.TotalNumber),
SignRecords = recordEntityList,
SignSpecialRecords = specialRecordEntityList,
MemberSignatureCard = cardEntityList,
EventAwardRecords = eventAwardEntityList
};
userSignList.Add(userSign);
//time.Marke("53." + cindex + ".数据赋值结束", id.ToString());
index++;
if (index >= 1000)
{
//time.Marke("54." + cindex + ".1000条插入mongodb开始", id.ToString());
_userSignActRepositoryMongo.InsertList(userSignList);
//time.Marke("55." + cindex + ".1000条插入mongodb结束", id.ToString());
index = 0;
//time.Marke("56." + cindex + ".清理列表开始", id.ToString());
userSignList.Clear();
//time.Marke("57." + cindex + ".清理列表结束", id.ToString());
}
}
//time.Marke("58.剩余的数据插入mongodb开始." + userSignList.Count, id.ToString());
_userSignActRepositoryMongo.InsertList(userSignList);
//time.Marke("59.剩余的数据插入mongodb结束." + userSignList.Count, id.ToString());
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 检测删除脏数据是否成功
/// </summary>
public void TestCheckDeleteBadDataIsSuccessfully()
{
//准备环境
IEnumerable <SignPointActivityDto> actIdList =
_signPointActivityRepository.Query <SignPointActivityDto>("select top 20 * from SignPointActivity");
actIdList.ShouldNotBeNull();
actIdList.Any().ShouldBe(true);
//
foreach (var act in actIdList)
{
_actuatorAppService.StartWorkFor(act.Id);
_redisHelper.StringSet(SUCCESSACTIDQUEUEKEY, act.Id.ToString(), 60 * 60 * 24 * 3);
}
var rid = actIdList.ToList().GetRange(16, 1).FirstOrDefault().Id;
//强制缓存在17条的位置停止
_redisHelper.StringSet(SUCCESSACTIDQUEUEKEY, rid.ToString(), 60 * 60 * 24 * 3);
//执行返回现场
_actuatorAppService.BackToLastExport();
//mongodb为缓存中最终添加的记录
int mongoDbId = _signActivityRepository.Queryable().Max(t => t.RowId);
mongoDbId.ShouldBe(rid);
//MongoDb中没有相关记录
IEnumerable <SignPointActivityDto> actList =
_signPointActivityRepository.Query <SignPointActivityDto>(
"select top 3 * from SignPointActivity where id>@id", new { id = rid });
foreach (var actItem in actList)
{
//活动数据不存在
var actMongo = _signActivityRepository.FirstOrDefault(actItem.ActID.ToString());
actMongo.ShouldBeNull();
//用户数据不存在
IEnumerable <string> openIdList = _signRecordsRepository
.Query <string>("select distinct openid from SignRecords where ActivityID=@actID ",
new { actID = actItem.Id });
foreach (var openId in openIdList)
{
//活动数据不存在
UserSignActivity actMongoTemp =
_userSignActRepositoryMongo.FirstOrDefault(UserSignActivity.GetId(openId,
actItem.ActID.ToString()));
actMongoTemp.ShouldBeNull();
}
}
var rids = actIdList.Select(x => x.Id);
var actids = actIdList.Select(x => x.ActID.ToString());
//清理测试数据
foreach (var act in actIdList)
{
_actuatorAppService.DeleteActData(act.Id, act.ActID.ToString());
}
//检测活动数据是否清除成功
_signActivityRepository.Count(x => rids.Contains(x.RowId)).ShouldBe(0);
_userSignActRepositoryMongo.Count(x => actids.Contains(x.ActivityId));
}
public void IsSuccessfullyInsertData()
{
var actIdList = _signPointActivityRepository.Query <int>("select distinct top 1 id from SignPointActivity");
var watch = new Stopwatch();
watch.Start();
//数据库应该有数据
actIdList.ShouldNotBeNull();
//条目不为空
actIdList.Any().ShouldBe(true);
var node = actIdList.FirstOrDefault();
var boo = _actuatorAppService.ExportAct(node);
boo.ShouldBe(true);
//检测mongodb的字段
List <IEnumerable <object> > queryList = _signPointActivityRepository.QueryMultiple(
"select top 1 * from SignPointActivity where ID=@id;select * from SignPointSet where ActivityID=@id",
new { id = node }, typeof(SignPointActivityDto), typeof(SignPointSetDto));
SignPointActivityDto signAct = (SignPointActivityDto)queryList[0].FirstOrDefault();
signAct.ShouldNotBeNull();
List <SignPointSetDto> actSetList = new List <SignPointSetDto>();
foreach (var item in queryList[1])
{
actSetList.Add((SignPointSetDto)item);
}
actSetList.Any().ShouldBe(true);
SignActivity signMongo = _signActivityRepository.FirstOrDefault(x => x.Id == signAct.ActID.ToString());
signMongo.ShouldNotBeNull();
signMongo.Title.ShouldBe(signAct.Title);
signMongo.BackGroundImg.ShouldBe(signAct.BackGroundImg);
signMongo.BtnName.ShouldBe(signAct.BtnName);
signMongo.BtnUrl.ShouldBe(signAct.BtnUrl);
signMongo.BtnUrlName.ShouldBe(signAct.BtnUrlName);
signMongo.CssStyle.ShouldBe(signAct.CssStyle);
signMongo.FreeChance.ShouldBe(signAct.FreeChance);
signMongo.RegistrationRemark.ShouldBe(signAct.RegistrationRemark);
signMongo.Memberlogin.ShouldBe(signAct.Memberlogin);
signMongo.SignPointSet.Count().ShouldBe(actSetList.Count());
string timePattern = "yyyyMMdd";
signMongo.BeginTime.ToString(timePattern).ShouldBe(signAct.BeginTime.ToString(timePattern));
signMongo.EndTime.ToString(timePattern).ShouldBe(signAct.EndTime.ToString(timePattern));
//检查奖项库存
foreach (var item in signMongo.SignPointSet)
{
if (item.WxHbID > 0)//红包
{
int prizeType = 0;
int activityType = item.IsSpecial == 0 ? 2 : 3;
string hbStockCountKey = string.Format(SignKeys.signactprizegrantnum_key, item.ID, prizeType);
hbStockCountKey = "B200016:" + hbStockCountKey;
int hbGrantCount = _eventAwardRecordsRepository.Count(" where MemberLogin=@Memberlogin and ActivityID=@ActID and ActivityType=@ActivityType and (PrizeType=@PrizeType or PrizeType=@PrizeType2 ) and AwardSetId = @AwardSetId",
new { Memberlogin = item.Memberlogin, ActID = node, ActivityType = activityType, PrizeType = 5, PrizeType2 = 6, AwardSetId = item.ID });
int count = Convert.ToInt32(_redisHelper.StringGet(hbStockCountKey));
count.ShouldBe(hbGrantCount);
}
if (item.ProductID > 0)//产品
{
int prizeType = 1;
int activityType = item.IsSpecial == 0 ? 2 : 3;
string productStockCountKey = string.Format(SignKeys.signactprizegrantnum_key, item.ID, prizeType);
productStockCountKey = "B200016:" + productStockCountKey;
int prizeTypeDB = 0;
int productStockCount = _eventAwardRecordsRepository.Count("where MemberLogin=@Memberlogin and ActivityID=@ActID and ActivityType=@ActivityType and PrizeType=@PrizeType and AwardSetId = @AwardSetId",
new { Memberlogin = item.Memberlogin, ActID = node, ActivityType = activityType, PrizeType = prizeTypeDB, AwardSetId = item.ID });
int count = Convert.ToInt32(_redisHelper.StringGet(productStockCountKey));
count.ShouldBe(productStockCount);
}
}
//检查用户数据
IEnumerable <string> openIdList = _signRecordsRepository
.Query <string>("select distinct openid from SignRecords where ActivityID=@actID ",
new { actID = node });
if (openIdList == null || !openIdList.Any())
{
return; //无人参加
}
string openid = openIdList.FirstOrDefault();
List <IEnumerable <object> > queryList2 = _signPointActivityRepository.QueryMultiple(
"select * from SignRecords where ActivityID=@actID and Openid=@openId order by ID desc; " +
"select * from SignSpecialRecords where ActivityID=@actID and Openid=@openId; " +
"select * from MemberSignatureCard where ActivityID=@actID and Openid=@openId; " +
//"select * from EventAwardRecords where ActivityID=@actID and Openid=@openId and (ActivityType=@actType or ActivityType=@actSpecialType ",
"select * from EventAwardRecords where ActivityID=@actID and Openid=@openId and ActivityType=@actType union select * from EventAwardRecords where ActivityID=@actID and Openid=@openId and ActivityType=@actSpecialType ",
new { actID = node, openId = openid, actType = 2, actSpecialType = 3 }, new Type[] { typeof(SignRecordsDto), typeof(SignSpecialRecordsDto), typeof(MemberSignatureCardDto), typeof(EventAwardRecordsDto) });
//签到记录
UserSignActivity userSignMongo = _userSignActRepositoryMongo.FirstOrDefault(UserSignActivity.GetId(openid, signMongo.Id));
userSignMongo.ShouldNotBeNull();
if (queryList2[0].Any())
{
List <SignRecordsDto> records = new List <SignRecordsDto>();
foreach (var item in queryList2[0])
{
records.Add((SignRecordsDto)item);
}
userSignMongo.SignRecords.Count().ShouldBe(records.Count());
var recordDB = records.OrderBy(m => m.Addtime).FirstOrDefault();
var recordMongo = userSignMongo.SignRecords.OrderBy(t => t.Addtime).FirstOrDefault();
userSignMongo.Id.ShouldBe(UserSignActivity.GetId(openid, signMongo.Id));
recordMongo.CustomerID.ShouldBe(recordDB.CustomerID);
recordMongo.Day.ShouldBe(recordDB.Day);
recordMongo.IsContinue.ShouldBe(recordDB.IsContinue);
recordMongo.IsSignature.ShouldBe(recordDB.IsSignature);
recordMongo.memberlogin.ShouldBe(recordDB.memberlogin);
}
//特殊
if (queryList2[1].Any())
{
List <SignSpecialRecordsDto> specials = new List <SignSpecialRecordsDto>();
foreach (var item in queryList2[1])
{
specials.Add((SignSpecialRecordsDto)item);
}
userSignMongo.SignSpecialRecords.Count().ShouldBe(specials.Count);
var recordDB = specials.OrderBy(m => m.Addtime).FirstOrDefault();
var recordMongo = userSignMongo.SignSpecialRecords.OrderBy(t => t.Addtime).FirstOrDefault();
recordMongo.SpecialSDate.ShouldBe(recordDB.SpecialSDate);
recordMongo.CustomerID.ShouldBe(recordDB.CustomerID);
}
//补签卡
if (queryList2[2].Any())
{
List <MemberSignatureCardDto> cards = new List <MemberSignatureCardDto>();
foreach (var item in queryList2[2])
{
cards.Add((MemberSignatureCardDto)item);
}
userSignMongo.MemberSignatureCard.Count().ShouldBe(cards.Count());
userSignMongo.MemberSignatureCard.Count(m => m.IsUse == 1).ShouldBe(cards.Count(m => m.IsUse == 1));
}
//奖项
if (queryList2[3].Any())
{
List <EventAwardRecordsDto> awards = new List <EventAwardRecordsDto>();
foreach (var item in queryList2[3])
{
awards.Add((EventAwardRecordsDto)item);
}
userSignMongo.EventAwardRecords.Count().ShouldBe(awards.Count());
}
//检测完删掉mongodb的测试数据
// _signActivityRepository.Delete
foreach (var user in openIdList)
{
_userSignActRepositoryMongo.Delete(UserSignActivity.GetId(user, signMongo.Id));
}
_signActivityRepository.Delete(signMongo.Id);
watch.Stop();
watch.ElapsedMilliseconds.ShouldBeLessThan(10000);
}
public void IsSuccessSecondExport()
{
//准备环境
IEnumerable <SignPointActivityDto> actIdList =
_signPointActivityRepository.Query <SignPointActivityDto>("select top 20 * from SignPointActivity");
actIdList.ShouldNotBeNull();
actIdList.Any().ShouldBe(true);
foreach (var act in actIdList)
{
_actuatorAppService.StartWorkFor(act.Id);
_redisHelper.StringSet(SUCCESSACTIDQUEUEKEY, act.Id.ToString(), 60 * 60 * 24 * 3);
}
var entity = actIdList.ToList().GetRange(16, 1).FirstOrDefault();
_redisHelper.StringSet(SUCCESSACTIDQUEUEKEY, entity.Id.ToString(), 60 * 60 * 24 * 3);
var watch = new Stopwatch();
watch.Start();
//返回现场
_actuatorAppService.ExcuteWorker(actIdList.Select(x => x.Id));
//检测数据条目有没有跟数据库条目一致
string actStr = _redisHelper.StringGet(SUCCESSACTIDQUEUEKEY);
int actId = 0;
if (!string.IsNullOrEmpty(actStr))
{
actId = Convert.ToInt32(actStr);
}
//缓存中的ID为最终添加的记录
int mongoDbId = _signActivityRepository.Queryable().Max(t => t.RowId);
actId.ShouldBe(actIdList.Max(t => t.Id));
mongoDbId.ShouldBe(actId);
//MongoDb中没有相关记录
IEnumerable <SignPointActivityDto> actList =
_signPointActivityRepository.Query <SignPointActivityDto>(
"select top 2 * from SignPointActivity where id>@id", new { id = actId });
foreach (var actItem in actList)
{
//活动数据不存在
var actMongo = _signActivityRepository.FirstOrDefault(actItem.ActID.ToString());
actMongo.ShouldBeNull();
//用户数据不存在
IEnumerable <string> openIdList = _signRecordsRepository
.Query <string>("select distinct openid from SignRecords where ActivityID=@actID ",
new { actID = actItem.Id });
foreach (var openId in openIdList)
{
//活动数据不存在
UserSignActivity actMongoTemp =
_userSignActRepositoryMongo.FirstOrDefault(UserSignActivity.GetId(openId,
actItem.ActID.ToString()));
actMongoTemp.ShouldBeNull();
}
}
//清理测试数据
foreach (var act in actIdList)
{
_actuatorAppService.DeleteActData(act.Id, act.ActID.ToString());
}
//重置缓存
_redisHelper.StringSet(SUCCESSACTIDQUEUEKEY, "0", 60 * 60 * 24 * 3);
watch.Stop();
watch.ElapsedMilliseconds.ShouldBeLessThan(10000);
}