{"Type":0,"Id":"f99866dc-f410-4a25-9edb-1645542610c3","Text":"Artikels","Image":"iVBORw0KGgoAAAANSUhEUgAAACgAAAAoCAYAAACM/rhtAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwwAADsMBx2+oZAAAAadJREFUWEftylGKRFEIA9G3/03PgBSahGyg4Z4vtfye5/l1f9BZzRM4VdnbnkiGtO0GOar5Bqcqe9sTyZC23SBHNd/gVGVveyIZ0rYb5KjmG5yq7G1PJEPadoMc1XyDU5W97YlkSNtukKOab3Cqsrc9kQxp2w1yVPMNTlX2tieSIW27QY5qvsGpyt72RDKkbTfIUc03OFXZ255IhrTtBjmq+QanKnvbE8mQtt0gRzXf4FRlb3siGdK2G+So5hucquxtTyRD2naDHNV8g1OVve2JZEjbbpCjmm9wqrK3PZEMadsNclTzDU5V9rYnkiFtu0GOar7Bqcre9kQypG03yFHNNzhV2dueSIa07QY5qvkGpyp72xPJkLbdIEc13+BUZW97IhnSthvkqOYbnKrsbU8kQ9p2gxzVfINTlb3tiWRI226Qo5pvcKqytz2RDGnbDXJU8w1OVfa2J5IhbbtBjmq+wanK3vZEMqRtN8hRzTc4VdnbnkiGtO0GOar5Bqcqe9sTyZC23SBHNd/gVGVveyIZ0rYb5KjmG5yq7G1PJEPaxvo8z4/6vn8ibsTWg8bdlwAAAABJRU5ErkJggg==","FormXaml":"\r\n\t\r\n\t\t\r\n\t\t\r\n\t\r\n\t\r\n\t\t\r\n","FormQuery":"if @key=''\r\n\traiserror('U dient minstens één zoeksleutel op te geven!',16,1 )\r\n\r\ndeclare @cle1Lib char(250), @cle2Lib char(250), @cle3Lib char(250)\r\n\r\nselect @cle1Lib = isnull(rtrim(valeur),'Interne code') from options where type = 'CLE1_S_N'\r\n\t\r\nif @sommeil=1\r\nselect dbo.XDESIGN_F(s_id) as modele,rtrim(@cle1Lib)+' : '+rtrim(s_cle1) as s_cle1,'Prijs excl. : '+ltrim(dbo.transform(s_prix_ht,'999 999.99')) as s_prix_ht,s_id \r\n\t\tfrom STOCK \r\n\t\twhere (s_modele like '%'+@key+'%') or (s_cle1 like '%'+@key+'%') or (s_cle2 like '%'+@key+'%') or (s_cle3 like '%'+@key+'%')\r\n\t\torder by s_modele\r\nelse\r\n\tselect dbo.XDESIGN_F(s_id) as modele,rtrim(@cle1Lib)+' : '+rtrim(s_cle1) as s_cle1,'Prijs excl. : '+ltrim(dbo.transform(s_prix_ht,'999 999.99')) as s_prix_ht,s_id \r\n\t\tfrom STOCK \r\n\t\twhere ((s_modele like '%'+@key+'%') or (s_cle1 like '%'+@key+'%') or (s_cle2 like '%'+@key+'%') or (s_cle3 like '%'+@key+'%'))\r\n\t\tand (s_sommeil=0)\r\n\t\torder by s_modele","Steps":[{"ViewCellXaml":"