public void Excluir()
{
if (IdMov > 0)
{
Controle.ExecutaSQL("DELETE FROM MvEstoque WHERE Id_Mov=" + IdMov.ToString().Trim());
Controle.ExecutaSQL("DELETE FROM MvEstoqueItens WHERE Id_Mov=" + IdMov.ToString().Trim());
}
}
public void CalcularImposto()
{
DataSet Itens = new DataSet();
Itens = Controle.ConsultaTabela("SELECT * FROM MVESTOQUEITENS WHERE ID_MOV=" + IdMov.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()) - (decimal.Parse(Itens.Tables[0].Rows[I]["VlrTotal"].ToString()) * decimal.Parse(Itens.Tables[0].Rows[I]["PercRed"].ToString()) / 100);
}
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()
{
if (TpMov == "S_TRA")
{
Controle.ExecutaSQL("UPDATE MvEstoque Set ID_MovChave=0,Status=0,Id_FormaPgto=0 Where Id_Mov=" + IdMov.ToString());
}
else
{
Controle.ExecutaSQL("UPDATE MvEstoque Set Status=0,Id_FormaPgto=0 Where Id_Mov=" + IdMov.ToString());
}
Status = 0;
IdFormaPgto = 0;
}
public void Concluir()
{
Controle.ExecutaSQL("UPDATE MvEstoque Set Status=1,Id_FormaPgto=" + IdFormaPgto.ToString() + " Where Id_Mov=" + IdMov.ToString());
Status = 1;
}
public void CalcularImposto()
{
DataSet Itens = new DataSet();
Itens = Controle.ConsultaTabela("SELECT T1.*,T2.CREDITOIPI FROM MVESTOQUEITENS T1 LEFT JOIN PRODUTOS T2 ON (T2.ID_PRODUTO=T1.ID_PRODUTO) WHERE T1.ID_MOV=" + IdMov.ToString());
decimal T_BIcms = 0;
decimal V_Icms = 0;
decimal V_Ipi = 0;
decimal VlrItem = 0;
decimal CredIPI = 0;
decimal T_Frete = 0;
decimal BIcmsSub = 0;
decimal TIcmsSub = 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());
}
T_Frete = T_Frete + decimal.Parse(Itens.Tables[0].Rows[I]["VlrFrete"].ToString());
if (decimal.Parse(Itens.Tables[0].Rows[I]["VlrIcms_Sub"].ToString()) > 0)
{
BIcmsSub = BIcmsSub + decimal.Parse(Itens.Tables[0].Rows[I]["VlrTotal"].ToString());
TIcmsSub = TIcmsSub + decimal.Parse(Itens.Tables[0].Rows[I]["VlrIcms_Sub"].ToString());
}
}
}
Controle.ExecutaSQL("UPDATE MVESTOQUE SET B_IcmsSub=" + Controle.FloatToStr(BIcmsSub, 2) + ",VlrIcmsSub = " + Controle.FloatToStr(TIcmsSub, 2) + ",VlrFrete=" + Controle.FloatToStr(T_Frete, 2) + ", OutrosIPI=" + Controle.FloatToStr(CredIPI, 2) + ", B_Icms=" + Controle.FloatToStr(T_BIcms, 2) + ",VlrIcms=" + Controle.FloatToStr(V_Icms, 2) + ",VlrIpi=" + Controle.FloatToStr(V_Ipi, 2) + "WHERE ID_MOV=" + IdMov.ToString());
}
