Example #1
0
        private void ProcessKeyword(ImpressionRecord record, ProcessKeywordMode mode)
        {
            //更新关键字模式,如果这个文章并不需要处理,直接退出
            if (mode == ProcessKeywordMode.TryUpdateKeyword)
            {
                if (AllSettings.Current.ContentKeywordSettings.ReplaceKeywords.NeedUpdate(record) == false)
                {
                    return;
                }
            }

            ImpressionRecordCollection records = new ImpressionRecordCollection();

            records.Add(record);

            ProcessKeyword(records, mode);
        }
Example #2
0
        public override RevertableCollection <ImpressionRecord> GetImpressionRecordsWithReverters(int[] impressionTypeIDs)
        {
            if (ValidateUtil.HasItems(impressionTypeIDs) == false)
            {
                return(null);
            }

            RevertableCollection <ImpressionRecord> records = new RevertableCollection <ImpressionRecord>();

            using (SqlQuery query = new SqlQuery())
            {
                query.CommandText = @"
SELECT 
    B.*,
	A.Text,
    A.KeywordVersion,
	TextReverter = ISNULL(R.TextReverter, '')
FROM 
    bx_ImpressionRecords AS B
LEFT JOIN
	bx_ImpressionTypes AS A WITH(NOLOCK) ON A.TypeID = B.TypeID
LEFT JOIN 
	bx_ImpressionTypeReverters AS R WITH(NOLOCK) ON R.TypeID = A.TypeID
WHERE 
	B.TypeID IN (@TypeIDs)"    ;

                query.CreateInParameter <int>("@TypeIDs", impressionTypeIDs);

                using (XSqlDataReader reader = query.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        string textReverter = reader.Get <string>("TextReverter");

                        ImpressionRecord record = new ImpressionRecord(reader);

                        records.Add(record, textReverter);
                    }
                }
            }

            return(records);
        }
Example #3
0
        public override RevertableCollection<ImpressionRecord> GetImpressionRecordsWithReverters(int[] impressionTypeIDs)
        {
            if (ValidateUtil.HasItems(impressionTypeIDs) == false)
                return null;

            RevertableCollection<ImpressionRecord> records = new RevertableCollection<ImpressionRecord>();

            using (SqlQuery query = new SqlQuery())
            {
                query.CommandText = @"
SELECT 
    B.*,
	A.Text,
    A.KeywordVersion,
	TextReverter = ISNULL(R.TextReverter, '')
FROM 
    bx_ImpressionRecords AS B
LEFT JOIN
	bx_ImpressionTypes AS A WITH(NOLOCK) ON A.TypeID = B.TypeID
LEFT JOIN 
	bx_ImpressionTypeReverters AS R WITH(NOLOCK) ON R.TypeID = A.TypeID
WHERE 
	B.TypeID IN (@TypeIDs)";

                query.CreateInParameter<int>("@TypeIDs", impressionTypeIDs);

                using (XSqlDataReader reader = query.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        string textReverter = reader.Get<string>("TextReverter");

                        ImpressionRecord record = new ImpressionRecord(reader);

                        records.Add(record, textReverter);
                    }
                }
            }

            return records;
        }