public void CargarDatos(string inicio)
{
Factura f = new Factura();
f.OT = txtOT.Text;
f.Nombre = txtproveedor.Text;
if (txtnroFactura.Text.Trim() != "")
{
f.NFactura = Convert.ToInt32(txtnroFactura.Text);
}
if (txtFechaInicio.Text.Trim() != "")
{
string[] feInicio = txtFechaInicio.Text.Split('-');
f.Ciudad = feInicio[2] + "-" + feInicio[1] + "-" + feInicio[0];
}
if (txtFechaTermino.Text.Trim() != "")
{
string[] feTermino = txtFechaTermino.Text.Split('-');
f.Comuna = feTermino[2] + "-" + feTermino[1] + "-" + feTermino[0];
}
if (inicio == "comienzo")
{
f.Ciudad = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
f.Comuna = DateTime.Now.ToString("yyyy-MM-dd");
}
Controller_Factura controlf = new Controller_Factura();
RadGridOT.DataSource = controlf.listarInfExterno(f);
RadGridOT.DataBind();
}
public void CargarGrilla(int id, string Usuario)
{
Controller_Factura controlFac = new Controller_Factura();
RgTemporal.DataSource = controlFac.Listar_Detfactura(id, Usuario);
RgTemporal.DataBind();
Cargar_ProcesoExterno();
Cargar_TipoProExterno();
}
public void Cargar_ProcesoExterno()
{
Controller_Factura controlFac = new Controller_Factura();
ddlExterno.DataSource = controlFac.listarProexterno();
ddlExterno.DataTextField = "Proceso";
ddlExterno.DataValueField = "Proceso";
ddlExterno.DataBind();
ddlExterno.Items.Insert(0, new ListItem("Seleccionar", "Seleccionar"));
}
public static string DeleteItem(string ID_DetFactura)
{
Controller_Factura controlFac = new Controller_Factura();
if (controlFac.DeleteDetFactura(ID_DetFactura))
{
return("OK");
}
else
{
return("Error");
}
}
//Modificado el 22/10/2014
protected void btnSalir_Click(object sender, EventArgs e)
{
try
{
Controller_Factura controlFac = new Controller_Factura();
controlFac.UpdateDetalle(Request.QueryString["id"], 2, lblUsuario.Text, 0, 0, 0);
string popupScript = "<script language='JavaScript'>window.opener.location='ServiciosExternos.aspx?id=8&Cat=6';window.close();</script>";
Page.RegisterStartupScript("PopupScript", popupScript);
}
catch (Exception excep)
{
string popupScript = "<script language='JavaScript'>alert('A Ocurrido el Siguente Error <br/>" + excep.Message + "');</script>";
Page.RegisterStartupScript("PopupScript", popupScript);
}
}
//Modificado el 22/10/2014
protected void btnModificarvari_Click(object sender, EventArgs e)
{
try
{
if (validador(2))
{
Factura fact = new Factura();
fact.ID_Factura = Convert.ToInt32(Request.QueryString["modi"]);
fact.NFactura = Convert.ToInt32(Request.QueryString["id"]);
fact.OT = txtOTVari.Text;
fact.Proceso = ddlExterno.SelectedItem.ToString();
fact.Cantidad = Convert.ToInt32(txtCantidadVari.Text.Replace(".", string.Empty));
fact.Observacion = txtObservVari.Text;
fact.Tipo = ddlTipo.SelectedItem.ToString();
fact.Formato = txtAncho.Text + " x " + txtLargo.Text;
fact.PrecioUnit = Convert.ToDouble(txtPreUnitVari.Text);
fact.Barniz = ddlBarniz.SelectedItem.ToString();
fact.Usuario = lblUsuario.Text;
fact.M2 = txtM2.Text;
fact.Costo = "Variable";
fact.Cant = txtCantidadM2.Text.Replace(".", string.Empty);
fact.Total = txtTotalVari.Text.Replace(".", string.Empty);
Controller_Factura controlFac = new Controller_Factura();
if (controlFac.UpdateDetFactura(fact))
{
CargarGrilla(fact.NFactura, fact.Usuario);
btnagregarvari.Visible = true;
btnModificarvari.Visible = false;
ClearForm();
}
}
else
{
string popupScript = "<script language='JavaScript'>Validador('Variable');</script>";
Page.RegisterStartupScript("PopupScript", popupScript);
}
}
catch (Exception excep)
{
string popupScript = "<script language='JavaScript'>alert('A Ocurrido el Siguente Error <br/>" + excep.Message + "');</script>";
Page.RegisterStartupScript("PopupScript", popupScript);
}
}
protected void btnAgregar_Click(object sender, EventArgs e)
{
try
{
if (validador(1))
{
Factura fact = new Factura();
fact.NFactura = Convert.ToInt32(Request.QueryString["id"]);
fact.OT = txtOTFijo.Text;
fact.Proceso = ddlProceso.SelectedItem.Text;
fact.Cant = "0";
fact.Cantidad = Convert.ToInt32(txtCantidadFijo.Text.Replace(".", string.Empty));
fact.Observacion = txtObservacionFijo.Text;
fact.Tipo = "";
fact.Formato = "";
fact.PrecioUnit = Convert.ToDouble(txtPrecioUniFijo.Text);
fact.Barniz = "";
fact.Costo = "Fijo";
fact.Total = txtTotalFijo.Text.Replace(".", string.Empty);
fact.Usuario = lblUsuario.Text;
Controller_Factura controlFac = new Controller_Factura();
if (controlFac.InsertDetFactura(fact))
{
CargarGrilla(fact.NFactura, fact.Usuario);
ClearForm();
}
}
else
{
string popupScript = "<script language='JavaScript'>Validador('Fijo');</script>";
Page.RegisterStartupScript("PopupScript", popupScript);
}
}
catch (Exception excep)
{
string popupScript = "<script language='JavaScript'>alert('A Ocurrido el Siguente Error <br/>" + excep.Message + "');</script>";
Page.RegisterStartupScript("PopupScript", popupScript);
}
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
try
{
double total = 0;
for (int i = 0; i < RgTemporal.Items.Count; i++)
{
total = total + Convert.ToInt32(RgTemporal.Items[i]["Total"].Text);
}
int iva = Convert.ToInt32(total * 0.19);
int TotalFinal = (Convert.ToInt32(total) + Convert.ToInt32(iva));
Controller_Factura controlFac = new Controller_Factura();
controlFac.UpdateDetalle(Request.QueryString["id"], 1, lblUsuario.Text, total, iva, TotalFinal);
string popupScript = "<script language='JavaScript'>window.opener.location='ServiciosExternos.aspx?id=8&Cat=6';window.close();</script>";
Page.RegisterStartupScript("PopupScript", popupScript);
}
catch (Exception excep)
{
string popupScript = "<script language='JavaScript'>alert('A Ocurrido el Siguente Error <br/>" + excep.Message + "');</script>";
Page.RegisterStartupScript("PopupScript", popupScript);
}
}
private void ExportarExcelMes()
{
string inicio = "comienzo";
Factura f = new Factura();
f.OT = txtOT.Text;
f.Nombre = txtproveedor.Text;
if (txtnroFactura.Text.Trim() != "")
{
f.NFactura = Convert.ToInt32(txtnroFactura.Text);
}
if (txtFechaTermino.Text.Trim() != "")
{
string[] feTermino = txtFechaTermino.Text.Split('-');
f.Comuna = feTermino[2] + "-" + feTermino[1] + "-" + feTermino[0];
}
if (txtFechaInicio.Text.Trim() != "")
{
string[] feInicio = txtFechaInicio.Text.Split('-');
f.Ciudad = feInicio[2] + "-" + feInicio[1] + "-" + feInicio[0];
}
else if (inicio == "comienzo")
{
f.Ciudad = DateTime.Now.ToString("yyyy") + "-" + DateTime.Now.ToString("MM") + "-01";
DateTime messiguente = Convert.ToDateTime(DateTime.Now.AddMonths(+1).ToString("MM") + "-" + "01" + "-" + DateTime.Now.ToString("yyyy"));
f.Comuna = DateTime.Now.ToString("yyyy") + "-" + DateTime.Now.ToString("MM") + "-" + messiguente.AddDays(-1).ToString("dd");
}
Controller_Factura controlf = new Controller_Factura();
List <Factura> lista = controlf.listarInfExterno(f);
Microsoft.Office.Interop.Excel.Application xlApp;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Microsoft.Office.Interop.Excel.Application();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
Microsoft.Office.Interop.Excel.Range chartRange;
//add data
#region Grilla Principal
int ContadorRows = 1;
int ContadorCells = 5;
int Contado = 0;
Microsoft.Office.Interop.Excel.Range rangoInicial = null;
Microsoft.Office.Interop.Excel.Range rangoFinal = null;
Microsoft.Office.Interop.Excel.Range rango1 = null;
Microsoft.Office.Interop.Excel.Range rangoGridIni = null;
Microsoft.Office.Interop.Excel.Range rangoGridFin = null;
foreach (Factura fac in lista)
{
if (Contado == 0)
{
rango1 = xlWorkSheet.Cells[ContadorCells - 1, ContadorRows];
Microsoft.Office.Interop.Excel.Range rango2 = xlWorkSheet.Cells[ContadorCells - 1, ContadorRows + 7];
xlWorkSheet.Cells[ContadorCells - 1, ContadorRows] = "Fecha";
xlWorkSheet.Cells[ContadorCells - 1, ContadorRows + 1] = "O.T.";
xlWorkSheet.Cells[ContadorCells - 1, ContadorRows + 2] = "Producto";
xlWorkSheet.Cells[ContadorCells - 1, ContadorRows + 3] = "Proveedor";
xlWorkSheet.Cells[ContadorCells - 1, ContadorRows + 4] = "Nº Factura";
xlWorkSheet.Cells[ContadorCells - 1, ContadorRows + 5] = "Valor Neto";
xlWorkSheet.Cells[ContadorCells - 1, ContadorRows + 6] = "I.V.A 19%";
xlWorkSheet.Cells[ContadorCells - 1, ContadorRows + 7] = "TOTAL";
chartRange = xlWorkSheet.get_Range(rango1, rango2);
chartRange.Font.Bold = true;
chartRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Blue);
chartRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
rangoInicial = xlWorkSheet.Cells[ContadorCells - 3, ContadorRows];
rangoFinal = xlWorkSheet.Cells[ContadorCells - 3, ContadorRows + 7];
}
xlWorkSheet.Cells[ContadorCells, ContadorRows] = fac.Ciudad;
xlWorkSheet.Cells[ContadorCells, ContadorRows + 1] = fac.OT;
xlWorkSheet.Cells[ContadorCells, ContadorRows + 2] = fac.NombreOT;
xlWorkSheet.Cells[ContadorCells, ContadorRows + 3] = fac.Nombre;
xlWorkSheet.Cells[ContadorCells, ContadorRows + 4] = fac.NFactura;
xlWorkSheet.Cells[ContadorCells, ContadorRows + 5] = fac.Sucursal;
xlWorkSheet.Cells[ContadorCells, ContadorRows + 6] = fac.Rut;
xlWorkSheet.Cells[ContadorCells, ContadorRows + 7] = fac.Tipo;
rangoGridIni = xlWorkSheet.Cells[ContadorCells - 1, ContadorRows];
rangoGridFin = xlWorkSheet.Cells[ContadorCells, ContadorRows + 7];
Contado++;
ContadorCells++;
}
xlWorkSheet.get_Range(rangoInicial, rangoFinal).Merge(false);
chartRange = xlWorkSheet.get_Range(rango1, rangoGridFin);
chartRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;
chartRange = xlWorkSheet.get_Range(rangoInicial, rangoFinal);
chartRange.FormulaR1C1 = "Factura Mes de Noviembre 2014";
chartRange.HorizontalAlignment = 3;
chartRange.VerticalAlignment = 3;
chartRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
chartRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);
chartRange.Font.Size = 11;
chartRange.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous, Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic);
#endregion
#region Grilla OT
int ContadorRowsOT = 2;
int ContadorCellsOT = Contado + 10;
int ContadoOT = 0;
List <Factura> lista1 = controlf.listarExternoMensual(f.Ciudad, 1);
Microsoft.Office.Interop.Excel.Range rangoInicialOT = null;
Microsoft.Office.Interop.Excel.Range rangoFinalOT = null;
Microsoft.Office.Interop.Excel.Range rango1OT = null;
Microsoft.Office.Interop.Excel.Range rangoGridFinOT = null;
foreach (Factura fac in lista1)
{
if (ContadoOT == 0)
{
rango1OT = xlWorkSheet.Cells[ContadorCellsOT - 1, ContadorRowsOT];
Microsoft.Office.Interop.Excel.Range rango2 = xlWorkSheet.Cells[ContadorCellsOT - 1, ContadorRowsOT + 6];
xlWorkSheet.Cells[ContadorCellsOT - 1, ContadorRowsOT] = "O.T.";
xlWorkSheet.Cells[ContadorCellsOT - 1, ContadorRowsOT + 1] = "Producto";
xlWorkSheet.Cells[ContadorCellsOT - 1, ContadorRowsOT + 2] = "Proceso";
xlWorkSheet.Cells[ContadorCellsOT - 1, ContadorRowsOT + 3] = "Valor M2";
xlWorkSheet.Cells[ContadorCellsOT - 1, ContadorRowsOT + 4] = "Cantidad";
xlWorkSheet.Cells[ContadorCellsOT - 1, ContadorRowsOT + 5] = "Costo";
xlWorkSheet.Cells[ContadorCellsOT - 1, ContadorRowsOT + 6] = "TOTAL";
chartRange = xlWorkSheet.get_Range(rango1OT, rango2);
chartRange.Font.Bold = true;
chartRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Blue);
chartRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
rangoInicialOT = xlWorkSheet.Cells[ContadorCellsOT - 3, ContadorRowsOT];
rangoFinalOT = xlWorkSheet.Cells[ContadorCellsOT - 3, ContadorRowsOT + 6];
}
xlWorkSheet.Cells[ContadorCellsOT, ContadorRowsOT] = fac.OT;
xlWorkSheet.Cells[ContadorCellsOT, ContadorRowsOT + 1] = fac.NombreOT;
xlWorkSheet.Cells[ContadorCellsOT, ContadorRowsOT + 2] = fac.Proceso;
xlWorkSheet.Cells[ContadorCellsOT, ContadorRowsOT + 3] = fac.M2;
xlWorkSheet.Cells[ContadorCellsOT, ContadorRowsOT + 4] = Convert.ToInt32(fac.Cant).ToString("N0").Replace(",", ".");
string[] split = fac.Costo.Split('.');
if (split.Count() == 2)
{
xlWorkSheet.Cells[ContadorCellsOT, ContadorRowsOT + 5] = Convert.ToInt32(split[0]).ToString("N0").Replace(",", ".") + "," + split[1];
}
else
{
xlWorkSheet.Cells[ContadorCellsOT, ContadorRowsOT + 5] = Convert.ToInt32(split[0]).ToString("N0").Replace(",", ".");
}
xlWorkSheet.Cells[ContadorCellsOT, ContadorRowsOT + 6] = Convert.ToInt32(fac.Total).ToString("N0").Replace(",", ".");
rangoGridFinOT = xlWorkSheet.Cells[ContadorCellsOT, ContadorRowsOT + 6];
ContadoOT++;
ContadorCellsOT++;
}
xlWorkSheet.get_Range(rangoInicialOT, rangoFinalOT).Merge(false);
chartRange = xlWorkSheet.get_Range(rango1OT, rangoGridFinOT);
chartRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;
chartRange = xlWorkSheet.get_Range(rangoInicialOT, rangoFinalOT);
chartRange.FormulaR1C1 = "Factura Mes por OT";
chartRange.HorizontalAlignment = 3;
chartRange.VerticalAlignment = 3;
chartRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
chartRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);
chartRange.Font.Size = 11;
chartRange.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous, Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic);
#endregion
#region Grilla Proveedor
int ContadorRowsPro = 3;
int ContadorCellsPro = ContadorCellsOT + 5;
int ContadoPro = 0;
List <Factura> lista2 = controlf.listarExternoMensual(f.Ciudad, 2);
Microsoft.Office.Interop.Excel.Range rangoInicialPro = null;
Microsoft.Office.Interop.Excel.Range rangoFinalPro = null;
Microsoft.Office.Interop.Excel.Range rango1Pro = null;
Microsoft.Office.Interop.Excel.Range rangoGridFinPro = null;
foreach (Factura fac in lista2)
{
if (ContadoPro == 0)
{
rango1Pro = xlWorkSheet.Cells[ContadorCellsPro - 1, ContadorRowsPro];
Microsoft.Office.Interop.Excel.Range rango2 = xlWorkSheet.Cells[ContadorCellsPro - 1, ContadorRowsPro + 2];
xlWorkSheet.Cells[ContadorCellsPro - 1, ContadorRowsPro] = "Proveedor";
xlWorkSheet.Cells[ContadorCellsPro - 1, ContadorRowsPro + 1] = "Proceso";
xlWorkSheet.Cells[ContadorCellsPro - 1, ContadorRowsPro + 2] = "Total";
chartRange = xlWorkSheet.get_Range(rango1Pro, rango2);
chartRange.Font.Bold = true;
chartRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Blue);
chartRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
rangoInicialPro = xlWorkSheet.Cells[ContadorCellsPro - 3, ContadorRowsPro];
rangoFinalPro = xlWorkSheet.Cells[ContadorCellsPro - 3, ContadorRowsPro + 2];
}
xlWorkSheet.Cells[ContadorCellsPro, ContadorRowsPro] = fac.Nombre;
xlWorkSheet.Cells[ContadorCellsPro, ContadorRowsPro + 1] = fac.Proceso;
xlWorkSheet.Cells[ContadorCellsPro, ContadorRowsPro + 2] = Convert.ToInt32(fac.Total).ToString("N0").Replace(",", ".");
rangoGridFinPro = xlWorkSheet.Cells[ContadorCellsPro, ContadorRowsPro + 2];
ContadoPro++;
ContadorCellsPro++;
}
xlWorkSheet.get_Range(rangoInicialPro, rangoFinalPro).Merge(false);
chartRange = xlWorkSheet.get_Range(rango1Pro, rangoGridFinPro);
chartRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;
chartRange = xlWorkSheet.get_Range(rangoInicialPro, rangoFinalPro);
chartRange.FormulaR1C1 = "Factura Mes por Proveedor";
chartRange.HorizontalAlignment = 3;
chartRange.VerticalAlignment = 3;
chartRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
chartRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);
chartRange.Font.Size = 11;
chartRange.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous, Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic);
#endregion
#region Grilla Proceso
int ContadorRowsPcs = 3;
int ContadorCellsPcs = ContadorCellsPro + 5;
int ContadoPcs = 0;
List <Factura> lista3 = controlf.listarExternoMensual(f.Ciudad, 3);
Microsoft.Office.Interop.Excel.Range rangoInicialPcs = null;
Microsoft.Office.Interop.Excel.Range rangoFinalPcs = null;
Microsoft.Office.Interop.Excel.Range rango1Pcs = null;
Microsoft.Office.Interop.Excel.Range rangoGridFinPcs = null;
foreach (Factura fac in lista3)
{
if (ContadoPcs == 0)
{
rango1Pcs = xlWorkSheet.Cells[ContadorCellsPcs - 1, ContadorRowsPcs];
Microsoft.Office.Interop.Excel.Range rango2 = xlWorkSheet.Cells[ContadorCellsPcs - 1, ContadorRowsPcs + 1];
xlWorkSheet.Cells[ContadorCellsPcs - 1, ContadorRowsPcs] = "Proceso";
xlWorkSheet.Cells[ContadorCellsPcs - 1, ContadorRowsPcs + 1] = "Total";
chartRange = xlWorkSheet.get_Range(rango1Pcs, rango2);
chartRange.Font.Bold = true;
chartRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Blue);
chartRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
rangoInicialPcs = xlWorkSheet.Cells[ContadorCellsPcs - 3, ContadorRowsPcs];
rangoFinalPcs = xlWorkSheet.Cells[ContadorCellsPcs - 3, ContadorRowsPcs + 1];
}
xlWorkSheet.Cells[ContadorCellsPcs, ContadorRowsPcs] = fac.Proceso;
xlWorkSheet.Cells[ContadorCellsPcs, ContadorRowsPcs + 1] = Convert.ToInt32(fac.Total).ToString("N0").Replace(",", ".");
rangoGridFinPcs = xlWorkSheet.Cells[ContadorCellsPcs, ContadorRowsPcs + 1];
ContadoPcs++;
ContadorCellsPcs++;
}
xlWorkSheet.get_Range(rangoInicialPcs, rangoFinalPcs).Merge(false);
chartRange = xlWorkSheet.get_Range(rango1Pcs, rangoGridFinPcs);
chartRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;
chartRange = xlWorkSheet.get_Range(rangoInicialPcs, rangoFinalPcs);
chartRange.FormulaR1C1 = "Factura Mes por Proceso";
chartRange.HorizontalAlignment = 3;
chartRange.VerticalAlignment = 3;
chartRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
chartRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);
chartRange.Font.Size = 11;
chartRange.BorderAround(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous, Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic, Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexAutomatic);
#endregion
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlApp);
releaseObject(xlWorkBook);
releaseObject(xlWorkSheet);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
if (RadGridOT.Items.Count > 0)
{
Controller_Factura controlf = new Controller_Factura();
List <Factura> lista = new List <Factura>();
for (int i = 0; i < RadGridOT.Items.Count; i++)
{
Factura f = new Factura();
GridDataItem row = RadGridOT.Items[i];
f.Ciudad = row["Ciudad"].Text;
f.OT = row["OT"].Text;
f.NombreOT = row["NombreOT"].Text;
f.Proceso = row["Nombre"].Text;
f.NFactura = Convert.ToInt32(row["NFactura"].Text);
f.Sucursal = row["Sucursal"].Text;
f.Rut = row["Rut"].Text;
f.Tipo = row["Tipo"].Text;
lista.Add(f);
}
GridView gv1 = new GridView();
gv1.DataSource = lista;
gv1.DataBind();
gv1.HeaderStyle.BackColor = System.Drawing.Color.Blue;
gv1.HeaderStyle.ForeColor = System.Drawing.Color.White;
gv1.HeaderRow.Cells[0].Text = "Fecha";
gv1.HeaderRow.Cells[1].Text = "O.T.";
gv1.HeaderRow.Cells[2].Text = "Producto";
gv1.HeaderRow.Cells[3].Text = "Proveedor";
gv1.HeaderRow.Cells[4].Text = "Nº Factura";
gv1.HeaderRow.Cells[5].Text = "Valor Neto";
gv1.HeaderRow.Cells[6].Text = "I.V.A 19%";
gv1.HeaderRow.Cells[7].Text = "TOTAL";
gv1.HeaderRow.Cells[8].Visible = false;
gv1.HeaderRow.Cells[9].Visible = false;
gv1.HeaderRow.Cells[10].Visible = false;
gv1.HeaderRow.Cells[11].Visible = false;
gv1.HeaderRow.Cells[12].Visible = false;
gv1.HeaderRow.Cells[13].Visible = false;
gv1.HeaderRow.Cells[14].Visible = false;
gv1.HeaderRow.Cells[15].Visible = false;
gv1.HeaderRow.Cells[16].Visible = false;
gv1.HeaderRow.Cells[17].Visible = false;
gv1.HeaderRow.Cells[18].Visible = false;
gv1.HeaderRow.Cells[19].Visible = false;
gv1.HeaderRow.Cells[20].Visible = false;
gv1.HeaderRow.Cells[21].Visible = false;
gv1.HeaderRow.Cells[22].Visible = false;
//gv1.ControlStyle.AddAttributesToRender();
for (int contador = 0; contador < gv1.Rows.Count; contador++)
{
GridViewRow row = gv1.Rows[contador];
row.Cells[0].Text = row.Cells[20].Text;
row.Cells[4].Text = row.Cells[1].Text;
row.Cells[1].Text = row.Cells[2].Text;
row.Cells[2].Text = row.Cells[3].Text;
row.Cells[3].Text = row.Cells[5].Text;
row.Cells[5].Text = row.Cells[18].Text;
row.Cells[6].Text = row.Cells[15].Text;
row.Cells[7].Text = row.Cells[8].Text;
row.Cells[8].Visible = false;
row.Cells[9].Visible = false;
row.Cells[10].Visible = false;
row.Cells[11].Visible = false;
row.Cells[12].Visible = false;
row.Cells[13].Visible = false;
row.Cells[14].Visible = false;
row.Cells[15].Visible = false;
row.Cells[16].Visible = false;
row.Cells[17].Visible = false;
row.Cells[18].Visible = false;
row.Cells[19].Visible = false;
row.Cells[20].Visible = false;
row.Cells[21].Visible = false;
row.Cells[22].Visible = false;
}
if (txtFechaInicio.Text != "" && txtFechaTermino.Text != "")
{
string mes = "";
string[] feInicio = txtFechaInicio.Text.Split('-');
switch (Convert.ToInt32(feInicio[1]))
{
case 1: mes = "Enero"; break;
case 2: mes = "Febrero"; break;
case 3: mes = "Marzo"; break;
case 4: mes = "Abril"; break;
case 5: mes = "Mayo"; break;
case 6: mes = "Junio"; break;
case 7: mes = "Julio"; break;
case 8: mes = "Agosto"; break;
case 9: mes = "Septiembre"; break;
case 10: mes = "Octubre"; break;
case 11: mes = "Noviembre"; break;
case 12: mes = "Diciembre"; break;
}
string Fecha = feInicio[2] + "-" + feInicio[1] + "-" + feInicio[0];
#region Proceso
GridView GrillaProceso = new GridView();
GrillaProceso.DataSource = controlf.listarExternoMensual(Fecha, 3);
GrillaProceso.DataBind();
GrillaProceso.HeaderStyle.BackColor = System.Drawing.Color.Blue;
GrillaProceso.HeaderStyle.ForeColor = System.Drawing.Color.White;
GrillaProceso.HeaderRow.Cells[0].Text = "";
GrillaProceso.HeaderRow.Cells[0].Style.Add("BORDER", "0px");
GrillaProceso.HeaderRow.Cells[0].BackColor = System.Drawing.Color.White;
GrillaProceso.HeaderRow.Cells[1].Text = "";
GrillaProceso.HeaderRow.Cells[1].Style.Add("BORDER", "0px");
GrillaProceso.HeaderRow.Cells[1].BackColor = System.Drawing.Color.White;
GrillaProceso.HeaderRow.Cells[2].Text = "Proceso";
GrillaProceso.HeaderRow.Cells[3].Text = "Valor";
GrillaProceso.HeaderRow.Cells[4].Visible = false;
GrillaProceso.HeaderRow.Cells[5].Visible = false;
GrillaProceso.HeaderRow.Cells[6].Visible = false;
GrillaProceso.HeaderRow.Cells[7].Visible = false;
GrillaProceso.HeaderRow.Cells[8].Visible = false;
GrillaProceso.HeaderRow.Cells[9].Visible = false;
GrillaProceso.HeaderRow.Cells[10].Visible = false;
GrillaProceso.HeaderRow.Cells[11].Visible = false;
GrillaProceso.HeaderRow.Cells[12].Visible = false;
GrillaProceso.HeaderRow.Cells[13].Visible = false;
GrillaProceso.HeaderRow.Cells[14].Visible = false;
GrillaProceso.HeaderRow.Cells[15].Visible = false;
GrillaProceso.HeaderRow.Cells[16].Visible = false;
GrillaProceso.HeaderRow.Cells[17].Visible = false;
GrillaProceso.HeaderRow.Cells[18].Visible = false;
GrillaProceso.HeaderRow.Cells[19].Visible = false;
GrillaProceso.HeaderRow.Cells[20].Visible = false;
GrillaProceso.HeaderRow.Cells[21].Visible = false;
GrillaProceso.HeaderRow.Cells[22].Visible = false;
for (int contador = 0; contador < GrillaProceso.Rows.Count; contador++)
{
GridViewRow row = GrillaProceso.Rows[contador];
row.Cells[0].Text = "";
row.Cells[0].Style.Add("BORDER", "0");
row.Cells[1].Text = "";
row.Cells[1].Style.Add("BORDER", "0");
row.Cells[2].Text = row.Cells[5].Text;
row.Cells[3].Text = row.Cells[22].Text;
row.Cells[4].Visible = false;
row.Cells[5].Visible = false;
row.Cells[6].Visible = false;
row.Cells[7].Visible = false;
row.Cells[8].Visible = false;
row.Cells[9].Visible = false;
row.Cells[10].Visible = false;
row.Cells[11].Visible = false;
row.Cells[12].Visible = false;
row.Cells[13].Visible = false;
row.Cells[14].Visible = false;
row.Cells[15].Visible = false;
row.Cells[16].Visible = false;
row.Cells[17].Visible = false;
row.Cells[18].Visible = false;
row.Cells[19].Visible = false;
row.Cells[20].Visible = false;
row.Cells[21].Visible = false;
row.Cells[22].Visible = false;
}
#endregion
#region Proveedor
GridView GrillaProveedor = new GridView();
GrillaProveedor.DataSource = controlf.listarExternoMensual(Fecha, 2);
GrillaProveedor.DataBind();
GrillaProveedor.HeaderStyle.BackColor = System.Drawing.Color.Blue;
GrillaProveedor.HeaderStyle.ForeColor = System.Drawing.Color.White;
GrillaProveedor.HeaderRow.Cells[0].Text = "";
GrillaProveedor.HeaderRow.Cells[0].Style.Add("BORDER", "0px");
GrillaProveedor.HeaderRow.Cells[0].BackColor = System.Drawing.Color.White;
GrillaProveedor.HeaderRow.Cells[1].Text = "";
GrillaProveedor.HeaderRow.Cells[1].Style.Add("BORDER", "0px");
GrillaProveedor.HeaderRow.Cells[1].BackColor = System.Drawing.Color.White;
GrillaProveedor.HeaderRow.Cells[2].Text = "Nombre";
GrillaProveedor.HeaderRow.Cells[3].Text = "Proceso";
GrillaProveedor.HeaderRow.Cells[4].Text = "Valor";
GrillaProveedor.HeaderRow.Cells[5].Visible = false;
GrillaProveedor.HeaderRow.Cells[6].Visible = false;
GrillaProveedor.HeaderRow.Cells[7].Visible = false;
GrillaProveedor.HeaderRow.Cells[8].Visible = false;
GrillaProveedor.HeaderRow.Cells[9].Visible = false;
GrillaProveedor.HeaderRow.Cells[10].Visible = false;
GrillaProveedor.HeaderRow.Cells[11].Visible = false;
GrillaProveedor.HeaderRow.Cells[12].Visible = false;
GrillaProveedor.HeaderRow.Cells[13].Visible = false;
GrillaProveedor.HeaderRow.Cells[14].Visible = false;
GrillaProveedor.HeaderRow.Cells[15].Visible = false;
GrillaProveedor.HeaderRow.Cells[16].Visible = false;
GrillaProveedor.HeaderRow.Cells[17].Visible = false;
GrillaProveedor.HeaderRow.Cells[18].Visible = false;
GrillaProveedor.HeaderRow.Cells[19].Visible = false;
GrillaProveedor.HeaderRow.Cells[20].Visible = false;
GrillaProveedor.HeaderRow.Cells[21].Visible = false;
GrillaProveedor.HeaderRow.Cells[22].Visible = false;
for (int contador = 0; contador < GrillaProveedor.Rows.Count; contador++)
{
GridViewRow row = GrillaProveedor.Rows[contador];
row.Cells[0].Text = "";
row.Cells[0].Style.Add("BORDER", "0");
row.Cells[1].Text = "";
row.Cells[1].Style.Add("BORDER", "0");
row.Cells[2].Text = row.Cells[17].Text;
row.Cells[3].Text = row.Cells[5].Text;
row.Cells[4].Text = row.Cells[22].Text;
row.Cells[5].Visible = false;
row.Cells[6].Visible = false;
row.Cells[7].Visible = false;
row.Cells[8].Visible = false;
row.Cells[9].Visible = false;
row.Cells[10].Visible = false;
row.Cells[11].Visible = false;
row.Cells[12].Visible = false;
row.Cells[13].Visible = false;
row.Cells[14].Visible = false;
row.Cells[15].Visible = false;
row.Cells[16].Visible = false;
row.Cells[17].Visible = false;
row.Cells[18].Visible = false;
row.Cells[19].Visible = false;
row.Cells[20].Visible = false;
row.Cells[21].Visible = false;
row.Cells[22].Visible = false;
}
#endregion
#region OT
GridView GrillaOT = new GridView();
GrillaOT.DataSource = controlf.listarExternoMensual(Fecha, 1);
GrillaOT.DataBind();
GrillaOT.HeaderStyle.BackColor = System.Drawing.Color.Blue;
GrillaOT.HeaderStyle.ForeColor = System.Drawing.Color.White;
GrillaOT.HeaderRow.Cells[0].Text = "";
GrillaOT.HeaderRow.Cells[0].Style.Add("BORDER", "0px");
GrillaOT.HeaderRow.Cells[0].BackColor = System.Drawing.Color.White;
GrillaOT.HeaderRow.Cells[1].Text = "OT";
GrillaOT.HeaderRow.Cells[2].Text = "Nombre OT";
GrillaOT.HeaderRow.Cells[3].Text = "Proceso";
GrillaOT.HeaderRow.Cells[4].Text = "Valor M2";
GrillaOT.HeaderRow.Cells[5].Text = "Cantidad";
GrillaOT.HeaderRow.Cells[6].Text = "Costo";
GrillaOT.HeaderRow.Cells[7].Text = "Total";
GrillaOT.HeaderRow.Cells[8].Visible = false;
GrillaOT.HeaderRow.Cells[9].Visible = false;
GrillaOT.HeaderRow.Cells[10].Visible = false;
GrillaOT.HeaderRow.Cells[11].Visible = false;
GrillaOT.HeaderRow.Cells[12].Visible = false;
GrillaOT.HeaderRow.Cells[13].Visible = false;
GrillaOT.HeaderRow.Cells[14].Visible = false;
GrillaOT.HeaderRow.Cells[15].Visible = false;
GrillaOT.HeaderRow.Cells[16].Visible = false;
GrillaOT.HeaderRow.Cells[17].Visible = false;
GrillaOT.HeaderRow.Cells[18].Visible = false;
GrillaOT.HeaderRow.Cells[19].Visible = false;
GrillaOT.HeaderRow.Cells[20].Visible = false;
GrillaOT.HeaderRow.Cells[21].Visible = false;
GrillaOT.HeaderRow.Cells[22].Visible = false;
for (int contador = 0; contador < GrillaOT.Rows.Count; contador++)
{
GridViewRow row = GrillaOT.Rows[contador];
row.Cells[0].Text = "";
row.Cells[0].Style.Add("BORDER", "0");
row.Cells[1].Text = row.Cells[2].Text;
row.Cells[2].Text = row.Cells[3].Text;
row.Cells[3].Text = row.Cells[5].Text;
row.Cells[4].Text = row.Cells[12].Text;
row.Cells[5].Text = row.Cells[16].Text;
row.Cells[6].Text = row.Cells[6].Text;
row.Cells[7].Text = row.Cells[22].Text;
//row.Cells[7].Visible = false;
row.Cells[8].Visible = false;
row.Cells[9].Visible = false;
row.Cells[10].Visible = false;
row.Cells[11].Visible = false;
row.Cells[12].Visible = false;
row.Cells[13].Visible = false;
row.Cells[14].Visible = false;
row.Cells[15].Visible = false;
row.Cells[16].Visible = false;
row.Cells[17].Visible = false;
row.Cells[18].Visible = false;
row.Cells[19].Visible = false;
row.Cells[20].Visible = false;
row.Cells[21].Visible = false;
row.Cells[22].Visible = false;
}
#endregion
ExportToExcel2(mes + " " + feInicio[2], gv1, GrillaProceso, GrillaProveedor, GrillaOT, mes + " " + feInicio[2]);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Controller_Factura controlFac = new Controller_Factura();
lblUsuario.Text = Request.QueryString["u"].ToString();
lblNFactura.Text = " " + controlFac.BuscarIDFactura(Convert.ToInt32(Request.QueryString["id"]));
CargarGrilla(Convert.ToInt32(Request.QueryString["id"]), lblUsuario.Text);
//txtPrecioUniFijo.Attributes.Add("onkeypress", "return pulsarTiraje(event);");
txtM2.Attributes.Add("onkeypress", "return pulsarTiraje(event);");
txtCantidadFijo.Attributes.Add("onkeypress", "return pulsarTiraje(event);");
txtCantidadVari.Attributes.Add("onkeypress", "return pulsarTiraje(event);");
txtCantidadM2.Attributes.Add("onkeypress", "return pulsarTiraje(event);");
txtTotalVari.Attributes.Add("onkeypress", "return pulsarTiraje(event);");
txtTotalFijo.Attributes.Add("onkeypress", "return pulsarTiraje(event);");
try
{
if (Request.QueryString["modi"] != null)
{
Factura f = controlFac.BuscarIDDetalle(Convert.ToInt32(Request.QueryString["modi"]));
if (f.Costo == "Fijo")
{
TabContainer1.ActiveTabIndex = 0;
txtOTFijo.Text = f.OT;
lblNombreOtFijo.Text = f.NombreOT;
ddlProceso.Items.FindByText(f.Proceso).Selected = true;
txtCantidadFijo.Text = f.Cantidad.ToString("N0").Replace(",", ".");
txtPrecioUniFijo.Text = f.PrecioUnit.ToString();
btnAgregarFijo.Visible = false;
btnModifiFijo.Visible = true;
txtTotalFijo.Text = Convert.ToInt32(f.Total).ToString("N0").Replace(",", ".");
txtObservacionFijo.Text = f.Observacion;
}
else
{
TabContainer1.ActiveTabIndex = 1;
txtOTVari.Text = f.OT;
lblNombreOTVari.Text = f.NombreOT;
ddlBarniz.Items.FindByText(f.Barniz).Selected = true;
ddlTipo.Items.FindByText(f.Tipo).Selected = true;
ddlExterno.Items.FindByText(f.Proceso).Selected = true;
txtCantidadVari.Text = f.Cantidad.ToString("N0").Replace(",", ".");
txtPreUnitVari.Text = f.PrecioUnit.ToString();
txtObservVari.Text = f.Observacion;
txtCantidadM2.Text = Convert.ToInt32(f.Cant).ToString("N0").Replace(",", ".");
txtTotalVari.Text = Convert.ToInt32(f.Total).ToString("N0").Replace(",", ".");
if (f.Formato != "")
{
string[] split = f.Formato.Split('x');
txtAncho.Text = split[0].Trim();
txtLargo.Text = split[1].Trim();
}
txtM2.Text = f.M2;
btnagregarvari.Visible = false;
btnModificarvari.Visible = true;
}
}
}
catch
{
}
}
}
