private void BtnConfirmar_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Confirma a Informação de Cobrança ?", "Confirmação", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (TxtRetorno.Text.Trim() != "/ /")
{
TxtObservacao.Text = TxtObservacao.Text + " Data Retorno: " + TxtRetorno.Text.Trim();
}
string Obs = "(" + FrmPrincipal.Perfil_Usuario.Usuario.Trim() + ") " + FrmPrincipal.DtHrServidor().ToShortDateString() + " " + FrmPrincipal.DtHrServidor().ToShortTimeString() + " - " + TxtObservacao.Text.Trim() + " \r\n";
Cobranca.LerDados(0);
Cobranca.IdPagRec = Financ.IdLanc;
Cobranca.IdPessoa = Financ.IdPessoa;
Cobranca.Data = FrmPrincipal.DtHrServidor();
Cobranca.Informacao = Obs;
Cobranca.GravarDados();
if (TxtRetorno.Text.Trim() != "/ /")
{
Controle.ExecutaSQL("Update RegCobranca set DtRetorno=Convert(DateTime,'" + TxtRetorno.Text.Trim() + "',103) where Id_lanc=" + Cobranca.IdLanc.ToString());
}
LerInformacoes();
}
}
private void BtnConfirmar_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Confirma o Registro da Informação", "Confirmação", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string Obs = "'(" + FrmPrincipal.Perfil_Usuario.Usuario.Trim() + ") " + FrmPrincipal.DtHrServidor().ToShortDateString() + " " + FrmPrincipal.DtHrServidor().ToShortTimeString() + " - " + TxtObservacao.Text.Trim() + " \r\n'";
Controle.ExecutaSQL("Update MVVenda set ObsCancelamento=rtrim(convert(char(3000),isnull(ObsCancelamento,''))) + " + Obs + " WHERE ID_VENDA=" + IdVenda.ToString());
LerInformacoes();
RegInf = true;
Close();
}
}
private void VerificaPromocao()
{
String sSQL = "Select * from PromocaoProdutosItens T1" +
" Left Join PromocaoProdutos t2 on (t2.Id_Promocao=T1.Id_Promocao) " +
" Where convert(DateTime,convert(char,GETDATE(),103),103) >= CONVERT(DATETIME,T2.DTINICIO,103) " +
" AND convert(DateTime,convert(char,GETDATE(),103),103) <= CONVERT(DATETIME,T2.DTFINAL,103) " +
" AND t2.ATIVO=1 AND T2.TIPOPROMOCAO in (0,4) AND T1.ATIVO=1";
DateTime Data = FrmPrincipal.DtHrServidor();
String sSQLDia = "";
if (Data.DayOfWeek == DayOfWeek.Monday)
{
sSQLDia = sSQLDia + " and t2.Segunda=1";
}
if (Data.DayOfWeek == DayOfWeek.Tuesday)
{
sSQLDia = sSQLDia + " and t2.Terca=1";
}
if (Data.DayOfWeek == DayOfWeek.Wednesday)
{
sSQLDia = sSQLDia + " and t2.Quarta=1";
}
if (Data.DayOfWeek == DayOfWeek.Thursday)
{
sSQLDia = sSQLDia + " and t2.Quinta=1";
}
if (Data.DayOfWeek == DayOfWeek.Friday)
{
sSQLDia = sSQLDia + " and t2.Sexta=1";
}
if (Data.DayOfWeek == DayOfWeek.Saturday)
{
sSQLDia = sSQLDia + " and t2.Sabado=1";
}
if (Data.DayOfWeek == DayOfWeek.Sunday)
{
sSQLDia = sSQLDia + " and t2.Domingo=1";
}
if (FrmPrincipal.Perfil_Usuario.IdPromocao > 0)
{
sSQLDia = sSQLDia + " or (T2.PorUsuario = 1 and t1.Id_Promocao = " + FrmPrincipal.Perfil_Usuario.IdPromocao.ToString() + ")";
}
else
{
sSQLDia = sSQLDia + " and T2.PorUsuario = 0";
}
SqlDataReader TabPromocao = Controle.ConsultaSQL(sSQL + sSQLDia);
bool DiaPromocao = false;
while (TabPromocao.Read())
{
if (TabPromocao["TipoCliente"].ToString() == "1" && TipoCliente != 0)
{
continue;
}
if (TabPromocao["TipoCliente"].ToString() == "2" && (TipoCliente != 3 || TipoCliente != 6 || TipoCliente != 7))
{
continue;
}
DiaPromocao = false;
if (Data.DayOfWeek == DayOfWeek.Monday && int.Parse(TabPromocao["Segunda"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Tuesday && int.Parse(TabPromocao["Terca"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Wednesday && int.Parse(TabPromocao["Quarta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Thursday && int.Parse(TabPromocao["Quinta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Friday && int.Parse(TabPromocao["Sexta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Saturday && int.Parse(TabPromocao["Sabado"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Sunday && int.Parse(TabPromocao["Domingo"].ToString()) == 1)
{
DiaPromocao = true;
}
if (DiaPromocao)
{
for (int I = GridDados.Rows.Count - 1; I >= 0; I--)
{
if (int.Parse(TabPromocao["ID_PRODUTO"].ToString()) == int.Parse(GridDados.Rows[I].Cells[0].Value.ToString()))
{
GridDados.Rows[I].Cells["ColIdPromocao"].Value = int.Parse(TabPromocao["ID_PROMOCAO"].ToString());
GridDados.Rows[I].Cells["NmPromocao"].Value = TabPromocao["Descricao"].ToString().Trim();
GridDados.Rows[I].Cells["P_Sensacional"].Value = decimal.Parse(TabPromocao["PRCSENSACIONAL"].ToString());
GridDados.Rows[I].Cells["P_Especial"].Value = decimal.Parse(TabPromocao["PRCESPECIAL"].ToString());
GridDados.Rows[I].Cells["P_Varejo"].Value = decimal.Parse(TabPromocao["PRCVAREJO"].ToString());
GridDados.Rows[I].Cells["P_Minimo"].Value = decimal.Parse(TabPromocao["PRCMINIMO"].ToString());
GridDados.Rows[I].Cells["P_Atacado"].Value = decimal.Parse(TabPromocao["PRCATACADO"].ToString());
GridDados.Rows[I].Cells["PComProm"].Value = decimal.Parse(TabPromocao["PComissao"].ToString());
if (int.Parse(TabPromocao["TipoPromocao"].ToString()) == 4)
{
GridDados.Rows[I].Cells["PromQtdeKit"].Value = 4;
}
else
{
GridDados.Rows[I].Cells["PromQtdeKit"].Value = 0;
}
}
}
}
}
//Verificando Promoção Qtde de Produto
TabPromocao = Controle.ConsultaSQL("Select * from Produtos T1" +
" Left Join PromocaoProdutos t2 on (t2.Id_Promocao=T1.Id_Promocao) " +
" Where convert(DateTime,convert(char,GETDATE(),103),103) >= CONVERT(DATETIME,T2.DTINICIO,103) " +
" AND convert(DateTime,convert(char,GETDATE(),103),103) <= CONVERT(DATETIME,T2.DTFINAL,103) AND t2.ATIVO=1 AND T2.TIPOPROMOCAO=1" + sSQLDia);
DiaPromocao = false;
while (TabPromocao.Read())
{
if (TabPromocao["TipoCliente"].ToString() == "1" && TipoCliente != 0)
{
continue;
}
if (TabPromocao["TipoCliente"].ToString() == "2" && (TipoCliente != 3 || TipoCliente != 6 || TipoCliente != 7))
{
continue;
}
DiaPromocao = false;
if (Data.DayOfWeek == DayOfWeek.Monday && int.Parse(TabPromocao["Segunda"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Tuesday && int.Parse(TabPromocao["Terca"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Wednesday && int.Parse(TabPromocao["Quarta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Thursday && int.Parse(TabPromocao["Quinta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Friday && int.Parse(TabPromocao["Sexta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Saturday && int.Parse(TabPromocao["Sabado"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Sunday && int.Parse(TabPromocao["Domingo"].ToString()) == 1)
{
DiaPromocao = true;
}
//if (!DiaPromocao)
// return;
for (int I = GridDados.Rows.Count - 1; I >= 0; I--)
{
if (int.Parse(TabPromocao["ID_PRODUTO"].ToString()) == int.Parse(GridDados.Rows[I].Cells[0].Value.ToString()))
{
if (!DiaPromocao)
{
DataRow item = TabItens.Tables[0].Rows[I];
if (item != null)
{
TabItens.Tables[0].Rows.Remove(item);
}
}
else
{
GridDados.Rows[I].Cells["ColIdPromocao"].Value = int.Parse(TabPromocao["ID_PROMOCAO"].ToString());
GridDados.Rows[I].Cells["PComProm"].Value = decimal.Parse(TabPromocao["PComissao"].ToString());
GridDados.Rows[I].Cells["PromQtdeKit"].Value = 1;
}
}
}
}
//Verificando Promoção Valor Pedido
sSQL = "Select t1.*,t2.*,(select isnull(sum(Qtde),0)+1 from MvVendaItens where Id_Promocao=t1.id_promocao and id_Venda=" + IdVenda.ToString() + ") as QtdeProm," +
" (select isnull(sum(VlrTotal),0) from MvVendaItens where Id_Promocao=t1.id_promocao and id_Venda=" + IdVenda.ToString() + ") as TotalItem from PromocaoProdutosItens T1" +
" Left Join PromocaoProdutos t2 on (t2.Id_Promocao=T1.Id_Promocao) " +
" Where convert(DateTime,convert(char,GETDATE(),103),103) >= CONVERT(DATETIME,T2.DTINICIO,103) " +
" AND convert(DateTime,convert(char,GETDATE(),103),103) <= CONVERT(DATETIME,T2.DTFINAL,103) " +
" AND t2.ATIVO=1 AND T2.TIPOPROMOCAO=2 AND T1.ATIVO=1";
if (FrmPrincipal.Perfil_Usuario.IdPromocao > 0)
{
sSQL = sSQL + " or (T2.PorUsuario = 1 and t1.Id_Promocao = " + FrmPrincipal.Perfil_Usuario.IdPromocao.ToString() + ")";
}
else
{
sSQL = sSQL + " and T2.PorUsuario = 0";
}
TabPromocao = Controle.ConsultaSQL(sSQL);
DiaPromocao = false;
while (TabPromocao.Read())
{
if (TabPromocao["TipoCliente"].ToString() == "1" && TipoCliente != 0)
{
continue;
}
if (TabPromocao["TipoCliente"].ToString() == "2" && (TipoCliente != 3 || TipoCliente != 6 || TipoCliente != 7))
{
continue;
}
DiaPromocao = false;
if (Data.DayOfWeek == DayOfWeek.Monday && int.Parse(TabPromocao["Segunda"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Tuesday && int.Parse(TabPromocao["Terca"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Wednesday && int.Parse(TabPromocao["Quarta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Thursday && int.Parse(TabPromocao["Quinta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Friday && int.Parse(TabPromocao["Sexta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Saturday && int.Parse(TabPromocao["Sabado"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Sunday && int.Parse(TabPromocao["Domingo"].ToString()) == 1)
{
DiaPromocao = true;
}
if (DiaPromocao)
{
for (int I = GridDados.Rows.Count - 1; I >= 0; I--)
{
//if ((VlrPedido - decimal.Parse(TabPromocao["TotalItem"].ToString())) < (decimal.Parse(TabPromocao["VlrPedido"].ToString()) * decimal.Parse(TabPromocao["QtdeProm"].ToString())))
//if (int.Parse(TabPromocao["ID_PRODUTO"].ToString()) == int.Parse(GridDados.Rows[I].Cells[0].Value.ToString()) && VlrPedido >= decimal.Parse(TabPromocao["VLRPEDIDO"].ToString()))
if (int.Parse(TabPromocao["ID_PRODUTO"].ToString()) == int.Parse(GridDados.Rows[I].Cells[0].Value.ToString()) && (VlrPedido - decimal.Parse(TabPromocao["TotalItem"].ToString())) >= (decimal.Parse(TabPromocao["VlrPedido"].ToString()) * decimal.Parse(TabPromocao["QtdeProm"].ToString())))
{
GridDados.Rows[I].Cells["ColIdPromocao"].Value = int.Parse(TabPromocao["ID_PROMOCAO"].ToString());
GridDados.Rows[I].Cells["NmPromocao"].Value = TabPromocao["Descricao"].ToString().Trim();
GridDados.Rows[I].Cells["P_Sensacional"].Value = decimal.Parse(TabPromocao["PRCSENSACIONAL"].ToString());
GridDados.Rows[I].Cells["P_Especial"].Value = decimal.Parse(TabPromocao["PRCESPECIAL"].ToString());
GridDados.Rows[I].Cells["P_Varejo"].Value = decimal.Parse(TabPromocao["PRCVAREJO"].ToString());
GridDados.Rows[I].Cells["P_Minimo"].Value = decimal.Parse(TabPromocao["PRCMINIMO"].ToString());
GridDados.Rows[I].Cells["P_Atacado"].Value = decimal.Parse(TabPromocao["PRCATACADO"].ToString());
GridDados.Rows[I].Cells["PComProm"].Value = decimal.Parse(TabPromocao["PComissao"].ToString());
}
}
}
}
//Verificando Promoção Valor Produto
sSQL = "Select * from PromocaoProdutosItens T1" +
" Left Join PromocaoProdutos t2 on (t2.Id_Promocao=T1.Id_Promocao) " +
" Where convert(DateTime,convert(char,GETDATE(),103),103) >= CONVERT(DATETIME,T2.DTINICIO,103) " +
" AND convert(DateTime,convert(char,GETDATE(),103),103) <= CONVERT(DATETIME,T2.DTFINAL,103) " +
" AND t2.ATIVO=1 AND T2.TIPOPROMOCAO=3 AND T1.ATIVO=1" +
" AND EXISTS (SELECT ID_PRODUTO FROM MVVENDAITENS T3 WHERE T3.ID_PRODUTO=T2.ID_PRODUTO AND ID_VENDA=" + IdVenda.ToString() + ")";
if (FrmPrincipal.Perfil_Usuario.IdPromocao > 0)
{
sSQL = sSQL + " or (T2.PorUsuario = 1 and t1.Id_Promocao = " + FrmPrincipal.Perfil_Usuario.IdPromocao.ToString() + ")";
}
else
{
sSQL = sSQL + " and T2.PorUsuario = 0";
}
TabPromocao = Controle.ConsultaSQL(sSQL);
DiaPromocao = false;
while (TabPromocao.Read())
{
if (TabPromocao["TipoCliente"].ToString() == "1" && TipoCliente != 0)
{
continue;
}
if (TabPromocao["TipoCliente"].ToString() == "2" && (TipoCliente != 3 || TipoCliente != 6 || TipoCliente != 7))
{
continue;
}
DiaPromocao = false;
if (Data.DayOfWeek == DayOfWeek.Monday && int.Parse(TabPromocao["Segunda"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Tuesday && int.Parse(TabPromocao["Terca"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Wednesday && int.Parse(TabPromocao["Quarta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Thursday && int.Parse(TabPromocao["Quinta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Friday && int.Parse(TabPromocao["Sexta"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Saturday && int.Parse(TabPromocao["Sabado"].ToString()) == 1)
{
DiaPromocao = true;
}
if (Data.DayOfWeek == DayOfWeek.Sunday && int.Parse(TabPromocao["Domingo"].ToString()) == 1)
{
DiaPromocao = true;
}
if (DiaPromocao)
{
for (int I = GridDados.Rows.Count - 1; I >= 0; I--)
{
if (int.Parse(TabPromocao["ID_PRODUTO"].ToString()) == int.Parse(GridDados.Rows[I].Cells[0].Value.ToString()))
{
GridDados.Rows[I].Cells["ColIdPromocao"].Value = int.Parse(TabPromocao["ID_PROMOCAO"].ToString());
GridDados.Rows[I].Cells["NmPromocao"].Value = TabPromocao["Descricao"].ToString().Trim();
GridDados.Rows[I].Cells["P_Sensacional"].Value = decimal.Parse(TabPromocao["PRCSENSACIONAL"].ToString());
GridDados.Rows[I].Cells["P_Especial"].Value = decimal.Parse(TabPromocao["PRCESPECIAL"].ToString());
GridDados.Rows[I].Cells["P_Varejo"].Value = decimal.Parse(TabPromocao["PRCVAREJO"].ToString());
GridDados.Rows[I].Cells["P_Minimo"].Value = decimal.Parse(TabPromocao["PRCMINIMO"].ToString());
GridDados.Rows[I].Cells["P_Atacado"].Value = decimal.Parse(TabPromocao["PRCATACADO"].ToString());
GridDados.Rows[I].Cells["PComProm"].Value = decimal.Parse(TabPromocao["PComissao"].ToString());
}
}
}
}
}
