public void Excluir()
{
if (IdNota > 0)
{
Controle.ExecutaSQL("DELETE FROM NotaFiscal WHERE Id_Nota=" + IdNota.ToString().Trim());
Controle.ExecutaSQL("DELETE FROM NotaFiscalItens WHERE Id_Nota=" + IdNota.ToString().Trim());
}
}
public void CalcularImposto()
{
DataSet Itens = new DataSet();
Itens = Controle.ConsultaTabela("SELECT * FROM NOTAFISCALITENS WHERE ID_NOTA=" + IdNota.ToString());
decimal T_BIcms = 0;
decimal V_Icms = 0;
decimal V_Ipi = 0;
decimal VlrItem = 0;
if (Itens.Tables[0].Rows.Count > 0)
{
for (int I = 0; I <= Itens.Tables[0].Rows.Count - 1; I++)
{
if (decimal.Parse(Itens.Tables[0].Rows[I]["VlrIcms"].ToString()) > 0)
{
if (decimal.Parse(Itens.Tables[0].Rows[I]["PercRed"].ToString( )) > 0)
{
VlrItem = decimal.Parse(Itens.Tables[0].Rows[I]["VlrTotal"].ToString()) - Math.Round((decimal.Parse(Itens.Tables[0].Rows[I]["VlrTotal"].ToString()) * decimal.Parse(Itens.Tables[0].Rows[I]["PercRed"].ToString()) / 100), 2);// MidpointRounding.AwayFromZero);
}
else
{
VlrItem = decimal.Parse(Itens.Tables[0].Rows[I]["VlrTotal"].ToString());
}
T_BIcms = T_BIcms + VlrItem;
V_Icms = V_Icms + decimal.Parse(Itens.Tables[0].Rows[I]["VlrIcms"].ToString());
}
if (decimal.Parse(Itens.Tables[0].Rows[I]["VlrIpi"].ToString()) > 0)
{
V_Ipi = V_Ipi + decimal.Parse(Itens.Tables[0].Rows[I]["VlrIpi"].ToString());
}
}
}
BIcms = T_BIcms;
VlrIcms = V_Icms;
VlrIpi = V_Ipi;
}
public void Cancelar()
{
Controle.ExecutaSQL("UPDATE NotaFiscal Set Status=2,DataCancel=convert(DateTime,'" + DateTime.Now.Date.ToShortDateString() + "',103) Where Id_Nota=" + IdNota.ToString());
Status = 2;
}
public void Concluir()
{
Controle.ExecutaSQL("UPDATE NotaFiscal Set Status=1 Where Id_Nota=" + IdNota.ToString());
Status = 1;
}
