public EasyOne.Model.Collection.CollectionPagingRuleInfo GetInfoById(int id, int ruleType)
        {
            Parameters cmdParams  = new Parameters();
            string     strCommand = "SELECT * FROM PE_CollectionPagingRules WHERE ItemId = @ItemId AND RuleType = @RuleType";

            cmdParams.AddInParameter("@ItemId", DbType.Int32, id);
            cmdParams.AddInParameter("@RuleType", DbType.Int32, ruleType);
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                if (reader.Read())
                {
                    return(CollectionPagingRuleInfo(reader));
                }
                return(new EasyOne.Model.Collection.CollectionPagingRuleInfo(true));
            }
        }
Ejemplo n.º 2
0
        public bool Delete(int commentId)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@CommentId", DbType.Int32, commentId);
            return(DBHelper.ExecuteSql("DELETE FROM PE_Comment WHERE CommentId = @CommentId", cmdParams));
        }
Ejemplo n.º 3
0
        public bool Add(DeliverChargeInfo deliverChargeInfo)
        {
            Parameters cmdParams = AddInCommonParameter(deliverChargeInfo);

            cmdParams.AddInParameter("@deliverTypeID", DbType.Int32, deliverChargeInfo.DeliverTypeId);
            return(DBHelper.ExecuteProc("PR_Shop_DeliverCharge_Add", cmdParams));
        }
Ejemplo n.º 4
0
        public void DeleteByCommentId(int commentId)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@CommentId", DbType.Int32, commentId);
            DBHelper.ExecuteSql("DELETE FROM PE_CommentPK WHERE CommentId = @CommentId", cmdParams);
        }
Ejemplo n.º 5
0
        public void Delete(int generalId)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            DBHelper.ExecuteSql("DELETE FROM PE_ContentPermission WHERE GeneralId = @GeneralId", cmdParams);
        }
Ejemplo n.º 6
0
        public bool Delete(int itemId)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@ItemId", DbType.Int32, itemId);
            return(DBHelper.ExecuteSql("DELETE FROM PE_BankrollItem WHERE [ItemId] = @ItemId", cmdParams));
        }
Ejemplo n.º 7
0
        public bool Update(BankrollItemInfo bankrollItemInfo)
        {
            Parameters cmdParams = GetParameters(bankrollItemInfo);

            cmdParams.AddInParameter("@ItemId", DbType.Int32, bankrollItemInfo.ItemId);
            return(DBHelper.ExecuteProc("PR_Accessories_BankrollItem_Update", cmdParams));
        }
Ejemplo n.º 8
0
        public bool Add(ADZoneInfo adZoneInfo)
        {
            Parameters cmdParams = GetParameters(adZoneInfo);

            cmdParams.AddInParameter("@ZoneId", DbType.Int32, GetMaxADZoneId());
            return(DBHelper.ExecuteProc("PR_Ad_ADZone_ADD", cmdParams));
        }
Ejemplo n.º 9
0
        public bool PauseADZone(string id)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@strZoneId", DbType.String, id);
            return(DBHelper.ExecuteProc("PR_AD_ADZone_Pause", cmdParams));
        }
Ejemplo n.º 10
0
        public bool Add(ContacterInfo contacterInfo)
        {
            Parameters parms = new Parameters();

            if (contacterInfo.ContacterId <= 0)
            {
                contacterInfo.ContacterId = DBHelper.GetMaxId("PE_Contacter", "ContacterID") + 1;
            }
            parms.AddInParameter("@ContacterID", DbType.Int32, contacterInfo.ContacterId);
            parms.AddInParameter("@ClientID", DbType.Int32, contacterInfo.ClientId);
            parms.AddInParameter("@ParentID", DbType.Int32, contacterInfo.ParentId);
            parms.AddInParameter("@CreateTime", DbType.DateTime, DateTime.Now);
            parms.AddInParameter("@Owner", DbType.String, contacterInfo.Owner);
            GetContacterParameters(contacterInfo, parms);
            return(DBHelper.ExecuteProc("PR_Crm_Contacter_Add", parms));
        }
Ejemplo n.º 11
0
        public bool Exists(int id)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@ItemId", DbType.Int32, id);
            return(DBHelper.ExistsSql("SELECT COUNT(*) FROM PE_CollectionListRules WHERE @ItemId = ItemId", cmdParams));
        }
