Gestor 41T1Ak1Kcqnifu29Y3hlL9USZa7JV0Ldy1r9zPvYJQ/kVM/JTU17NcNDbcxoAGpOwtb1bMZZQfnqE4SUZD3oRoNezUzUQKrI701N+E7UIV7ZFvUJRkoircBJDRxNZGJe1Br7K1hzUajtRw== 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 vendedor,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 data,System.DateTime hora,System.String nome_contato,System.String telefone_contato,System.String defeito,System.String solucao,System.String observacoes,System.String nome_cliente,System.String cpf_cnpj,System.String logradouro,System.String numero,System.String bairro,System.String uf,System.String valor_produtos,System.Decimal valor_servicos,System.Decimal valor_total,System.Decimal finalizado,System.Boolean cliente_id,System.Int32 tecnico_id,System.Int32 atendente_id,System.Int32 status_id,System.Int32 tipo_equipamento_id,System.Int32 orcamento_id,System.Int32 cidade_id,System.Int32 id1,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 numero1,System.String bairro1,System.String uf1,System.String cpf_cnpj1,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 observacoes1,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 bairro_id,System.Int32 cidade_id1,System.Int32 grupo_usuario_id,System.Int32 grupo_correntista_id,System.Int32 pais_id,System.Int32 codigo_geral,System.String imagem,System.Byte[] 30 False dados Gestor select * from ordem_servico baixa left join correntista tecnico on tecnico.id = baixa.tecnico_id where DATE_FORMAT(CAST(baixa.data as DATE), '%Y-%m-%d') BETWEEN DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') and CASE WHEN {Todos_os_produtos} = 1 THEN 1 = 1 ELSE tecnico.id = {funcionario_id} END 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 funcionario = 1 ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,vendedor_id,vendedor_id,System.Int32,_x0030_,False,False ,data_inicial,data_inicial,System.String,_x0032_016-03-01,False,False ,data_final,data_final,System.String,_x0032_016-03-31,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0038__x005F_x002F_13_x005F_x002F_2018_x005F_x0020_5:05:43_x005F_x0020_PM_x002C__x005F_x0038__x005F_x002F_13_x005F_x002F_2018_x005F_x0020_5:05:43_x005F_x0020_PM,False,False ,funcionario_id,funcionario_id,System.Int32,_x0030_,False,False ,Todos_os_produtos,Todos_os_produtos,System.Boolean,false,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,4.2 GlassBrush,Gainsboro,True,0.2 0,2.2,19,0.8 Transparent 0.2,0.1,18.6,0.6 Tahoma,14.25,Bold,Point,False,0 b477fa6ca8314ffa84101e90adebd93d Center 0,0,0,0 Text1 ORDENS DE SERVIÇO Black Expression 5ec57d6d6fbe4b22832fe900eedd309a Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 e3190c0b3e734bae98aaceae2c9ffb0f 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 4e7cbdc300ca4665802434919c3f2389 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 bffdaccca0f24554a72a6fec6963f170 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 4bc9fbfe1a76416ca43ed1d751c7b3dc Right 0,0,0,0 Text5 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo 4de07384d7b7483a9f15ace801a7cd10 imgLogo True Transparent 17,3,2,0.6 Tahoma,8.25,Bold,Point,False,0 1922ab82129d446584889487b6df9c1c Right 0,0,0,0 Text16 {Data.ToDate.Date} Black Expression Center Transparent 12.4,3,3.6,0.6 Tahoma,8.25,Bold,Point,False,0 f80d7580f5a9451d84f2ae9f753e61ac Right 0,0,0,0 Text20 {Data.FromDate.Date} Black Expression Center Transparent 16,3,1,0.6 Tahoma,8.25,Bold,Point,False,0 4131f614132a43bd8e7ff26b3fc13f93 Center 0,0,0,0 Text24 até Black Expression Center ReportTitleBand1 Transparent 0,5.4,19,1.6 Transparent 4.2,1.2,6.6,0.4 Tahoma,8.25,Bold,Point,False,0 7c7db95f5a7c4550ad0cd9026aae8930 0,0,0,0 Text6 Cliente: Black Expression Center Transparent 10.8,1.2,2.2,0.4 Tahoma,8.25,Bold,Point,False,0 744fd17fe4fc4c20b50bc94cb8095ac4 Center 0,0,0,0 Text10 Data Black Expression Center Transparent 13,1.2,2,0.4 Tahoma,8.25,Bold,Point,False,0 60edbc88256f47188dd1a617cf1bfce7 Center 0,0,0,0 Text12 Vlr. Serviços Black Expression Center Transparent 0.4,1.2,1.6,0.4 Tahoma,8.25,Bold,Point,False,0 f04b7ccb17274bf4831bfd2f3822703f 0,0,0,0 Text17 Número Black Expression Center Transparent 15,1.2,2,0.4 Tahoma,8.25,Bold,Point,False,0 4e772cfd85e24f06ba47b93eaca709d7 Right 0,0,0,0 Text8 Vlr. Produtos Black Expression Center Transparent 17,1.2,2,0.4 Tahoma,8.25,Bold,Point,False,0 d2ab8016c44a402f964177a12f91192e Right 0,0,0,0 Text15 Valor Total Black Expression Center Transparent 0.4,0.2,9.6,0.6 Tahoma,8.25,Bold,Point,False,0 e28baa4eb74e43088c2bb843fee4bff4 0,0,0,0 Text44 Funcionário: {dados.nome_fantasia} Black Expression Center Transparent 2,1.2,2.2,0.4 Tahoma,8.25,Bold,Point,False,0 f982f38189dc4316a8e35d2a770d5c70 0,0,0,0 Text27 Orçamento Black Expression Center {dados.nome_fantasia} GroupHeaderBand1 Transparent 0,7.8,19,0.4 Transparent 17,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 d7de0daf6fb54c1aa02d8a1948bd9972 Right 0,0,0,0 Text13 {dados.valor_total} Black , . 1 0 R$ DataColumn Center Transparent 13,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 c5fa1c8e56654933ac7eebdfe9070b02 Center 0,0,0,0 Text22 {dados.valor_servicos} Black , . 1 0 R$ DataColumn Center Transparent 0.4,0,1.6,0.4 Tahoma,8.25,Regular,Point,False,0 95f87ca11f8f4cada4a4dc2cee7c9ba1 0,0,0,0 Text7 {dados.id} Black DataColumn Center Transparent 4.2,0,6.6,0.4 Tahoma,8.25,Regular,Point,False,0 18c042a5e78d43689e8b36c5506caa0c 0,0,0,0 Text9 {dados.nome_cliente} Black DataColumn Center Transparent 10.8,0,2.2,0.4 Tahoma,8.25,Regular,Point,False,0 b7a0514af12049ce8f58ca960960c8c9 Center 0,0,0,0 Text18 {dados.data} Black Expression Center Transparent 15,0,2,0.4 Tahoma,8.25,Regular,Point,False,0 49f0378d6d7441d280ccf970a6ca0532 Right 0,0,0,0 Text19 {dados.valor_produtos} Black , . 1 0 R$ DataColumn Center Transparent 2,0,2.2,0.4 Tahoma,8.25,Regular,Point,False,0 8fb0fc217aae462aa35bec9e0e7d0493 0,0,0,0 Text28 {dados.orcamento_id} Black DataColumn Center 0,0,19,0.0254 Black Black 508ce17a18774317ae7501365e7fd9f3 HorizontalLinePrimitive2 Black 0,0.4,19,0.0254 Black Black 75cf1729f085416598928c9484f767b1 HorizontalLinePrimitive3 Black dados DataBand2 True Transparent 0,9,19,0.6 Transparent 10.6,0,2.4,0.6 Tahoma,8.25,Bold,Point,False,0 d96c709d6edc48cabfb510eb0750af4b Right 0,0,0,0 Text11 Totais R$: Black Expression Center Transparent 13,0,2,0.6 Tahoma,8.25,Regular,Point,False,0 3caa77f96e6d4ec1902c4c4243668ae5 Center 0,0,0,0 Text23 {Sum(DataBand2,dados.valor_servicos)} Black , . 1 Totals Center Transparent 15,0,2,0.6 Tahoma,8.25,Regular,Point,False,0 1bad5ee608284fb5ab72e6e9390d2d04 Right 0,0,0,0 Text25 {Sum(DataBand2,dados.valor_produtos)} Black , . 1 Totals Center Transparent 17,0,2,0.6 Tahoma,8.25,Regular,Point,False,0 451843b65ea74f7db69993d150bb671c Right 0,0,0,0 Text26 {Sum(DataBand2,dados.valor_total)} Black , . 1 Totals Center 0,0,19,0.0254 Black Black HorizontalLinePrimitive1 Black ReportSummaryBand1 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Control Window 24,48,96,20 Microsoft Sans Serif,8 Black Short 44dbb8891ae947eb868e6e318f58522c 24, 48 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtInicial 96, 20 2/6/2018 4:30:02 PM Window 160,48,96,20 Microsoft Sans Serif,8 Black Short 3c782d4b80514954997c098abb36c123 160, 48 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtFinal 96, 20 2/6/2018 4:30:08 PM Control 24,24,96,24 Microsoft Sans Serif,8 Black 43da8f65be6f4108a7a0596d0325402a 24, 24 LabelControl1 96, 24 Data Inicial Control 160,24,96,24 Microsoft Sans Serif,8 Black 1fe8aeb8a6734445b909848fbd2101a4 160, 24 LabelControl2 96, 24 Data Final 24,168,96,24 Cancel Microsoft Sans Serif,8 Black deb367707b034b328af1f1fe786ca8cb 24, 168 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; int.TryParse(txtFuncionario.SelectedValue.ToString(), out funcionario_id); Todos_os_produtos = tdProdutos.Checked; 160,168,96,24 OK Microsoft Sans Serif,8 Black bec8be4d22bc4e699efbc59fcdddfe6e 160, 168 btnGerar 96, 24 Gerar Window 24,128,232,20 Microsoft Sans Serif,8 Black f570008a92f7445589e1587719e6f853 24, 128 txtFuncionario 232, 20 Control 24,112,96,16 Microsoft Sans Serif,8 Black 8b783cae4ec645728fc1b82203c6231b 24, 112 LabelControl3 96, 16 Funcionário Control 24,80,232,24 Microsoft Sans Serif,8 Black 83fcb19295104c19b6e38070067a037e 24, 80 tdProdutos 232, 24 Todos os Funcionários Microsoft Sans Serif,8 085a40e77afb4c0ba6124cf1f7a823c1 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, 232 Informe o periodo 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 4/16/2019 3:47:10 PM 9/25/2015 9:37:43 PM 0f79c8f37c874532b6adf5a2ffba4243 Report Centimeters 2015.1.0 CSharp