protected void Page_Load(object sender, EventArgs e) { string tipoF = Request.QueryString["Tipo"]; string folio = Request.QueryString["Folio"]; oper = Request.QueryString["Oper"]; string posi = Request.QueryString["posi"]; hidTipo.Value = tipoF; hidFolio.Value = folio; hidOper.Value = "N"; hidPosi.Value = posi; Conexion con = new Conexion(); catalogos c = new catalogos(); if (oper != null) { if (oper.Equals("N")) { string links = ""; links += "<a href='Procesa.aspx"; links += "?Tipo=" + tipoF + "&Folio=" + folio + "&Oper=A&Posi=" + posi; links += "'>Autorizar</a> | <a href='Procesa.aspx"; links += "?Tipo=" + tipoF + "&Folio=" + folio + "&Oper=R&Posi=" + posi; links += "'>Rechazar</a> | <a href='Default.aspx'>Regresar</a> "; //links += "| <a href='https://www.terzaonline.com/nworkflow/login/'>Cerrar sesión</a> "; links += " "; hidOper.Value = oper; lblLinks.InnerHtml = links; if (con.conectar()) { if (tipoF.Equals("01")) { IRfcTable header = con.consultaCabecera(folio, ""); IRfcTable detail = con.consultaDetalle(folio, ""); List <Solicitudes> ss = new List <Solicitudes>(); if (header.Count > 0) { txtFolio.InnerText = "Autorización de Solicitud " + header.GetString("ID_SOLICITUD"); txtPERNR.InnerText = header.GetString("PERNR") + " " + con.nombrePERNR(header.GetString("PERNR")); txtDATE.InnerText = f.fechaToOUT(f.fecha(header.GetString("FECHA"))); txtCOMM.InnerText = header.GetString("COMMENTS"); for (int i = 0; i < detail.Count; i++) { detail.CurrentIndex = i; Solicitudes s = new Solicitudes(); s.vkorg = detail.GetString("VKORG"); s.vtweg = detail.GetString("VTWEG"); s.spart = detail.GetString("SPART"); s.kunnr = detail.GetString("KUNNR"); s.pltyp = detail.GetString("LP_ANT"); s.pltyp_n = detail.GetString("LP_NVO"); s.date = f.fecha(detail.GetString("FECHA")); if (!s.pltyp.Equals("")) { //s.pltyp_desc = c.getDescLP(s.pltyp); s.pltyp_desc = con.getLP_Desc("", s.pltyp); } else { s.pltyp_desc = "Sin lista de precios"; } if (!s.pltyp_n.Equals("")) { //s.pltyp_n_desc = c.getDescLP(s.pltyp_n); s.pltyp_n_desc = con.getLP_Desc("", s.pltyp_n); } else { s.pltyp_n_desc = "Sin lista de precios"; } s.name1 = c.getColumnaCliente(s.vkorg, s.vtweg, s.spart, s.kunnr, "NAME1"); ss.Add(s); } string tab = ""; tab = "<table border='0' style='border-width: 0px; border-style: None; width: 100%; border-collapse: collapse;'><tbody>"; tab += "<tr><td class='cell12'>Org. Compras</td><td class='cell12'>Canal Dist.</td><td class='cell12'>Sector</td><td class='cell12'>Cliente</td><td class='cell12'>Nombre</td><td class='cell12'>Lista anterior</td><td class='cell12'>Nueva Lista de precios</td><td class='cell12'>Vigencia</td></tr>"; foreach (Solicitudes s in ss) { string style = ""; if (s.error) { style = "background-color: red !important;"; } tab += "<tr style='" + style + "'>"; if (s.error) { style = "white-text"; } tab += "<td class='cell18 " + style + "'>" + s.vkorg + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.vtweg + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.spart + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.kunnr + "</td>"; tab += "<td class='cell17 " + style + "'>" + s.name1 + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.pltyp_desc + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.pltyp_n_desc + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.date.ToString("dd/MM/yyyy") + "</td>"; tab += "</tr>"; } tab += "</tbody></table>"; lblTabla.InnerHtml = tab; } else { Response.Redirect("Default.aspx", false); } } else if (tipoF.Equals("02")) { IRfcTable header = con.consultaCabeceraL(folio, ""); IRfcTable detail = con.consultaDetalleL(folio, ""); List <SolicitudesL> ss = new List <SolicitudesL>(); if (header.Count > 0) { txtFolio.InnerText = "Autorización de Solicitud " + header.GetString("ID_SOLICITUD"); txtPERNR.InnerText = header.GetString("PERNR") + " " + con.nombrePERNR(header.GetString("PERNR")); txtDATE.InnerText = f.fechaToOUT(f.fecha(header.GetString("FECHA"))); txtCOMM.InnerText = header.GetString("COMMENTS"); string vkorg = header.GetString("VKORG"); string vtweg = header.GetString("VTWEG"); string spart = header.GetString("SPART"); string kunnr = header.GetString("KUNNR"); string pltyp = header.GetString("PLTYP"); string matnr = header.GetString("MATNR"); string cabecera = "<table style='position: relative; left: 50%; margin-left: -200px'>"; //cabecera += "<tr>"; if (!vkorg.Equals("")) { cabecera += "<tr><td class='cell03'>Org. Compras</td>"; cabecera += "<td class='cell05'>" + vkorg + " " + con.ListaVKORG(vkorg, "").GetString("VTEXT") + "</td></tr>"; } if (!vtweg.Equals("")) { cabecera += "<tr><td class='cell03'>Canal Distribución</td>"; cabecera += "<td class='cell05'>" + vtweg + " " + con.ListaVTWEG(vtweg, "", "").GetString("VTEXT") + "</td></tr>"; } if (!spart.Equals("")) { cabecera += "<tr><td class='cell03'>Sector</td>"; cabecera += "<td class='cell05'>" + spart + " " + con.ListaSPART(spart, "", "", "", "").GetString("VTEXT") + "</td></tr>"; } if (!kunnr.Equals("")) { cabecera += "<tr><td class='cell03'>Cliente</td>"; cabecera += "<td class='cell05'>" + kunnr + " " + con.getCliente(vkorg, vtweg, spart, kunnr).GetString("NAME1") + "</td></tr>"; } if (!pltyp.Equals("")) { cabecera += "<tr><td class='cell03'>Lista de precios</td>"; cabecera += "<td class='cell05'>" + con.getLP_Desc("", pltyp) + "</td></tr>"; } if (!matnr.Equals("")) { cabecera += "<tr><td class='cell03'>Material</td>"; cabecera += "<td class='cell05'>" + matnr + " " + con.columnaMatnr(matnr, "MAKTG", "X") + "</td></tr>"; } cabecera += "<tr><td class='cell03'>Porcentaje</td>"; cabecera += "<td class='cell05'>" + header.GetString("PORCENTAJE") + " %" + "</td></tr>"; cabecera += "</table>"; lblFolio.InnerHtml = cabecera; string tipo = header.GetString("TIPO"); string obj = ""; string titulo = ""; if (tipo.Substring(1, 1).Equals("M")) { obj = "MATNR"; titulo = "Material"; } else if (tipo.Substring(1, 1).Equals("G")) { obj = "MATKL"; titulo = "Grupo de artículos"; } else if (tipo.Substring(1, 1).Equals("P")) { obj = "EBELN"; titulo = "Pedido de cliente"; } else if (tipo.Substring(1, 1).Equals("L")) { obj = "CHARG"; titulo = "Lote"; } for (int i = 0; i < detail.Count; i++) { detail.CurrentIndex = i; SolicitudesL s = new SolicitudesL(); s.obj = detail.GetString(obj); //s.desc = detail.GetString("VTWEG"); //s.desc2 = detail.GetString("SPART"); s.importe = detail.GetString("PR_ANT"); s.moneda = detail.GetString("MON_ANT"); s.importe_n = detail.GetString("PR_NVO"); s.moneda_n = detail.GetString("MON_NVO"); s.fecha_a = f.fecha(detail.GetString("FECHA_INI")); s.fecha_b = f.fecha(detail.GetString("FECHA_FIN")); s.comentario = detail.GetString("COMMENTS"); //if (tipo.Substring(1, 1).Equals("M")) //{ // s.desc = con.columnaMatnr(s.obj, "MAKTG"); // s.desc2 = con.columnaMatnr(s.obj, "MEINS"); //} //else if (tipo.Substring(1, 1).Equals("G")) //{ // s.desc = con.columnaMatkl(s.obj, "WGBEZ"); //} ss.Add(s); } ss = obtenerDatos(ss, tipo.Substring(1, 1)); string tab = ""; tab = "<table border='0' style='border-width: 0px; border-style: None; width: 100%; border-collapse: collapse;'><tbody>"; tab += "<tr>"; tab += "<td class='cell10'>" + titulo + "</td>"; if (!tipo.Substring(1, 1).Equals("P") & !tipo.Substring(1, 1).Equals("L")) { tab += "<td class='cell11'>Denominación</td>"; } if (tipo.Substring(1, 1).Equals("M")) { tab += "<td class='cell12'>Unidad</td>"; } tab += "<td class='cell12'>Precio Anterior</td>"; tab += "<td class='cell12'>Moneda</td>"; tab += "<td class='cell12'>Precio nuevo</td>"; tab += "<td class='cell12'>Moneda</td>"; tab += "<td class='cell12'>Válido de</td>"; tab += "<td class='cell12'>Válido a</td>"; if (tipo.Substring(1, 1).Equals("L")) { tab += "<td class='cell12'>Comentarios</td>"; } tab += "</tr>"; foreach (SolicitudesL s in ss) { string style = ""; if (s.error) { style = "background-color: red !important;"; } tab += "<tr style='" + style + "'>"; if (s.error) { style = "white-text"; } tab += "<td class='cell16 " + style + "'>" + s.obj + "</td>"; if (!tipo.Substring(1, 1).Equals("P") & !tipo.Substring(1, 1).Equals("L")) { tab += "<td class='cell17 " + style + "'>" + s.desc + "</td>"; } if (tipo.Substring(1, 1).Equals("M")) { tab += "<td class='cell18 " + style + "'>" + s.desc2 + "</td>"; } tab += "<td class='cell18 " + style + "'>" + s.importe + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.moneda + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.importe_n + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.moneda_n + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.fecha_a.ToString("dd/MM/yyyy") + "</td>"; tab += "<td class='cell18 " + style + "'>" + s.fecha_b.ToString("dd/MM/yyyy") + "</td>"; if (tipo.Substring(1, 1).Equals("L")) { tab += "<td class='cell18 " + style + "'>" + s.comentario + "</td>"; } tab += "</tr>"; } tab += "</tbody></table>"; lblTabla.InnerHtml = tab; } } IRfcTable bitacora = con.getBitacora(tipoF, folio); string tabla = ""; tabla = "<table border='0' style='border-width: 0px; border-style: None; width: 100%; border-collapse: collapse;'><tbody>"; tabla += "<tr><td class='cell12'>Empleado</td><td class='cell12'>Evento</td><td class='cell12'>Fecha autorizar</td><td class='cell12'>Fecha Procesada</td><td class='cell12'>Status</td><td class='cell12'>Comentario</td></tr>"; for (int i = 0; i < bitacora.Count; i++) { bitacora.CurrentIndex = i; tabla += "<tr><td class='cell17'>"; tabla += bitacora.GetString("ZUSRA") + " - " + bitacora.GetString("ZDUSA"); tabla += "</td>"; tabla += "<td class='cell18'>"; tabla += bitacora.GetString("ZDEEV"); tabla += "</td>"; tabla += "<td class='cell18'>"; tabla += bitacora.GetString("ZFEAL") + "[" + bitacora.GetString("ZHOAL") + "]"; tabla += "</td>"; tabla += "<td class='cell18'>"; tabla += bitacora.GetString("ZFEUM") + "[" + bitacora.GetString("ZHOUM") + "]"; tabla += "</td>"; tabla += "<td class='cell18'>"; tabla += bitacora.GetString("ZSWAR"); tabla += "</td>"; tabla += "<td class='cell18'>"; tabla += bitacora.GetString("ZCOME"); //tabla += "sad ads fas a s fasifu sa disad iasduasdiasud a sdaiud asi duiasdhasoidha soih sad sahdjashdiusahd sa "; tabla += "</td>"; tabla += "</tr>"; } lblBItacora.InnerHtml = tabla; } } else if (oper.Equals("A")) { hidOper.Value = oper; if (con.conectar()) { string links = ""; links += "<a href='Procesa.aspx"; links += "?Tipo=" + tipoF + "&Folio=" + folio + "&Oper=N&Posi=" + posi; links += "'>Cancelar</a> "; lblLinks.InnerHtml = links; if (tipoF.Equals("01")) { IRfcTable header = con.consultaCabecera(folio, ""); //IRfcTable detail = con.consultaDetalle(folio, ""); //List<Solicitudes> ss = new List<Solicitudes>(); if (header.Count > 0) { txtFolio.InnerText = "Ha Seleccionado Autorizar Solicitud " + header.GetString("ID_SOLICITUD"); } } else if (tipoF.Equals("02")) { IRfcTable header = con.consultaCabeceraL(folio, ""); //IRfcTable detail = con.consultaDetalleL(folio, ""); //List<SolicitudesL> ss = new List<SolicitudesL>(); if (header.Count > 0) { txtFolio.InnerText = "Ha Seleccionado Autorizar Solicitud " + header.GetString("ID_SOLICITUD"); } } } } else if (oper.Equals("R")) { hidOper.Value = oper; if (con.conectar()) { string links = ""; links += "<a href='Procesa.aspx"; links += "?Tipo=" + tipoF + "&Folio=" + folio + "&Oper=N&Posi=" + posi; links += "'>Cancelar</a> "; lblLinks.InnerHtml = links; if (tipoF.Equals("01")) { IRfcTable header = con.consultaCabecera(folio, ""); //IRfcTable detail = con.consultaDetalle(folio, ""); //List<Solicitudes> ss = new List<Solicitudes>(); if (header.Count > 0) { txtFolio.InnerText = "Ha Seleccionado Rechazar Solicitud " + header.GetString("ID_SOLICITUD"); } } else if (tipoF.Equals("02")) { IRfcTable header = con.consultaCabeceraL(folio, ""); //IRfcTable detail = con.consultaDetalleL(folio, ""); //List<SolicitudesL> ss = new List<SolicitudesL>(); if (header.Count > 0) { txtFolio.InnerText = "Ha Seleccionado Rechazar Solicitud " + header.GetString("ID_SOLICITUD"); } } } } } }
protected void Page_Load(object sender, EventArgs e) { try { hidUsuario.Value = Session["Usuario"].ToString(); hidNumEmp.Value = Session["NumEmp"].ToString(); hidTipoEmp.Value = Session["TipoEmp"].ToString(); //string[] a = Request.Form.AllKeys; //Conexion c = new Conexion("E-DESARROLL2", "Initial02"); Conexion con = new Conexion(); catalogos c = new catalogos(); if (con.conectar()) { List <string> mon = con.monedas(); List <meins> mei = con.meinss(); monedas = formaMoneda("MXN", mon); um_meins = formaMeins("", mei); fecha_limite = con.fechaLimite(); if (Request.Form.AllKeys.Length == 0) { IRfcTable lista_vkorg = con.ListaVKORG("", hidNumEmp.Value); //IRfcTable lista_pltyp = con.ListaPLTYP(); for (int i = 0; i < lista_vkorg.Count; i++) { lista_vkorg.CurrentIndex = i; txtVKORG.Items.Add(new ListItem(lista_vkorg.GetString("VKORG") + " " + lista_vkorg.GetString("VTEXT"), lista_vkorg.GetString("VKORG"))); } IRfcTable lista_vtweg = con.ListaVTWEG("", hidNumEmp.Value, txtVKORG.Value); for (int i = 0; i < lista_vtweg.Count; i++) { lista_vtweg.CurrentIndex = i; txtVTWEG.Items.Add(new ListItem(lista_vtweg.GetString("VTWEG") + " " + lista_vtweg.GetString("VTEXT"), lista_vtweg.GetString("VTWEG"))); } IRfcTable lista_spart = con.ListaSPART("", hidNumEmp.Value, txtVKORG.Value, txtVTWEG.Value, "02"); for (int i = 0; i < lista_spart.Count; i++) { lista_spart.CurrentIndex = i; txtSPART.Items.Add(new ListItem(lista_spart.GetString("SPART") + " " + lista_spart.GetString("VTEXT"), lista_spart.GetString("SPART"))); } } if (Request.Form.AllKeys.Length > 0) { string vkorg = Request.Form["txtVKORG"]; string vtweg = Request.Form["txtVTWEG"]; string spart = Request.Form["txtSPART"]; string kunnr = Request.Form["txtKUNNR"]; //txtVKORG.Disabled = true; //txtVTWEG.Disabled = true; //txtSPART.Disabled = true; txtNAME1.Value = c.getColumnaCliente(vkorg, vtweg, spart, kunnr, "NAME1"); IRfcTable a720 = con.consultaLPDetail("", "", spart, kunnr, "", "", "", "A720"); txtPos.Value = a720.Count + ""; string tabla = ""; string valores = ""; tabla = "<table id='Table9' style='borde -width: 0px; border-style: None; width: 100 %; border-collapse: collapse;'><tbody><tr class='cell08'><td></td></tr></tbody></table>"; tabla += "<table id='tblTabla' border='0' style='border-width: 0px; border-style: None; width: 100%; border-collapse: collapse;'><tbody>"; tabla += "<tr><td class='tablahead'>Pedido del cliente</td><td class='tablahead'>Unidad</td>" + "<td class='tablahead'>Precio actual</td><td class='tablahead'>Moneda</td>" + "<td class='tablahead'>Precio nuevo</td><td class='tablahead'>Moneda</td>" + "<td class='tablahead'>Válido de</td><td class='tablahead'>Válido a</td><td class='tablahead'></td><td class='tablahead'></td></tr>"; if (a720.Count > 0) { List <SolicitudesL> ss = new List <SolicitudesL>(); for (int i = 0; i < a720.Count; i++) { SolicitudesL s = new SolicitudesL(); a720.CurrentIndex = i; s.obj = a720.GetString("ZZBSTKD"); s.importe = a720.GetString("KBETR"); s.moneda = a720.GetString("KONWA"); s.importe_n = nuevoPrecio(a720.GetString("KBETR")); s.moneda_n = a720.GetString("KONWA"); s.fecha_a = f.fecha(a720.GetString("DATAB")); s.fecha_b = f.fecha(a720.GetString("DATBI")); s.id = a720.GetString("KNUMH"); s.escala = a720.GetString("ESCALA"); s.desc2 = a720.GetString("KMEIN"); ss.Add(s); } int pos = 0; for (int i = 0; i < ss.Count; i++) { pos++; tabla += "<tr id='tr-" + pos + "'><td class='tablaCent' id='OBJ-" + pos + "' ondblclick='escalas(this.id)'>"; tabla += "<input type='hidden' id='MATNR-" + pos + "' value='" + ss[i].obj + "' />"; tabla += ss[i].obj; tabla += "</td>"; tabla += "<td class='tablaCent' id='DESC2-" + pos + "' ondblclick='escalas(this.id)'>"; tabla += "<select id='MEINS-" + pos + "' class='cell031' style='width:40px;' onchange='cambiaMeins(this.id, this.value)' />"; tabla += formaMeins(ss[i].desc2, mei); tabla += "</select>"; tabla += "</td>"; tabla += "<td class='tablaCent'>"; tabla += ss[i].importe; tabla += "</td><td class='tablaCent'>"; tabla += ss[i].moneda; tabla += "</td>"; tabla += "<td class='tablaCent'>"; tabla += "<input class='cell031' type='text' onchange='cambiaCant(this.id)' id='KBETR-" + pos + "' value='"; tabla += ss[i].importe_n; tabla += "' />"; tabla += "</td><td class='tablaCent'>"; tabla += "<select class='cell031' onchange='cambiaMone(this)' id='KONWA-" + pos + "'>"; tabla += formaMoneda(ss[i].moneda_n, mon); tabla += "' </select>"; tabla += "</td><td class='tablaCent'>"; tabla += "<input class='cell031 datepicker' type='text' onchange='cambiaFechA(this.value, this.id);' ondblclick='copiaA(this.value)' id='DATAB-" + pos + "' value='"; tabla += f.fechaToOUT(ss[i].fecha_a); tabla += "' />"; tabla += "</td><td class='tablaCent'>"; tabla += "<input class='cell031 datepicker' type='text' onchange='cambiaFechB(this.value, this.id);' ondblclick='copiaB(this.value)' id='DATBI-" + pos + "' value='"; tabla += f.fechaToOUT(ss[i].fecha_b); tabla += "' />"; tabla += "</td>"; tabla += "<td><input type='checkbox' id='chk-" + pos + "'"; if (ss[i].escala.Equals("X")) { tabla += "checked disabled='disabled' /><input type='hidden' id='knumh-" + pos + "' value='" + ss[i].id + "' /><script>generaEscalas('" + ss[i].id + "', " + pos + ");</script></td>"; } else { tabla += " disabled='disabled' /><input type='hidden' id='knumh-" + pos + "' value='' /></td>"; } tabla += "<td class='tablaCent'><input type='button' id='btn-" + pos + "' value='-' class='btn2' onclick='elimina(this.id)' /></td></tr>"; valores += ss[i].obj + "|" + ss[i].importe + "|" + ss[i].moneda + "|"; valores += ss[i].importe_n; if (ss[i].moneda_n.Trim().Equals("")) { valores += "|MXN|"; } else { valores += "|" + ss[i].moneda_n + "|"; } valores += f.fechaToOUT(ss[i].fecha_a) + "|" + f.fechaToOUT(ss[i].fecha_b) + "|" + ss[i].id + "|X||"; btnSubmit.Disabled = false; valores += ss[i].desc2 + "|"; btnSubmit.Disabled = false; btnCargar.Disabled = false; btnAgregar.Disabled = false; } } else { btnCargar.Disabled = false; btnAgregar.Disabled = false; } tabla += "</tbody></table>"; lblTabla.InnerHtml = tabla; txtTabla.Value = valores; } } } catch (Exception ex) { //Response.Redirect("../../../Default.aspx"); var page = HttpContext.Current.Handler as Page; if (page != null) { page.ClientScript.RegisterClientScriptBlock(typeof(string), "Redirect", "window.parent.location='https://www.terzaonline.com/nworkflow/login/';", true); } //ClientScriptManager.RegisterClientScriptBlock(this.GetType(), "RedirectScript", "window.parent.location = '../../../Default.aspx'", true); } }
protected void Page_Load(object sender, EventArgs e) { try { hidUsuario.Value = Session["Usuario"].ToString(); hidNumEmp.Value = Session["NumEmp"].ToString(); string folio = Request.QueryString["Folio"]; Conexion con = new Conexion(); catalogos c = new catalogos(); IRfcTable header = con.consultaCabecera(folio, hidNumEmp.Value); IRfcTable detail = con.consultaDetalle(folio, hidNumEmp.Value); List <Solicitudes> ss = new List <Solicitudes>(); if (header.Count > 0) { txtFolio.Value = header.GetString("ID_SOLICITUD"); txtPERNR.InnerText = header.GetString("PERNR") + " " + con.nombrePERNR(header.GetString("PERNR")); txtDATE.InnerText = f.fechaToOUT(f.fecha(header.GetString("FECHA"))); txtCOMM.InnerText = header.GetString("COMMENTS"); for (int i = 0; i < detail.Count; i++) { detail.CurrentIndex = i; Solicitudes s = new Solicitudes(); s.vkorg = detail.GetString("VKORG"); s.vtweg = detail.GetString("VTWEG"); s.spart = detail.GetString("SPART"); s.kunnr = detail.GetString("KUNNR"); s.pltyp = detail.GetString("LP_ANT"); s.pltyp_n = detail.GetString("LP_NVO"); s.date = f.fecha(detail.GetString("FECHA")); if (!s.pltyp.Equals("")) { //s.pltyp_desc = c.getDescLP(s.pltyp); s.pltyp_desc = con.getLP_Desc("", s.pltyp); } else { s.pltyp_desc = "Sin lista de precios"; } if (!s.pltyp_n.Equals("")) { //s.pltyp_n_desc = c.getDescLP(s.pltyp_n); s.pltyp_n_desc = con.getLP_Desc("", s.pltyp_n); } else { s.pltyp_n_desc = "Sin lista de precios"; } s.name1 = c.getColumnaCliente(s.vkorg, s.vtweg, s.spart, s.kunnr, "NAME1"); ss.Add(s); } string tab = ""; tab = "<table border='0' style='border-width: 0px; border-style: None; width: 100%; border-collapse: collapse;'><tbody>"; tab += "<tr><td class='tablahead'>Org. Compras</td><td class='tablahead'>Canal Dist.</td><td class='tablahead'>Sector</td><td class='tablahead'>Cliente</td><td class='tablahead'>Nombre</td><td class='tablahead'>Lista anterior</td><td class='tablahead'>Nueva Lista de precios</td><td class='tablahead'>Vigencia</td></tr>"; foreach (Solicitudes s in ss) { string style = ""; if (s.error) { style = "background-color: red !important;"; } tab += "<tr style='" + style + "'>"; if (s.error) { style = "white-text"; } tab += "<td class='tablaCent " + style + "'>" + s.vkorg + "</td>"; tab += "<td class='tablaCent " + style + "'>" + s.vtweg + "</td>"; tab += "<td class='tablaCent " + style + "'>" + s.spart + "</td>"; tab += "<td class='tablaCent " + style + "'>" + s.kunnr + "</td>"; tab += "<td class='tablaIzq " + style + "'>" + s.name1 + "</td>"; tab += "<td class='tablaCent " + style + "'>" + s.pltyp_desc + "</td>"; tab += "<td class='tablaCent " + style + "'>" + s.pltyp_n_desc + "</td>"; tab += "<td class='tablaCent " + style + "'>" + s.date.ToString("dd/MM/yyyy") + "</td>"; tab += "</tr>"; } tab += "</tbody></table>"; lblTabla.InnerHtml = tab; IRfcTable bitacora = con.getBitacora("01", folio); string tabla = ""; tabla = "<table border='0' style='border-width: 0px; border-style: None; width: 100%; border-collapse: collapse;'><tbody>"; tabla += "<tr><td class='cell12'>Empleado</td><td class='cell12'>Evento</td><td class='cell12'>Fecha autorizar</td><td class='cell12'>Fecha Procesada</td><td class='cell12'>Status</td><td class='cell12'>Comentario</td></tr>"; for (int i = 0; i < bitacora.Count; i++) { bitacora.CurrentIndex = i; tabla += "<tr><td class='cell17'>"; tabla += bitacora.GetString("ZUSRA") + " - " + bitacora.GetString("ZDUSA"); tabla += "</td>"; tabla += "<td class='cell18'>"; tabla += bitacora.GetString("ZDEEV"); tabla += "</td>"; tabla += "<td class='cell18'>"; tabla += bitacora.GetString("ZFEAL") + "[" + bitacora.GetString("ZHOAL") + "]"; tabla += "</td>"; tabla += "<td class='cell18'>"; tabla += bitacora.GetString("ZFEUM") + "[" + bitacora.GetString("ZHOUM") + "]"; tabla += "</td>"; tabla += "<td class='cell18'>"; tabla += bitacora.GetString("ZSWAR"); tabla += "</td>"; tabla += "<td class='cell18' style='max-width:200px;overflow-y:hidden;'>"; tabla += bitacora.GetString("ZCOME"); //tabla += "sad ads fas a s fasifu sa disad iasduasdiasud a sdaiud asi duiasdhasoidha soih sad sahdjashdiusahd sa "; tabla += "</td>"; tabla += "</tr>"; } lblBItacora.InnerHtml = tabla; } else { Response.Redirect("Default.aspx", false); } } catch (Exception ex) { Response.Redirect("https://www.terzaonline.com/nworkflow/login/"); } }