예제 #1
0
        private void btRelatorio_Click(object sender, System.EventArgs e)
        {
            //Consistência Região
            if (ddlRegiao.SelectedValue.ToString().Equals("null"))

            {
                Page.RegisterStartupScript("Alert", "<script language='JavaScript'>alert('Selecione uma Região'); </script>");
                return;
            }

            //Consistência Cooperativa
            if (ddlCoop.SelectedValue.ToString().Equals("null"))

            {
                Page.RegisterStartupScript("Alert", "<script language='JavaScript'>alert('Selecione uma Cooperativa'); </script>");
                return;
            }


            //Consistência Mês

            if (ddlMes.SelectedValue == "")
            {
                Page.RegisterStartupScript("Alert", "<script language='JavaScript'>alert('Informe o Mês'); </script>");
                return;
            }



            //Consistência Ano

            if (ddlAno.SelectedValue == "")
            {
                Page.RegisterStartupScript("Alert", "<script language='JavaScript'>alert('Informe o Ano'); </script>");
                return;
            }

            string [] Fields = { "@CodRegiao", "@CodCoop", "@CodProd", "@Mes", "@Ano" };
            string [] Param  = { ddlRegiao.SelectedValue.ToString(), ddlCoop.SelectedValue.ToString(), ddlProd.SelectedValue.ToString(), ddlMes.SelectedValue.ToString(), ddlAno.SelectedValue.ToString() };

            string sPathLocal = HttpContext.Current.Server.MapPath("Relatorio").ToString();
            string FilePath   = sPathLocal + "\\REL_ANALISE_LEITE.pdf";

            clsCrystal.clsCrystal crt = new clsCrystal.clsCrystal();
            crt.ReportCrystal("PR_REL_ANALISE_LEITE", strConn, Fields, Param, FilePath);


            HttpContext.Current.Response.Redirect("http://200.187.137.92/RelCaptacao/Relatorio/REL_ANALISE_LEITE.pdf");
            //HttpContext.Current.Response.Redirect("http://cclteste/RelCaptacao/Relatorio/REL_ANALISE_LEITE.pdf");
            //HttpContext.Current.Response.Redirect("http://dif-1029/RelCaptacao/Relatorio/REL_ANALISE_LEITE.pdf");
        }
예제 #2
0
        private void btRelatorio_Click(object sender, System.EventArgs e)
        {
            string [] Fields = { "@CodRegiao", "@Linha", "@Mes", "@Ano" };
            //string [] Param = {"3513", "1", "10", "2004"};
            string [] Param      = { ddlRegiao.SelectedValue.ToString(), ddlLinha.SelectedValue.ToString(), ddlMes.SelectedValue.ToString(), ddlAno.SelectedValue.ToString() };
            string    sPathLocal = HttpContext.Current.Server.MapPath("Relatorio").ToString();
            string    FilePath   = sPathLocal + "\\REL_CONT_FORNEC_LEITE.pdf";        //@"F:\Dif\emerson\Teste.pdf";

            //string FilePath = @"c:\RelLeite.pdf";

            clsCrystal.clsCrystal crt = new clsCrystal.clsCrystal();
            crt.ReportCrystal("PR_REL_CONT_FORNEC_LEITE", strConn, Fields, Param, FilePath);
            HttpContext.Current.Response.Redirect("http://200.187.137.92/Relcaptacao/Relatorio/REL_CONT_FORNEC_LEITE.pdf");
            //HttpContext.Current.Response.Redirect("http://cclteste/Relcaptacao/Relatorio/REL_CONT_FORNEC_LEITE.pdf");
        }
        private void btRelatorio_Click(object sender, System.EventArgs e)
        {
            string [] Fields = { "@DatInicio", "@DatFim", "@CodRegiao", "@CodCoop" };
            string [] Param  = { txtDtIni.Text, txtDtFim.Text, ddlRegiao.SelectedValue.ToString(), ddlCoop.SelectedValue.ToString() };

            string sPathLocal = HttpContext.Current.Server.MapPath("Relatorio").ToString();
            string FilePath   = sPathLocal + "\\COLETA_LEITE_ASSOCIADA.pdf";           //@"F:\Dif\emerson\Teste.pdf";

            clsCrystal.clsCrystal crt = new clsCrystal.clsCrystal();
            crt.ReportCrystal("SP_REL_COLETA_LEITE_ASSOCIADA", strConn, Fields, Param, FilePath);

            HttpContext.Current.Response.Redirect("http://200.187.137.92/RelCaptacao/Relatorio/COLETA_LEITE_ASSOCIADA.pdf");
            //HttpContext.Current.Response.Redirect("http://cclteste/RelCaptacao/Relatorio/COLETA_LEITE_ASSOCIADA.pdf");
            //HttpContext.Current.Response.Redirect("http://dif-1029/RelCaptacao/Relatorio/COLETA_LEITE_ASSOCIADA.pdf");
        }
