manuelbl / SwissQRBill.NET

.NET library for Swiss QR bill payment slips (aka QR-Rechnung)
MIT License
88 stars 33 forks source link

Question: Can "UnstructuredMessage" contain text with \r\n ? #42

Closed ststeiger closed 2 years ago

ststeiger commented 2 years ago

I'm porting an old red invoice to QR. AFAIK, the whole conceptually not thought through QR thing is new-line sensitive. But SwissQRBill.Generator.Bill.UnstructuredMessage allows messages with newlines. Is this correct ?

RPT_ES_Zweck => UnstructuredMessage

SELECT [...]
    ,
    'Rechnungs-Nr. '
    +
    FORMAT(KZ_Druck_Datum, 'yyyy')
    +
    '_'
    + 
    CASE
        WHEN LEN(KZ_Druck_Auftragsnummer) > 4 THEN FORMAT(KZ_Druck_Auftragsnummer, '00000')
        WHEN LEN(KZ_Druck_Auftragsnummer) > 3 THEN FORMAT(KZ_Druck_Auftragsnummer, '0000')
        ELSE FORMAT(KZ_Druck_Auftragsnummer, '000')
    END
    +
    CHAR(10) + CHAR(13)
    +
    'KOA 8300 9901/PC DL-IT'
    +
    CHAR(10) + CHAR(13)
    +
    'Copycenter'
    AS RPT_ES_Zweck
FROM [...] 
ststeiger commented 2 years ago

Ah I see, it removes the newline. Changing data - Wonderful...