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", "@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");
}
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 = {"@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");
}
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");
}