protected void btnConsumir_Click(object sender, EventArgs e)
{
Bobina b = new Bobina();
Bobina_Controller controlbo = new Bobina_Controller();
b.ID_Bobina = Convert.ToInt32(IDBobina.Text);
if (Convert.ToInt32(ddlSaldo.SelectedValue) == 1)
{
b.Saldo = Convert.ToInt32(txtSaldo.Text);
b.Peso_Cono = 0;
Validacion.Visible = false;
if (b.Saldo > 0)
{
if (controlbo.UpdateBobinaClose(b, 1))
{
string popupScript4 = "<script language='JavaScript'>window.opener.location='Consumo_Dimensionadora.aspx?id=3&Cat=10&o=" + lblOT.Text + "&c=" + lblPliego.Text + "&f=" + lblFolio.Text + "&t=" + lblCantidad.Text + "&n=" + lblNombreOt.Text + "';window.close();</script>";
Page.RegisterStartupScript("PopupScript", popupScript4);
}
else
{
Validacion0.Visible = true;
Validacion0.Attributes.Add("style", "background-color:Red");
Image0.ImageUrl = "../../Images/cross.png";
lblvalidacion0.ForeColor = Color.White;
lblvalidacion0.Text = "Error de Conexion, Intente Nuevamente.";
}
}
else
{
Validacion0.Visible = true;
Validacion0.Attributes.Add("style", "background-color:Red");
Image0.ImageUrl = "../../Images/cross.png";
lblvalidacion0.ForeColor = Color.White;
lblvalidacion0.Text = "Ingrese Monto Valido.";
}
}
if (Convert.ToInt32(ddlSaldo.SelectedValue) == 2)
{
b.Saldo = 0;
Validacion.Visible = false;
b.Peso_Cono = Convert.ToDouble(txtCono.Text);
if (controlbo.UpdateBobinaClose(b, 2))
{
string popupScript4 = "<script language='JavaScript'>window.opener.location='Consumo_Dimensionadora.aspx?id=3&Cat=10&o=" + lblOT.Text + "&c=" + lblPliego.Text + "&f=" + lblFolio.Text + "&t=" + lblCantidad.Text + "&n=" + lblNombreOt.Text + "';window.close();</script>";
Page.RegisterStartupScript("PopupScript", popupScript4);
}
else
{
Validacion0.Visible = true;
Validacion0.Attributes.Add("style", "background-color:Red");
Image0.ImageUrl = "../../Images/cross.png";
lblvalidacion0.ForeColor = Color.White;
lblvalidacion0.Text = "Error de Conexion, Intente Nuevamente.";
}
}
}
public void Cargar_OrigenCorte()
{
Bobina_Controller controlbob = new Bobina_Controller();
DropDownList1.DataSource = controlbob.ListarOrigenesCorte();
DropDownList1.DataTextField = "Lote";
DropDownList1.DataValueField = "Lote";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, new ListItem("Seleccione..."));
}
public void CargarCategorias()
{
Bobina_Controller controlBob = new Bobina_Controller();
ddlCategoria.DataSource = controlBob.ListarOrigenesCorte();
ddlCategoria.DataTextField = "Lote";
ddlCategoria.DataValueField = "Lote";
ddlCategoria.DataBind();
ddlCategoria.Items.Insert(0, new ListItem("Todas", "Todas"));
}
protected void ddlResponsable_SelectedIndexChanged(object sender, EventArgs e)
{
if (Convert.ToInt32(ddlResponsable.SelectedValue) != 0)
{
Bobina_Controller controlbo = new Bobina_Controller();
ddlCausa.DataSource = controlbo.BuscarEstado_bobi(Convert.ToInt32(ddlResponsable.SelectedValue));
ddlCausa.DataTextField = "Tipo";
ddlCausa.DataValueField = "Codigo";
ddlCausa.DataBind();
ddlCausa.Visible = true;
lblcausa.Visible = true;
}
else
{
ddlCausa.Visible = false;
lblcausa.Visible = false;
}
}
public static string GuardarMotivo(string Usuario, string IDBobina, string Origen, string Motivo)
{
string respuesta = "Error";
Bobina_Controller controlbob = new Bobina_Controller();
Bobina bobina = new Bobina();
bobina.Codigo = IDBobina;
bobina.Proveedor = Origen;
bobina.VerMas = Usuario;
bobina.pliego = Motivo;
if (Origen != "Seleccione..." && Motivo != "Seleccione...")
{
if (controlbob.InsertMotivoCorte(bobina))
{
respuesta = "OK";
}
}
return(respuesta);
}
public void CargarBobina()
{
Bobina_Controller controlbo = new Bobina_Controller();
string codigo = "0";
if (txtCodigoB.Text != "")
{
codigo = txtCodigoB.Text;
}
Bobina bob = controlbo.BuscarBobinaCodigo(codigo);
List <Bobina> lista = new List <Bobina>();
lista.Add(bob);
RadGrid1.DataSource = lista;
RadGrid1.DataBind();
Validacion.Visible = false;
RadGrid1.Visible = true;
lblBobina.Text = bob.Ubicacion;
}
public static string Carga_Motivo(string TipoOrigen)
{
Bobina_Controller controlbob = new Bobina_Controller();
List <Bobina> lista = controlbob.ListarMotivoCorte(TipoOrigen);
List <Bobina> lista2 = new List <Bobina>();
int contador = 1;
Bobina insert1 = new Bobina();
insert1.Lote = "Seleccione...";
lista2.Insert(0, insert1);
foreach (Bobina ps in lista)
{
Bobina objst = new Bobina();
objst.Lote = ps.Lote;
lista2.Insert(contador, objst);
contador++;
}
JavaScriptSerializer jscript = new JavaScriptSerializer();
return(jscript.Serialize(lista2));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Controller_Dimensionadora dd = new Controller_Dimensionadora();
try
{
lblOT.Text = Request.QueryString["o"].ToString();
lblNombreOT.Text = Request.QueryString["n"].ToString();
lblComponente.Text = Request.QueryString["c"].ToString();
lblCantidad.Text = Request.QueryString["t"].ToString();
lblFolio.Text = Request.QueryString["f"].ToString();
Bobina_Controller controlBo = new Bobina_Controller();
List <Bobina> listaPendiente1 = controlBo.listarBobinaPend(Request.QueryString["o"].ToString(), " ", 1);
List <Bobina> listaPendiente2 = controlBo.listarBobinaPend(Request.QueryString["o"].ToString(), Request.QueryString["c"].ToString(), 1);
List <Bobina> listaConsumoda1 = controlBo.listarBobinaPend(Request.QueryString["o"].ToString(), " ", 2);
List <Bobina> listaConsumoda2 = controlBo.listarBobinaPend(Request.QueryString["o"].ToString(), Request.QueryString["c"].ToString(), 2);
RadGrid4.DataSource = listaPendiente1.Union(listaPendiente2);
RadGrid5.DataSource = listaConsumoda1.Union(listaConsumoda2);
RadGrid4.DataBind();
RadGrid5.DataBind();
divPliego.Visible = true;
divDimensionadora.Visible = false;
}
catch
{
RadGrid2.DataSource = dd.CargaPendientesDimensionadoraConsumo(0, "", "");
RadGrid2.DataBind();
divPliego.Visible = false;
divDimensionadora.Visible = true;
}
}
}
protected void ibExcel_Click(object sender, ImageClickEventArgs e)
{
int PesoTotalOrig = 0;
string f1 = "";
string f2 = "";
if (txtFechaInicio.Text != "" && txtFechaTermino.Text != "")
{
string fechaI = txtFechaInicio.Text;
string[] str = fechaI.Split('/');
string dia = str[0];
string mes = str[1];
string año = str[2];
año = año.Substring(0, 4);
string fechaInicio = mes + "/" + dia + "/" + año;
f1 = fechaInicio;
string fechaT = txtFechaTermino.Text;
string[] str2 = fechaT.Split('/');
string dia2 = str2[0];
string mes2 = str2[1];
string año2 = str2[2];
año = año.Substring(0, 4);
string fechaTermino = mes2 + "/" + dia2 + "/" + año2;
f2 = fechaTermino;
}
else
{
f1 = DateTime.Now.AddDays(-1).ToString("MM/dd/yyyy");
f2 = DateTime.Now.AddDays(-30).ToString("MM/dd/yyyy");
}
HttpResponse response = Response;
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Page pageToRender = new Page();
HtmlForm form = new HtmlForm();
Label la = new Label();
Bobina_Controller controlb = new Bobina_Controller();
List <Inf_Regional> lista = controlb.List_Inf_Regional(f1, f2);
PesoTotalOrig = controlb.PesoOriginalTB(f1, f2);
List <Inf_Regional> lista1 = lista.Where(o => o.Maquina.Substring(0, 3).ToUpper() != "WEB" && o.Turno == "Mañana" && o.Maquina != "General").ToList();
Inf_Regional TTurnoR = new Inf_Regional();
int CantidadBob = 0;
foreach (Inf_Regional x in lista1)
{
CantidadBob = CantidadBob + (Convert.ToInt32(x.BobBueCant) + Convert.ToInt32(x.BobDetCant) + Convert.ToInt32(x.BobOtrCant) + Convert.ToInt32(x.BobRotCant));
TTurnoR.Maquina = "T. Turno";
TTurnoR.BobBueCant = (Convert.ToInt32(x.BobBueCant) + Convert.ToInt32(TTurnoR.BobBueCant)).ToString(); TTurnoR.BobBueEsc = (Convert.ToDouble(x.BobBueEsc) + Convert.ToDouble(TTurnoR.BobBueEsc)).ToString();
TTurnoR.BobDetCant = (Convert.ToInt32(x.BobDetCant) + Convert.ToInt32(TTurnoR.BobDetCant)).ToString(); TTurnoR.BobDetEsc = (Convert.ToDouble(x.BobDetEsc) + Convert.ToDouble(TTurnoR.BobDetEsc)).ToString();
TTurnoR.BobOtrCant = (Convert.ToInt32(x.BobOtrCant) + Convert.ToInt32(TTurnoR.BobOtrCant)).ToString(); TTurnoR.BobOtrEsc = (Convert.ToDouble(x.BobOtrEsc) + Convert.ToDouble(TTurnoR.BobOtrEsc)).ToString();
TTurnoR.BobRotCant = (Convert.ToInt32(x.BobRotCant) + Convert.ToInt32(TTurnoR.BobRotCant)).ToString(); TTurnoR.BobRotEsc = (Convert.ToDouble(x.BobRotEsc) + Convert.ToDouble(TTurnoR.BobRotEsc)).ToString();
}
if (TTurnoR.BobBueCant != "0")
{
TTurnoR.BobBueProm = (Convert.ToDouble(TTurnoR.BobBueEsc) / Convert.ToInt32(TTurnoR.BobBueCant)).ToString("N1");
TTurnoR.BobBueProG = ((Convert.ToDouble(TTurnoR.BobBueCant) / CantidadBob) * 100).ToString("N2");
}
else
{
TTurnoR.BobBueProm = "0"; TTurnoR.BobBueProG = "0.00";
}
if (TTurnoR.BobDetCant != "0")
{
TTurnoR.BobDetProm = (Convert.ToDouble(TTurnoR.BobDetEsc) / Convert.ToInt32(TTurnoR.BobDetCant)).ToString("N1");
TTurnoR.BobDetProG = ((Convert.ToDouble(TTurnoR.BobDetCant) / CantidadBob) * 100).ToString("N2");
}
else
{
TTurnoR.BobDetProm = "0"; TTurnoR.BobDetProG = "0.00";
}
if (TTurnoR.BobOtrCant != "0")
{
TTurnoR.BobOtrProm = (Convert.ToDouble(TTurnoR.BobOtrEsc) / Convert.ToInt32(TTurnoR.BobOtrCant)).ToString("N1");
TTurnoR.BobOtrProG = ((Convert.ToDouble(TTurnoR.BobOtrCant) / CantidadBob) * 100).ToString("N2");
}
else
{
TTurnoR.BobOtrProm = "0"; TTurnoR.BobOtrProG = "0.00";
}
if (TTurnoR.BobRotCant != "0")
{
TTurnoR.BobRotProm = (Convert.ToDouble(TTurnoR.BobRotEsc) / Convert.ToInt32(TTurnoR.BobRotCant)).ToString("N1");
TTurnoR.BobRotProG = ((Convert.ToDouble(TTurnoR.BobRotCant) / CantidadBob) * 100).ToString("N2");
}
else
{
TTurnoR.BobRotProm = "0"; TTurnoR.BobRotProG = "0.00";
}
lista1.Add(TTurnoR);
List <Inf_Regional> lista2 = lista.Where(o => o.Maquina.ToUpper() != "WEB 1" && o.Turno == "Tarde" && o.Maquina != "General" && o.Maquina.ToUpper() != "WEB 2").ToList();
Inf_Regional TTurnoR2 = new Inf_Regional();
int CantidadBob2 = 0;
foreach (Inf_Regional x in lista2)
{
CantidadBob2 = CantidadBob2 + (Convert.ToInt32(x.BobBueCant) + Convert.ToInt32(x.BobDetCant) + Convert.ToInt32(x.BobOtrCant) + Convert.ToInt32(x.BobRotCant));
TTurnoR2.Maquina = "T. Turno";
TTurnoR2.BobBueCant = (Convert.ToInt32(x.BobBueCant) + Convert.ToInt32(TTurnoR2.BobBueCant)).ToString(); TTurnoR2.BobBueEsc = (Convert.ToDouble(x.BobBueEsc) + Convert.ToDouble(TTurnoR2.BobBueEsc)).ToString();
TTurnoR2.BobDetCant = (Convert.ToInt32(x.BobDetCant) + Convert.ToInt32(TTurnoR2.BobDetCant)).ToString(); TTurnoR2.BobDetEsc = (Convert.ToDouble(x.BobDetEsc) + Convert.ToDouble(TTurnoR2.BobDetEsc)).ToString();
TTurnoR2.BobOtrCant = (Convert.ToInt32(x.BobOtrCant) + Convert.ToInt32(TTurnoR2.BobOtrCant)).ToString(); TTurnoR2.BobOtrEsc = (Convert.ToDouble(x.BobOtrEsc) + Convert.ToDouble(TTurnoR2.BobOtrEsc)).ToString();
TTurnoR2.BobRotCant = (Convert.ToInt32(x.BobRotCant) + Convert.ToInt32(TTurnoR2.BobRotCant)).ToString(); TTurnoR2.BobRotEsc = (Convert.ToDouble(x.BobRotEsc) + Convert.ToDouble(TTurnoR2.BobRotEsc)).ToString();
}
if (TTurnoR2.BobBueCant != "0")
{
TTurnoR2.BobBueProm = (Convert.ToDouble(TTurnoR2.BobBueEsc) / Convert.ToInt32(TTurnoR2.BobBueCant)).ToString("N1");
TTurnoR2.BobBueProG = ((Convert.ToDouble(TTurnoR2.BobBueCant) / CantidadBob2) * 100).ToString("N2");
}
else
{
TTurnoR2.BobBueProm = "0"; TTurnoR2.BobBueProG = "0.00";
}
if (TTurnoR2.BobDetCant != "0")
{
TTurnoR2.BobDetProm = (Convert.ToDouble(TTurnoR2.BobDetEsc) / Convert.ToInt32(TTurnoR2.BobDetCant)).ToString("N1");
TTurnoR2.BobDetProG = ((Convert.ToDouble(TTurnoR2.BobDetCant) / CantidadBob2) * 100).ToString("N2");
}
else
{
TTurnoR2.BobDetProm = "0"; TTurnoR2.BobDetProG = "0.00";
}
if (TTurnoR2.BobOtrCant != "0")
{
TTurnoR2.BobOtrProm = (Convert.ToDouble(TTurnoR2.BobOtrEsc) / Convert.ToInt32(TTurnoR2.BobOtrCant)).ToString("N1");
TTurnoR2.BobOtrProG = ((Convert.ToDouble(TTurnoR2.BobOtrCant) / CantidadBob2) * 100).ToString("N2");
}
else
{
TTurnoR2.BobOtrProm = "0"; TTurnoR2.BobOtrProG = "0.00";
}
if (TTurnoR2.BobRotCant != "0")
{
TTurnoR2.BobRotProm = (Convert.ToDouble(TTurnoR2.BobRotEsc) / Convert.ToInt32(TTurnoR2.BobRotCant)).ToString("N1");
TTurnoR2.BobRotProG = ((Convert.ToDouble(TTurnoR2.BobRotCant) / CantidadBob2) * 100).ToString("N2");
}
else
{
TTurnoR2.BobRotProm = "0"; TTurnoR2.BobRotProG = "0.00";
}
lista2.Add(TTurnoR2);
List <Inf_Regional> lista3 = lista.Where(o => o.Turno == "Mañana" && o.Maquina.Substring(0, 3).ToUpper() == "WEB").ToList();
int CantidadBob3 = 0;
Inf_Regional TTurno = new Inf_Regional();
foreach (Inf_Regional x in lista3)
{
CantidadBob3 = CantidadBob3 + (Convert.ToInt32(x.BobBueCant) + Convert.ToInt32(x.BobDetCant) + Convert.ToInt32(x.BobOtrCant) + Convert.ToInt32(x.BobRotCant));
TTurno.Maquina = "T. Turno";
TTurno.BobBueCant = (Convert.ToInt32(x.BobBueCant) + Convert.ToInt32(TTurno.BobBueCant)).ToString(); TTurno.BobBueEsc = (Convert.ToDouble(x.BobBueEsc) + Convert.ToDouble(TTurno.BobBueEsc)).ToString();
TTurno.BobDetCant = (Convert.ToInt32(x.BobDetCant) + Convert.ToInt32(TTurno.BobDetCant)).ToString(); TTurno.BobDetEsc = (Convert.ToDouble(x.BobDetEsc) + Convert.ToDouble(TTurno.BobDetEsc)).ToString();
TTurno.BobOtrCant = (Convert.ToInt32(x.BobOtrCant) + Convert.ToInt32(TTurno.BobOtrCant)).ToString(); TTurno.BobOtrEsc = (Convert.ToDouble(x.BobOtrEsc) + Convert.ToDouble(TTurno.BobOtrEsc)).ToString();
TTurno.BobRotCant = (Convert.ToInt32(x.BobRotCant) + Convert.ToInt32(TTurno.BobRotCant)).ToString(); TTurno.BobRotEsc = (Convert.ToDouble(x.BobRotEsc) + Convert.ToDouble(TTurno.BobRotEsc)).ToString();
}
if (TTurno.BobBueCant != "0")
{
TTurno.BobBueProm = (Convert.ToDouble(TTurno.BobBueEsc) / Convert.ToInt32(TTurno.BobBueCant)).ToString("N1");
TTurno.BobBueProG = ((Convert.ToDouble(TTurno.BobBueCant) / CantidadBob3) * 100).ToString("N2");
}
else
{
TTurno.BobBueProm = "0"; TTurno.BobBueProG = "0.00";
}
if (TTurno.BobDetCant != "0")
{
TTurno.BobDetProm = (Convert.ToDouble(TTurno.BobDetEsc) / Convert.ToInt32(TTurno.BobDetCant)).ToString("N1");
TTurno.BobDetProG = ((Convert.ToDouble(TTurno.BobDetCant) / CantidadBob3) * 100).ToString("N2");
}
else
{
TTurno.BobDetProm = "0"; TTurno.BobDetProG = "0.00";
}
if (TTurno.BobOtrCant != "0")
{
TTurno.BobOtrProm = (Convert.ToDouble(TTurno.BobOtrEsc) / Convert.ToInt32(TTurno.BobOtrCant)).ToString("N1");
TTurno.BobOtrProG = ((Convert.ToDouble(TTurno.BobOtrCant) / CantidadBob3) * 100).ToString("N2");
}
else
{
TTurno.BobOtrProm = "0"; TTurno.BobOtrProG = "0.00";
}
if (TTurno.BobRotCant != "0")
{
TTurno.BobRotProm = (Convert.ToDouble(TTurno.BobRotEsc) / Convert.ToInt32(TTurno.BobRotCant)).ToString("N1");
TTurno.BobRotProG = ((Convert.ToDouble(TTurno.BobRotCant) / CantidadBob3) * 100).ToString("N2");
}
else
{
TTurno.BobRotProm = "0"; TTurno.BobRotProG = "0.00";
}
lista3.Add(TTurno);
List <Inf_Regional> lista4 = lista.Where(o => o.Maquina.Substring(0, 3).ToUpper() == "WEB" && o.Turno == "Tarde").ToList();
int CantidadBob4 = 0;
Inf_Regional TTurno1 = new Inf_Regional();
foreach (Inf_Regional x in lista4)
{
CantidadBob4 = CantidadBob4 + (Convert.ToInt32(x.BobBueCant) + Convert.ToInt32(x.BobDetCant) + Convert.ToInt32(x.BobOtrCant) + Convert.ToInt32(x.BobRotCant));
TTurno1.Maquina = "T. Turno";
TTurno1.BobBueCant = (Convert.ToInt32(x.BobBueCant) + Convert.ToInt32(TTurno1.BobBueCant)).ToString(); TTurno1.BobBueEsc = (Convert.ToDouble(x.BobBueEsc) + Convert.ToDouble(TTurno1.BobBueEsc)).ToString();
TTurno1.BobDetCant = (Convert.ToInt32(x.BobDetCant) + Convert.ToInt32(TTurno1.BobDetCant)).ToString(); TTurno1.BobDetEsc = (Convert.ToDouble(x.BobDetEsc) + Convert.ToDouble(TTurno1.BobDetEsc)).ToString();
TTurno1.BobOtrCant = (Convert.ToInt32(x.BobOtrCant) + Convert.ToInt32(TTurno1.BobOtrCant)).ToString(); TTurno1.BobOtrEsc = (Convert.ToDouble(x.BobOtrEsc) + Convert.ToDouble(TTurno1.BobOtrEsc)).ToString();
TTurno1.BobRotCant = (Convert.ToInt32(x.BobRotCant) + Convert.ToInt32(TTurno1.BobRotCant)).ToString(); TTurno1.BobRotEsc = (Convert.ToDouble(x.BobRotEsc) + Convert.ToDouble(TTurno1.BobRotEsc)).ToString();
}
if (TTurno1.BobBueCant != "0")
{
TTurno1.BobBueProm = (Convert.ToDouble(TTurno1.BobBueEsc) / Convert.ToInt32(TTurno1.BobBueCant)).ToString("N1");
TTurno1.BobBueProG = ((Convert.ToDouble(TTurno1.BobBueCant) / CantidadBob4) * 100).ToString("N2");
}
else
{
TTurno1.BobBueProm = "0"; TTurno1.BobBueProG = "0.00";
}
if (TTurno1.BobDetCant != "0")
{
TTurno1.BobDetProm = (Convert.ToDouble(TTurno1.BobDetEsc) / Convert.ToInt32(TTurno1.BobDetCant)).ToString("N1");
TTurno1.BobDetProG = ((Convert.ToDouble(TTurno1.BobDetCant) / CantidadBob4) * 100).ToString("N2");
}
else
{
TTurno1.BobDetProm = "0"; TTurno1.BobDetProG = "0.00";
}
if (TTurno1.BobOtrCant != "0")
{
TTurno1.BobOtrProm = (Convert.ToDouble(TTurno1.BobOtrEsc) / Convert.ToInt32(TTurno1.BobOtrCant)).ToString("N1");
TTurno1.BobOtrProG = ((Convert.ToDouble(TTurno1.BobOtrCant) / CantidadBob4) * 100).ToString("N2");
}
else
{
TTurno1.BobOtrProm = "0"; TTurno1.BobOtrProG = "0.00";
}
if (TTurno1.BobRotCant != "0")
{
TTurno1.BobRotProm = (Convert.ToDouble(TTurno1.BobRotEsc) / Convert.ToInt32(TTurno1.BobRotCant)).ToString("N1");
TTurno1.BobRotProG = ((Convert.ToDouble(TTurno1.BobRotCant) / CantidadBob4) * 100).ToString("N2");
}
else
{
TTurno1.BobRotProm = "0"; TTurno1.BobRotProG = "0.00";
}
lista4.Add(TTurno1);
List <Inf_Regional> lista5 = lista.Where(o => o.Maquina.Substring(0, 3).ToUpper() == "WEB" && o.Turno == "Noche").ToList();
int CantidadBob5 = 0;
Inf_Regional TTurno2 = new Inf_Regional();
foreach (Inf_Regional x in lista5)
{
CantidadBob5 = CantidadBob5 + (Convert.ToInt32(x.BobBueCant) + Convert.ToInt32(x.BobDetCant) + Convert.ToInt32(x.BobOtrCant) + Convert.ToInt32(x.BobRotCant));
TTurno2.Maquina = "T. Turno";
TTurno2.BobBueCant = (Convert.ToInt32(x.BobBueCant) + Convert.ToInt32(TTurno2.BobBueCant)).ToString(); TTurno2.BobBueEsc = (Convert.ToDouble(x.BobBueEsc) + Convert.ToDouble(TTurno2.BobBueEsc)).ToString();
TTurno2.BobDetCant = (Convert.ToInt32(x.BobDetCant) + Convert.ToInt32(TTurno2.BobDetCant)).ToString(); TTurno2.BobDetEsc = (Convert.ToDouble(x.BobDetEsc) + Convert.ToDouble(TTurno2.BobDetEsc)).ToString();
TTurno2.BobOtrCant = (Convert.ToInt32(x.BobOtrCant) + Convert.ToInt32(TTurno2.BobOtrCant)).ToString(); TTurno2.BobOtrEsc = (Convert.ToDouble(x.BobOtrEsc) + Convert.ToDouble(TTurno2.BobOtrEsc)).ToString();
TTurno2.BobRotCant = (Convert.ToInt32(x.BobRotCant) + Convert.ToInt32(TTurno2.BobRotCant)).ToString(); TTurno2.BobRotEsc = (Convert.ToDouble(x.BobRotEsc) + Convert.ToDouble(TTurno2.BobRotEsc)).ToString();
}
if (TTurno2.BobBueCant != "0")
{
TTurno2.BobBueProm = (Convert.ToDouble(TTurno2.BobBueEsc) / Convert.ToInt32(TTurno2.BobBueCant)).ToString("N1");
TTurno2.BobBueProG = ((Convert.ToDouble(TTurno2.BobBueCant) / CantidadBob5) * 100).ToString("N2");
}
else
{
TTurno2.BobBueProm = "0"; TTurno2.BobBueProG = "0.00";
}
if (TTurno2.BobDetCant != "0")
{
TTurno2.BobDetProm = (Convert.ToDouble(TTurno2.BobDetEsc) / Convert.ToInt32(TTurno2.BobDetCant)).ToString("N1");
TTurno2.BobDetProG = ((Convert.ToDouble(TTurno2.BobDetCant) / CantidadBob5) * 100).ToString("N2");
}
else
{
TTurno2.BobDetProm = "0"; TTurno2.BobDetProG = "0.00";
}
if (TTurno2.BobOtrCant != "0")
{
TTurno2.BobOtrProm = (Convert.ToDouble(TTurno2.BobOtrEsc) / Convert.ToInt32(TTurno2.BobOtrCant)).ToString("N1");
TTurno2.BobOtrProG = ((Convert.ToDouble(TTurno2.BobOtrCant) / CantidadBob5) * 100).ToString("N2");
}
else
{
TTurno2.BobOtrProm = "0"; TTurno2.BobOtrProG = "0.00";
}
if (TTurno2.BobRotCant != "0")
{
TTurno2.BobRotProm = (Convert.ToDouble(TTurno2.BobRotEsc) / Convert.ToInt32(TTurno2.BobRotCant)).ToString("N1");
TTurno2.BobRotProG = ((Convert.ToDouble(TTurno2.BobRotCant) / CantidadBob5) * 100).ToString("N2");
}
else
{
TTurno2.BobRotProm = "0"; TTurno2.BobRotProG = "0.00";
}
lista5.Add(TTurno2);
List <Inf_Regional> lista6 = lista.Where(o => o.Maquina == "General").ToList();
GridView MaquinasMR = new GridView();
MaquinasMR.DataSource = lista1;
MaquinasMR.DataBind();
MaquinasMR.HeaderStyle.BackColor = System.Drawing.Color.Blue;
MaquinasMR.HeaderStyle.ForeColor = System.Drawing.Color.White;
GridView MaquinasTR = new GridView();
MaquinasTR.DataSource = lista2;
MaquinasTR.DataBind();
MaquinasTR.HeaderStyle.BackColor = System.Drawing.Color.Blue;
MaquinasTR.HeaderStyle.ForeColor = System.Drawing.Color.White;
GridView MaquinasMW = new GridView();
MaquinasMW.DataSource = lista3;
MaquinasMW.DataBind();
MaquinasMW.HeaderStyle.BackColor = System.Drawing.Color.Blue;
MaquinasMW.HeaderStyle.ForeColor = System.Drawing.Color.White;
GridView MaquinaTW = new GridView();
MaquinaTW.DataSource = lista4;
MaquinaTW.DataBind();
MaquinaTW.HeaderStyle.BackColor = System.Drawing.Color.Blue;
MaquinaTW.HeaderStyle.ForeColor = System.Drawing.Color.White;
GridView MaquinaNW = new GridView();
MaquinaNW.DataSource = lista5;
MaquinaNW.DataBind();
MaquinaNW.HeaderStyle.BackColor = System.Drawing.Color.Blue;
MaquinaNW.HeaderStyle.ForeColor = System.Drawing.Color.White;
MaquinasMR.HeaderRow.Cells[1].Text = "Bob.";
MaquinasMR.HeaderRow.Cells[2].Text = "Peso";
MaquinasMR.HeaderRow.Cells[3].Text = "P. Prom";
MaquinasMR.HeaderRow.Cells[4].Text = "%";
MaquinasMR.HeaderRow.Cells[5].Text = "Bob.";
MaquinasMR.HeaderRow.Cells[6].Text = "Peso";
MaquinasMR.HeaderRow.Cells[7].Text = "P. Prom";
MaquinasMR.HeaderRow.Cells[8].Text = "%";
MaquinasMR.HeaderRow.Cells[9].Text = "Bob.";
MaquinasMR.HeaderRow.Cells[10].Text = "Peso";
MaquinasMR.HeaderRow.Cells[11].Text = "P. Prom";
MaquinasMR.HeaderRow.Cells[12].Text = "%";
MaquinasMR.HeaderRow.Cells[13].Text = "Bob.";
MaquinasMR.HeaderRow.Cells[14].Text = "Peso";
MaquinasMR.HeaderRow.Cells[15].Text = "P. Prom";
MaquinasMR.HeaderRow.Cells[16].Text = "%";
MaquinasMR.HeaderRow.Cells[17].Visible = false;
MaquinasTR.HeaderRow.Cells[1].Text = "Bob.";
MaquinasTR.HeaderRow.Cells[2].Text = "Peso";
MaquinasTR.HeaderRow.Cells[3].Text = "P. Prom";
MaquinasTR.HeaderRow.Cells[4].Text = "%";
MaquinasTR.HeaderRow.Cells[5].Text = "Bob.";
MaquinasTR.HeaderRow.Cells[6].Text = "Peso";
MaquinasTR.HeaderRow.Cells[7].Text = "P. Prom";
MaquinasTR.HeaderRow.Cells[8].Text = "%";
MaquinasTR.HeaderRow.Cells[9].Text = "Bob.";
MaquinasTR.HeaderRow.Cells[10].Text = "Peso";
MaquinasTR.HeaderRow.Cells[11].Text = "P. Prom";
MaquinasTR.HeaderRow.Cells[12].Text = "%";
MaquinasTR.HeaderRow.Cells[13].Text = "Bob.";
MaquinasTR.HeaderRow.Cells[14].Text = "Peso";
MaquinasTR.HeaderRow.Cells[15].Text = "P. Prom";
MaquinasTR.HeaderRow.Cells[16].Text = "%";
MaquinasTR.HeaderRow.Cells[17].Visible = false;
MaquinasMW.HeaderRow.Cells[1].Text = "Bob.";
MaquinasMW.HeaderRow.Cells[2].Text = "Peso";
MaquinasMW.HeaderRow.Cells[3].Text = "P. Prom";
MaquinasMW.HeaderRow.Cells[4].Text = "%";
MaquinasMW.HeaderRow.Cells[5].Text = "Bob.";
MaquinasMW.HeaderRow.Cells[6].Text = "Peso";
MaquinasMW.HeaderRow.Cells[7].Text = "P. Prom";
MaquinasMW.HeaderRow.Cells[8].Text = "%";
MaquinasMW.HeaderRow.Cells[9].Text = "Bob.";
MaquinasMW.HeaderRow.Cells[10].Text = "Peso";
MaquinasMW.HeaderRow.Cells[11].Text = "P. Prom";
MaquinasMW.HeaderRow.Cells[12].Text = "%";
MaquinasMW.HeaderRow.Cells[13].Text = "Bob.";
MaquinasMW.HeaderRow.Cells[14].Text = "Peso";
MaquinasMW.HeaderRow.Cells[15].Text = "P. Prom";
MaquinasMW.HeaderRow.Cells[16].Text = "%";
MaquinasMW.HeaderRow.Cells[17].Visible = false;
MaquinaTW.HeaderRow.Cells[1].Text = "Bob.";
MaquinaTW.HeaderRow.Cells[2].Text = "Peso";
MaquinaTW.HeaderRow.Cells[3].Text = "P. Prom";
MaquinaTW.HeaderRow.Cells[4].Text = "%";
MaquinaTW.HeaderRow.Cells[5].Text = "Bob.";
MaquinaTW.HeaderRow.Cells[6].Text = "Peso";
MaquinaTW.HeaderRow.Cells[7].Text = "P. Prom";
MaquinaTW.HeaderRow.Cells[8].Text = "%";
MaquinaTW.HeaderRow.Cells[9].Text = "Bob.";
MaquinaTW.HeaderRow.Cells[10].Text = "Peso";
MaquinaTW.HeaderRow.Cells[11].Text = "P. Prom";
MaquinaTW.HeaderRow.Cells[12].Text = "%";
MaquinaTW.HeaderRow.Cells[13].Text = "Bob.";
MaquinaTW.HeaderRow.Cells[14].Text = "Peso";
MaquinaTW.HeaderRow.Cells[15].Text = "P. Prom";
MaquinaTW.HeaderRow.Cells[16].Text = "%";
MaquinaTW.HeaderRow.Cells[17].Visible = false;
MaquinaNW.HeaderRow.Cells[1].Text = "Bob.";
MaquinaNW.HeaderRow.Cells[2].Text = "Peso";
MaquinaNW.HeaderRow.Cells[3].Text = "P. Prom";
MaquinaNW.HeaderRow.Cells[4].Text = "%";
MaquinaNW.HeaderRow.Cells[5].Text = "Bob.";
MaquinaNW.HeaderRow.Cells[6].Text = "Peso";
MaquinaNW.HeaderRow.Cells[7].Text = "P. Prom";
MaquinaNW.HeaderRow.Cells[8].Text = "%";
MaquinaNW.HeaderRow.Cells[9].Text = "Bob.";
MaquinaNW.HeaderRow.Cells[10].Text = "Peso";
MaquinaNW.HeaderRow.Cells[11].Text = "P. Prom";
MaquinaNW.HeaderRow.Cells[12].Text = "%";
MaquinaNW.HeaderRow.Cells[13].Text = "Bob.";
MaquinaNW.HeaderRow.Cells[14].Text = "Peso";
MaquinaNW.HeaderRow.Cells[15].Text = "P. Prom";
MaquinaNW.HeaderRow.Cells[16].Text = "%";
MaquinaNW.HeaderRow.Cells[17].Visible = false;
for (int contador = 0; contador < MaquinasMR.Rows.Count; contador++)
{
GridViewRow row = MaquinasMR.Rows[contador];
row.Cells[1].Style.Add("text-align", "right");
row.Cells[2].Style.Add("text-align", "right");
row.Cells[3].Style.Add("text-align", "right");
row.Cells[4].Style.Add("text-align", "right");
row.Cells[5].Style.Add("text-align", "right");
row.Cells[6].Style.Add("text-align", "right");
row.Cells[7].Style.Add("text-align", "right");
row.Cells[8].Style.Add("text-align", "right");
row.Cells[9].Style.Add("text-align", "right");
row.Cells[10].Style.Add("text-align", "right");
row.Cells[11].Style.Add("text-align", "right");
row.Cells[12].Style.Add("text-align", "right");
row.Cells[13].Style.Add("text-align", "right");
row.Cells[14].Style.Add("text-align", "right");
row.Cells[15].Style.Add("text-align", "right");
row.Cells[16].Style.Add("text-align", "right");
row.Cells[17].Visible = false;
}
for (int contador = 0; contador < MaquinasTR.Rows.Count; contador++)
{
GridViewRow row = MaquinasTR.Rows[contador];
row.Cells[1].Style.Add("text-align", "right");
row.Cells[2].Style.Add("text-align", "right");
row.Cells[3].Style.Add("text-align", "right");
row.Cells[4].Style.Add("text-align", "right");
row.Cells[5].Style.Add("text-align", "right");
row.Cells[6].Style.Add("text-align", "right");
row.Cells[7].Style.Add("text-align", "right");
row.Cells[8].Style.Add("text-align", "right");
row.Cells[9].Style.Add("text-align", "right");
row.Cells[10].Style.Add("text-align", "right");
row.Cells[11].Style.Add("text-align", "right");
row.Cells[12].Style.Add("text-align", "right");
row.Cells[13].Style.Add("text-align", "right");
row.Cells[14].Style.Add("text-align", "right");
row.Cells[15].Style.Add("text-align", "right");
row.Cells[16].Style.Add("text-align", "right");
row.Cells[17].Visible = false;
}
for (int contador = 0; contador < MaquinasMW.Rows.Count; contador++)
{
GridViewRow row = MaquinasMW.Rows[contador];
row.Cells[1].Style.Add("text-align", "right");
row.Cells[2].Style.Add("text-align", "right");
row.Cells[3].Style.Add("text-align", "right");
row.Cells[4].Style.Add("text-align", "right");
row.Cells[5].Style.Add("text-align", "right");
row.Cells[6].Style.Add("text-align", "right");
row.Cells[7].Style.Add("text-align", "right");
row.Cells[8].Style.Add("text-align", "right");
row.Cells[9].Style.Add("text-align", "right");
row.Cells[10].Style.Add("text-align", "right");
row.Cells[11].Style.Add("text-align", "right");
row.Cells[12].Style.Add("text-align", "right");
row.Cells[13].Style.Add("text-align", "right");
row.Cells[14].Style.Add("text-align", "right");
row.Cells[15].Style.Add("text-align", "right");
row.Cells[16].Style.Add("text-align", "right");
row.Cells[17].Visible = false;
}
for (int contador = 0; contador < MaquinaTW.Rows.Count; contador++)
{
GridViewRow row = MaquinaTW.Rows[contador];
row.Cells[1].Style.Add("text-align", "right");
row.Cells[2].Style.Add("text-align", "right");
row.Cells[3].Style.Add("text-align", "right");
row.Cells[4].Style.Add("text-align", "right");
row.Cells[5].Style.Add("text-align", "right");
row.Cells[6].Style.Add("text-align", "right");
row.Cells[7].Style.Add("text-align", "right");
row.Cells[8].Style.Add("text-align", "right");
row.Cells[9].Style.Add("text-align", "right");
row.Cells[10].Style.Add("text-align", "right");
row.Cells[11].Style.Add("text-align", "right");
row.Cells[12].Style.Add("text-align", "right");
row.Cells[13].Style.Add("text-align", "right");
row.Cells[14].Style.Add("text-align", "right");
row.Cells[15].Style.Add("text-align", "right");
row.Cells[16].Style.Add("text-align", "right");
row.Cells[17].Visible = false;
}
for (int contador = 0; contador < MaquinaNW.Rows.Count; contador++)
{
GridViewRow row = MaquinaNW.Rows[contador];
row.Cells[1].Style.Add("text-align", "right");
row.Cells[2].Style.Add("text-align", "right");
row.Cells[3].Style.Add("text-align", "right");
row.Cells[4].Style.Add("text-align", "right");
row.Cells[5].Style.Add("text-align", "right");
row.Cells[6].Style.Add("text-align", "right");
row.Cells[7].Style.Add("text-align", "right");
row.Cells[8].Style.Add("text-align", "right");
row.Cells[9].Style.Add("text-align", "right");
row.Cells[10].Style.Add("text-align", "right");
row.Cells[11].Style.Add("text-align", "right");
row.Cells[12].Style.Add("text-align", "right");
row.Cells[13].Style.Add("text-align", "right");
row.Cells[14].Style.Add("text-align", "right");
row.Cells[15].Style.Add("text-align", "right");
row.Cells[16].Style.Add("text-align", "right");
row.Cells[17].Visible = false;
}
string Titulo = "<div align='center'>Reporte de Desponche por Turno <br/>Rango de Fechas: Desde: " + txtFechaInicio.Text + " Hasta " + txtFechaTermino.Text + " </div><br />";
la.Text = Titulo;
form.Controls.Add(la);
Label MaquinasM = new Label();
MaquinasM.Text = "<table><tr><td>2 Turnos</td><td>12 Horas</td></tr></table><table style='width: 100%;'>" +
"<tr><td style='border:1px solid black;'>Turno Mañana</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Bobina Buena</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Problema Rotativa</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Deposito</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Otros Daños</td></tr></table>";
form.Controls.Add(MaquinasM);
form.Controls.Add(MaquinasMR);
Label MaquinaT = new Label();
MaquinaT.Text = "<br/><table style='width: 100%;'>" +
"<tr><td style='border:1px solid black;'>Turno Tarde</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Bobina Buena</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Problema Rotativa</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Deposito</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Otros Daños</td></tr></table>";
form.Controls.Add(MaquinaT);
form.Controls.Add(MaquinasTR);
Label TaTotLitho = new Label();
TaTotLitho.Text = "<br/><table><tr><td>3 Turnos</td><td>8 Horas</td></tr></table><table style='width: 100%;'>" +
"<tr><td style='border:1px solid black;'>Turno Mañana</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Bobina Buena</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Problema Rotativa</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Deposito</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Otros Daños</td></tr></table>";
form.Controls.Add(TaTotLitho);
form.Controls.Add(MaquinasMW);
Label TaTotM600 = new Label();
TaTotM600.Text = "<br/><table style='width: 100%;'>" +
"<tr><td style='border:1px solid black;'>Turno Tarde</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Bobina Buena</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Problema Rotativa</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Deposito</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Otros Daños</td></tr></table>";
form.Controls.Add(TaTotM600);
form.Controls.Add(MaquinaTW);
Label TaTotDimen = new Label();
TaTotDimen.Text = "<br/><table style='width: 100%;'>" +
"<tr><td style='border:1px solid black;'>Turno Noche</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Bobina Buena</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Problema Rotativa</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Deposito</td>" +
"<td style='border:1px solid black;' colspan='4' align='center'>Otros Daños</td></tr></table>";
form.Controls.Add(TaTotDimen);
form.Controls.Add(MaquinaNW);
Label TaTotWeb1 = new Label();
Inf_Regional regional = new Inf_Regional();
foreach (Inf_Regional a in lista6)
{
regional = a;
}
TaTotWeb1.Text = "<br/><table style='width: 100%;'>" +
"<tr><td style='border:1px solid black;'>T. General</td>" +
"<td style='border:1px solid black;text-align:right;'>" + regional.BobBueCant + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobBueEsc + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobBueProm + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobBueProG + "</td>" +
"<td style='border:1px solid black;text-align:right;'>" + regional.BobRotCant + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobRotEsc + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobRotProm + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobRotProG + "</td>" +
"<td style='border:1px solid black;text-align:right;'>" + regional.BobDetCant + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobDetEsc + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobDetProm + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobDetProG + "</td>" +
"<td style='border:1px solid black;text-align:right;'>" + regional.BobOtrCant + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobOtrEsc + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobOtrProm + "</td><td style='border:1px solid black;text-align:right;'>" + regional.BobOtrProG + "</td></tr></table>";
form.Controls.Add(TaTotWeb1);
Label TotalEscalpe = new Label();
double Total = (Convert.ToDouble(regional.BobBueEsc) + Convert.ToDouble(regional.BobRotEsc) + Convert.ToDouble(regional.BobDetEsc) + Convert.ToDouble(regional.BobOtrEsc)) * 100;
double Total2 = Total / PesoTotalOrig;
string detalle = "";
List <Bobina> listadet = controlb.ListarPromEsc(f1, f2);
foreach (Bobina b in listadet)
{
detalle = detalle + "<tr><td colspan ='2'></td><td colspan ='2' style='border:1px solid black;'>Resumen</td><td colspan ='2' style='border:1px solid black;'>Con Proyectos</td><td colspan ='2' style='border:1px solid black;text-align:right;'>" + b.Lote.Replace(".", ",") + "</td><td style='border:1px solid black;text-align:right;'>" + b.Porc_Buenas + "%</td><td colspan ='2' style='border:1px solid black;'>Sin Proyectos</td><td style='border:1px solid black;text-align:right;'>" + b.Marca.Replace(".", ",") + "</td><td style='border:1px solid black;text-align:right;'>" + b.Porc_Malas + "%</td></tr>";
}
TotalEscalpe.Text = "<br/><table style='width: 100%;'><tr><td colspan ='2'></td><td colspan ='2' style='border:1px solid black;'>Total KG. Mes</td><td colspan ='2' style='border:1px solid black;text-align:right;'>" + PesoTotalOrig.ToString("N0").Replace(",", ".") + "</td>" +
"<td colspan ='2' style='border:1px solid black;'>Escarpe KG. Mes</td><td style='border:1px solid black;'>" + Convert.ToInt32(Total / 100).ToString("N0").Replace(",", ".") + "</td><td colspan ='2' style='border:1px solid black;'>% Escarpe/P.Bruto</td><td colspan ='2' style='border:1px solid black;text-align:right;'>" + Total2.ToString("N2") + "%</td></tr>" +
detalle + "<tr><td colspan ='2'></td><td colspan ='2' style='border:1px solid black;'>Prom. Escarpe Int</td><td colspan ='2' style='border:1px solid black;text-align:right;'>" + (((Convert.ToDouble(regional.BobBueEsc) + Convert.ToDouble(regional.BobRotEsc) + Convert.ToDouble(regional.BobDetEsc)) / PesoTotalOrig) * 100).ToString("N2") + "%</td><td colspan ='2' style='border:1px solid black;'>Total Escarpe Otr. Daños</td><td style='border:1px solid black;'>" + regional.BobOtrEsc + "</td></tr></table><br/>";
form.Controls.Add(TotalEscalpe);
pageToRender.Controls.Add(form);
response.Clear();
response.Buffer = true;
response.ContentType = "application/vnd.ms-excel";
string fecha;
if (txtFechaInicio.Text == "")
{
fecha = DateTime.Now.AddDays(-1).ToShortDateString();
}
else
{
fecha = txtFechaInicio.Text;
}
response.AddHeader("Content-Disposition", "attachment;filename=Reporte de Desponche " + fecha + ".xls");
response.Charset = "UTF-8";
response.ContentEncoding = Encoding.Default;
pageToRender.RenderControl(htw);
response.Write(sw.ToString());
response.End();
//fin del excel
}
protected void ibExcel_Click(object sender, ImageClickEventArgs e)
{
Bobina_Controller controlbob = new Bobina_Controller();
Bobina bob = new Bobina();
string FechaInicio = "";
string FechaTermino = "";
if (txtFechaInicio.Text != "" && txtFechaTermino.Text != "")
{
string[] str = txtFechaInicio.Text.Split('-');
FechaInicio = str[2] + "-" + str[1] + "-" + str[0];
string[] str2 = txtFechaTermino.Text.Split('-');
FechaTermino = str2[2] + "-" + str2[1] + "-" + str2[0];
}
bob.NumeroOp = txtNumeroOT.Text.ToString().Trim();
bob.Codigo = txtCodigoBob.Text.ToString().Trim();
if (ddlCategoria.SelectedItem.Text != "Todas")
{
bob.Marca = ddlCategoria.SelectedItem.Text.ToString();
}
else
{
bob.Marca = "";
}
if (ddlMaquina.SelectedItem.Text != "Todas")
{
bob.Lote = ddlMaquina.SelectedItem.Text.ToString();
}
else
{
bob.Lote = "";
}
List <Bobina> lista = controlbob.Listar_Informe_fallaCorte(bob, FechaInicio, FechaTermino);
GridView GridView1 = new GridView();
GridView1.DataSource = lista;
GridView1.DataBind();
GridView1.HeaderStyle.BackColor = System.Drawing.Color.Blue;
GridView1.HeaderStyle.ForeColor = System.Drawing.Color.White;
GridView1.HeaderRow.Cells[0].Text = "Maquina";
GridView1.HeaderRow.Cells[1].Text = "OTs";
GridView1.HeaderRow.Cells[2].Text = "Pliegos";
GridView1.HeaderRow.Cells[3].Text = "Categoria";
GridView1.HeaderRow.Cells[4].Text = "Motivo";
GridView1.HeaderRow.Cells[5].Text = "Cod. Bob. ";
GridView1.HeaderRow.Cells[6].Text = "Tipo Bob.";
GridView1.HeaderRow.Cells[7].Text = "Marca";
GridView1.HeaderRow.Cells[8].Text = "Proveedor";
GridView1.HeaderRow.Cells[9].Text = "Gr.";
GridView1.HeaderRow.Cells[10].Text = "Ancho";
GridView1.HeaderRow.Cells[11].Text = "Fecha";
GridView1.HeaderRow.Cells[12].Visible = false;
GridView1.HeaderRow.Cells[13].Visible = false;
GridView1.HeaderRow.Cells[14].Visible = false;
GridView1.HeaderRow.Cells[15].Visible = false;
GridView1.HeaderRow.Cells[16].Visible = false;
GridView1.HeaderRow.Cells[17].Visible = false;
GridView1.HeaderRow.Cells[18].Visible = false;
GridView1.HeaderRow.Cells[19].Visible = false;
GridView1.HeaderRow.Cells[20].Visible = false;
GridView1.HeaderRow.Cells[21].Visible = false;
GridView1.HeaderRow.Cells[22].Visible = false;
GridView1.HeaderRow.Cells[23].Visible = false;
GridView1.HeaderRow.Cells[24].Visible = false;
GridView1.HeaderRow.Cells[25].Visible = false;
GridView1.HeaderRow.Cells[26].Visible = false;
GridView1.HeaderRow.Cells[27].Visible = false;
for (int contador = 0; contador < GridView1.Rows.Count; contador++)
{
GridViewRow row = GridView1.Rows[contador];
string once = row.Cells[11].Text;
row.Cells[11].Text = row.Cells[0].Text;
row.Cells[0].Text = row.Cells[26].Text;
row.Cells[10].Text = row.Cells[4].Text;
row.Cells[4].Text = row.Cells[1].Text;
row.Cells[1].Text = once;
row.Cells[2].Text = row.Cells[22].Text;
row.Cells[9].Text = row.Cells[3].Text;
row.Cells[3].Text = row.Cells[24].Text;
string cinco = row.Cells[7].Text;
row.Cells[7].Text = row.Cells[5].Text;
row.Cells[5].Text = cinco;
row.Cells[8].Text = row.Cells[25].Text;
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;
}
ExportToExcel("Falla Corte Banda" + FechaInicio, GridView1);
}
protected void TextBox6_TextChanged(object sender, EventArgs e)
{
Bobina_Controller controlbo = new Bobina_Controller();
lblSKU.Text = controlbo.Bobina_Dimensionadora_SKU(lblFolio.Text);
if (txtCodigoB.Text.Length > 0)
{
string codigo = "0";
if (txtCodigoB.Text != "")
{
codigo = txtCodigoB.Text;
}
Bobina bob = controlbo.BuscarBobinaCodigo(codigo);
if (bob.Ubicacion == "Nueva" || bob.Ubicacion == "Saldo")
{
CargarBobina();
if (bob.Ubicacion == "Saldo")
{
txtEmboltorio.Text = "0";
txtEscarpe.Text = "0";
txtTapa.Text = "0";
txtTapa.Enabled = false;
txtEmboltorio.Enabled = false;
Validacion.Visible = true;
Validacion.Attributes.Add("style", "background-color:green");
lblvalidacion.ForeColor = Color.White;
string coincide = "";
if (bob.Cono != lblSKU.Text)
{
coincide = "Esta Bobina no coincide con la solicitud";
}
lblvalidacion.Text = "Bobina Saldo permite tapa, escarpe y envoltorio valores 0 " + coincide;
lblEscarpe.Text = "Peso Escarpe";
}
else
{
Validacion.Visible = false;
if (bob.Cono != lblSKU.Text)
{
Validacion.Visible = true;
Validacion.Attributes.Add("style", "background-color:green");
lblvalidacion.ForeColor = Color.White;
lblvalidacion.Text = "Esta Bobina no coincide con la solicitud";
}
}
}
else if (bob.Ubicacion != "" && bob.Ubicacion != null)
{
Validacion.Visible = true;
Validacion.Attributes.Add("style", "background-color:Red");
Image.ImageUrl = "../../Images/cross.png";
lblvalidacion.ForeColor = Color.White;
lblvalidacion.Text = bob.Ubicacion;
RadGrid1.Visible = false;
}
else if (bob.Ubicacion == null)
{
Validacion.Visible = true;
Validacion.Attributes.Add("style", "background-color:Red");
Image.ImageUrl = "../../Images/cross.png";
lblvalidacion.ForeColor = Color.White;
lblvalidacion.Text = "Bobina no encotrada en el Stock de Metrics";
RadGrid1.Visible = false;
}
}
}
public bool EnvioCorreo(Bobina b, string Usuario, string obs)
{
Bobina_Controller controlbo = new Bobina_Controller();
/* Carga de PAra la base de Datos*/
/*-------------------------MENSAJE DE CORREO----------------------*/
//Creamos un nuevo Objeto de mensaje
System.Net.Mail.MailMessage mmsg = new System.Net.Mail.MailMessage();
//Direccion de correo electronico a la que queremos enviar el mensaje
//mmsg.To.Add("*****@*****.**");
mmsg.To.Add("*****@*****.**");
//mmsg.To.Add("*****@*****.**");
//Nota: La propiedad To es una colección que permite enviar el mensaje a más de un destinatario
//Asunto
mmsg.Subject = "Exceso de escarpe en Bobina";
mmsg.SubjectEncoding = System.Text.Encoding.UTF8;
//Direccion de correo electronico que queremos que reciba una copia del mensaje
//mmsg.Bcc.Add("*****@*****.**"); //Opcional
DateTime hoy = DateTime.Now;
string fecha = hoy.ToString("dd/MM/yyyy HH:mm");
string[] str = fecha.Split('/');
string dia = str[0];
string mes = str[1];
string año = str[2];
//año = año.Substring(0, 4);
//string hora = hoy.ToLongTimeString();
string Daño = "";
List <Bobina> list = controlbo.BuscarEstado_bobi(b.Responsable);
foreach (Bobina bobin in list)
{
if (bobin.Codigo == "100")
{
Daño = bobin.Tipo;
}
else if (bobin.Codigo == ddlCausa.SelectedValue.ToString())
{
Daño = bobin.Tipo;
}
}
OrdenController orden = new OrdenController();
Orden OT = orden.BuscarPorOT(b.NumeroOp);
//Cuerpo del Mensaje
mmsg.Body =
"<table style='width:80%;'>" +
"<tr>" +
"<td>" +
"<img src='http://www.qg.com/images/qg_logocrop.gif' />" +
"<img src='http://www.qg.com/la/es/images/QG_Tagline_sp.jpg' />" +
" </td>" +
"</tr>" +
"</table>" +
//termino cargar logo
"<div style='border-color:Black;border-width:3px;border-style:solid;'>" +
"<table style='width:100%;'>" +
"<tr>" +
"<td style='width:194px;'>" +
" </td>" +
"<td colspan='3'>" +
" </td>" +
"</tr>" +
"<tr>" +
"<td style='width:194px;'>" +
"OT Nro.: </td>" +
"<td>" + b.NumeroOp + "</td>" +
"<td>Nombre OT : </td>" +
"<td>" + OT.NombreOT + "</td>" +
"</tr>" +
// "<tr>" +
// "<td style='width:194px;'>" +
// " Fecha:</td>" +
// "<td colspan='3'>" + dia + "/" + mes + "/" + año + "</td>" +
//"</tr>" +
"<tr>" +
"<td style='width:194px;'>" +
"Creador Por:</td>" +
"<td colspan='3'>" + Usuario +
"</td>" +
"</tr>" +
"</table>" +
"<br />" +
"</div>" +
"<table style='width:80%;'><tr>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;'>Codigo Bob.</td>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;'>P. Bruto</td>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;'>P. Tapa</td>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;'>P. Env.</td>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;'>P. Esc.</td>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;'>Marca</td>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;'>Tipo</td>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;'>Ancho</td>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;'>Gr</td>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;'>Maquina</td>" +
"</tr>" +
"<tr>" +
"<td style='border:1px solid #5D8CC9;'>" + b.Codigo.ToString() + "</td>" +
"<td style='border:1px solid #5D8CC9;'>" + b.Peso_Original.ToString("N0").Replace(',', '.') + "</td>" +
"<td style='border:1px solid #5D8CC9;'>" + b.Peso_Tapa.ToString() + "</td>" +
"<td style='border:1px solid #5D8CC9;'>" + b.Peso_emboltorio.ToString() + "</td>" +
"<td style='border:1px solid #5D8CC9;'>" + b.PesoEscarpe.ToString() + "</td>" +
"<td style='border:1px solid #5D8CC9;'>" + b.Marca + "</td>" +
"<td style='border:1px solid #5D8CC9;'>" + b.Tipo + "</td>" +
"<td style='border:1px solid #5D8CC9;'>" + b.Ancho.ToString() + "</td>" +
"<td style='border:1px solid #5D8CC9;'>" + b.Gramage.ToString() + "</td>" +
"<td style='border:1px solid #5D8CC9;'>" + b.Ubicacion + "</td>" +
"</tr>" +
"<tr>" +
"<td style='border:1px solid #5D8CC9;background:#5D8CC9;' colspan='10'>Observación</td>" +
"</tr>" +
"<tr>" +
"<td style='border:1px solid #5D8CC9;' colspan='10'>Daño: " + Daño + "- Obs.:" + obs + "</td></tr></table>";
mmsg.BodyEncoding = System.Text.Encoding.UTF8;
mmsg.IsBodyHtml = true; //Si no queremos que se envíe como HTML
//Correo electronico desde la que enviamos el mensaje
mmsg.From = new System.Net.Mail.MailAddress("*****@*****.**");//"*****@*****.**");
/*-------------------------CLIENTE DE CORREO----------------------*/
//Creamos un objeto de cliente de correo
System.Net.Mail.SmtpClient cliente = new System.Net.Mail.SmtpClient();
//Hay que crear las credenciales del correo emisor
cliente.Credentials =
new System.Net.NetworkCredential("*****@*****.**", "SI2013.");
//Lo siguiente es obligatorio si enviamos el mensaje desde Gmail
/*
* cliente.Port = 587;
* cliente.EnableSsl = true;
*/
cliente.Host = "mail.qgchile.cl";
/*-------------------------ENVIO DE CORREO----------------------*/
try
{
//Enviamos el mensaje
cliente.Send(mmsg);
return(true);
//Label1.Text = "enviado correctamente";
}
catch (System.Net.Mail.SmtpException ex)
{
return(false);
//Aquí gestionamos los errores al intentar enviar el correo
//Label1.Text = "error al enviar el correo";
}
}
protected void btnGrabar_Click(object sender, EventArgs e)
{
Bobina b = new Bobina();
Bobina_Controller controlbo = new Bobina_Controller();
b.NumeroOp = Request.QueryString["o"].ToString();
b.Codigo = txtCodigoB.Text;
b.pliego = Request.QueryString["c"].ToString();
for (int i = 0; i < RadGrid1.Items.Count; i++)
{
GridDataItem item = (GridDataItem)RadGrid1.Items[i];
b.Proveedor = item["Proveedor"].Text;
b.Marca = item["Marca"].Text;
b.Tipo = item["Tipo"].Text;
string PBruto = item["Peso_Original"].Text;
if (PBruto.Length >= 4)
{
b.Peso_Original = Convert.ToInt32(PBruto.ToString().Replace(",", string.Empty));
}
else
{
b.Peso_Original = Convert.ToInt32(PBruto);
}
string PGr = item["Gramage"].Text;
if (PGr.Length >= 4)
{
b.Gramage = Convert.ToInt32(PGr.Replace(",", string.Empty));
}
else
{
b.Gramage = Convert.ToInt32(PGr);
}
string PAncho = item["Ancho"].Text;
if (PAncho.Length >= 4)
{
b.Ancho = Convert.ToInt32(PAncho.Replace(",", string.Empty));
}
else
{
b.Ancho = Convert.ToInt32(PAncho);
}
}
if (Convert.ToInt32(ddlEstado.SelectedValue) == 1)
{
b.Responsable = 1;
b.Estado_Bobina = 100;
}
else
{
b.Responsable = Convert.ToInt32(ddlResponsable.SelectedValue);
b.Estado_Bobina = Convert.ToInt32(ddlCausa.SelectedValue);
}
b.Peso_Tapa = Convert.ToDouble(txtTapa.Text);
b.Peso_emboltorio = Convert.ToDouble(txtEmboltorio.Text);
b.PesoEscarpe = Convert.ToDouble(txtEscarpe.Text);
string Fecha = "";
if (b.Codigo != "")
{
if (b.PesoEscarpe <= (30) || txtobs.Visible == true)
{
string Maquina = controlbo.BuscarMaquinaUser(GetDireccionIp(Request));
b.Ubicacion = Maquina;
if (Maquina != "")
{
if (controlbo.AgregarBobinaDimen(b, lblUsuario.Text, Maquina, lblSKU.Text, lblFolio.Text))
{
if ((b.Peso_Tapa < 15) && (b.Peso_emboltorio < 15))
{
if (b.PesoEscarpe >= (20))
{
EnvioCorreo(b, lblUsuario.Text, txtobs.Text.ToString());
}
string popupScript4 = "<script language='JavaScript'>window.opener.location='Consumo_Dimensionadora.aspx?id=3&Cat=10&o=" + b.NumeroOp + "&c=" + b.pliego + "&f=" + lblFolio.Text + "&t=" + lblCantidad.Text + "&n=" + lblNombreOt.Text + "';window.close();</script>";
Page.RegisterStartupScript("PopupScript", popupScript4);
}
else
{
Validacion.Visible = true;
Image.ImageUrl = "../../Images/cross.png";
lblvalidacion.Text = "Peso de Tapa y de Envoltura no debe ser mayor a 15KG.";
lblvalidacion.ForeColor = Color.White;
Validacion.Attributes.Add("style", "background-color:red");
}
}
else
{
Validacion.Visible = true;
Image.ImageUrl = "../../Images/cross.png";
lblvalidacion.Text = "Error al Ingresar Registro a Base de Datos.";
lblvalidacion.ForeColor = Color.White;
Validacion.Attributes.Add("style", "background-color:red");
}
}
}
else
{
Validacion.Visible = true;
Image.Visible = false;
lblvalidacion.Text = "Obs.";
lblvalidacion.ForeColor = Color.White;
Validacion.Attributes.Add("style", "background-color:red");
txtobs.Visible = true;
}
}
else
{
Validacion.Visible = true;
Image.ImageUrl = "../../Images/cross.png";
lblvalidacion.Text = "Codigo de Bobina es un campo obligatorio.";
lblvalidacion.ForeColor = Color.White;
Validacion.Attributes.Add("style", "background-color:red");
}
}
