Gestor 41T1Ak1KcqlrCDGA4njsr9XEjYzZTyLda1r9zPtM4AfHEsHNTUvTccNDbczqAC1O5Nb171hR+vXqbdH44SXnRsJeZQ1IQJKMfBWlaHT4LF7EWvkJ1UqapMBu6IXlKetj38j1AtML8rx5ey0c 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 razao_social,System.String cidade,System.String ie_rg,System.String imagem_logo,System.Byte[] 30 False config Gestor select c.razao_social, c.nome_fantasia, c.cnpj_cpf, c.logradouro, c.numero, c.bairro, c.uf, c.telefone, cidade.nome as cidade, c.ie_rg, c.imagem_logo from configuracao c left join cidade on cidade.id = c.cidade_id dados id,System.Int32 razao_social,System.String endereco,System.String numero,System.String bairro,System.String telefone,System.String celular,System.String descricao,System.String id1,System.Int32 quantidade,System.Decimal quantidade_nova,System.Decimal quantidade_retirada,System.Decimal 30 False dados Gestor select orc.id, cor.razao_social, cor.endereco, cor.numero, cor.bairro, cor.telefone, cor.celular, orc_item.descricao, orc_item.id, orc_item.quantidade, bri.quantidade AS quantidade_retirada from orcamento orc left join orcamento_item orc_item on orc_item.orcamento_id = orc.id left join correntista cor on cor.id = orc.cliente_id left join baixa_retirar_item bri on bri.orcamento_item_id = orc_item.id where orc.tipo_orcamento = 'RETIRAR' and cor.id = {funcionario_id} and (orc_item.quantidade-bri.quantidade > 0 or bri.quantidade is null) funcionario id,System.Int32 tipo_pessoa,System.String nome_fantasia,System.String razao_social,System.String contato,System.String data_nascimento,System.DateTime cep,System.String endereco,System.String numero,System.String bairro,System.String uf,System.String cpf_cnpj,System.String rg_ie,System.String telefone,System.String celular,System.String fax,System.String email,System.String limite_credito,System.Decimal data_cadastro,System.DateTime observacoes,System.String cliente,System.Boolean funcionario,System.Boolean fornecedor,System.Boolean estado_civil,System.String inativo,System.Boolean usuario,System.String senha,System.String liberador,System.Boolean seq_sincronizacao,System.Int64 codigo_retaguarda,System.String fun_limite_desconto,System.Decimal ddd_telefone,System.String ddd_celular,System.String limite_credito_utilizado,System.Decimal limite_credito_saldo,System.Decimal complemento,System.String inscricao_municipal,System.String filiacao_mae,System.String filiacao_pai,System.String conjuge_nome,System.String conjuge_telefone,System.String conjuge_celular,System.String conjuge_local_trabalho,System.String trabalho_empresa,System.String trabalho_cargo,System.String trabalho_data_admissao,System.DateTime trabalho_renda,System.Decimal senha_venda,System.String nao_contribuinte_icms,System.Boolean ie_produtor_rural,System.String codigo_geral,System.String bairro_id,System.Int32 cidade_id,System.Int32 grupo_usuario_id,System.Int32 grupo_correntista_id,System.Int32 pais_id,System.Int32 id_temp,System.String cidade_temp,System.String imagem,System.Byte[] 30 False funcionario Gestor select * from correntista where cliente = 1 ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,id,id,System.Int32,,False,False ,funcionario_id,funcionario_id,System.Int32,,False,False ,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0034__x005F_x002F_5_x005F_x002F_2019_x005F_x0020_10:08:16_x005F_x0020_AM_x002C__x005F_x0034__x005F_x002F_5_x005F_x002F_2019_x005F_x0020_10:08:16_x005F_x0020_AM,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.9,19,0.8 Transparent 15.4,0.1,3.6,0.4 Arial,10 Right 0,0,0,0 Text3 {PageNofMThrough} Black Transparent 0,0.1,8.4,0.6 Arial,8 0,0,0,0 Text21 Kinyx Gestor v.{versao} - www.kinyx.com.br Black Expression PageFooterBand1 Transparent 0,0.4,19,3 GlassBrush,Gainsboro,True,0.2 0,2.2,19,0.8 Transparent 0.2,0.1,18.6,0.6 Arial,14,Bold Center 0,0,0,0 Text1 PRODUTOS A RETIRAR Black Expression Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 64784c7b676f4c698b57570218461c87 0,0,0,0 Text4 {config.razao_social} Black Expression Transparent 2.2,0.4,13.6,1.8 Tahoma,9,Regular,Point,False,0 7d9ba2a052f0456eb6bdb672168eab94 0,0,0,0 Text14 CNPJ: {config.cnpj_cpf} - IE: {config.ie_rg} End.: {config.logradouro}, {config.numero} Bairro: {config.bairro} {config.cidade}/{config.uf} Black Expression Transparent 13.6,0.2,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 7d9018930e31473d849da1b343539c85 Right 0,0,0,0 Text2 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 15.8,0.6,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 f90b963cc99c42338bc3462bd402727a Right 0,0,0,0 Text20 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo 51f90c8b34c6447eae86484a742f46d1 imgLogo True Transparent 15.8,1.6,3.2,0.4 Tahoma,8.25,Bold,Point,False,0 63fd1e08c7a148e88008643061bc968f 0,0,0,0 Text46 Black Expression Center ReportTitleBand1 Transparent 0,4.2,19,2 Transparent 0,1,1.4,0.4 Tahoma,8.25,Bold,Point,False,0 0f612823e4674e21b7daba77b0c7a5b0 0,0,0,0 Text13 Cliente: Black Expression Center Transparent 1.6,1,17.4,0.4 Tahoma,8.25,Regular,Point,False,0 074cabf5caf741ae8ab0ffe469d5a0bf 0,0,0,0 Text15 {dados.razao_social} Black Expression Center Transparent 0,1.4,1.6,0.4 Tahoma,8.25,Bold,Point,False,0 8b7cd7f19e68434c857c677b960499e7 0,0,0,0 Text133 Endereço: Black Expression Center Transparent 1.6,1.4,17.4,0.4 Tahoma,8.25,Regular,Point,False,0 647bc636e40a4cf2ae2a3d69586fd71d 0,0,0,0 Text155 {dados.endereco}, {dados.numero} - {dados.bairro} - TEL: {dados.telefone} - CEL: {dados.celular} Black ,,,,WordWrap=True,A=0 Expression Center Transparent 0,0,19,0.6 Arial,9.75,Bold,Point,False,0 8bd18bd861ea4f978df71b88d8a33f2c Center 0,0,0,0 Text12 NÃO TEM VALOR FISCAL Black Expression Center DataBand2 Transparent 0,7,19,0.8 Transparent 0,0.4,1.8,0.4 Tahoma,8.25,Bold,Point,False,0 d7dd394a1d6b489a9e6f1e31e630f532 0,0,0,0 Text16 Código Black Expression Center Transparent 0,0,19,0.4 Tahoma,8.25,Bold,Point,False,0 31d06b3ea50c442d9e6df4d6e4ac1b77 Center 0,0,0,0 Text17 PRODUTOS Black Expression Center Transparent 1.8,0.4,14.4,0.4 Tahoma,8.25,Bold,Point,False,0 f8093f41d1dd4694837761f0fb64c07d 0,0,0,0 Text28 Descrição Black Expression Center Transparent 16.2,0.4,1.4,0.4 Tahoma,8.25,Bold,Point,False,0 2999a4c7d2b8440eab977c9337bafdc9 Center 0,0,0,0 Text29 Qtde Black Expression Center Transparent 17.6,0.4,1.4,0.4 Tahoma,8.25,Bold,Point,False,0 8df9f163d1e34eba934572430a990884 Right 0,0,0,0 Text5 Retirado Black Expression Center GroupHeaderBand1 Transparent 0,8.6,19,0.4 Transparent 0,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 c22aa8d1319c46b3a2e25baf0f69adf7 0,0,0,0 Text33 {dados.id1} Black DataColumn Center Transparent 1.8,0,14.4,0.4 Tahoma,8.25,Regular,Point,False,0 e7a48b4f95ad420788d45b2543c0d120 0,0,0,0 Text34 {dados.descricao} Black DataColumn Center Transparent 16.2,0,1.4,0.4 Tahoma,8.25,Regular,Point,False,0 7dc40520c0a246d78f29eb8a0e9b97fb Center 0,0,0,0 Text35 {dados.quantidade} Black , . 1 DataColumn Center Transparent 17.6,0,1.4,0.4 Tahoma,8.25,Regular,Point,False,0 ae11a58113944e2d85a3a6b8f9c4ffed Right 0,0,0,0 Text6 {dados.quantidade_retirada} Black , . 1 Expression Center 0,0.4,19,0.0254 Black Black 54178534cd534d5aaf309d26535501e0 HorizontalLinePrimitive3 Black dados False DataBand3 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Control 32,72,96,24 Cancel Microsoft Sans Serif,8 Black b36c2e81cf3d480cbd389a73bfd5d23a 32, 72 btnCancelar 96, 24 Cancelar int.TryParse(txtFuncionario.SelectedValue.ToString(), out funcionario_id); 168,72,96,24 OK Microsoft Sans Serif,8 Black c35792d5ac864aafac089092a8df4e99 168, 72 btnGerar 96, 24 Gerar Window 32,32,232,20 Microsoft Sans Serif,8 Black 1e524356b671421ea3195702d8737e03 32, 32 txtFuncionario 232, 20 Control 32,16,96,16 Microsoft Sans Serif,8 Black aa150a1e59f943b3bfa4a1f47bcaf63b 32, 16 LabelControl3 96, 16 Cliente Microsoft Sans Serif,8 d98e0a8fbdc845a6ad76321ea706a8a3 txtFuncionario.Control.Items.Clear(); txtFuncionario.Control.DisplayMember = "nome_fantasia"; txtFuncionario.Control.ValueMember = "id"; txtFuncionario.Control.DataSource = this.Dictionary.DataSources["funcionario"].DataTable; 0, 0 Form1 304, 152 Selecione System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Gestor.exe Report 4/5/2019 11:03:37 AM 9/25/2015 9:37:43 PM 211aa2b7f26542ab95195697fd9eba53 Report Centimeters 2015.1.0 CSharp