Voeg Checkboxes, Teks Invoer, Of Beelde

Die samesmelting enjin neem’n dokument as insette, soek vir MERGEFIELD velde in dit, en vervang hulle met die data verkry uit die data bron. Gewoonlik word gewone teks en HTML ingevoeg, maar Aspose.Words gebruikers kan ook’n dokument genereer wat meer ongewone scenario’s vir Mail Merge velde hanteer.

Kragtige Aspose.Words funksionaliteit laat jou toe om die Mail Merge proses uit te brei:

• voeg merkblokkies en teksinvoervormvelde in die dokument in tydens a mail merge
• voeg beelde van enige persoonlike stoor (lêers, BLOB velde, ens.)

Voeg Checkboxes en Teks Invoer gedurende Mail Merge

Soms is dit nodig om’n Mail Merge operasie uit te voer sodat nie teks vervang word in die samesmelting veld, maar’n boks of teks invoer veld. Alhoewel dit nie die algemeenste scenario is nie, is dit baie handig vir sommige take.

Die volgende skermkiekie van’n Word dokument toon’n sjabloon met merge velde:

Hierdie skermkiekie van die Word-dokument hieronder wys die reeds gegenereerde dokument:

Let daarop dat sommige velde vervang is met gewone teks, sommige velde is vervang met boks vorm velde, en die Subject veld is vervang met’n teks invoer veld.

Die volgende kode voorbeeld toon hoe om te voeg boks en invoer teks velde in’n dokument tydens’n mail merge:

// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git.
Document doc = new Document(MyDir + "Mail merge destinations - Fax.docx");

// Setup mail merge event handler to do the custom work.
doc.MailMerge.FieldMergingCallback = new HandleMergeField();
// Trim trailing and leading whitespaces mail merge values.
doc.MailMerge.TrimWhitespaces = false;

string[] fieldNames = {
    "RecipientName", "SenderName", "FaxNumber", "PhoneNumber",
    "Subject", "Body", "Urgent", "ForReview", "PleaseComment"
};

object[] fieldValues = {
    "Josh", "Jenny", "123456789", "", "Hello",
    "<b>HTML Body Test message 1</b>", true, false, true
};

doc.MailMerge.Execute(fieldNames, fieldValues);

doc.Save(ArtifactsDir + "WorkingWithFields.MailMergeFormFields.docx");

// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git.
private class HandleMergeField : IFieldMergingCallback
{
    /// <summary>
    /// This handler is called for every mail merge field found in the document,
    /// for every record found in the data source.
    /// </summary>
    void IFieldMergingCallback.FieldMerging(FieldMergingArgs e)
    {
        if (mBuilder == null)
            mBuilder = new DocumentBuilder(e.Document);

        // We decided that we want all boolean values to be output as check box form fields.
        if (e.FieldValue is bool)
        {
            // Move the "cursor" to the current merge field.
            mBuilder.MoveToMergeField(e.FieldName);

            string checkBoxName = $"{e.FieldName}{e.RecordIndex}";

            mBuilder.InsertCheckBox(checkBoxName, (bool) e.FieldValue, 0);

            return;
        }

        switch (e.FieldName)
        {
            case "Body":
                mBuilder.MoveToMergeField(e.FieldName);
                mBuilder.InsertHtml((string) e.FieldValue);
                break;
            case "Subject":
            {
                mBuilder.MoveToMergeField(e.FieldName);
                string textInputName = $"{e.FieldName}{e.RecordIndex}";
                mBuilder.InsertTextInput(textInputName, TextFormFieldType.Regular, "", (string) e.FieldValue, 0);
                break;
            }
        }
    }

    void IFieldMergingCallback.ImageFieldMerging(ImageFieldMergingArgs args)
    {
        args.ImageFileName = "Image.png";
        args.ImageWidth.Value = 200;
        args.ImageHeight = new MergeFieldImageDimension(200, MergeFieldImageDimensionUnit.Percent);
    }

    private DocumentBuilder mBuilder;
}

Voeg Beelde in tydens Mail Merge

Wanneer u’n Mail Merge - bewerking uitvoer, kan u beelde uit die databasis in die dokument invoeg met behulp van spesiale beeld Mail Merge - velde. Die beeld Mail Merge veld is’n samesmelting veld genoem Beeld:MyFieldName.

Voeg Beelde van’n Databasis in

Tydens’n mail merge, wanneer’n beeld Mail Merge veld in’n dokument teëgekom word, word die FieldMergingCallback gebeurtenis afgevuur. U kan op hierdie gebeurtenis reageer om’n lêernaam, stroom of beeldvoorwerp na die Mail Merge - enjin terug te stuur sodat dit in die dokument ingevoeg kan word.

