public override MiicConditionCollections visitor(PublishInfoDao publishInfoDao) { MiicConditionCollections condition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition editStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressPublishInfo, string>(o => o.EditStatus), ((int)MiicYesNoSetting.No).ToString(), DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, editStatusCondition)); MiicConditionCollections dateCondition = new MiicConditionCollections(); MiicCondition yearCondition = new MiicCondition(MiicSimpleDateTimeFunction.YearFunc <AddressPublishInfo, DateTime?>(o => o.PublishTime), Year, DbType.String, MiicDBOperatorSetting.Equal); dateCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, yearCondition)); if (!string.IsNullOrEmpty(Month)) { MiicCondition monthCondition = new MiicCondition(MiicSimpleDateTimeFunction.MonthFunc <AddressPublishInfo, DateTime?>(o => o.PublishTime), Month, DbType.String, MiicDBOperatorSetting.Equal); dateCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.And, monthCondition)); } condition.Add(dateCondition); //发表人是用户 MiicCondition createrIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <AddressPublishInfo, string>(o => o.CreaterID), this.UserID, DbType.String, MiicDBOperatorSetting.Equal); condition.Add(new MiicConditionLeaf(createrIDCondition)); return(condition); }
bool ICommon <CollectInfo> .Insert(CollectInfo collectInfo) { Contract.Requires <ArgumentNullException>(collectInfo != null, "参数collectInfo:不能为空!"); Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(collectInfo.ID), "参数collectInfo.ID:不能为空!"); bool result = false; List <string> sqls = new List <string>(); string message = string.Empty; string message1 = string.Empty; string message2 = string.Empty; string message3 = string.Empty; IPublishInfo Itemp = new PublishInfoDao(); sqls.Add(DBService.InsertSql(collectInfo, out message1)); try { PublishInfo temp = ((ICommon <PublishInfo>)Itemp).GetInformation(collectInfo.PublishID); sqls.Add(DBService.UpdateSql(new PublishInfo() { ID = collectInfo.PublishID, CollectNum = temp.CollectNum + 1 }, out message2)); Notice.MessageInfo messageInfo = new Notice.MessageInfo() { ID = Guid.NewGuid().ToString(), PublisherID = collectInfo.CollectorID, PublisherName = collectInfo.CollectorName, PublishTime = collectInfo.CollectTime, PublishID = collectInfo.PublishID, NoticerID = temp.CreaterID, NoticerName = temp.CreaterName, ReadStatus = ((int)MiicReadStatusSetting.UnRead).ToString(), Source = ((int)Miic.Friends.Common.Setting.BusinessTypeSetting.Community).ToString(), MessageType = ((int)Miic.Friends.Behavior.Setting.BehaviorTypeSetting.Collect).ToString() }; if (collectInfo.CollectorID != temp.CreaterID) { sqls.Add(DBService.InsertSql(messageInfo, out message3)); } result = dbService.excuteSqls(sqls, out message); //积分 sqls.Add(DBService.InsertSql <UserScopeHistory>(new UserScopeHistory() { ID = Guid.NewGuid().ToString(), BusinessID = collectInfo.ID, CreateTime = DateTime.Now, GetWay = ((int)GetWayTypeSetting.Behavior).ToString(), Score = ScoreConfig.Score.BehaviorScore, ServiceID = ScoreConfig.ServiceID, UserID = collectInfo.CollectorID, UserName = collectInfo.CollectorName }, out message)); if (result == true) { InsertCache(collectInfo); lock (syncRoot) { if (PublishInfoDao.items.Find(o => o.ID == collectInfo.PublishID) != null) { PublishInfoDao.items.Find(o => o.ID == collectInfo.PublishID).CollectNum = temp.CollectNum + 1; } } } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
bool ICommon <CommentInfo> .Delete(string id) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(id), "参数id:不能为空"); bool result = false; List <string> sqls = new List <string>(); string message = string.Empty; string message1 = string.Empty; string message2 = string.Empty; IPublishInfo Itemp = new PublishInfoDao(); try { CommentInfo tempCommentInfo = ((ICommon <CommentInfo>) this).GetInformation(id); PublishInfo tempPublishInfo = ((ICommon <PublishInfo>)Itemp).GetInformation(tempCommentInfo.PublishID); sqls.Add(DBService.DeleteSql(new CommentInfo() { ID = id }, out message1)); sqls.Add(DBService.UpdateSql(new PublishInfo() { ID = tempCommentInfo.PublishID, CommentNum = tempPublishInfo.CommentNum - 1 }, out message2)); //删除级联noticeInfo MiicConditionCollections noticeCondition = new MiicConditionCollections(MiicDBLogicSetting.No); MiicCondition commentIDCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.CommentID), id, DbType.String, MiicDBOperatorSetting.Equal); noticeCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, commentIDCondition)); MiicCondition readStatusCondition = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <NoticeInfo, string>(o => o.ReadStatus), ((int)Miic.Base.Setting.MiicReadStatusSetting.UnRead).ToString(), DbType.String, MiicDBOperatorSetting.Equal); noticeCondition.Add(new MiicConditionLeaf(readStatusCondition)); sqls.Add(DBService.DeleteConditionsSql <NoticeInfo>(noticeCondition, out message)); //积分 sqls.Add(DBService.InsertSql <UserScopeHistory>(new UserScopeHistory() { ID = Guid.NewGuid().ToString(), BusinessID = tempCommentInfo.ID, CreateTime = DateTime.Now, GetWay = ((int)GetWayTypeSetting.Comment).ToString(), Score = -1 * ScoreConfig.Score.CommentScore, ServiceID = ScoreConfig.ServiceID, UserID = tempCommentInfo.FromCommenterID, UserName = tempCommentInfo.FromCommenterName }, out message)); result = dbService.excuteSqls(sqls, out message); if (result == true) { DeleteCache(o => o.ID == id); lock (syncRoot) { if (PublishInfoDao.items.Find(o => o.ID == tempCommentInfo.PublishID) != null) { PublishInfoDao.items.Find(o => o.ID == tempCommentInfo.PublishID).CommentNum = tempPublishInfo.CommentNum - 1; } } } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
public abstract MiicConditionCollections visitor(PublishInfoDao publishInfoDao);
bool ICommon <BrowseInfo> .Insert(BrowseInfo browseInfo) { Contract.Requires <ArgumentNullException>(browseInfo != null, "参数browseInfo:不能为空!"); Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(browseInfo.ID), "参数browseInfo.ID:不能为空!"); bool result = false; List <string> sqls = new List <string>(); string message = string.Empty; string message1 = string.Empty; string message2 = string.Empty; IPublishInfo Itemp = new PublishInfoDao(); //设置提示 browseInfo.IsHinted = ((int)MiicYesNoSetting.Yes).ToString(); sqls.Add(DBService.InsertSql(browseInfo, out message1)); //积分 //sqls.Add(DBService.InsertSql<UserScopeHistory>(new UserScopeHistory() //{ // ID = Guid.NewGuid().ToString(), // BusinessID = browseInfo.PublishID, // CreateTime = DateTime.Now, // GetWay = ((int)GetWayTypeSetting.Behavior).ToString(), // Score = ScoreConfig.BehaviorScore, // ServiceID = ScoreConfig.ServiceID, // UserID = browseInfo.BrowserID, // UserName = browseInfo.BrowserName //}, out message)); try { PublishInfo temp = ((ICommon <PublishInfo>)Itemp).GetInformation(browseInfo.PublishID); sqls.Add(DBService.UpdateSql(new PublishInfo() { ID = browseInfo.PublishID, BrowseNum = temp.BrowseNum + 1 }, out message2)); result = dbService.excuteSqls(sqls, out message); if (result == true) { InsertCache(browseInfo); lock (syncRoot) { if (PublishInfoDao.items.Find(o => o.ID == browseInfo.PublishID) != null) { PublishInfoDao.items.Find(o => o.ID == browseInfo.PublishID).BrowseNum = temp.BrowseNum + 1; } } } } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } return(result); }
bool ICommon <CollectInfo> .Delete(string id) { Contract.Requires <ArgumentNullException>(!string.IsNullOrEmpty(id), "参数id:不能为空"); bool result = false; List <string> sqls = new List <string>(); string message = string.Empty; string message1 = string.Empty; string message2 = string.Empty; string message3 = string.Empty; IPublishInfo IpublishInfo = new PublishInfoDao(); CollectInfo tempCollectInfo = ((ICommon <CollectInfo>) this).GetInformation(id); if (tempCollectInfo == null) { throw new NoNullAllowedException("收藏信息不能为空,请核查!"); } PublishInfo tempPublishInfo = ((ICommon <PublishInfo>)IpublishInfo).GetInformation(tempCollectInfo.PublishID); if (tempPublishInfo == null) { throw new NoNullAllowedException("朋友圈发布信息不能为空,请核查!"); } sqls.Add(DBService.DeleteSql(new CollectInfo() { ID = id }, out message1)); sqls.Add(DBService.UpdateSql(new PublishInfo() { ID = tempCollectInfo.PublishID, CollectNum = tempPublishInfo.CollectNum - 1 }, out message2)); MessageInfo messageInfo = new MessageInfo() { ID = Guid.NewGuid().ToString(), PublisherID = tempCollectInfo.CollectorID, PublisherName = tempCollectInfo.CollectorName, PublishTime = tempCollectInfo.CollectTime, PublishID = tempCollectInfo.PublishID, NoticerID = tempPublishInfo.CreaterID, NoticerName = tempPublishInfo.CreaterName, ReadStatus = ((int)MiicReadStatusSetting.UnRead).ToString(), Source = ((int)BusinessTypeSetting.Moments).ToString(), MessageType = ((int)BehaviorTypeSetting.CancelCollect).ToString() }; if (tempCollectInfo.CollectorID != tempPublishInfo.CreaterID) { sqls.Add(DBService.InsertSql(messageInfo, out message3)); } //积分 sqls.Add(DBService.InsertSql <UserScopeHistory>(new UserScopeHistory() { ID = Guid.NewGuid().ToString(), BusinessID = tempCollectInfo.ID, CreateTime = DateTime.Now, GetWay = ((int)GetWayTypeSetting.Behavior).ToString(), Score = -1 * ScoreConfig.Score.BehaviorScore, ServiceID = ScoreConfig.ServiceID, UserID = tempCollectInfo.CollectorID, UserName = tempCollectInfo.CollectorName }, out message)); try { result = dbService.excuteSqls(sqls, out message); } catch (Exception ex) { Config.IlogicLogService.Write(new LogicLog() { AppName = Config.AppName, ClassName = ClassName, NamespaceName = NamespaceName, MethodName = MethodBase.GetCurrentMethod().Name, Message = ex.Message, Oper = Config.Oper }); } if (result == true) { if (tempCollectInfo.CollectorID != tempPublishInfo.CreaterID) { MessageInfoDao.InsertCache(messageInfo); } DeleteCache(o => o.ID == id); lock (syncRoot) { if (PublishInfoDao.items.Find(o => o.ID == tempCollectInfo.PublishID) != null) { PublishInfoDao.items.Find(o => o.ID == tempCollectInfo.PublishID).CollectNum = tempPublishInfo.CollectNum - 1; } } } return(result); }