private void CarregaDGVs() { DateTime Data = new DateTime(AnoAtual, mesAtual, 1); DALConexao cx = new DALConexao(DadosDaConexao.StringDaConexao); BLLConsultaCMV bll = new BLLConsultaCMV(cx); DataTable table = bll.ListarCustoReceitaPaxAcrescimos(idUnidade, Data); dgvCusto.DataSource = table; dgvCusto.Columns[0].Width = 70; dgvCusto.Columns[0].HeaderText = "DATA"; dgvCusto.Columns[1].Width = 70; dgvCusto.Columns[1].HeaderText = "CUSTO"; dgvCusto.Columns[2].Width = 70; dgvCusto.Columns[2].HeaderText = "+CUSTO"; dgvCusto.Columns[3].Width = 70; dgvCusto.Columns[3].HeaderText = "RECEITA_B"; dgvCusto.Columns[4].Width = 70; dgvCusto.Columns[4].HeaderText = "RECEITA_L"; dgvCusto.Columns[5].Width = 70; dgvCusto.Columns[5].HeaderText = "+RECEITA"; dgvCusto.Columns[6].Width = 50; dgvCusto.Columns[6].HeaderText = "PAX"; dgvCusto.Columns[7].Width = 50; dgvCusto.Columns[7].HeaderText = "+PAX"; //carrega dgvAcrescimos dgvAcrescimos.Rows.Clear(); BLLAcrescimos blla = new BLLAcrescimos(cx); DataTable acrescimos = blla.LocalizarAcrescimos(idUnidade, Data); string data; String[] S; for (int i = 0; i < acrescimos.Rows.Count; i++) { data = Convert.ToDateTime(acrescimos.Rows[i][1]).ToShortDateString(); S = new string[] { acrescimos.Rows[i][0].ToString(), data, acrescimos.Rows[i][2].ToString(), acrescimos.Rows[i][3].ToString(), acrescimos.Rows[i][4].ToString(), acrescimos.Rows[i][5].ToString() }; dgvAcrescimos.Rows.Add(S); } }
private void AtualizaDGV() { String[] T = new string[] { "-1", "CONTA GERENCIAL", "CUSTO", "$", "%" }; this.dgvDetalhe.Rows.Add(T); String[] V; int grupoCusto = 01; DALConexao cx = new DALConexao(DadosDaConexao.StringDaConexao); BLLCmvGraficos bll = new BLLCmvGraficos(cx); BLLConsultaCMV bllc = new BLLConsultaCMV(cx); DataTable TABELA; if (geral) { TABELA = bll.TabelaCustoCMVReceitaPaxGeral(unidade, diaI, diaF, grupoCusto); } else { TABELA = bll.TabelaCustoCMVReceitaPaxPorGrupo(unidade, diaI, diaF, grupo, grupoCusto); } if (TABELA.Rows.Count > 0) { for (int i = 0; i < TABELA.Rows.Count; i++) { V = new string[] { TABELA.Rows[i][0].ToString(), TABELA.Rows[i][1].ToString(), Convert.ToDouble(TABELA.Rows[i][2]).ToString("#,0.00"), Convert.ToDouble(TABELA.Rows[i][3]).ToString("#,0.00"), Convert.ToDouble(TABELA.Rows[i][4]).ToString("#,0.00") + "%" }; this.dgvDetalhe.Rows.Add(V); } } else { } V = new string[] { "0", "", "", "", "" }; this.dgvDetalhe.Rows.Add(V); if (TABELA.Rows.Count > 0) { V = new string[] { "-1", "TOTAL", Convert.ToDouble(TABELA.Rows[0][5]).ToString("#,0.00"), (Convert.ToDouble(TABELA.Rows[0][5]) / Convert.ToDouble(TABELA.Rows[0][7])).ToString("#,0.00"), ((Convert.ToDouble(TABELA.Rows[0][5]) / Convert.ToDouble(TABELA.Rows[0][6])) * 100).ToString("#,0.00") + "%" }; this.dgvDetalhe.Rows.Add(V); } lbReceitaePax.Text = $"Total Pax = {Convert.ToDouble(TABELA.Rows[0][7]).ToString("#,0")} - total receita = R$ {Convert.ToDouble(TABELA.Rows[0][6]).ToString("#,0.00")}"; }
void CarregarPizza1() { DateTime Diai = new DateTime(Convert.ToInt32(numAno.Value), Convert.ToInt32(cbMes.SelectedValue), 1); DateTime Diaf = Diai.AddDays(-(Diai.Day - 1)).AddMonths(1).AddDays(-1); DateTime DiaA = Diai; int unidade = Convert.ToInt32(cbUnidade.SelectedValue); DALConexao cx = new DALConexao(DadosDaConexao.StringDaConexao); BLLConsultaCMV bll = new BLLConsultaCMV(cx); DataTable tabela; ComparativoCusto.Series.Clear(); Series series1 = new Series { Name = "Serie1", IsVisibleInLegend = true, Color = System.Drawing.Color.Green, ChartType = SeriesChartType.Pie }; ComparativoCusto.Series.Add(series1); double valor1, valor2, valor3; string percent1, percent2, percent3; tabela = bll.TotalCustoPorTipo(unidade, "a", Diai, Diaf); try { valor1 = Convert.ToDouble(tabela.Rows[0][0]); }catch { valor1 = 0; } tabela = bll.TotalCustoPorTipo(unidade, "b", Diai, Diaf); try { valor2 = Convert.ToDouble(tabela.Rows[0][0]); } catch { valor2 = 0; } tabela = bll.TotalCustoPorTipo(unidade, "o", Diai, Diaf); try { valor3 = Convert.ToDouble(tabela.Rows[0][0]); } catch { valor3 = 0; } if ((Math.Round(valor1 / (valor1 + valor2 + valor3), 2)) * 100 >= 5) { percent1 = ((Math.Round(valor1 / (valor1 + valor2 + valor3), 2)) * 100).ToString() + "%"; } else { percent1 = ""; } if ((Math.Round(valor2 / (valor1 + valor2 + valor3), 2)) * 100 >= 5) { percent2 = ((Math.Round(valor2 / (valor1 + valor2 + valor3), 2)) * 100).ToString() + "%"; } else { percent2 = ""; } if ((Math.Round(valor3 / (valor1 + valor2 + valor3), 2)) * 100 >= 5) { percent3 = ((Math.Round(valor3 / (valor1 + valor2 + valor3), 2)) * 100).ToString() + "%"; } else { percent3 = ""; } series1.Points.Add(valor1); series1.Points.Add(valor2); series1.Points.Add(valor3); var p1 = series1.Points[0]; p1.AxisLabel = percent1; p1.LegendText = "Alimentos"; var p2 = series1.Points[1]; p2.AxisLabel = percent2; p2.LegendText = "Bebidas"; var p3 = series1.Points[2]; p3.AxisLabel = percent3; p3.LegendText = "Outros"; }
private void CarregaDiaENoite() { graficoComparativo1.Series[0].Points.Clear(); graficoComparativo1.Series[1].Points.Clear(); DateTime diaI = new DateTime(Convert.ToInt32(numAno.Value), Convert.ToInt32(cbMes.SelectedValue), 1); DateTime diaF = diaI.AddDays(-(diaI.Day - 1)).AddMonths(1).AddDays(-1); DateTime DiaA = diaI; int unidade = Convert.ToInt32(cbUnidade.SelectedValue); int paxD, paxN, p, c; double cmvD, cmvN; DALConexao cx = new DALConexao(DadosDaConexao.StringDaConexao); BLLConsultaCMV bll = new BLLConsultaCMV(cx); DataTable TabelaCustoD, TabelaCustoN, TabelaPax, totalCustoD, totalCustoN, totalCusto, totalPaxD, totalPaxN; TabelaCustoD = bll.TabelaCustoPorTutno(unidade, diaI, diaF, "a"); TabelaCustoN = bll.TabelaCustoPorTutno(unidade, diaI, diaF, "j"); TabelaPax = bll.TabelaPaxPorDia(unidade, diaI, diaF); totalCustoD = bll.TotalCustoAeB(unidade, diaI, diaF, "a"); totalCustoN = bll.TotalCustoAeB(unidade, diaI, diaF, "j"); totalCusto = bll.TotalCustoAeBGeral(unidade, diaI, diaF); totalPaxD = bll.TotalPax(unidade, diaI, diaF, 1); totalPaxN = bll.TotalPax(unidade, diaI, diaF, 0); DiaA = diaI; p = 0; c = 0; if (cbComparativo.SelectedValue.ToString() == "1") { cmvD = 0; cmvN = 0; for (int i = 0; i < diaF.Day; i++) { try { if (Convert.ToDateTime(TabelaCustoD.Rows[c][0]) != Convert.ToDateTime(TabelaPax.Rows[p][0])) { if (Convert.ToDateTime(TabelaCustoD.Rows[c][0]) > Convert.ToDateTime(TabelaPax.Rows[p][0])) { cmvD = 0; p++; } else { cmvD = 0; c++; } } else { if (Convert.ToDateTime(TabelaCustoD.Rows[c][0]) == DiaA) { cmvD = Math.Round(Convert.ToDouble(TabelaCustoD.Rows[c][1]) / Convert.ToDouble(TabelaPax.Rows[p][1]), 2) * -1; c++; p++; } else { cmvD = 0; } } } catch { cmvD = 0; p++; c++; } graficoComparativo1.Series["Dia"].Points.AddXY(DiaA.Day.ToString(), cmvD); DiaA = DiaA.AddDays(1); } DiaA = diaI; p = 0; c = 0; for (int i = 0; i < diaF.Day; i++) { try { if (Convert.ToDateTime(TabelaCustoN.Rows[c][0]) != Convert.ToDateTime(TabelaPax.Rows[p][0])) { if (Convert.ToDateTime(TabelaCustoN.Rows[c][0]) > Convert.ToDateTime(TabelaPax.Rows[p][0])) { cmvN = 0; p++; } else { cmvN = 0; c++; } } else { if (Convert.ToDateTime(TabelaCustoN.Rows[c][0]) == DiaA) { cmvN = Math.Round(Convert.ToDouble(TabelaCustoN.Rows[c][1]) / Convert.ToDouble(TabelaPax.Rows[p][1]), 2) * -1; c++; p++; } else { cmvN = 0; } } } catch { cmvN = 0; p++; c++; } graficoComparativo1.Series["Noite"].Points.AddXY(DiaA.Day.ToString(), cmvN); DiaA = DiaA.AddDays(1); } try { paxD = Convert.ToInt32(totalPaxD.Rows[0][0]); paxN = Convert.ToInt32(totalPaxN.Rows[0][0]); cmvD = Convert.ToDouble(totalCustoD.Rows[0][0]) / (paxD + paxN); cmvN = Convert.ToDouble(totalCustoN.Rows[0][0]) / (paxD + paxN); graficoComparativo1.Series["Dia"].Points.AddXY("Total", Math.Round(cmvD * -1, 2)); graficoComparativo1.Series["Noite"].Points.AddXY("Total", Math.Round(cmvN * -1, 2)); } catch { } } else { } }