Die volgende kode voorbeeld toon hoe om beelde gestoor in’n databasis BLOB veld in’n verslag in te voeg:

// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git.
Document doc = new Document(MyDir + "Mail merge destination - Northwind employees.docx");

doc.MailMerge.FieldMergingCallback = new HandleMergeImageFieldFromBlob();

string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + DatabaseDir + "Northwind.accdb";
OleDbConnection conn = new OleDbConnection(connString);
conn.Open();

OleDbCommand cmd = new OleDbCommand("SELECT * FROM Employees", conn);
IDataReader dataReader = cmd.ExecuteReader();

doc.MailMerge.ExecuteWithRegions(dataReader, "Employees");

conn.Close();
            
doc.Save(ArtifactsDir + "WorkingWithFields.MailMergeImageFromBlob.docx");

// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git.
public class HandleMergeImageFieldFromBlob : IFieldMergingCallback
{
    void IFieldMergingCallback.FieldMerging(FieldMergingArgs args)
    {
        // Do nothing.
    }

    /// <summary>
    /// This is called when mail merge engine encounters Image:XXX merge field in the document.
    /// You have a chance to return an Image object, file name, or a stream that contains the image.
    /// </summary>
    void IFieldMergingCallback.ImageFieldMerging(ImageFieldMergingArgs e)
    {
        // The field value is a byte array, just cast it and create a stream on it.
        MemoryStream imageStream = new MemoryStream((byte[]) e.FieldValue);
        // Now the mail merge engine will retrieve the image from the stream.
        e.ImageStream = imageStream;
    }
}

Stel Beeldeienskappe gedurende Mail Merge

Terwyl jy’n beeldversmelte veld saamvoeg, moet jy dalk soms verskeie beeldeienskappe beheer, soos WrapType.

Tans, met behulp van ImageFieldMergingArgs jy kan slegs stel beeld breedte of hoogte eienskappe, onderskeidelik. Om hierdie probleem te oorkom, bied Aspose.Words die Shape eienskap, wat dit makliker maak om volle beheer oor die ingevoegde beeld of enige ander vorm te kry.

Die volgende kode voorbeeld toon hoe om verskeie beeld eienskappe stel:

// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git.
Document doc = new Document();
DocumentBuilder builder = new DocumentBuilder(doc);

builder.Writeln("{{#foreach example}}");
builder.Writeln("{{Image(126pt;126pt):stempel}}");
builder.Writeln("{{/foreach example}}");

doc.MailMerge.UseNonMergeFields = true;
doc.MailMerge.TrimWhitespaces = true;
doc.MailMerge.UseWholeParagraphAsRegion = false;
doc.MailMerge.CleanupOptions = MailMergeCleanupOptions.RemoveEmptyTableRows
        | MailMergeCleanupOptions.RemoveContainingFields
        | MailMergeCleanupOptions.RemoveUnusedRegions
        | MailMergeCleanupOptions.RemoveUnusedFields;

doc.MailMerge.FieldMergingCallback = new ImageFieldMergingHandler();
doc.MailMerge.ExecuteWithRegions(new DataSourceRoot());

doc.Save(ArtifactsDir + "WorkingWithFields.MailMergeImageField.docx");

// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git.
private class ImageFieldMergingHandler : IFieldMergingCallback
{
    void IFieldMergingCallback.FieldMerging(FieldMergingArgs args)
    {
        //  Implementation is not required.
    }

    void IFieldMergingCallback.ImageFieldMerging(ImageFieldMergingArgs args)
    {
        Shape shape = new Shape(args.Document, ShapeType.Image)
        {
            Width = 126, Height = 126, WrapType = WrapType.Square
        };

        shape.ImageData.SetImage(MyDir + "Mail merge image.png");

        args.Shape = shape;
    }
}

// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git.
public class DataSourceRoot : IMailMergeDataSourceRoot
{
    public IMailMergeDataSource GetDataSource(string s)
    {
        return new DataSource();
    }

    private class DataSource : IMailMergeDataSource
    {
        private bool next = true;

        string IMailMergeDataSource.TableName => TableName();

        private string TableName()
        {
            return "example";
        }

        public bool MoveNext()
        {
            bool result = next;
            next = false;
            return result;
        }

        public IMailMergeDataSource GetChildDataSource(string s)
        {
            return null;
        }

        public bool GetValue(string fieldName, out object fieldValue)
        {
            fieldValue = null;
            return false;
        }
    }
}