public RecommendUrlSettingsEntity GetSettings(Guid domainId, string appId) { if (String.IsNullOrEmpty(appId)) { return(null); } List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domainId", domainId)); parameterList.Add(new CommandParameter("@appId", appId)); List <RecommendUrlSettingsEntity> list = _dataBase.Select <RecommendUrlSettingsEntity>( "SELECT * FROM [RecommendUrlSettings] WHERE [Domain] = @domainId AND [AppId] = @appId", parameterList); if (list.Count > 0) { return(list[0]); } _dataBase.ExecuteNonQuery(CommandType.StoredProcedure, "CreateRecommendUrlSettings", parameterList); RecommendUrlSettingsEntity settings = new RecommendUrlSettingsEntity() { Domain = domainId, AppId = appId }; return(settings); }
/// <summary> /// 刷新指定域下面分组信息,将调用微信API获取最新分组信息 /// </summary> /// <param name="domainContext"></param> public void SyncGroupList(DomainContext domainContext) { RequestApiResult <WeixinGetGroupListResult> result = GroupApiWrapper.GetGroupList(domainContext); if (result.Success) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domain", domainContext.Domain.Id)); parameterList.Add(new CommandParameter("@appId", domainContext.AppId)); _dataBase.ExecuteNonQuery("DELETE FROM [MemberGroup] WHERE [Domain] = @domain AND [AppId] = @appId", parameterList); foreach (WeixinGetGroupListResult_Group item in result.ApiResult.GroupList) { MemberGroupEntity group = new MemberGroupEntity(); group.GroupId = item.Id; group.Name = item.Name; group.Domain = domainContext.Domain.Id; group.AppId = domainContext.AppId; _dataBase.Insert(group); } //过滤用户,将已不存在的分组置为0 } else { _log.Write("RefreshGroupList 失败", result.Message, TraceEventType.Warning); } }
/// <summary> /// 刷新指定域下面分组信息,将调用微信API获取最新分组信息 /// </summary> /// <param name="domainContext"></param> public void SyncTagList(DomainContext domainContext) { RequestApiResult <WeixinGetTagListResult> result = TagsApiWrapper.GetTagList(domainContext); if (result.Success) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domain", domainContext.Domain.Id)); parameterList.Add(new CommandParameter("@appId", domainContext.AppId)); _dataBase.ExecuteNonQuery("DELETE FROM [MemberTag] WHERE [Domain] = @domain AND [AppId] = @appId", parameterList); foreach (WeixinGetTagListResult_Tag item in result.ApiResult.TagList) { MemberTagEntity tag = new MemberTagEntity(); tag.TagId = item.Id; tag.Name = item.Name; tag.Domain = domainContext.Domain.Id; tag.AppId = domainContext.AppId; _dataBase.Insert(tag); } //过滤用户,将已不存在的分组置为0 } else { _log.Write("RefreshTagList 失败", result.Message, TraceEventType.Warning); } }
public void RemoveAdvancedArticle(Guid id) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@id", id)); _dataBase.ExecuteNonQuery("DELETE FROM [AdvancedArticle] WHERE [Id] = @id", parameterList); }
public void UpdateLastUpdateTime(Guid domainId) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@id", domainId)); _dataBase.ExecuteNonQuery("UPDATE [Domain] SET [LastUpdateTime]=GETDATE() WHERE [Id] = @id", parameterList); }
public void Remove(Guid id) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@id", id)); _dataBase.ExecuteNonQuery("DELETE FROM [ScenicQRCode] WHERE [Id] = @id", parameterList); _dataBase.ExecuteNonQuery("DELETE FROM [ScenicQRCodeLandingLog] WHERE [QRCodeId] = @id", parameterList); }
public void RemovePointCommodity(Guid id) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@id", id)); _dataBase.ExecuteNonQuery("UPDATE [PointCommodity] SET [Remove] = 1 WHERE [Id] = @id", parameterList); }
//解除授权 public void Unauthorized(Guid domainId, string appId) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domainId", domainId)); parameterList.Add(new CommandParameter("@appId", appId)); _dataBase.ExecuteNonQuery( "UPDATE [Authorizer] SET [Online] = 0 WHERE [AppId] = @appId AND [Domain] = @domainId", parameterList); //更新LastUpdateTime DomainManager.Instance.UpdateLastDockingTime(domainId); }
public void RemoveAutoReplyOnKeyWordsRule(Guid domainId, Guid id) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@id", id)); _dataBase.ExecuteNonQuery("DELETE FROM [AutoReplyOnKeyWordsRule] WHERE [Id] = @id", parameterList); _dataBase.ExecuteNonQuery("DELETE FROM [AutoReplyOnKeyWordsContent] WHERE [RuleId] = @id", parameterList); _domainManager.UpdateLastUpdateTime(domainId); }
public void RemoveTemplate(Guid id) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@id", id)); _dataBase.ExecuteNonQuery("DELETE FROM [PortalPresetTemplate] WHERE [Id] = @id", parameterList); }
/// <summary> /// 0 删除成功 1 指定的用户是域的最初拥有者 /// </summary> /// <param name="id"></param> /// <returns></returns> public NormalResult RemoveUser(Guid id) { NormalResult result = new NormalResult(false); List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@id", id)); //判断是否是DomainOwner bool domainOwner = false; _dataBase.ExecuteScalar <bool>( "SELECT [DomainOwner] FROM [User] WHERE [Removed] = 0 AND [Id] = @id", parameterList, (scalarValue) => { domainOwner = scalarValue; }); if (domainOwner) { result.Reason = 1; return(result); } _dataBase.ExecuteNonQuery("UPDATE [User] SET [Removed] = 1 WHERE [Id] = @id", parameterList); result.Reason = 0; result.Success = true; return(result); }
public void PageVisit(Guid campaignId) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@campaignId", campaignId)); DataBase.ExecuteNonQuery("UPDATE [Campaign] SET [PageVisitCount] = [PageVisitCount] + 1 WHERE [Id] = @campaignId", parameterList); }
public void RemoveCustomForm(Guid id) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@id", id)); _dataBase.ExecuteNonQuery("DELETE FROM [CustomForm] WHERE [Id] = @id", parameterList); _dataBase.ExecuteNonQuery("DELETE FROM [CustomFormContent] WHERE [Form] = @id", parameterList); }
/// <summary> /// 预约更新用户信息的标记,由Windows服务更新 /// </summary> /// <param name="domainId"></param> /// <param name="appId"></param> /// <param name="memberId"></param> public void NeedUpdate(Guid memberId, bool needUpdate) { List <CommandParameter> parameterList = new List <CommandParameter>(); //parameterList.Add(new CommandParameter("@domainId", domainId)); //parameterList.Add(new CommandParameter("@appId", appId)); parameterList.Add(new CommandParameter("@id", memberId)); parameterList.Add(new CommandParameter("@needUpdate", needUpdate)); _dataBase.ExecuteNonQuery( "UPDATE [Member] SET [NeedUpdate] = @needUpdate WHERE [Id] = @id", parameterList); }
/// <summary> /// 推送component_verify_ticket协议 /// </summary> /// <param name="xml"></param> private void ProcessComponentVerifyTicket(XElement xml) { string componentVerifyTicket = xml.XPathSelectElement("ComponentVerifyTicket").Value; if (String.IsNullOrEmpty(componentVerifyTicket)) { return; } //写缓存 //_caching.Set("ComponentVerifyTicket", componentVerifyTicket); _componentVerifyTicket = componentVerifyTicket; //写数据库 try { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@componentVerifyTicket", componentVerifyTicket)); object objCount = _dataBase.ExecuteScalar("SELECT Count(1) FROM [ThirdParty]"); if (objCount == null || objCount == DBNull.Value || int.Parse(objCount.ToString()) == 0) { _dataBase.ExecuteNonQuery("INSERT INTO [ThirdParty] ([ComponentVerifyTicket]) VALUES (@componentVerifyTicket)", parameterList); } else { _dataBase.ExecuteNonQuery("UPDATE [ThirdParty] SET [ComponentVerifyTicket] = @componentVerifyTicket", parameterList); } } catch (Exception ex) { _logService.Write("ComponentVerifyTicket", "写入数据库失败。" + ex.Message, TraceEventType.Error); } }
public void RemoveInformation(Guid id) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@id", id)); _dataBase.ExecuteNonQuery("DELETE FROM [Information] WHERE [Id] = @id", parameterList); _dataBase.ExecuteNonQuery("DELETE FROM [InformationCategory] WHERE [Information] = @id", parameterList); _dataBase.ExecuteNonQuery("DELETE FROM [InformationItem] WHERE [Information] = @id", parameterList); }
public void Finish(Guid domainId, string appId, ReceivingXMLMessage_GroupMessageFinishEvent message) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domain", domainId)); parameterList.Add(new CommandParameter("@appId", appId)); parameterList.Add(new CommandParameter("@msgId", message.MsgId)); parameterList.Add(new CommandParameter("@status", message.Status)); parameterList.Add(new CommandParameter("@totalCount", message.TotalCount)); parameterList.Add(new CommandParameter("@filterCount", message.FilterCount)); parameterList.Add(new CommandParameter("@sentCount", message.SentCount)); parameterList.Add(new CommandParameter("@errorCount", message.ErrorCount)); _dataBase.ExecuteNonQuery( "UPDATE [GroupMessage] SET [Status] = @status, [TotalCount] = @totalCount,[FilterCount] = @filterCount,[SentCount] = @sentCount, [ErrorCount] = @errorCount WHERE [Domain] = @domain AND [AppId] = @appId AND [MsgId] = @msgId", parameterList); }
public string RemoveNormalMaterial(DomainContext domainContext, Guid id, string mediaId) { RequestApiResult requestApiResult = MaterialApiWrapper.RemoveMaterial(domainContext, mediaId); if (requestApiResult.Success == false) { return(requestApiResult.Message); } List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@id", id)); parameterList.Add(new CommandParameter("@mediaId", mediaId)); _dataBase.ExecuteNonQuery("DELETE FROM [NormalMaterial] WHERE [Id] = @id AND [MediaId] = @mediaId", parameterList); return(null); }
public void Execute(IJobExecutionContext context) { List <PointCommodityOrderEntity> orderList = _pointCommodityManager.GetOverdueOrderList(); if (orderList == null || orderList.Count == 0) { return; } _log.Write("释放过期的积分商城订单", String.Format("取得过期订单:{0}", orderList.Count), TraceEventType.Verbose); foreach (PointCommodityOrderEntity item in orderList) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@orderId", item.Id)); _dataBase.ExecuteNonQuery(CommandType.StoredProcedure, "ReleaseOverduePointCommodityOrder", parameterList); } }
/// <summary> /// 商品上架 /// </summary> private void CommodityForSale() { _dataBase.ExecuteNonQuery(CommandType.StoredProcedure, "OneDollarBuyingCommodityPutOnSale"); }
public NormalResult RefreshPayOrder(string outTradeNo, AuthorizerPayConfig config) { NormalResult result = new NormalResult(); if (config == null) { result.Success = false; result.Message = "当前公众号没有微信支付所需配置信息。"; return(result); } WeixinPayOrderQueryArgs orderQueryArgs = new WeixinPayOrderQueryArgs(); orderQueryArgs.AppId = config.AppId; orderQueryArgs.MchId = config.MchId; orderQueryArgs.OutTradeNo = outTradeNo; WxPayArgs wxPayArgs = config.GetWxPayArgs(false); RequestPayApiResult <WeixinPayOrderQueryResult> orderQueryResult = WxPayApi.OrderQuery(orderQueryArgs, wxPayArgs); if (orderQueryResult.Success == false) { _log.Write("OrderQuery 失败", orderQueryResult.Message + "\r\n" + JsonHelper.Serializer(orderQueryArgs) + " " + JsonHelper.Serializer(orderQueryResult), TraceEventType.Warning); result.Success = false; result.Message = orderQueryResult.Message; return(result); } WeixinPayOrderQueryResult orderQuery = orderQueryResult.ApiResult; Guid payOrderId; if (Guid.TryParse(orderQuery.Attach, out payOrderId) == false) { string attacth = String.Empty; if (orderQuery.Attach != null) { attacth = orderQuery.Attach; } _log.Write("Attach 无法转为本地订单Id" + attacth, orderQuery.OutTradeNo, TraceEventType.Verbose); result.Success = false; result.Message = "Attach 无法转为本地订单Id。" + attacth; return(result); } PayOrderEntity payOrder = GetPayOrder(payOrderId); SqlStructureBuild sqlBuild = new SqlStructureBuild(); sqlBuild.Table = "PayOrder"; sqlBuild.Type = SqlExpressionType.Update; sqlBuild.AddParameter("Id", payOrderId, true); sqlBuild.AddParameter("TradeState", EnumHelper.GetEnumFieldByValue <EnumPayTradeState>(orderQuery.TradeState)); sqlBuild.AddParameter("TradeStateDesc", orderQuery.TradeStateDesc); sqlBuild.AddParameter("BankType", orderQuery.BankType); sqlBuild.AddParameter("FeeType", orderQuery.FeeType); sqlBuild.AddParameter("CouponFee", orderQuery.CouponFee); sqlBuild.AddParameter("CouponCount", orderQuery.CouponCount); sqlBuild.AddParameter("TransactionId", orderQuery.TransactionId); if (orderQuery.TimeEnd != null) { sqlBuild.AddParameter("TimeEnd", WeixinApiHelper.ConvertStringToDateTime(orderQuery.TimeEnd)); } sqlBuild.AddParameter("Notify_ReturnCode", orderQuery.ReturnCode); sqlBuild.AddParameter("Notify_ReturnMsg", orderQuery.ReturnMsg); sqlBuild.AddParameter("Notify_ResultCode", orderQuery.ResultCode); sqlBuild.AddParameter("Notify_ErrCode", orderQuery.ErrCode); sqlBuild.AddParameter("Notify_ErrCodeDes", orderQuery.ErrCodeDes); int affectedRowCount = _dataBase.ExcuteSqlExpression(sqlBuild.GetSqlExpression()); if (affectedRowCount == 0) { _log.Write("本地订单不存在", orderQuery.OutTradeNo, TraceEventType.Warning); result.Success = false; result.Message = "本地订单不存在。"; return(result); } if (orderQuery.CouponCount > 0) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@payOrderId", payOrder.Id)); _dataBase.ExecuteNonQuery( "DELETE FROM [PayOrderCoupon] WHERE [PayOrderId] = @payOrderId", parameterList); foreach (WeixinPayOrderQueryResult_Coupon coupon in orderQuery.CouponList) { coupon.PayOrderId = payOrder.Id; _dataBase.Insert(coupon); } } result.Success = true; return(result); }
public void Sync(Guid domainId, string appId, MovieTimesBundle bundle) { if (bundle == null) { return; } List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domainId", domainId)); parameterList.Add(new CommandParameter("@appId", appId)); _dataBase.ExecuteNonQuery( "UPDATE [MovieSettings] SET [SyncTime] = GETDATE() WHERE [Domain] = @domainId AND [AppId] = @appId", parameterList); parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domainId", domainId)); parameterList.Add(new CommandParameter("@appId", appId)); parameterList.Add(new CommandParameter("@date", bundle.Date)); _dataBase.ExecuteNonQuery( "DELETE FROM [MoviePlan] WHERE [Domain] = @domainId AND [AppId] = @appId AND [Date] = @date", parameterList); _dataBase.ExecuteNonQuery( "DELETE FROM [MovieTimes] WHERE [Domain] = @domainId AND [AppId] = @appId AND CONVERT(VARCHAR(10),[Time],120) = CONVERT(VARCHAR(10),@date,120)", parameterList); int i = 0; foreach (MovieEntity movie in bundle.MovieList) { i++; parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@mtimeId", movie.MtimeId)); List <MovieEntity> movieList = _dataBase.Select <MovieEntity>( "SELECT * FROM [Movie] WHERE [MtimeId] = @mtimeId", parameterList); if (movieList.Count == 0) { _dataBase.Insert(movie); } else { movie.Id = movieList[0].Id; } MoviePlanEntity plan = new MoviePlanEntity(); plan.Domain = domainId; plan.AppId = appId; plan.Date = bundle.Date; plan.Movie = movie.Id; plan.Sort = i; _dataBase.Insert(plan); foreach (MovieTimesEntity item in movie.TimesList) { item.Domain = domainId; item.AppId = appId; item.Movie = movie.Id; _dataBase.Insert(item); } } }