private void dgvNFe_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvNFe.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
string ValueCell = dgvNFe.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString().TrimEnd().ToUpper();
if (ValueCell != "S" && ValueCell != "N")
{
MessageBox.Show("Digite apenas S ou N!");
dgvNFe.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "N";
}
else
{
dgvNFe.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = ValueCell;
NOTAFISCALEEntity NOTAFISCALTy = new NOTAFISCALEEntity();
NOTAFISCALEProvider NOTAFISCALEP = new NOTAFISCALEProvider();
NOTAFISCALTy = NOTAFISCALEP.Read(Convert.ToInt32(LIS_NOTAFISCALEColl[e.RowIndex].IDNOTAFISCALE));
if (e.ColumnIndex == 1)
{
NOTAFISCALTy.FLAGCANCELADA = ValueCell.ToUpper();
NOTAFISCALEP.Save(NOTAFISCALTy);
}
else if (e.ColumnIndex == 2)
{
NOTAFISCALTy.FLAGENVIADA = ValueCell.ToUpper();
NOTAFISCALEP.Save(NOTAFISCALTy);
}
else if (e.ColumnIndex == 3)
{
NOTAFISCALTy.FLAGINUTILIZADO = ValueCell.ToUpper();
NOTAFISCALEP.Save(NOTAFISCALTy);
}
}
}
else
{
MessageBox.Show("Digite apenas S ou N!");
dgvNFe.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "N";
}
}
catch (Exception ex)
{
MessageBox.Show("Erro técnico: " + ex.Message);
}
}
private void PreencheGrid2()
{
CreaterCursor Cr = new CreaterCursor();
this.Cursor = Cr.CreateCursor(Cr.btmap, 0, 0);
try
{
TotalGeral = 0;
DataGriewDados.Rows.Clear();
foreach (var LIS_PRODUTONFEEntity in LIS_PRODUTONFE_2Coll)
{
NOTAFISCALEEntity NOTAFISCALETY = new NOTAFISCALEEntity();
NOTAFISCALEProvider NOTAFISCALEP = new NOTAFISCALEProvider();
NOTAFISCALETY = NOTAFISCALEP.Read(Convert.ToInt32(LIS_PRODUTONFEEntity.IDNOTAFISCALE));
CLIENTEEntity CLIENTETy = new CLIENTEEntity();
CLIENTEProvider CLIENTEP = new CLIENTEProvider();
CLIENTETy = CLIENTEP.Read(Convert.ToInt32(LIS_PRODUTONFEEntity.IDCLIENTE));
string NotaFiscal = NOTAFISCALETY.NOTAFISCALE;
decimal ValorTotal = Convert.ToDecimal(NOTAFISCALETY.TOTALNOTA);
TotalGeral += ValorTotal;
string FlagEnviada = NOTAFISCALETY.FLAGENVIADA;
string FLAGINUTILIZADO = NOTAFISCALETY.FLAGINUTILIZADO;
string FLAGCANCELADA = NOTAFISCALETY.FLAGCANCELADA;
DataGridViewRow row1 = new DataGridViewRow();
row1.CreateCells(DataGriewDados, NotaFiscal, CLIENTETy.NOME, FlagEnviada, FLAGINUTILIZADO, FLAGCANCELADA, ValorTotal.ToString("n2"));
row1.DefaultCellStyle.Font = new Font("Arial", 8);
DataGriewDados.Rows.Add(row1);
}
DataGridViewRow rowLinha = new DataGridViewRow();
rowLinha.CreateCells(DataGriewDados, "-------", "-----------------------------", "---------", "---------", "Total geral:", TotalGeral.ToString("n2"));
rowLinha.DefaultCellStyle.Font = new Font("Arial", 8, FontStyle.Bold);
DataGriewDados.Rows.Add(rowLinha);
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
MessageBox.Show("Erro técnico: " + ex.Message);
}
}
private void AtualizaDadosNFE()
{
try
{
CreaterCursor Cr = new CreaterCursor();
this.Cursor = Cr.CreateCursor(Cr.btmap, 0, 0);
NOTAFISCALEProvider NOTAFISCALEP = new NOTAFISCALEProvider();
LIS_NOTAFISCALEProvider LIS_NOTAFISCALEP = new LIS_NOTAFISCALEProvider();
LIS_NOTAFISCALECollection LIS_NOTAFISCALEColl2 = new LIS_NOTAFISCALECollection();
RowsFiltroCollection RowRelatorio = new RowsFiltroCollection();
RowRelatorio.Add(new RowsFiltro("NFISCALE", "System.String", ">=", txtIni.Text.PadLeft(8, '0')));
RowRelatorio.Add(new RowsFiltro("NFISCALE", "System.String", "<=", txtFim.Text.PadLeft(8, '0')));
RowRelatorio.Add(new RowsFiltro("FLAGENVIADA", "System.String", "=", "N"));
LIS_NOTAFISCALEColl2 = LIS_NOTAFISCALEP.ReadCollectionByParameter(RowRelatorio);
if (LIS_NOTAFISCALEColl2.Count > 0)
{
foreach (LIS_NOTAFISCALEEntity item in LIS_NOTAFISCALEColl2)
{
NOTAFISCALEEntity NOTAFISCALETy = new NOTAFISCALEEntity();
NOTAFISCALETy = NOTAFISCALEP.Read(Convert.ToInt32(item.IDNOTAFISCALE));
NOTAFISCALETy.FLAGINUTILIZADO = "S";
NOTAFISCALEP.Save(NOTAFISCALETy);
}
this.Cursor = Cursors.Default;
}
else
{
this.Cursor = Cursors.Default;
MessageBox.Show("Não foi possível alterar as notas selecionadas!!");
}
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
MessageBox.Show("Erro técnico: " + ex.Message);
}
}
