<\/a>using System.Data;<\/p>\n\n\n\nusing System.Linq;<\/p>\n\n\n\n
using Dapper;<\/p>\n\n\n\n
using QSS.Contfakt.Data;<\/p>\n\n\n\n
public sealed class XInvoiceSellerWriter {<\/p>\n\n\n\n
private readonly IDbConnection _db;<\/p>\n\n\n\n
public XInvoiceSellerWriter(IDbConnection db) {<\/p>\n\n\n\n
_db = db;<\/p>\n\n\n\n
}<\/p>\n\n\n\n
public void Write(int documentId, string documentType, int mandantId) {<\/p>\n\n\n\n
var fields = _db.Query<XInvoiceFieldMap>(<\/p>\n\n\n\n
@“SELECT *<\/p>\n\n\n\n
FROM dbo.xinvoice_field_map<\/p>\n\n\n\n
WHERE section = ‚SELLER'“<\/p>\n\n\n\n
).ToList();<\/p>\n\n\n\n
_db.Execute(@“<\/p>\n\n\n\n
DELETE FROM dbo.xinvoice_data<\/p>\n\n\n\n
WHERE document_id = @DocId<\/p>\n\n\n\n
AND document_type = @DocType<\/p>\n\n\n\n
AND party_role = ‚SELLER'“,<\/p>\n\n\n\n
new { DocId = documentId, DocType = documentType });<\/p>\n\n\n\n
foreach (var f in fields) {<\/p>\n\n\n\n
if (string.IsNullOrWhiteSpace(f.SourceTable) ||<\/p>\n\n\n\n
string.IsNullOrWhiteSpace(f.SourceField) ||<\/p>\n\n\n\n
string.IsNullOrWhiteSpace(f.BtCode))<\/p>\n\n\n\n
throw new InvalidOperationException(<\/p>\n\n\n\n
$“Invalid mapping row for BT {f.BtCode}“);<\/p>\n\n\n\n
var sql = $@“<\/p>\n\n\n\n
SELECT [{f.SourceField}]<\/p>\n\n\n\n
FROM tv.[{f.SourceTable}]<\/p>\n\n\n\n
WHERE MandantenNummer = @MandantID“;<\/p>\n\n\n\n
var value = _db.ExecuteScalar(sql, new { MandantID = mandantId });<\/p>\n\n\n\n
InsertValue(documentId, documentType, f, value);<\/p>\n\n\n\n
}<\/p>\n\n\n\n
}<\/p>\n\n\n\n
private void InsertValue(<\/p>\n\n\n\n
int documentId,<\/p>\n\n\n\n
string documentType,<\/p>\n\n\n\n
XInvoiceFieldMap f,<\/p>\n\n\n\n
object value) {<\/p>\n\n\n\n
const string sql = @“<\/p>\n\n\n\n
INSERT INTO dbo.xinvoice_data<\/p>\n\n\n\n
(document_id, document_type, party_role, bt_code,<\/p>\n\n\n\n
value_text, value_number, value_date)<\/p>\n\n\n\n
VALUES<\/p>\n\n\n\n
(@DocId, @DocType, ‚SELLER‘, @Bt,<\/p>\n\n\n\n
@Text, @Number, @Date)“;<\/p>\n\n\n\n
_db.Execute(sql, new {<\/p>\n\n\n\n
DocId = documentId,<\/p>\n\n\n\n
DocType = documentType,<\/p>\n\n\n\n
Bt = f.BtCode,<\/p>\n\n\n\n
Text = f.ValueType == „text“ ? value : null,<\/p>\n\n\n\n
Number = f.ValueType == „number“ ? value : null,<\/p>\n\n\n\n
Date = f.ValueType == „date“ ? value : null<\/p>\n\n\n\n
});<\/p>\n\n\n\n
}<\/p>\n\n\n\n
}<\/p>\n<\/blockquote>\n\n\n\n
Hey, was hast Du, alter Mann, es l\u00e4uft doch ….<\/p>\n\n\n\n
100:1 das wird Code mit dem wir Alten uns in naher Zukunft rum\u00e4ergern m\u00fcssen\/d\u00fcrfen.<\/p>\n\n\n\n
Wirklich?<\/p>\n","protected":false},"excerpt":{"rendered":"
Hier ein Beispiel zu meinem vorletzten Eintrag. Wieder nur f\u00fcr Programmierer: Schauen Sie sich das mal an (chatgtp generierter Code) using System; using System.Data; using System.Linq; using Dapper; using QSS.Contfakt.Data; public sealed class XInvoiceSellerWriter { private readonly IDbConnection _db; public XInvoiceSellerWriter(IDbConnection db) { _db = db; } public void Write(int documentId, string documentType, int mandantId) […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7995],"tags":[],"class_list":["post-19376","post","type-post","status-publish","format-standard","hentry","category-information"],"_links":{"self":[{"href":"https:\/\/www.q-software-solutions.de\/blog\/wp-json\/wp\/v2\/posts\/19376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.q-software-solutions.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.q-software-solutions.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.q-software-solutions.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.q-software-solutions.de\/blog\/wp-json\/wp\/v2\/comments?post=19376"}],"version-history":[{"count":1,"href":"https:\/\/www.q-software-solutions.de\/blog\/wp-json\/wp\/v2\/posts\/19376\/revisions"}],"predecessor-version":[{"id":19377,"href":"https:\/\/www.q-software-solutions.de\/blog\/wp-json\/wp\/v2\/posts\/19376\/revisions\/19377"}],"wp:attachment":[{"href":"https:\/\/www.q-software-solutions.de\/blog\/wp-json\/wp\/v2\/media?parent=19376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.q-software-solutions.de\/blog\/wp-json\/wp\/v2\/categories?post=19376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.q-software-solutions.de\/blog\/wp-json\/wp\/v2\/tags?post=19376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}