Ejemplo n.º 12
0
        public bool Exists(string userName)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@UserName", DbType.String, userName);
            return(DBHelper.ExistsSql("SELECT COUNT(*) FROM PE_Contacter WHERE UserName = @UserName", cmdParams));
        }
Ejemplo n.º 13
0
        public bool Exists(int contacterId)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@ContacterID", DbType.Int32, contacterId);
            return(DBHelper.ExistsSql("SELECT COUNT(*) FROM PE_Contacter WHERE ContacterID = @ContacterID", cmdParams));
        }
Ejemplo n.º 14
0
        public bool DeleteByUserName(string userName)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@UserName", DbType.String, userName);
            return(DBHelper.ExecuteSql("DELETE FROM PE_Contacter WHERE UserName = @UserName", cmdParams));
        }
Ejemplo n.º 15
0
        public bool SaveConfig(StatInfoListInfo info)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@MasterTimeZone", DbType.Int32, info.MasterTimeZone);
            cmdParams.AddInParameter("@Interval", DbType.Int32, info.Interval);
            cmdParams.AddInParameter("@IntervalNum", DbType.Int32, info.IntervalNum);
            cmdParams.AddInParameter("@OnlineTime", DbType.Int32, info.OnlineTime);
            cmdParams.AddInParameter("@VisitRecord", DbType.Int32, info.VisitRecord);
            cmdParams.AddInParameter("@KillRefresh", DbType.Int32, info.KillRefresh);
            cmdParams.AddInParameter("@RegFields_Fill", DbType.String, info.RegFieldsFill);
            cmdParams.AddInParameter("@OldTotalNum", DbType.Int32, info.OldTotalNum);
            cmdParams.AddInParameter("@OldTotalView", DbType.Int32, info.OldTotalView);
            cmdParams.AddInParameter("@StartDate", DbType.String, info.StartDate);
            return(DBHelper.ExecuteNonQueryProc("PR_Analytics_SaveConfig", cmdParams) > 0);
        }
Ejemplo n.º 16
0
        public bool Update(ADZoneInfo adZoneInfo)
        {
            Parameters cmdParams = GetParameters(adZoneInfo);

            cmdParams.AddInParameter("@ZoneId", DbType.Int32, adZoneInfo.ZoneId);
            return(DBHelper.ExecuteProc("PR_AD_ADZone_UPDATE", cmdParams));
        }
Ejemplo n.º 17
0
        public bool VisitUpdate(int visitCount)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@visit", DbType.Int32, visitCount);
            return(DBHelper.ExecuteNonQueryProc("PR_Analytics_StatVisit_Update", cmdParams) > 0);
        }
Ejemplo n.º 18
0
        public bool ClearADZone(int id)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@ZoneId", DbType.Int32, id);
            return(DBHelper.ExecuteSql("DELETE FROM PE_Zone_Advertisement WHERE ZoneId = @ZoneId", cmdParams));
        }
Ejemplo n.º 19
0
        public bool Add(BankrollItemInfo bankrollItemInfo)
        {
            Parameters cmdParams = GetParameters(bankrollItemInfo);

            cmdParams.AddInParameter("@Memo", DbType.String, bankrollItemInfo.Memo);
            return(DBHelper.ExecuteProc("PR_Accessories_BankrollItem_Add", cmdParams));
        }
Ejemplo n.º 20
0
        public void UpdateReceive(int orderId)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@OrderID", DbType.Int32, orderId);
            DBHelper.ExecuteSql("UPDATE PE_DeliverItem SET Received = 1 WHERE OrderID = @OrderID AND Received = 0", cmdParams);
        }
Ejemplo n.º 21
0
        public void Delete(int pkId)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@PKId", DbType.Int32, pkId);
            DBHelper.ExecuteSql("DELETE FROM PE_CommentPK WHERE PKId = @PKId", cmdParams);
        }
