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()); } } } } }