예제 #4
0
        private void btRelatorio_Click(object sender, System.EventArgs e)
        {
            string [] Fields = { "@CodRegiao", "@CodCoop", "@CodAtiv", "@CodOrd" };
            string [] Param  = { ddlRegiao.SelectedValue.ToString(), ddlCoop.SelectedValue.ToString(), ddlAtiv.SelectedValue.ToString(), ddlOrd.SelectedValue.ToString() };

            string sPathLocal = HttpContext.Current.Server.MapPath("Relatorio").ToString();
            string FilePath   = sPathLocal + "\\CAD_PRODUTORES.pdf";           //@"F:\Dif\emerson\Teste.pdf";

            clsCrystal.clsCrystal crt = new clsCrystal.clsCrystal();
            crt.ReportCrystal("PR_SEL_CAD_PRODUTORES", strConn, Fields, Param, FilePath);
            //string FilePath = @"c:\CadProdutor.pdf";

            HttpContext.Current.Response.Redirect("http://200.187.137.92/RelCaptacao/Relatorio/CAD_PRODUTORES.pdf");
            //HttpContext.Current.Response.Redirect("http://cclteste/RelCaptacao/Relatorio/CAD_PRODUTORES.pdf");
            //HttpContext.Current.Response.Redirect("http://dif-1029/RelCaptacao/Relatorio/CAD_PRODUTORES.pdf");
        }
예제 #5
0
        private void btRelatorio_Click(object sender, System.EventArgs e)
        {
            string [] Fields     = { "@CodRegiao", "@LinhaDe", "@LinhaAte" };
            string [] Param      = { ddlRegiao.SelectedValue.ToString(), ddlLinhaDe.SelectedValue.ToString(), ddlLinhaAte.SelectedValue.ToString() };
            string    sPathLocal = HttpContext.Current.Server.MapPath("Relatorio").ToString();
            string    FilePath   = sPathLocal + "\\REL_CONF_LINHA.pdf";        //@"F:\Dif\emerson\Teste.pdf";

            //string FilePath = @"c:\RelWal.pdf";

            clsCrystal.clsCrystal crt = new clsCrystal.clsCrystal();
            crt.ReportCrystal("PR_REL_CONFERENCIA_LINHA", strConn, Fields, Param, FilePath);


            HttpContext.Current.Response.Redirect("http://200.187.137.92/Relcaptacao/Relatorio/REL_CONF_LINHA.pdf");
            //HttpContext.Current.Response.Redirect("http://cclteste/Relcaptacao/Relatorio/REL_CONF_LINHA.pdf");
        }
		private void btRelatorio_Click(object sender, System.EventArgs e)
		{
 
			string [] Fields = {"@DatInicio","@DatFim","@CodRegiao","@CodCoop"};
			string [] Param = { txtDtIni.Text,txtDtFim.Text,ddlRegiao.SelectedValue.ToString(),ddlCoop.SelectedValue.ToString()};

			string sPathLocal = HttpContext.Current.Server.MapPath("Relatorio").ToString();
			string FilePath = sPathLocal + "\\COLETA_LEITE_ASSOCIADA.pdf"; //@"F:\Dif\emerson\Teste.pdf";  
			
			clsCrystal.clsCrystal crt = new clsCrystal.clsCrystal();
    		crt.ReportCrystal("SP_REL_COLETA_LEITE_ASSOCIADA",strConn,Fields,Param,FilePath);
				
			HttpContext.Current.Response.Redirect("http://200.187.137.92/RelCaptacao/Relatorio/COLETA_LEITE_ASSOCIADA.pdf");
			//HttpContext.Current.Response.Redirect("http://cclteste/RelCaptacao/Relatorio/COLETA_LEITE_ASSOCIADA.pdf");
			//HttpContext.Current.Response.Redirect("http://dif-1029/RelCaptacao/Relatorio/COLETA_LEITE_ASSOCIADA.pdf");

		}