Ejemplo n.º 22
0
        private static Parameters GetParameters(LogInfo logInfo)
        {
            Parameters parameters = new Parameters();

            parameters.AddInParameter("@Category", DbType.Int32, (int)logInfo.Category);
            parameters.AddInParameter("@Priority", DbType.Int32, logInfo.Priority);
            parameters.AddInParameter("@Title", DbType.String, logInfo.Title);
            parameters.AddInParameter("@Message", DbType.AnsiString, logInfo.Message);
            parameters.AddInParameter("@Timestamp", DbType.DateTime, logInfo.Timestamp);
            parameters.AddInParameter("@UserName", DbType.String, logInfo.UserName);
            parameters.AddInParameter("@UserIP", DbType.String, logInfo.UserIP);
            parameters.AddInParameter("@Source", DbType.AnsiString, logInfo.Source);
            parameters.AddInParameter("@ScriptName", DbType.String, logInfo.ScriptName);
            parameters.AddInParameter("@PostString", DbType.AnsiString, logInfo.PostString);
            return(parameters);
        }
Ejemplo n.º 23
0
        public bool Add(ReplyInfo info)
        {
            Parameters cmdParams = GetParameters(info);

            cmdParams.AddInParameter("@QuestionID", DbType.Int32, info.QuestionId);
            return(DBHelper.ExecuteSql("INSERT INTO PE_Reply(ID, QuestionID, ReplyCreator, ReplyTime, ReplyContent) VALUES (@ID, @QuestionID, @ReplyCreator, @ReplyTime, @ReplyContent)", cmdParams));
        }
Ejemplo n.º 24
0
        public bool Update(LogInfo logInfo)
        {
            Parameters cmdParams = GetParameters(logInfo);

            cmdParams.AddInParameter("@LogID", DbType.Int32, logInfo.LogId);
            return(DBHelper.ExecuteProc("PR_Accessories_Log_Update", cmdParams));
        }
Ejemplo n.º 25
0
        public bool Exists(int generalId)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            return(DBHelper.ExistsSql("SELECT COUNT(*) FROM PE_ContentPermission WHERE GeneralId = @GeneralId", cmdParams));
        }
Ejemplo n.º 26
0
        public IList <ProductPriceInfo> GetProductPriceById(int productId, string tableName)
        {
            IList <ProductPriceInfo> list = new List <ProductPriceInfo>();
            Parameters cmdParams          = new Parameters();

            cmdParams.AddInParameter("@TableName", DbType.String, tableName);
            cmdParams.AddInParameter("@ProductId", DbType.Int32, productId);
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT ID, GroupID, Price, PropertyValue FROM PE_ProductPrice WHERE TableName = @TableName AND ProductId = @ProductId", cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(ProductPriceFromrdr(reader));
                }
            }
            return(list);
        }
Ejemplo n.º 27
0
        public IList <DeliverChargeInfo> GetDeliverChargeListByAreaType(int typeId, int areaType)
        {
            IList <DeliverChargeInfo> list = new List <DeliverChargeInfo>();
            Parameters cmdParams           = new Parameters();

            cmdParams.AddInParameter("@typeId", DbType.Int32, typeId);
            cmdParams.AddInParameter("@areaType", DbType.Int32, areaType);
            using (NullableDataReader reader = DBHelper.ExecuteReaderProc("PR_Shop_DeliverCharge_GetListByAreaType", cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(CreateInfo(reader));
                }
            }
            return(list);
        }
Ejemplo n.º 28
0
        public bool SetPassedOfForbid(int surveyId)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@SurveyID", DbType.Int32, surveyId);
            return(DBHelper.ExecuteSql("UPDATE PE_Survey SET IsOpen = 1 WHERE SurveyID = @SurveyID", cmdParams));
        }
Ejemplo n.º 29
0
        public bool Update(DeliverChargeInfo deliverChargeInfo)
        {
            Parameters cmdParams = AddInCommonParameter(deliverChargeInfo);

            cmdParams.AddInParameter("@id", DbType.Int32, deliverChargeInfo.Id);
            return(DBHelper.ExecuteProc("PR_Shop_DeliverCharge_Update", cmdParams));
        }
Ejemplo n.º 30
0
        public bool Exists(string itemName)
        {
            Parameters cmdParams = new Parameters();

            cmdParams.AddInParameter("@ItemName", DbType.String, itemName);
            return(DBHelper.ExistsSql("SELECT COUNT(*) FROM PE_CollectionItem WHERE ItemName = @ItemName", cmdParams));
        }