protected void btnVisualizar_Click(object sender, EventArgs e)
{
try
{
string sUser = UsuarioWeb.GetNomeUsuarioConectado(Session);
Session["DadosConsultaRepresentante"] = null;
UsuarioWeb objUsuario = Session["ObjetoUsuario"] as UsuarioWeb;
string sCodRepresentante = string.Empty;
if (ckbVendedor.Checked)
{
sCodRepresentante = cbxVendedor.SelectedValue;
}
if (txtDataInicial.Text != "" && txtDataFinal.Text != "")
{
dsVendas ds = GetVendasByRepresentantes(Convert.ToDateTime(txtDataInicial.Text), Convert.ToDateTime(txtDataFinal.Text), objUsuario, sCodRepresentante);
Session["VendasRepresLista"] = ds;
string sDtInicial = txtDataInicial.Text.Replace("/", ".");
string sDtFinal = txtDataFinal.Text.Replace("/", ".");
Response.Redirect("~/ViewVendasPorRepresentanteListagem.aspx?DT_INI=" + sDtInicial + "&DT_FIM=" + sDtFinal);
}
else
{
MessageHLP.ShowPopUpMsg("As datas estão incorretas.", this);
}
}
catch (Exception ex)
{
MessageHLP.ShowPopUpMsg(ex.Message, this.Page);
}
}
public override global::System.Data.DataSet Clone()
{
dsVendas cln = ((dsVendas)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
dsVendas ds = new dsVendas();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
protected dsVendas GetVendasByRepresentantes(DateTime dtIni, DateTime dtFim, UsuarioWeb objUsuario, string sCodRepresentante = "")
{
dsVendas ds = new dsVendas();
string sdtIni = dtIni.ToShortDateString().Replace("/", ".");
string sdtFim = dtFim.ToShortDateString().Replace("/", ".");
string stpdocs = objUsuario.oTabelas.hlpDbFuncoes.qrySeekValue("EMPRESA", "DS_TPDOCWEB", "CD_EMPRESA = '" + objUsuario.oTabelas.sEmpresa + "'");
string sTpdocFinal = "";
foreach (string item in stpdocs.Split(';'))
{
string[] tpdoc = item.Split(',');
if (tpdoc.Length > 1)
{
sTpdocFinal += "'" + tpdoc[1].ToString().Trim() + "',";
}
}
sTpdocFinal = sTpdocFinal.Remove(sTpdocFinal.Length - 1, 1);
StringBuilder sQuery = new StringBuilder();
sQuery.Append("select v.cd_vend, coalesce(sum(p.vl_totalped),0) TOTAL,v.nm_vend NM_VEND ");
sQuery.Append("from pedido p inner join clifor c on p.cd_cliente = c.cd_clifor inner join vendedor v on v.cd_vend = c.cd_vend1 ");
sQuery.Append("where coalesce(v.st_acessa_web,'N') = 'S' and p.dt_pedido between '{0}' and '{1}' and ");
sQuery.Append("p.cd_tipodoc in ({2}) ");
if (sCodRepresentante != "")
{
sQuery.Append("and v.cd_vend = '" + sCodRepresentante + "' ");
}
sQuery.Append("group by v.cd_vend,v.nm_vend order by v.cd_vend ");
string sQueryFinal = string.Format(sQuery.ToString(), sdtIni, sdtFim, sTpdocFinal);
StringBuilder sQueryTotDia = new StringBuilder();
sQueryTotDia.Append("select coalesce(sum(p.vl_totalped),0) from pedido p inner join clifor c on p.cd_cliente = c.cd_clifor inner join vendedor v on ");
sQueryTotDia.Append("v.cd_vend = c.cd_vend1 where p.cd_vend1 = '{0}' and p.dt_pedido = '{1}' and p.cd_tipodoc in ('{2}')");
dsVendas.VendasRow rowVendas = ds.Vendas.NewVendasRow();
foreach (DataRow item in objUsuario.oTabelas.hlpDbFuncoes.qrySeekRet(sQueryFinal).Rows)
{
rowVendas.CD_VEND = item["CD_VEND"].ToString();
rowVendas.TOTAL = item["TOTAL"].ToString();
rowVendas.NM_VEND = item["NM_VEND"].ToString();
rowVendas.TOTAL_DIA = objUsuario.oTabelas.hlpDbFuncoes.qrySeekValue("PEDIDO", "coalesce(sum(vl_totalped),0)",
string.Format("cd_vend1 = '{0}' and dt_pedido = '{1}' and cd_tipodoc in ({2})",
rowVendas.CD_VEND,
DateTime.Today.ToShortDateString().Replace("/", "."),
sTpdocFinal));
ds.Vendas.AddVendasRow(rowVendas);
rowVendas = ds.Vendas.NewVendasRow();
}
return(ds);
}
protected dsVendas GetVendasByRepresentantes(DateTime dtIni, DateTime dtFim, UsuarioWeb objUsuario, string sCodRepresentante = "")
{
dsVendas ds = new dsVendas();
string sdtIni = dtIni.ToShortDateString().Replace("/", ".");
string sdtFim = dtFim.ToShortDateString().Replace("/", ".");
string stpdocs = objUsuario.oTabelas.hlpDbFuncoes.qrySeekValue("EMPRESA", "DS_TPDOCWEB", "CD_EMPRESA = '" + objUsuario.oTabelas.sEmpresa + "'");
string sTpdocFinal = "";
foreach (string item in stpdocs.Split(';'))
{
string[] tpdoc = item.Split(',');
if (tpdoc.Length > 1)
{
sTpdocFinal += "'" + tpdoc[1].ToString().Trim() + "',";
}
}
sTpdocFinal = sTpdocFinal.Remove(sTpdocFinal.Length - 1, 1);
StringBuilder sQuery = new StringBuilder();
sQuery.Append("select v.cd_vend, coalesce(sum(p.vl_totalped),0) TOTAL,v.nm_vend NM_VEND ");
sQuery.Append("from pedido p inner join clifor c on p.cd_cliente = c.cd_clifor inner join vendedor v on v.cd_vend = c.cd_vend1 ");
sQuery.Append("where coalesce(v.st_acessa_web,'N') = 'S' and p.dt_pedido between '{0}' and '{1}' and ");
sQuery.Append("p.cd_tipodoc in ({2}) ");
if (sCodRepresentante != "")
{
sQuery.Append("and v.cd_vend = '" + sCodRepresentante + "' ");
}
sQuery.Append("group by v.cd_vend,v.nm_vend order by v.cd_vend ");
string sQueryFinal = string.Format(sQuery.ToString(), sdtIni, sdtFim, sTpdocFinal);
StringBuilder sQueryTotDia = new StringBuilder();
sQueryTotDia.Append("select coalesce(sum(p.vl_totalped),0) from pedido p inner join clifor c on p.cd_cliente = c.cd_clifor inner join vendedor v on ");
sQueryTotDia.Append("v.cd_vend = c.cd_vend1 where p.cd_vend1 = '{0}' and p.dt_pedido = '{1}' and p.cd_tipodoc in ('{2}')");
dsVendas.VendasRow rowVendas = ds.Vendas.NewVendasRow();
foreach (DataRow item in objUsuario.oTabelas.hlpDbFuncoes.qrySeekRet(sQueryFinal).Rows)
{
rowVendas.CD_VEND = item["CD_VEND"].ToString();
rowVendas.TOTAL = item["TOTAL"].ToString();
rowVendas.NM_VEND = item["NM_VEND"].ToString();
rowVendas.TOTAL_DIA = objUsuario.oTabelas.hlpDbFuncoes.qrySeekValue("PEDIDO", "coalesce(sum(vl_totalped),0)",
string.Format("cd_vend1 = '{0}' and dt_pedido = '{1}' and cd_tipodoc in ({2})",
rowVendas.CD_VEND,
DateTime.Today.ToShortDateString().Replace("/", "."),
sTpdocFinal));
ds.Vendas.AddVendasRow(rowVendas);
rowVendas = ds.Vendas.NewVendasRow();
}
return ds;
}
protected void btnVisualizar_Click(object sender, EventArgs e)
{
string sUser = UsuarioWeb.GetNomeUsuarioConectado(Session);
if (sUser != "")
{
Session["DadosConsultaRepresentante"] = null;
UsuarioWeb objUsuario = Session["ObjetoUsuario"] as UsuarioWeb;
string sCodRepresentante = objUsuario.oTabelas.CdVendedorAtual;
if (txtDataInicial.Text != "" && txtDataFinal.Text != "")
{
dsVendas ds = GetVendasByRepresentantes(Convert.ToDateTime(txtDataInicial.Text), Convert.ToDateTime(txtDataFinal.Text), objUsuario, sCodRepresentante);
Session["VendasRepresLista"] = ds;
string sDtInicial = txtDataInicial.Text.Replace("/", ".");
string sDtFinal = txtDataFinal.Text.Replace("/", ".");
Response.Redirect("~/ViewVendasPorRepresentanteListagem.aspx?DT_INI=" + sDtInicial + "&DT_FIM=" + sDtFinal);
}
else
{
MessageHLP.ShowPopUpMsg("As datas estão incorretas.", this);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sUser = UsuarioWeb.GetNomeUsuarioConectado(Session);
if (Request["DT_INI"] == null || Request["DT_FIM"] == null)
{
Response.Redirect("~/Home.aspx");
}
string sDataInicial = Request["DT_INI"].ToString();
string sDataFinal = Request["DT_FIM"].ToString();
dsVendas dsImpressao = (dsVendas)Session["VendasRepresLista"];
rpt.Load(Server.MapPath("rptVendasRepres.rpt"));
rpt.SetDataSource(dsImpressao);
CrystalReportViewer1.ReportSource = rpt;
string sfiltro = string.Format("Período de {0} à {1}", sDataInicial, sDataFinal);
if (rpt.DataDefinition.FormulaFields["Filtro"] != null)
{
rpt.DataDefinition.FormulaFields["Filtro"].Text = "\"" + sfiltro + "\"";
}
GerarPDF();
}
}