예제 #7
0
		private void btRelatorio_Click(object sender, System.EventArgs e)
		{
			//Consistência Região
			if (ddlRegiao.SelectedValue.ToString().Equals("null"))

			{

				Page.RegisterStartupScript("Alert","<script language='JavaScript'>alert('Selecione uma Região'); </script>");
				return;
			}

			//Consistência Cooperativa
			if (ddlCoop.SelectedValue.ToString().Equals("null"))

			{

				Page.RegisterStartupScript("Alert","<script language='JavaScript'>alert('Selecione uma Cooperativa'); </script>");
				return;

			}

			
			//Consistência Mês

			if (ddlMes.SelectedValue == "")
  		    {
			Page.RegisterStartupScript("Alert","<script language='JavaScript'>alert('Informe o Mês'); </script>");
				return;
			}
			
			
			
			//Consistência Ano

			if (ddlAno.SelectedValue == "")
  		    {
			Page.RegisterStartupScript("Alert","<script language='JavaScript'>alert('Informe o Ano'); </script>");
				return;
			}

				string [] Fields = {"@CodRegiao","@CodCoop","@CodProd","@Mes","@Ano"};
				string [] Param = { ddlRegiao.SelectedValue.ToString(),ddlCoop.SelectedValue.ToString(),ddlProd.SelectedValue.ToString(),ddlMes.SelectedValue.ToString(),ddlAno.SelectedValue.ToString()};
						
				string sPathLocal = HttpContext.Current.Server.MapPath("Relatorio").ToString();
				string FilePath = sPathLocal + "\\REL_ANALISE_LEITE.pdf"; 
			
				clsCrystal.clsCrystal crt = new clsCrystal.clsCrystal();
				crt.ReportCrystal("PR_REL_ANALISE_LEITE",strConn,Fields,Param,FilePath);
			
				
				HttpContext.Current.Response.Redirect("http://200.187.137.92/RelCaptacao/Relatorio/REL_ANALISE_LEITE.pdf");
				//HttpContext.Current.Response.Redirect("http://cclteste/RelCaptacao/Relatorio/REL_ANALISE_LEITE.pdf");
				//HttpContext.Current.Response.Redirect("http://dif-1029/RelCaptacao/Relatorio/REL_ANALISE_LEITE.pdf");

		}
		private void btRelatorio_Click(object sender, System.EventArgs e)
		{
 
			string [] Fields = {"@CodRegiao","@CodCoop","@CodAtiv","@CodOrd"};
			string [] Param = { ddlRegiao.SelectedValue.ToString(),ddlCoop.SelectedValue.ToString(),ddlAtiv.SelectedValue.ToString(),ddlOrd.SelectedValue.ToString()};
						
			string sPathLocal = HttpContext.Current.Server.MapPath("Relatorio").ToString();
			string FilePath = sPathLocal + "\\CAD_PRODUTORES.pdf"; //@"F:\Dif\emerson\Teste.pdf";  
			
			clsCrystal.clsCrystal crt = new clsCrystal.clsCrystal();
			crt.ReportCrystal("PR_SEL_CAD_PRODUTORES",strConn,Fields,Param,FilePath);
			//string FilePath = @"c:\CadProdutor.pdf";
				
			HttpContext.Current.Response.Redirect("http://200.187.137.92/RelCaptacao/Relatorio/CAD_PRODUTORES.pdf");
			//HttpContext.Current.Response.Redirect("http://cclteste/RelCaptacao/Relatorio/CAD_PRODUTORES.pdf");
			//HttpContext.Current.Response.Redirect("http://dif-1029/RelCaptacao/Relatorio/CAD_PRODUTORES.pdf");

		}
		private void btRelatorio_Click(object sender, System.EventArgs e)
		{
			string [] Fields = {"@CodRegiao","@LinhaDe","@LinhaAte"};
			string [] Param = {ddlRegiao.SelectedValue.ToString(),ddlLinhaDe.SelectedValue.ToString(), ddlLinhaAte.SelectedValue.ToString()};
			string sPathLocal = HttpContext.Current.Server.MapPath("Relatorio").ToString();
			string FilePath = sPathLocal + "\\REL_CONF_LINHA.pdf"; //@"F:\Dif\emerson\Teste.pdf";
			//string FilePath = @"c:\RelWal.pdf";
			
			clsCrystal.clsCrystal crt = new clsCrystal.clsCrystal();
			crt.ReportCrystal("PR_REL_CONFERENCIA_LINHA",strConn,Fields,Param,FilePath);
			

			HttpContext.Current.Response.Redirect("http://200.187.137.92/Relcaptacao/Relatorio/REL_CONF_LINHA.pdf");
			//HttpContext.Current.Response.Redirect("http://cclteste/Relcaptacao/Relatorio/REL_CONF_LINHA.pdf");

		}
		private void btRelatorio_Click(object sender, System.EventArgs e)
		{
			string [] Fields = {"@CodRegiao","@Linha", "@Mes", "@Ano"};
		    //string [] Param = {"3513", "1", "10", "2004"};
			string [] Param = {ddlRegiao.SelectedValue.ToString(), ddlLinha.SelectedValue.ToString(),ddlMes.SelectedValue.ToString(), ddlAno.SelectedValue.ToString()};
			string sPathLocal = HttpContext.Current.Server.MapPath("Relatorio").ToString();
			string FilePath = sPathLocal + "\\REL_CONT_FORNEC_LEITE.pdf"; //@"F:\Dif\emerson\Teste.pdf";
	    	//string FilePath = @"c:\RelLeite.pdf";
			
			clsCrystal.clsCrystal crt = new clsCrystal.clsCrystal();
			crt.ReportCrystal("PR_REL_CONT_FORNEC_LEITE",strConn,Fields,Param,FilePath);
			HttpContext.Current.Response.Redirect("http://200.187.137.92/Relcaptacao/Relatorio/REL_CONT_FORNEC_LEITE.pdf");
			//HttpContext.Current.Response.Redirect("http://cclteste/Relcaptacao/Relatorio/REL_CONT_FORNEC_LEITE.pdf");
			

		}