protected void lnk_litigios_Click(object sender, EventArgs e)
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
DataTable dt;
cLitigios oDetalle = new cLitigios(ref oConn);
oDetalle.nKeyCliente = hdd_cliente.Value;
oDetalle.CodHolding = hdd_holding.Value;
dt = oDetalle.getDetalle();
gdDetalle.DataSource = dt;
gdDetalle.DataBind();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
toExcel.Visible = true;
}
}
dt = null;
hdd_periodo.Value = string.Empty;
num_factura.Text = string.Empty;
nom_cliente.Text = string.Empty;
}
oConn.Close();
}
public void ProcessRequest(HttpContext context)
{
DataTable dt = null;
DBConn oConn = new DBConn();
if (oConn.Open())
{
cLitigios oDetalle = new cLitigios(ref oConn);
oDetalle.nKeyCliente = oWeb.GetData("hdd_cliente");
oDetalle.CodHolding = oWeb.GetData("hdd_holding");
if (!string.IsNullOrEmpty(oWeb.GetData("nom_cliente")))
{
oDetalle.NomCliente = oWeb.GetData("nom_cliente");
}
if (!string.IsNullOrEmpty(oWeb.GetData("num_factura")))
{
oDetalle.NumFactura = oWeb.GetData("num_factura");
}
if (!string.IsNullOrEmpty(oWeb.GetData("hdd_periodo")))
{
oDetalle.Periodo = oWeb.GetData("hdd_periodo");
oDetalle.OrderBy = true;
}
dt = oDetalle.getDetalle();
}
oConn.Close();
System.Web.HttpResponse oResponse = System.Web.HttpContext.Current.Response;
XLWorkbook wb = new XLWorkbook();
wb.Worksheets.Add(dt, "ReporteVentas");
oResponse.Clear();
oResponse.Buffer = true;
oResponse.Charset = "";
oResponse.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
oResponse.AddHeader("content-disposition", "attachment;filename=Reporte_Litigios_" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx");
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(oResponse.OutputStream);
oResponse.Flush();
oResponse.End();
}
}
public void getDetalle()
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
DataTable dt;
cLitigios oDetalle = new cLitigios(ref oConn);
oDetalle.nKeyCliente = hdd_cliente.Value;
oDetalle.CodHolding = hdd_holding.Value;
if (!string.IsNullOrEmpty(nom_cliente.Text))
{
oDetalle.NomCliente = nom_cliente.Text;
}
if (!string.IsNullOrEmpty(num_factura.Text))
{
oDetalle.NumFactura = num_factura.Text;
}
if (!string.IsNullOrEmpty(hdd_periodo.Value))
{
oDetalle.Periodo = hdd_periodo.Value;
oDetalle.OrderBy = true;
}
dt = oDetalle.getDetalle();
gdDetalle.DataSource = dt;
gdDetalle.DataBind();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
toExcel.Visible = true;
}
}
dt = null;
}
oConn.Close();
}
protected void lnk_litigiosmayor_Click(object sender, EventArgs e)
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
DataTable dt;
cLitigios oDetalle = new cLitigios(ref oConn);
oDetalle.nKeyCliente = hdd_cliente.Value;
oDetalle.CodHolding = hdd_holding.Value;
if (!string.IsNullOrEmpty(nom_cliente.Text))
{
oDetalle.NomCliente = nom_cliente.Text;
}
if (!string.IsNullOrEmpty(num_factura.Text))
{
oDetalle.NumFactura = num_factura.Text;
}
oDetalle.Periodo = "mayor";
oDetalle.OrderBy = true;
dt = oDetalle.getDetalle();
gdDetalle.DataSource = dt;
gdDetalle.DataBind();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
toExcel.Visible = true;
}
}
dt = null;
hdd_periodo.Value = "mayor";
}
oConn.Close();
}
