Gestor 49T1CeMLG+3CFYRUZHTvXoYajyvnA8tt4kOhCE1MrWPHwM/rQ12jpO1tpeToKOEv6BSNLVpLAfXtWxUAYwBhe8PIaStPXfvdcUCs Gestor config nome_fantasia,System.String cnpj_cpf,System.String logradouro,System.String numero,System.String bairro,System.String uf,System.String telefone,System.String ie_rg,System.String cidade,System.String razao_social,System.String 30 False config Gestor select config.nome_fantasia, config.cnpj_cpf, config.ie_rg, config.logradouro, config.numero, config.bairro, config.uf, config.telefone, UPPER(cid.nome) as cidade, config.razao_social from configuracao config left join cidade cid on cid.id = config.cidade_id itens id,System.Int32 descricao,System.String UN,System.String quantidade,System.Decimal valor_unitario,System.Decimal valor_total,System.Decimal VLTributo,System.String base_legal_estadual,System.String base_legal_federal,System.String 30 False itens Gestor select prod.id, item.descricao, 'UN', item.quantidade, item.valor_unitario, item.valor_total, '0' as VLTributo,prod.base_legal_estadual, prod.base_legal_federal from nota_fiscal_item item inner join produto prod on prod.id = item.produto_id where item.nota_fiscal_id = {nota_fiscal_id} nota destinatario_nome,System.String destinatario_cnpjcpf,System.String destinatario_endereco,System.String destinatario_bairro,System.String destinatario_cidade,System.String destinatario_uf,System.String serie,System.String valor_produtos,System.Decimal desconto,System.Decimal valor_nota,System.Decimal chave_acesso,System.String protocolo,System.String protocolo_dh,System.String numero,System.String data_emissao,System.DateTime data_ent_sai,System.DateTime valor_tributos,System.Decimal endereco_consulta,System.String tipo_emissao,System.String 30 False nota Gestor select CONCAT(cor.razao_social, COALESCE(CONCAT(' - ', nf.destinatario_cnpjcpf, ''), ''), COALESCE(CONCAT(' - ', nf.destinatario_endereco), ''), COALESCE(CONCAT(', ', nf.destinatario_numero), ''), COALESCE(CONCAT(' - BAIRRO ', nf.destinatario_bairro), ''), COALESCE(CONCAT(' - ', UPPER(cid_dest.nome)), ''), COALESCE(CONCAT('/', cid_dest.uf), '')) AS destinatario_nome, nf.destinatario_cnpjcpf, nf.destinatario_endereco, nf.destinatario_bairro, UPPER(cid_dest.nome) as destinatario_cidade,nf.destinatario_uf,nf.serie, nf.valor_produtos,nf.desconto,nf.valor_nota, nf.chave_acesso,nf.protocolo,nf.protocolo_dh,nf.numero,nf.data_emissao,nf.data_ent_sai, nf.valor_tributos, nf.endereco_consulta, nf.tipo_emissao from nota_fiscal nf left join correntista cor on cor.id = nf.cliente_id left join cidade cid_dest on cid_dest.id = nf.destinatario_cidade_id where nf.id = {nota_fiscal_id} faturas descricao,System.String valor,System.Decimal 30 False faturas Gestor select titulo.descricao, fatura.valor from nota_fiscal_fatura fatura inner join titulo on titulo.id = fatura.titulo_id where fatura.nota_fiscal_id = {nota_fiscal_id} ,nota_fiscal_id,nota_fiscal_id,numero_x0020_da_x0020_nota_x0020_fiscal,System.Int32,,False,False,True EngineV2 qrCode.AutoScale = true; // Só exibir mensagem de contingência quando precisar dtContingencia.Enabled = nota.tipo_emissao == "9 - Contingência off-line da NFC-e"; None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,7.5,3 Transparent 0.2,0,7.4,1.6 Arial,8.25,Regular,Point,False,0 Center 0,0,0,0 Text4 {config.nome_fantasia} {config.razao_social} CNPJ: {config.cnpj_cpf} - IE: {config.ie_rg} {config.logradouro} {config.numero} - {config.cidade}/{config.uf} Telefone: {config.telefone} Black Expression Transparent 0.2,1.6,7.4,1.4 Arial,6.75,Bold,Point,False,0 Center 0,0,0,0 Text9 DANFE NFC-e - Documento Auxiliar da Nota Fiscal Eletrônica de Consumidor Eletrônica NFC-e não permite aproveitamento de crédito ICMS Black ,,,,WordWrap=True,A=0 Expression Center 0.2,1.7,7.4,0.0254 Black Black HorizontalLinePrimitive1 Black 0.2,3,7.4,0.0254 Black Black 931b3f2590534e3ba16fd809a4dedb87 HorizontalLinePrimitive2 Black ReportTitleBand1 Transparent 0,4.2,7.5,0.5 Transparent 0.2,0,1,0.5 Arial,8.25,Regular,Point,False,0 0,0,0,0 Text12 Código Black Expression Transparent 1.2,0,2.6,0.5 Arial,8.25,Regular,Point,False,0 28e950b49218481e86a5c5f4cb8c89cd 0,0,0,0 Text13 Descrição Black Expression Transparent 4.4,0,0.8,0.5 Arial,8.25,Regular,Point,False,0 52c2ec6ec40b487487b29fbe56014d54 Right 0,0,0,0 Text15 Qtde Black Expression Transparent 5.2,0,1.2,0.5 Arial,8.25,Regular,Point,False,0 5e0e7a798ebe4071a203118147c42349 Right 0,0,0,0 Text17 Vlr unit. Black Expression Transparent 6.4,0,1,0.5 Arial,8.25,Regular,Point,False,0 5e35de85013345798149afcb39405ad1 Right 0,0,0,0 Text19 Vlr total Black Expression Transparent 3.8,0,0.6,0.5 Arial,8.25,Regular,Point,False,0 61edbb56089a48f6bb91fdd5a4dab001 Center 0,0,0,0 Text16 UN Black Expression 0.2,0.5,7.4,0.0254 Black Black 2a53a9ff0b184a10b8bf71a01bce046c HorizontalLinePrimitive4 Black HeaderBand1 Transparent 0,5.5,7.5,0.4 Transparent True 0.2,0,1,0.4 Arial,6,Bold,Point,False,0 0,0,0,0 Dataitens_id {itens.id} Black ,,,,WordWrap=True,A=0 Center True Transparent True 1.2,0,2.6,0.4 Arial,6,Bold,Point,False,0 0,0,0,0 Dataitens_descricao {itens.descricao}{IIF(!String.IsNullOrEmpty(itens.base_legal_estadual) || !String.IsNullOrEmpty(itens.base_legal_federal), "<br>", "")} <font size=6> {IIF(!String.IsNullOrEmpty(itens.base_legal_federal), itens.base_legal_federal, "")}</font> Black ,,,,WordWrap=True,A=0 Wysiwyg Expression Center Transparent True 3.8,0,0.6,0.4 Arial,6,Bold,Point,False,0 0,0,0,0 Dataitens_UN {itens.UN} Black ,,,,WordWrap=True,A=0 Center Transparent True 4.4,0,0.8,0.4 Arial,6,Bold,Point,False,0 Right 0,0,0,0 Dataitens_quantidade {itens.quantidade} Black , . 1 False ,,,,WordWrap=True,A=0 Center Transparent True 5.2,0,1.2,0.4 Arial,6,Bold,Point,False,0 Right 0,0,0,0 Dataitens_valor_unitario {itens.valor_unitario} Black , . 1 False ,,,,WordWrap=True,A=0 Center Transparent True 6.4,0,1,0.4 Arial,6,Bold,Point,False,0 Right 0,0,0,0 Dataitens_valor_total {itens.valor_total} Black , . 1 ,,,,WordWrap=True,A=0 Center itens Dataitens Transparent 0,6.7,7.5,4 Transparent 0.4,0.49,3.8,0.5 Arial,9.75,Regular,Point,False,0 f1c2547c85e145ca913798ee86ac51ac 0,0,0,0 Text21 VALOR BRUTO Black Expression Transparent 0.4,1,3.8,0.5 Arial,9.75,Regular,Point,False,0 968172dec74b4439827c6dd710ac5d68 0,0,0,0 Text22 VALOR DESCONTO Black Expression Transparent 0.4,1.6,3.8,0.5 Arial,9.75,Regular,Point,False,0 6c1764d130c0421395b78ad7d40774a5 0,0,0,0 Text23 VALOR TOTAL R$ Black Expression Transparent 0.4,2.2,3.8,0.5 Arial,9.75,Regular,Point,False,0 f8e6f6bacff5440a880533f6b516bf1a 0,0,0,0 Text24 VALOR PAGO Black Expression Transparent 0.4,2.8,3.8,0.5 Arial,9.75,Regular,Point,False,0 ca1659f9cd484ea8aaee113ebb1e7d62 0,0,0,0 Text25 VALOR TROCO Black Expression Transparent 0.2,3.6,4.2,0.5 Arial,9,Regular,Point,False,0 75f1862fd1f14cb981716e9e38514d2a 0,0,0,0 Text26 FORMA DE PAGAMENTO Black Expression Transparent 4.4,3.6,3,0.5 Arial,9,Regular,Point,False,0 b14631d98c2540d7ab386e20d6620ed0 Right 0,0,0,0 Text28 VALOR PAGO Black Expression Transparent True 4.2,0.49,3.2,0.4 Arial,9.75,Bold,Point,False,0 Right 0,0,0,0 Dataitens_VLTributo {nota.valor_produtos} Black , . 9 2 R$ False ,,,,WordWrap=True,A=0 DataColumn Center Transparent True 4.2,1.1,3.2,0.4 Arial,9.75,Bold,Point,False,0 83ff9a18b40a4a83a801182d715ff9f2 Right 0,0,0,0 Text10 {nota.desconto} Black , . 9 2 R$ False ,,,,WordWrap=True,A=0 DataColumn Center Transparent True 4.2,1.7,3.2,0.4 Arial,9.75,Bold,Point,False,0 5e273eddd0b7457fb52825e1c45357b2 Right 0,0,0,0 Text11 {nota.valor_nota} Black , . 9 2 R$ False ,,,,WordWrap=True,A=0 DataColumn Center Transparent True 4.2,2.3,3.2,0.4 Arial,9.75,Bold,Point,False,0 4d1ea39538ea4709ba45d7752451d278 Right 0,0,0,0 Text18 {nota.valor_nota} Black , . 9 2 R$ False ,,,,WordWrap=True,A=0 DataColumn Center Transparent True 4.2,2.9,3.2,0.4 Arial,9.75,Bold,Point,False,0 25ee6de6a924467ebb3f8ddad31678d0 Right 0,0,0,0 Text37 R$ 0,00 Black , . 9 2 R$ False ,,,,WordWrap=True,A=0 Expression Center 0.2,0.5,7.4,0.0254 Black Black 432b51b217f94c839fca3f2866b77c36 HorizontalLinePrimitive7 Black 0.2,3.3,7.4,0.0254 Black Black 239a50289ef4406da0c4852c4f3279de HorizontalLinePrimitive8 Black FooterBand1 Transparent 0,11.5,7.5,0.4 Transparent 0.2,0,4.2,0.5 Arial,8.25,Regular,Point,False,0 bb8c8f5f8b9949a489bb8441f2a44670 0,0,0,0 Text38 {faturas.descricao} Black Expression Transparent 4.6,0,2.8,0.5 Arial,8.25,Regular,Point,False,0 d2c78b85d0064030a67713d9523e5f5d Right 0,0,0,0 Text39 {faturas.valor} Black , . 9 2 R$ Expression faturas DataBand1 Transparent 0,12.7,7.5,0.6 Transparent 0.2,0.1,7.4,0.5 Arial,8.25,Bold,Point,False,0 f2974674a406453c98d95865a049c71a Center 0,0,0,0 Text1 NFC-e emitida em contingência Black Expression dtContingencia Transparent 0,14.1,7.5,10.4 Transparent 0.2,0,4.8,0.5 Arial,9,Regular,Point,False,0 5d6de3c5c82c436dade8f88ab750702e 0,0,0,0 Text29 Vlr aprox. tributos (Lei 12.741/12) Black Expression Transparent 5,0,2.4,0.5 Arial,8.25,Regular,Point,False,0 830574c4c7034b688af7e9576ce8404a Right 0,0,0,0 Text20 {nota.valor_tributos} Black , . 9 2 R$ Expression Transparent 4.2,0.6,1,0.5 Arial,9,Regular,Point,False,0 ae141011e8b24c369d95a93e103e6bcc 0,0,0,0 Text31 Série: Black Expression Transparent 5.2,0.6,1,0.5 Arial,9,Bold,Point,False,0 e2b73203bf764e8e9e9f733f4fbbbf58 0,0,0,0 Text27 {nota.serie} Black Expression Transparent 0.2,0.6,1.6,0.5 Arial,9,Regular,Point,False,0 c56af24324dc46af9d9e422bee9b98c3 0,0,0,0 Text30 NFC-e Nº: Black Expression Transparent 1.8,0.6,2.4,0.5 Arial,9,Bold,Point,False,0 84e84f4ed1b249a2adce6da6b2c4d2ab 0,0,0,0 Text40 {nota.numero} Black DataColumn Transparent 0.2,1,1.6,0.5 Arial,9,Regular,Point,False,0 c0e89a0d414a4ed3925e87616df3211d 0,0,0,0 Text32 Emissão: Black Expression Transparent 1.8,1,2.6,0.5 Arial,9,Bold,Point,False,0 26b1a1c9986644e1a8f4735895b10a0a 0,0,0,0 Text41 {Format("{0:dd/MM/yyyy}", nota.data_emissao)} Black Expression Transparent 0.2,3.9,7.4,0.5 Microsoft Sans Serif,6.75,Regular,Point,False,0 250bfc9d4f954ea6a4f6e6bc6a9b3c72 Center 0,0,0,0 Text34 Consulte pela Chave de Acesso em http://www.nfce.sefin.ro.gov.br Black Expression Transparent 0.2,1.4,7.4,0.5 Arial,8.25,Regular,Point,False,0 cfe68497b09f4f2aad62f51d0be5d2ad Center 0,0,0,0 Text35 Chave de Acesso Black Expression Transparent 0.2,1.9,7.4,0.7 Arial,6.75,Bold,Point,False,0 f46046b4b0d24989b7892ffe4f7cb23a Center 0,0,0,0 Text42 {Length(nota.chave_acesso) == 44 ? Mid(nota.chave_acesso,0,4) + ' ' + Mid(nota.chave_acesso,4,4) + ' ' + Mid(nota.chave_acesso,8,4) + ' ' + Mid(nota.chave_acesso,12,4) + ' ' + Mid(nota.chave_acesso,16,4) + ' ' + Mid(nota.chave_acesso,20,4) + ' ' + Mid(nota.chave_acesso,24,4) + ' ' + Mid(nota.chave_acesso,28,4) + ' ' + Mid(nota.chave_acesso,32,4) + ' ' + Mid(nota.chave_acesso,36,4) + ' ' + Mid(nota.chave_acesso,40,4) + ' ' : nota.chave_acesso} Black Expression Transparent True True 0.2,2.8,7.4,0.4 Arial,6.75,Regular,Point,False,0 052d1308322f4958a3f755010a7f3696 Center 0,0,0,0 Text33 Consumidor: {nota.destinatario_nome} Black ,,,,WordWrap=True,A=0 Expression Transparent 0.2,3.4,7.4,0.5 Arial,9,Regular,Point,False,0 2d303e6cfa364504885f7bca53c7bd60 Center 0,0,0,0 Text3 Consulta via leitor de QR Code Black Expression Transparent 1.8,4.3,4.2,3.8 {nota.endereco_consulta} Arial,8,Bold,Pixel Black Center qrCode DecreasingSize Transparent 0.2,9.4,7.2,0.9 Arial,9,Regular,Point,False,0 bfae9818a4f049a5a1a51aaaadd2a6b3 Center 0,0,0,0 Text36 Protocolo de Autorização: {nota.protocolo} Kinyx Tecnologia - www.kinyx.com.br Black Expression 0.2,0,0,0 StartPointPrimitive5 7133c99776a54ad18cca032e9f6f7b9b 7.4,0.5,0,0 EndPointPrimitive5 7133c99776a54ad18cca032e9f6f7b9b 0.2,2.7,7.2,0.0254 Black Black 52974fa4e24d4e6abcdf00629c84e4e4 HorizontalLinePrimitive6 Black 0.2,3.3,7.4,0.0254 Black Black 7a09b753950a405398442b28775ddf52 HorizontalLinePrimitive5 Black ReportSummaryBand1 0.2,14.1,7.2,0.5 Black 7133c99776a54ad18cca032e9f6f7b9b RectanglePrimitive3 16e140f4ea7b4950b32fdf7a12ea7df3 0,0,0,0 Page1 12 7.5 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 10/16/2018 9:33:59 AM 9/25/2015 9:37:43 PM b09ac55055874a6ebcfca44880254b1b Report Centimeters 2015.1.0 CSharp