/// <summary>
/// 自动关闭活动
/// </summary>
/// <returns></returns>
public async Task <List <GroupActivity> > AutoCloseAsync()
{
// 直接sql操作
// PikachuDataContext.Database.Connection.Execute(@"
//SELECT ActivityType
// FROM activitylogs
//WHERE EndTime IS NULL AND PredictEndTime <= NOW()
//");
var list = await PikachuDataContext.GroupActivities
.Where(u => u.ActivityStateType == ActivityStateTypes.Open && u.PredictEndTime < DateTime.Now)
.ToListAsync();
foreach (var item in list)
{
item.EndTime = DateTime.Now;
item.ActivityStateType = ActivityStateTypes.Close;
item.Description = "job 自动关闭";
}
await PikachuDataContext.SaveChangesAsync();
return(list);
}
public void AddGroupAuth(string groupNo, out string msg)
{
var old = PikachuDataContext.GroupAuths.FirstOrDefault(u => u.GroupNo.Equals(groupNo));
if (old != null)
{
old.Enable = true;
old.UpdateTime = DateTime.Now;
}
else
{
PikachuDataContext.GroupAuths.Add(new GroupAuth()
{
GroupNo = groupNo,
UpdateTime = DateTime.Now,
Enable = true
});
;
}
PikachuDataContext.SaveChanges();
msg = "添加授权成功!";
}
public GroupConfigService(PikachuDataContext pikachuDataContext) : base(pikachuDataContext)
{
}
public BillFlowService(PikachuDataContext pikachuDataContext) : base(pikachuDataContext)
{
}
public ManageService(PikachuDataContext pikachuDataContext) : base(pikachuDataContext)
{
}
public GroupMsgCopyService(PikachuDataContext pikachuDataContext) : base(pikachuDataContext)
{
}
public GroupAuthService(PikachuDataContext pikachuDataContext) : base(pikachuDataContext)
{
}
public MemberInfoService(PikachuDataContext pikachuDataContext) : base(pikachuDataContext)
{
}
public JobConfigService(PikachuDataContext pikachuDataContext) : base(pikachuDataContext)
{
}
public PrivateMessageFromFriendReceivedMahuaEvent(IMahuaApi mahuaApi,
IGeneratePrivateMsgDeal generatePrivateMsgDeal, PikachuDataContext dbContext
)
{
_mahuaApi = mahuaApi;
_generatePrivateMsgDeal = generatePrivateMsgDeal;
this.dbContext = dbContext;
}
public BaseService(PikachuDataContext pikachuDataContext)
{
PikachuDataContext = pikachuDataContext;
}
public SolutionDeal(IDatabase database, PikachuDataContext dbContext)
{
this.database = database;
this.dbContext = dbContext;
}
public GroupActivityService(PikachuDataContext pikachuDataContext) : base(pikachuDataContext)
{
}
