protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string OT = txtOT.Text;
Controller_Consumo controlcons = new Controller_Consumo();
if (OT.Trim() != "")
{
GridView gv = new GridView();
gv.DataSource = controlCons.Listar(txtOT.Text);
gv.DataBind();
gv.HeaderStyle.BackColor = System.Drawing.Color.Blue;
gv.HeaderStyle.ForeColor = System.Drawing.Color.White;
gv.HeaderRow.Cells[1].Text = "Cod Item";
gv.HeaderRow.Cells[2].Text = "Nombre Papel";
gv.HeaderRow.Cells[3].Text = "Gr.";
gv.HeaderRow.Cells[6].Text = "Consumo Pliego";
gv.HeaderRow.Cells[7].Text = "Consumo Bobina";
gv.HeaderRow.Cells[8].Text = "Certificación";
gv.HeaderRow.Cells[9].Text = "Costo Unitario";
gv.HeaderRow.Cells[10].Text = "Costo Total";
if (lblOT.Text != "")
{
string NombreOT = "OT : " + txtOT.Text + " - " + lblOT.Text;
ExportToExcel("Consumo por OT " + DateTime.Now.ToString("dd-MM-yyyy HH:mm"), gv, NombreOT, Label2.Text + lblFeliqui.Text);
}
}
}
public void CargarMaquinas()
{
Controller_Consumo controlconsumo = new Controller_Consumo();
ddlMaquina.DataSource = controlconsumo.ListarStockInsumoMaquina();
ddlMaquina.DataTextField = "Gramage";
ddlMaquina.DataValueField = "CodItem";
ddlMaquina.DataBind();
ddlMaquina.Items.Insert(0, new ListItem("-- Seleccione --", "0"));
}
public void CargarDatos()
{
Controller_Consumo controlConsumo = new Controller_Consumo();
string codigo = txtCodItem.Text;
string Descripcion = txtDescrip.Text;
string Grupo = txtGrupo.Text;
RadGridInsumo.DataSource = controlConsumo.ListarStockInsumo(codigo, Descripcion, Grupo);
RadGridInsumo.DataBind();
}
public void CargarDatos()
{
string Mes = ddlMes.SelectedValue.ToString();
string Año = ddlAño.SelectedValue.ToString();
Controller_Consumo controlcons = new Controller_Consumo();
if (Mes != "Seleccione Mes")
{
List <Cabecera> lista1 = controlcons.ListarConsumoMes(Mes, Año, 1);
List <Cabecera> lista2 = controlcons.ListarConsumoMes(Mes, Año, 2);
RadGridInforme.DataSource = lista1.Where(o => o.Id_Funcionalidad != "");
RadGridInforme.DataBind();
RadGridOtros.DataSource = lista2.Where(o => o.Id_Funcionalidad != "");
RadGridOtros.DataBind();
foreach (Cabecera cab in lista1.Where(o => o.Id_Funcionalidad == ""))
{
lblOperacion.Text = cab.EmpId;
lblHoja.Text = cab.LlgDocNumDoc;
lblPrecioHoja.Text = cab.LlgDocGlosa;
lblBobina.Text = cab.LlgDocFechaIng;
lblPrecioBob.Text = cab.LlgDocNumInterno;
lblKgTotal.Text = cab.IntPeriodo;
lblPrecioTotal.Text = cab.OpeCod;
lblFlPliego.Text = cab.DivCodigo;
}
foreach (Cabecera cab in lista2.Where(o => o.Id_Funcionalidad == ""))
{
lblOperacion2.Text = cab.EmpId;
lblHoja2.Text = cab.LlgDocNumDoc;
lblPrecioHoja2.Text = cab.LlgDocGlosa;
lblBobina2.Text = cab.LlgDocFechaIng;
lblPrecioBob2.Text = cab.LlgDocNumInterno;
lblKgTotal2.Text = cab.IntPeriodo;
lblPrecioTotal2.Text = cab.OpeCod;
lblFlPliego2.Text = cab.DivCodigo;
}
}
else
{
RadGridInforme.DataSource = "";
RadGridInforme.DataBind();
RadGridOtros.DataSource = "";
RadGridOtros.DataBind();
}
}
public void CargarOTs(int procedimiento)
{
string OT = txtNumeroOT.Text;
string NombreOT = txtNombreOT.Text;
string Cliente = txtCliente.Text;
string FeInicio = "";
string FeTermino = "";
if (txtFechaInicio.Text.Trim() != "" && txtFechaTermino.Text.Trim() != "")
{
string[] split = txtFechaInicio.Text.Split('/');
FeInicio = split[2] + "-" + split[1] + "-" + split[0];
string[] split2 = txtFechaTermino.Text.Split('/');
FeTermino = split2[2] + "-" + split2[1] + "-" + split2[0] + " 23:59:59";
}
if (procedimiento == 1 && txtFechaInicio.Text.Trim() == "" && txtFechaTermino.Text.Trim() == "" && OT == "" && NombreOT == "" && Cliente == "")
{
procedimiento = 0;
}
Controller_Consumo controlconsum = new Controller_Consumo();
RadGridLiq.DataSource = controlconsum.ListarLiquidarOTs(OT, NombreOT, Cliente, FeInicio, FeTermino, procedimiento);
RadGridLiq.DataBind();
}
public void CargarFacturacion(string OT)
{
Controller_Consumo controlCons = new Controller_Consumo();
List <Consumo> lista = controlCons.Listar(OT);
Consumo Papel = new Consumo();
RadGridRF.DataSource = lista.Where(o => o.Tipo == "Bobina" || o.Tipo == "Pliego").ToList();
RadGridRF.DataBind();
string aaaa = "";
foreach (Consumo c in lista.Where(o => o.Tipo == "Bobina" || o.Tipo == "Pliego"))
{
if (c.Tipo == "Bobina")
{
Papel.Cons_Bobina = (Convert.ToInt32(c.Cons_Bobina.Substring(0, c.Cons_Bobina.Length - 2).Replace(".", string.Empty)) + Convert.ToInt32(Papel.Cons_Bobina)).ToString();
}
else
{
Papel.Cons_Pliego = (Convert.ToInt32(c.Cons_Pliego.Substring(0, c.Cons_Pliego.Length - 2).Replace(".", string.Empty)) + Convert.ToInt32(Papel.Cons_Pliego)).ToString();
}
Papel.Costtot = (Convert.ToDouble(Papel.Costtot) + Convert.ToDouble(c.Costtot.Replace(".", string.Empty).Replace(",", "."))).ToString();
}
lblPliego.Text = Convert.ToInt32(Papel.Cons_Pliego).ToString("N0").Replace(",", ".") + " FL";
lblBobina.Text = Convert.ToInt32(Papel.Cons_Bobina).ToString("N0").Replace(",", ".") + " KG";
lblTotal.Text = Convert.ToDouble(Papel.Costtot).ToString("N2");
if (lista.Where(o => o.Tipo == "Plancha").ToList().Count > 0)
{
RadGridPlanchas.DataSource = lista.Where(o => o.Tipo == "Plancha").ToList();
RadGridPlanchas.DataBind();
RadGridPlanchadiv.Visible = true;
RadGridPlanchaTit.Visible = true;
tablaPlancha.Visible = true;
foreach (Consumo c in lista.Where(o => o.Tipo == "Plancha"))
{
Papel.Cons_Plancha = (Convert.ToInt32(c.Cons_Plancha.Substring(0, c.Cons_Plancha.Length - 2).Replace(",", string.Empty)) + Convert.ToInt32(Papel.Cons_Plancha)).ToString();
Papel.Ancho = (Convert.ToDouble(Papel.Ancho) + Convert.ToDouble(c.Costtot.Replace(".", string.Empty).Replace(",", "."))).ToString();
}
lblPlancha.Text = Convert.ToInt32(Papel.Cons_Plancha).ToString("N0") + " UN";
lblTotalplc.Text = Convert.ToDouble(Papel.Ancho).ToString("N2");
}
else
{
RadGridPlanchadiv.Visible = false;
RadGridPlanchaTit.Visible = false;
tablaPlancha.Visible = false;
}
if (lista.Where(o => o.Tipo == "Otro").ToList().Count > 0)
{
RadGridOtros.DataSource = lista.Where(o => o.Tipo == "Otro").ToList();
RadGridOtros.DataBind();
RadGridOtrosdiv.Visible = true;
RadGridOtrosTit.Visible = true;
TableOtros.Visible = true;
foreach (Consumo c in lista.Where(o => o.Tipo == "Otro"))
{
Papel.Cons_Otros = (Convert.ToInt32(c.Cons_Otros.Substring(0, c.Cons_Otros.Length - 2).Replace(".", string.Empty)) + Convert.ToInt32(Papel.Cons_Otros)).ToString();
Papel.Certif = (Convert.ToDouble(Papel.Certif) + Convert.ToDouble(c.Costtot.Replace(".", string.Empty).Replace(",", "."))).ToString();
}
lblOtros.Text = Convert.ToInt32(Papel.Cons_Otros).ToString("N0") + " UN";
lblTotalOtros.Text = Convert.ToDouble(Papel.Certif).ToString("N2");
}
else
{
RadGridOtrosdiv.Visible = false;
RadGridOtrosTit.Visible = false;
TableOtros.Visible = false;
}
List <Consumo> lista2 = controlCons.ListarSerExterno(OT);
if (lista2.Count > 0)
{
DivTitServExt.Visible = true;
DivSerExterno.Visible = true;
TablaSerExter.Visible = true;
RadGridSerExterno.DataSource = lista2;
RadGridSerExterno.DataBind();
foreach (Consumo c in lista2)
{
Papel.CostUni = (Convert.ToDouble(Papel.CostUni) + Convert.ToDouble(c.Costtot.Replace(",", string.Empty))).ToString();
aaaa = aaaa + "+" + Convert.ToDouble(c.Costtot.Replace(".", string.Empty).Replace(",", ".")).ToString();
}
lblTotalSerExt.Text = Convert.ToDouble(Papel.CostUni).ToString("N2");
string b = aaaa;
}
else
{
DivTitServExt.Visible = false;
DivSerExterno.Visible = false;
TablaSerExter.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
OrdenController oc = new OrdenController();
List <Consumo> lista = new List <Consumo>();
Controller_Consumo controlCons = new Controller_Consumo();
string Facturacion = "";
int Pag = 0;
string[] OTs = Request.QueryString["id"].Split(',');
for (int i = 0; i < OTs.Count(); i++)
{
lista = new List <Consumo>();
lista = controlCons.Listar(OTs[i]);
string ConsumoPapel = "";
string ConsumoPlancha = "";
string ConsumoOtros = "";
string ConsumoSerExt = "";
int contadorPapel = 0;
int contadorPlancha = 0;
int contadorOtros = 0;
int contadorSerExt = 0;
Consumo Papel = new Consumo();
foreach (Consumo c in lista.Where(o => o.Tipo == "Bobina" || o.Tipo == "Pliego").ToList())
{
if (contadorPapel == 0)
{
ConsumoPapel = "<div style='width:1000px;' align='center'>Consumos de Papel</div><table id='tblPapel' runat='server' cellspacing='0' cellpadding='0' >" +
"<thead><tr>" +
"<td style='text-align:center;'>Lote</td>" +
"<td style='text-align:center;'>Cod Item</td>" +
"<td style='text-align:center;'>Nombre Papel</td>" +
"<td style='text-align:center;'>Gr.</td>" +
"<td style='text-align:center;'>Ancho</td>" +
"<td style='text-align:center;'>Largo</td>" +
"<td style='text-align:center;'>Cons. Pliego</td>" +
"<td style='text-align:center;'>Cons. Bobina</td>" +
"<td style='text-align:center;'>Certificación</td>" +
"<td style='text-align:center;'>Costo Unitario</td>" +
"<td style='text-align:center;'>Costo Total</td>" +
"</tr></thead><tbody>";
contadorPapel++;
}
ConsumoPapel = ConsumoPapel + "<tr>" +
"<td style='text-align:right;'>" + c.Lote + "</td>" +
"<td style='text-align:right;'>" + c.CodItem + "</td>" +
"<td style='text-align:center;'>" + c.NombrePapel + "</td>" +
"<td style='text-align:right;'>" + c.Gramage + "</td>" +
"<td style='text-align:right;'>" + c.Ancho + "</td>" +
"<td style='text-align:right;'>" + c.Largo + "</td>" +
"<td style='text-align:right;'>" + c.Cons_Pliego + "</td>" +
"<td style='text-align:right;'>" + c.Cons_Bobina + "</td>" +
"<td style='text-align:center;'>" + c.Certif + "</td>" +
"<td style='text-align:right;'>" + c.CostUni + "</td>" +
"<td style='text-align:right;'>" + c.Costtot + "</td>" +
"</tr>";
if (c.Tipo == "Bobina")
{
Papel.Cons_Bobina = (Convert.ToInt32(c.Cons_Bobina.Substring(0, c.Cons_Bobina.Length - 2).Replace(".", string.Empty)) + Convert.ToInt32(Papel.Cons_Bobina)).ToString();
}
else
{
Papel.Cons_Pliego = (Convert.ToInt32(c.Cons_Pliego.Substring(0, c.Cons_Pliego.Length - 2).Replace(".", string.Empty)) + Convert.ToInt32(Papel.Cons_Pliego)).ToString();
}
string algo = c.Costtot.Replace(".", string.Empty);
Papel.Costtot = (Convert.ToDouble(Papel.Costtot) + Convert.ToDouble(algo)).ToString();
}
foreach (Consumo c in lista.Where(o => o.Tipo == "Plancha"))
{
if (contadorPlancha == 0)
{
ConsumoPlancha = "<div style='width:1000px;' align='center'>Consumos de Planchas</div><table id='tblPapel' runat='server' cellspacing='0' cellpadding='0' >" +
"<thead><tr>" +
"<td style='text-align:center;'>Lote</td>" +
"<td style='text-align:center;'>Cod Item</td>" +
"<td style='text-align:center;'>Descripción</td>" +
"<td style='text-align:center;'>Cantidad</td>" +
"<td style='text-align:center;'>Costo Unitario</td>" +
"<td style='text-align:center;'>Costo Total</td>" +
"</tr></thead><tbody>";
contadorPlancha++;
}
ConsumoPlancha = ConsumoPlancha + "<tr>" +
"<td style='text-align:right;'>" + c.Lote + "</td>" +
"<td style='text-align:right;'>" + c.CodItem + "</td>" +
"<td style='text-align:center;'>" + c.NombrePapel + "</td>" +
"<td style='text-align:right;'>" + c.Cons_Plancha + "</td>" +
"<td style='text-align:right;'>" + c.CostUni + "</td>" +
"<td style='text-align:right;'>" + c.Costtot + "</td>" +
"</tr>";
Papel.Cons_Plancha = (Convert.ToInt32(c.Cons_Plancha.Substring(0, c.Cons_Plancha.Length - 2).Replace(",", string.Empty)) + Convert.ToInt32(Papel.Cons_Plancha)).ToString();
Papel.Ancho = (Convert.ToDouble(Papel.Ancho) + Convert.ToDouble(c.Costtot.Replace(".", string.Empty))).ToString();
}
foreach (Consumo c in lista.Where(o => o.Tipo == "Otro"))
{
if (contadorOtros == 0)
{
ConsumoOtros = "<div style='width:1000px;' align='center'>Otros Consumos</div><table id='tblPapel' runat='server' cellspacing='0' cellpadding='0'>" +
"<thead><tr>" +
"<td style='text-align:center;'>Lote</td>" +
"<td style='text-align:center;'>Cod Item</td>" +
"<td style='text-align:center;'>Nombre Material</td>" +
"<td style='text-align:center;'>Cons. Otros</td>" +
"<td style='text-align:center;'>Costo Unitario</td>" +
"<td style='text-align:center;'>Costo Total</td>" +
"</tr></thead><tbody>";
contadorOtros++;
}
ConsumoOtros = ConsumoOtros + "<tr>" +
"<td style='text-align:right;'>" + c.Lote + "</td>" +
"<td style='text-align:right;'>" + c.CodItem + "</td>" +
"<td style='text-align:center;'>" + c.NombrePapel + "</td>" +
"<td style='text-align:right;'>" + c.Cons_Otros + "</td>" +
"<td style='text-align:right;'>" + c.CostUni + "</td>" +
"<td style='text-align:right;'>" + c.Costtot + "</td>" +
"</tr>";
Papel.Cons_Otros = (Convert.ToInt32(c.Cons_Otros.Substring(0, c.Cons_Otros.Length - 2).Replace(".", string.Empty)) + Convert.ToInt32(Papel.Cons_Otros)).ToString();
Papel.Certif = (Convert.ToDouble(Papel.Certif) + Convert.ToDouble(c.Costtot.Replace(".", string.Empty))).ToString();
}
List <Consumo> lista2 = controlCons.ListarSerExterno(OTs[i]);
foreach (Consumo c in lista2)
{
if (contadorSerExt == 0)
{
ConsumoSerExt = "<div style='width:1000px;' align='center'>Servicios Externos</div><table id='tblPapel' runat='server' cellspacing='0' cellpadding='0' >" +
"<thead><tr>" +
"<td style='text-align:center;'>Descripción Proceso</td>" +
"<td style='text-align:center;'>Componente</td>" +
"<td style='text-align:center;'>Aplicación</td>" +
"<td style='text-align:center;'>Formato (A x L)</td>" +
"<td style='text-align:center;'>Cantidad</td>" +
"<td style='text-align:center;'>Costo Unitario</td>" +
"<td style='text-align:center;'>Costo Total</td>" +
"</tr></thead><tbody>";
contadorSerExt++;
}
ConsumoSerExt = ConsumoSerExt + "<tr>" +
"<td style='text-align:center;'>" + c.Lote + "</td>" +
"<td style='text-align:center;'>" + c.Cons_Plancha + "</td>" +
"<td style='text-align:center;'>" + c.CodItem + "</td>" +
"<td style='text-align:right;'>" + c.NombrePapel + "</td>" +
"<td style='text-align:right;'>" + c.Certif + "</td>" +
"<td style='text-align:right;'>" + c.CostUni + "</td>" +
"<td style='text-align:right;'>" + c.Costtot + "</td>" +
"</tr>";
Papel.CostUni = (Convert.ToDouble(Papel.CostUni) + Convert.ToDouble(c.Costtot.Replace(".", string.Empty))).ToString();
}
if (contadorPapel > 0)
{
ConsumoPapel = ConsumoPapel + "<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td style='text-align:center;'>Cons. Pliego</td>" +
"<td style='text-align:center;'>Cons. Bobina </td><td style='text-align:center;'>Costo Total </td></tr><tr>" +
"<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td style='text-align:center;'>Total</td>" +
"<td style='text-align:right;'>" + Convert.ToInt32(Papel.Cons_Pliego).ToString("N0").Replace(",", ".") + " FL" + "</td>" +
"<td style='text-align:right;'>" + Convert.ToInt32(Papel.Cons_Bobina).ToString("N0").Replace(",", ".") + " KG" + "</td>" +
"<td style='text-align:right;'>" + Convert.ToDouble(Papel.Costtot).ToString("N2") + "</td>" +
"</tr></tbody></table>";
}
if (contadorPlancha > 0)
{
ConsumoPlancha = ConsumoPlancha + "<tr><td></td><td></td><td></td><td></td>" +
"<td style='text-align:center;'>Cantidad de Planchas </td><td style='text-align:center;'>Costo Total </td>" +
"</tr><tr><td></td><td></td><td></td><td style='text-align:center;'>Total</td>" +
"<td style='text-align:right;'>" + Convert.ToInt32(Papel.Cons_Plancha).ToString("N0") + " UN" + "</td><td style='text-align:right;'>" + Convert.ToDouble(Papel.Ancho).ToString("N2") + "</td>" +
"</tr></tbody></table>";
}
if (contadorOtros > 0)
{
ConsumoOtros = ConsumoOtros + "<tr><td></td><td></td><td></td><td></td>" +
"<td style='text-align:center;'>Cons. Otros</td><td style='text-align:center;'>Costo Total</td></tr><tr>" +
"<td></td><td></td><td></td><td style='text-align:center;'>Total</td>" +
"<td style='text-align:right;'>" + Convert.ToInt32(Papel.Cons_Otros).ToString("N0") + " UN" + "</td>" +
"<td style='text-align:right;'>" + Convert.ToDouble(Papel.Certif).ToString("N2") + "</td>" +
"</tr></tbody></table>";
}
if (contadorSerExt > 0)
{
ConsumoSerExt = ConsumoSerExt + "<tr><td style='text-align:center;'></td><td style='text-align:center;'></td>" +
"<td style='text-align:center;'></td><td style='text-align:right;'></td><td style='text-align:right;'></td>" +
"<td style='text-align:right;'></td><td style='text-align:right;'>Costo Total </td></tr>" +
"<tr><td style='text-align:center;'></td><td style='text-align:center;'></td>" +
"<td style='text-align:center;'></td><td style='text-align:right;'></td><td style='text-align:right;'></td>" +
"<td style='text-align:right;'>Total</td><td style='text-align:right;'>" + Convert.ToDouble(Papel.CostUni).ToString("N2") + "</td></tr></tbody></table>";
}
if (Pag == 0 && OTs.Count() > 1)
{
Facturacion = Facturacion + "<div style='page-break-after:always;'><h1 style='text-align:center;'>" + OTs[i] + " - " + oc.Seguimiento_BuscarNM(OTs[i]) + "</h1>" + ConsumoPapel + "<br/>" + ConsumoPlancha + "<br/>" + ConsumoSerExt + "<br/>" + ConsumoOtros + "</div>";
Pag++;
}
else if (Pag == 0 && OTs.Count() == 1)
{
Facturacion = Facturacion + "<div><h1 style='text-align:center;'>" + OTs[i] + " - " + oc.Seguimiento_BuscarNM(OTs[i]) + "</h1>" + ConsumoPapel + "<br/>" + ConsumoPlancha + "<br/>" + ConsumoSerExt + "<br/>" + ConsumoOtros + "</div>";
Pag++;
}
else if (Pag == 1)
{
Facturacion = Facturacion + "<div><h1 style='text-align:center;'>" + OTs[i] + " - " + oc.Seguimiento_BuscarNM(OTs[i]) + "</h1>" + ConsumoPapel + "<br/>" + ConsumoPlancha + "<br/>" + ConsumoSerExt + "<br/>" + ConsumoOtros + "</div>";
Pag++;
}
else
{
Facturacion = Facturacion + "<div style='page-break-before:always;'><h1 style='text-align:center;'>" + OTs[i] + " - " + oc.Seguimiento_BuscarNM(OTs[i]) + "</h1>" + ConsumoPapel + "<br/>" + ConsumoPlancha + "<br/>" + ConsumoSerExt + "<br/>" + ConsumoOtros + "</div>";
}
}
lblImprimir.Text = Facturacion;
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string Mes = ddlMes.SelectedValue.ToString();
string Año = ddlAño.SelectedValue.ToString();//"2014";
Controller_Consumo controlcons = new Controller_Consumo();
if (Mes != "Seleccionar")
{
List <Cabecera> lista1 = controlcons.ListarConsumoMes(Mes, Año, 1);
List <Cabecera> lista2 = controlcons.ListarConsumoMes(Mes, Año, 2);
List <Cabecera> listaFinal = lista1.Concat(lista2).ToList();
GridView gv = new GridView();
gv.DataSource = listaFinal;
gv.DataBind();
gv.HeaderStyle.BackColor = System.Drawing.Color.Blue;
gv.HeaderStyle.ForeColor = System.Drawing.Color.White;
gv.HeaderRow.Cells[0].Text = "OT";
gv.HeaderRow.Cells[1].Text = "Nombre OT";
gv.HeaderRow.Cells[2].Text = "Fl Pliego";
gv.HeaderRow.Cells[3].Text = "Kg Hoja";
gv.HeaderRow.Cells[4].Text = "$ Hoja";
gv.HeaderRow.Cells[5].Text = "Kg Bobina";
gv.HeaderRow.Cells[6].Text = "$ Bobina";
gv.HeaderRow.Cells[7].Text = "Kg total";
gv.HeaderRow.Cells[8].Text = "$ Total";
gv.HeaderRow.Cells[9].Visible = false;
gv.HeaderRow.Cells[10].Visible = false;
gv.HeaderRow.Cells[11].Visible = false;
gv.HeaderRow.Cells[12].Visible = false;
gv.HeaderRow.Cells[13].Visible = false;
gv.HeaderRow.Cells[14].Visible = false;
gv.HeaderRow.Cells[15].Visible = false;
gv.HeaderRow.Cells[16].Visible = false;
gv.HeaderRow.Cells[17].Visible = false;
gv.HeaderRow.Cells[18].Visible = false;
gv.HeaderRow.Cells[19].Visible = false;
gv.HeaderRow.Cells[20].Visible = false;
gv.HeaderRow.Cells[21].Visible = false;
gv.HeaderRow.Cells[22].Visible = false;
gv.HeaderRow.Cells[23].Visible = false;
gv.HeaderRow.Cells[24].Visible = false;
gv.HeaderRow.Cells[25].Visible = false;
gv.HeaderRow.Cells[26].Visible = false;
gv.HeaderRow.Cells[27].Visible = false;
gv.HeaderRow.Cells[28].Visible = false;
gv.HeaderRow.Cells[29].Visible = false;
gv.HeaderRow.Cells[30].Visible = false;
gv.HeaderRow.Cells[31].Visible = false;
gv.HeaderRow.Cells[32].Visible = false;
gv.HeaderRow.Cells[33].Visible = false;
gv.HeaderRow.Cells[34].Visible = false;
gv.HeaderRow.Cells[35].Visible = false;
gv.HeaderRow.Cells[36].Visible = false;
gv.HeaderRow.Cells[37].Visible = false;
for (int contador = 0; contador < gv.Rows.Count; contador++)
{
GridViewRow row = gv.Rows[contador];
row.Cells[0].Text = row.Cells[1].Text;
if (row.Cells[2].Text != "Total Operacional" && row.Cells[2].Text != "Total Otros")
{
row.Cells[1].Text = row.Cells[2].Text;
row.Cells[2].Text = row.Cells[3].Text;
row.Cells[3].Text = row.Cells[10].Text;
row.Cells[4].Text = row.Cells[8].Text;
row.Cells[8].Text = row.Cells[7].Text;
row.Cells[7].Text = row.Cells[6].Text;
row.Cells[6].Text = row.Cells[9].Text;
}
else
{
row.Cells[1].Text = "<div style='font-weight: bold;font-size:medium;'>" + row.Cells[2].Text + "</div>";
row.Cells[2].Text = "<div style='font-weight: bold;font-size:medium;'>" + row.Cells[3].Text + "</div>";
row.Cells[3].Text = "<div style='font-weight: bold;font-size:medium;'>" + row.Cells[10].Text + "</div>";
row.Cells[4].Text = "<div style='font-weight: bold;font-size:medium;'>" + row.Cells[8].Text + "</div>";
row.Cells[5].Text = "<div style='font-weight: bold;font-size:medium;'>" + row.Cells[5].Text + "</div>";
row.Cells[8].Text = "<div style='font-weight: bold;font-size:medium;'>" + row.Cells[7].Text + "</div>";
row.Cells[7].Text = "<div style='font-weight: bold;font-size:medium;'>" + row.Cells[6].Text + "</div>";
row.Cells[6].Text = "<div style='font-weight: bold;font-size:medium;'>" + row.Cells[9].Text + "</div>";
}
//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;
row.Cells[23].Visible = false;
row.Cells[24].Visible = false;
row.Cells[25].Visible = false;
row.Cells[26].Visible = false;
row.Cells[27].Visible = false;
row.Cells[28].Visible = false;
row.Cells[29].Visible = false;
row.Cells[30].Visible = false;
row.Cells[31].Visible = false;
row.Cells[32].Visible = false;
row.Cells[33].Visible = false;
row.Cells[34].Visible = false;
row.Cells[35].Visible = false;
row.Cells[36].Visible = false;
row.Cells[37].Visible = false;
}
ExportToExcel("Consumo Mensual por OT " + DateTime.Now.ToString("dd-MM-yyyy HH:mm"), gv);
}
}
protected void btnFiltro_Click1(object sender, EventArgs e)
{
Controller_Consumo cc = new Controller_Consumo();
try
{
if (txtOT.Text != "")
{
if (txtOT.Text == "108")
{
if (txtFechaInicio.Text != "" && txtFechaTermino.Text != "")
{
string[] str = txtFechaInicio.Text.Split('/');
DateTime fi = Convert.ToDateTime(str[2] + "-" + str[1] + "-" + str[0] + " 00:00:00");
string[] str2 = txtFechaTermino.Text.Split('/');
DateTime ft = Convert.ToDateTime(str2[2] + "-" + str2[1] + "-" + str2[0] + " 23:59:59");
Label11.Text = cc.CargaConsumoMetrics(txtOT.Text, fi, ft, 5);
}
else
{
string popupScript = "<script language='JavaScript'> alert('¡ La OT 108 debe tener Fecha de inicio y termino!'); </script>";
Page.RegisterStartupScript("PopupScript", popupScript);
}
}
else
{
Label11.Text = cc.CargaConsumoMetrics(txtOT.Text, DateTime.Now, DateTime.Now, 3);
}
}
else if (txtFechaInicio.Text != "" && txtFechaTermino.Text != "")
{
if (rdDesperdicio.Checked)//chkDesperdicio
{
string[] str = txtFechaInicio.Text.Split('/');
DateTime fi = Convert.ToDateTime(str[2] + "-" + str[1] + "-" + str[0] + " 00:00:00");
string[] str2 = txtFechaTermino.Text.Split('/');
DateTime ft = Convert.ToDateTime(str2[2] + "-" + str2[1] + "-" + str2[0] + " 23:59:59");
string ot = cc.CargaOTS("", fi, ft, 1);
Label11.Text = cc.CargaConsumoMetrics(ot, DateTime.Now, DateTime.Now, 4);
}
else if (rdDiferenciasDesperdicio.Checked)
{
string[] str = txtFechaInicio.Text.Split('/');
DateTime fi = Convert.ToDateTime(str[2] + "-" + str[1] + "-" + str[0] + " 00:00:00");
string[] str2 = txtFechaTermino.Text.Split('/');
DateTime ft = Convert.ToDateTime(str2[2] + "-" + str2[1] + "-" + str2[0] + " 23:59:59");
string ot = cc.CargaOTS("", fi, ft, 1);
Label11.Text = cc.CargaConsumoMetrics(ot, DateTime.Now, DateTime.Now, 6);
}
else if (rdDiferenciasTeorico.Checked)
{
string[] str = txtFechaInicio.Text.Split('/');
DateTime fi = Convert.ToDateTime(str[2] + "-" + str[1] + "-" + str[0] + " 00:00:00");
string[] str2 = txtFechaTermino.Text.Split('/');
DateTime ft = Convert.ToDateTime(str2[2] + "-" + str2[1] + "-" + str2[0] + " 23:59:59");
string ot = cc.CargaOTS("", fi, ft, 1);
Label11.Text = cc.CargaConsumoTeoricoVsMetrics2(ot, DateTime.Now, DateTime.Now, 7);
}
else
{
string[] str = txtFechaInicio.Text.Split('/');
DateTime fi = Convert.ToDateTime(str[2] + "-" + str[1] + "-" + str[0] + " 00:00:00");
string[] str2 = txtFechaTermino.Text.Split('/');
DateTime ft = Convert.ToDateTime(str2[2] + "-" + str2[1] + "-" + str2[0] + " 23:59:59");
string ot = cc.CargaOTS("", fi, ft, 1);
Label11.Text = cc.CargaConsumoMetrics(ot, fi, ft, 0);
}
}
else
{
string ot = cc.CargaOTS("", DateTime.Now, DateTime.Now, 2);
Label11.Text = cc.CargaConsumoMetrics(ot, DateTime.Now, DateTime.Now, 0);
}
}
catch
{
Label11.Text = "<div align='center'>¡No se han Encontrado Registros!</div>";
}
}
protected void btnAgregar_Click(object sender, EventArgs e)
{
Validacion.Visible = false;
if (ddlMaquina.SelectedItem.ToString() != "-- Seleccione --")
{
string[] stk = lblStock.Text.ToString().Replace(",", string.Empty).Split(' ');
double Stock = Convert.ToDouble(stk[0]);
if (txtCantidad.Text.ToString() != "")
{
double Solicitado = Convert.ToDouble(txtCantidad.Text.ToString());
if (Stock >= Solicitado)
{
if ((lblNombreOT.Text != "") || (txtOT.Text != ""))
{
Consumo consumo = new Consumo();
consumo.CodItem = lblCodigo.Text;
consumo.NombrePapel = lblDescripcion.Text;
string[] stock = lblStock.Text.ToString().Replace(",", string.Empty).Split(' ');
consumo.Lote = stock[0];
consumo.Costtot = txtOT.Text;
consumo.Tipo = lblNombreOT.Text;
consumo.Cons_Pliego = txtCantidad.Text;
consumo.Cons_Otros = ddlMaquina.SelectedItem.ToString();
consumo.Cons_Plancha = Session["Usuario"].ToString();
Controller_Consumo controlconsumo = new Controller_Consumo();
if (controlconsumo.AgregarSolicStock(consumo))
{
string popupScript4 = "<script language='JavaScript'>opener.location.reload();window.close();</script>";
Page.RegisterStartupScript("PopupScript", popupScript4);
}
else
{
Validacion.Visible = true;
Image1.ImageUrl = "../../Images/cross.png";
Label1.Text = "Error al Ingresar";
Label1.ForeColor = Color.White;
Validacion.Attributes.Add("style", "background-color:red");
Label1.Text = "Error al Ingresar";
}
}
else
{
Validacion.Visible = true;
Image1.ImageUrl = "../../Images/cross.png";
Label1.Text = "Error al Ingresar";
Label1.ForeColor = Color.White;
Validacion.Attributes.Add("style", "background-color:red");
Label1.Text = "Debe seleccionar una OT";
}
}
else
{
Validacion.Visible = true;
Image1.ImageUrl = "../../Images/cross.png";
Label1.Text = "Error al Ingresar";
Label1.ForeColor = Color.White;
Validacion.Attributes.Add("style", "background-color:red");
Label1.Text = "El Stock no es suficiente para la Solicitud";
}
}
else
{
Validacion.Visible = true;
Image1.ImageUrl = "../../Images/cross.png";
Label1.Text = "Error al Ingresar";
Label1.ForeColor = Color.White;
Validacion.Attributes.Add("style", "background-color:red");
Label1.Text = "Debe indicar Cantidad de la Solicitud";
}
}
else
{
Validacion.Visible = true;
Image1.ImageUrl = "../../Images/cross.png";
Label1.Text = "Error al Ingresar";
Label1.ForeColor = Color.White;
Validacion.Attributes.Add("style", "background-color:red");
Label1.Text = "Debe seleccionar una Maquina";
}
}
