protected void Button2_Click(object sender, EventArgs e) { lblVerificacion.Visible = false; SQL = "SELECT * FROM ALIUSERS WHERE CODUSE='" + (string)(Session["Usuario"]).ToString().Trim() + "' AND CODPWD='" + txtPWDAnterior.Text.ToUpper().Trim() + "'"; objTablas = new BTablas(); dtPruebaUsuarios = objTablas.Query(SQL); if (dtPruebaUsuarios.Rows.Count > 0) { lblVerificacion.Visible = true; SQL = "UPDATE ALIUSERS SET CODPWD = '" + txtPWDNuevo.Text.ToUpper().Trim() + "' WHERE CODUSE='" + (string)(Session["Usuario"]).ToString().Trim() + "' AND CODPWD='" + txtPWDAnterior.Text.ToUpper().Trim() + "'"; objTablas = new BTablas(); int i = objTablas.InUpDelTablas(SQL); if (i == 1) { txtPWDAnterior.Text = ""; txtPWDConfirmacion.Text = ""; txtPWDNuevo.Text = ""; Response.Redirect("~/WebMenuPrincipal.aspx"); } else { lblVerificacion.Text = "No se pudo actualizar contraseña"; } } else { lblVerificacion.Visible = true; lblVerificacion.Text = "Contraseña Anterior Incorrecta"; } }
void LlenarGrilla() { SQL = "SELECT " + " A11NSA,A11FSA, " + " CASE WHEN (A11TUR = '1') THEN '1er Turno' " + " WHEN (A11TUR = '2') THEN '2do Turno' " + " ELSE '3er Turno' END A11TUR, " + " CASE WHEN A11OTR IN (0,99) THEN U.T01AL1 ELSE CC.T01AL1 END AS T01AL1,CC.ODTDES, " + " IFNULL(CASE WHEN (A11STT || ' - ' ||A11EST) IN('S - D','J - D','G - D') THEN 'X Generar' " + " WHEN (A11STT || ' - ' ||A11EST) IN('S - SP') THEN 'Generado Parcial' " + " WHEN (A11STT || ' - ' ||A11EST) IN('S - 1') THEN 'x Firma' " + " WHEN (A11STT || ' - ' ||A11EST) IN('S - 2') THEN 'x Firma Jef.' " + " WHEN (A11STT || ' - ' ||A11EST) IN('S - 3') THEN 'x Firma Ger.' " + " WHEN (A11STT || ' - ' ||A11EST) IN('S - S') THEN 'Generado' ELSE 'Eliminado' " + " END,'') ESTADO " + " FROM ALI011UTIL AS A11 LEFT OUTER JOIN " + " (SELECT ODTSTT, CAST(ODTCOD AS CHAR(3)) AS ODTCOD,CAST(ODTDPT AS CHAR(5)) AS ODTDPT,ODTDES, ifnull(T01AL1,'') AS T01AL1 " + " FROM AIODET LEFT JOIN UGT01 ON (DIGITS(ODTDPT) = T01ESP AND T01IDT='CCT')) AS CC ON A11.A11OTR=CC.ODTCOD " + " LEFT OUTER JOIN (SELECT T01ESP,T01AL1 FROM UGT01 WHERE T01IDT='CCT') AS U ON DIGITS(A11.A11ARE)=U.T01ESP " + " WHERE A11SOL=" + Convert.ToDecimal((string)(Session["CodPlanilla"])) + " " + " ORDER BY A11FSA DESC"; objTablas = new BTablas(); dtReq = objTablas.Query(SQL); dgvRequrimientos.DataSource = dtReq; dgvRequrimientos.DataBind(); }
void LlenarGrilla() { SQL = " SELECT " + " A11NSA,A11FSA, " + " CASE WHEN (A11TUR = '1') THEN '1er Turno' " + " WHEN (A11TUR = '2') THEN '2do Turno' " + " ELSE '3er Turno' END A11TUR, " + " CASE WHEN A11OTR IN (0,99) THEN U.T01AL1 ELSE CC.T01AL1 END AS T01AL1,CC.ODTDES, " + " IsNULL(CASE WHEN (A11STT + ' - ' +A11EST) IN('S - D','J - D','G - D') THEN 'X Generar' " + " WHEN (A11STT + ' - ' + A11EST) IN('S - SP') THEN 'Generado Parcial' " + " WHEN (A11STT + ' - ' + A11EST) IN('S - 1') THEN 'x Firma' " + " WHEN (A11STT + ' - ' + A11EST) IN('S - 2') THEN 'x Firma Jef.' " + " WHEN (A11STT + ' - ' + A11EST) IN('S - 3') THEN 'x Firma Ger.' " + " WHEN (A11STT + ' - ' + A11EST) IN('S - S') THEN 'Generado' " + " END,'') ESTADO, (SELECT top 1 TRANOM FROM V_TRABAJ WHERE TRACVE=A11SOL) AS NOMBRE " + " FROM ALI011UTIL AS A11 LEFT OUTER JOIN " + " (SELECT ODTSTT, CAST(ODTCOD AS CHAR(3)) AS ODTCOD,CAST(ODTDPT AS CHAR(5)) AS ODTDPT,ODTDES, isnull(T01AL1,'') AS T01AL1 " + " FROM AIODET LEFT JOIN UGT01 ON (CAST(ODTDPT as CHAR(5)) = T01ESP AND T01IDT='CCT')) AS CC ON A11.A11OTR=CC.ODTCOD " + " LEFT OUTER JOIN (SELECT T01ESP,T01AL1 FROM UGT01 WHERE T01IDT='CCT') AS U ON CAST(A11.A11ARE as CHAR(5))=U.T01ESP " + " WHERE A11STT<>'E' AND A11TIP IN (" + (string)(Session["Condiciones"]) + ") AND A11EST='1' AND A11STT='S' " + " ORDER BY A11FSA DESC "; objTablas = new BTablas(); dtReq = objTablas.Query(SQL); dgvRequrimientos.DataSource = dtReq; dgvRequrimientos.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SQL = "SELECT CODUSE,CODEMP,NOMEMP FROM ALIUSERS"; objTablas = new BTablas(); dtUsuarios = objTablas.Query(SQL); dgvUsuarios.DataSource = dtUsuarios; dgvUsuarios.DataBind(); }
protected void dgvUsuarios_PageIndexChanging(object sender, GridViewPageEventArgs e) { dgvUsuarios.PageIndex = e.NewPageIndex; SQL = "SELECT CODUSE,CODEMP,NOMEMP FROM ALIUSERS"; objTablas = new BTablas(); dtUsuarios = objTablas.Query(SQL); dgvUsuarios.DataSource = dtUsuarios; dgvUsuarios.DataBind(); }
protected void cboTipoArt_SelectedIndexChanged(object sender, EventArgs e) { objTab = new BTablas(); SQL = "SELECT MPMCOD,MPMDES, " + "TRIM(T01AL1) AS T01AL1,MPMSCO,MPMSDI,MPMCPR, " + "MPMCDO,MPMUBI,MPMCCA,MPMPRO,MPMCTA " + "FROM ALMMMAP LEFT OUTER JOIN " + "(SELECT T01ESP,T01AL1,T01AL2,T01NU2 FROM UGT01 WHERE T01IDT='UND' AND T01NU2=1) AS M ON SUBSTR(DIGITS(MPMUNI),2,2)=M.T01ESP " + "WHERE MPMCTA='" + cboTipoArt.SelectedValue.Trim().ToString() + "' AND MPMSTT IN ('M','O')"; dtArt = objTab.Query(SQL); dgvConsulta.DataSource = dtArt; dgvConsulta.DataBind(); Session["DTART"] = dtArt; dv = new DataView(dtArt); Session["DVIEW"] = dv; }
protected void Button1_Click(object sender, EventArgs e) { FechaSis = DateTime.Now; tbldetalle = (DataTable)Session["CARRITO"]; if (txtOTR.Text == "") { lblError.Visible = true; lblError.Text = "Ingrese Orden de Trabajo"; return; } else { lblError.Visible = false; lblError.Text = ""; } if (dgvDetReq.Rows.Count == 0) { lblError.Visible = true; lblError.Text = "Ingrese Items"; return; } else { lblError.Visible = false; lblError.Text = ""; } int h = 0; string Hostmaquina = (string)Session["Usuario"].ToString().Trim(); // Environment.MachineName.ToUpper().Trim(); decimal codSolici = Convert.ToDecimal((string)Session["CodPlanilla"]); //switch (Hostmaquina) //{ // case "PCFME1": // objTablas = new BTablas(); // Nro = objTablas.Query("SELECT (MPTDES + 1) AS CORR FROM TEST1.ALMTALMWEB WHERE MPTTAB='NDI' AND MPTARG='" + Hostmaquina + "'").Rows[0]["CORR"].ToString().Trim(); // nroReq = Hostmaquina + " - " + Nro; // objTablas = new BTablas(); // h = objTablas.InUpDelTablas("UPDATE TEST1.ALMTALMWEB SET MPTDES='" + Nro + "' WHERE MPTTAB='NDI' AND MPTARG='" + Hostmaquina + "'"); // break; // case "PCFME2": // objTablas = new BTablas(); // Nro = objTablas.Query("SELECT (MPTDES + 1) AS CORR FROM TEST1.ALMTALMWEB WHERE MPTTAB='NDI' AND MPTARG='" + Hostmaquina + "'").Rows[0]["CORR"].ToString().Trim(); // nroReq = Hostmaquina + " - " + Nro; // objTablas = new BTablas(); // h = objTablas.InUpDelTablas("UPDATE TEST1.ALMTALMWEB SET MPTDES='" + Nro + "' WHERE MPTTAB='NDI' AND MPTARG='" + Hostmaquina + "'"); // break; // case "PCFME3": // objTablas = new BTablas(); // Nro = objTablas.Query("SELECT (MPTDES + 1) AS CORR FROM TEST1.ALMTALMWEB WHERE MPTTAB='NDI' AND MPTARG='" + Hostmaquina.Trim() + "'").Rows[0]["CORR"].ToString().Trim(); // nroReq = Hostmaquina + " - " + Nro; // objTablas = new BTablas(); // h = objTablas.InUpDelTablas("UPDATE TEST1.ALMTALMWEB SET MPTDES='" + Nro + "' WHERE MPTTAB='NDI' AND MPTARG='" + Hostmaquina + "'"); // break; // default: // objTablas = new BTablas(); // Nro = objTablas.Query("SELECT (MPTDES + 1) AS CORR FROM TEST1.ALMTALMWEB WHERE MPTTAB='NDI' AND MPTARG='PCOTR1'").Rows[0]["CORR"].ToString().Trim(); // nroReq = Hostmaquina + " - " + Nro; // objTablas = new BTablas(); // h = objTablas.InUpDelTablas("UPDATE TEST1.ALMTALMWEB SET MPTDES='" + Nro + "' WHERE MPTTAB='NDI' AND MPTARG='PCOTR1'"); // break; //} objTablas = new BTablas(); Nro = objTablas.Query("SELECT (COUNT(*) + 1) AS CORR FROM ali011util WHERE A11SOL=" + codSolici + "").Rows[0]["CORR"].ToString().Trim(); nroReq = Hostmaquina + " - " + Nro; fecha = FechaSis.ToShortDateString().Substring(6, 4) + FechaSis.ToShortDateString().Substring(3, 2) + FechaSis.ToShortDateString().Substring(0, 2); Hora = FechaSis.Hour.ToString() + FechaSis.Minute.ToString(); decimal hor1 = FechaSis.Hour; if (hor1 >= 7 && hor1 < 15) { turno = 1; } if (hor1 >= 15 && hor1 < 23) { turno = 2; } if ((hor1 >= 1 && hor1 < 7) || hor1 == 23 || hor1 == 24) { turno = 3; } GrabarCabecera(); GrabaDetalle(); Mensaje("Requerimiento " + nroReq + " ha sido generado"); }
protected void LoginButton_Click(object sender, EventArgs e) { BTablas objTablas = new BTablas(); DataTable dtPruebaUsuarios = new DataTable(); DataTable dtPermisosUsuarios = new DataTable(); string SQL = ""; if (Login1.UserName != "") { lblMensaje.Visible = false; //SQL = "SELECT CODUSE,TRANOM AS NOMEMP,CODEMP,DATCVE AS R99PUE,DATDES AS R99NPU,T01NU3 AS GERENCIA FROM LALMINGB.ALIUSERS LEFT OUTER JOIN " + // " adamperuv2.v_trabaj ON CODEMP=CAST(TRACVE AS DECIMAL(4,0)) LEFT OUTER JOIN " + // " LUGTF.UGT01 ON (T01IDT='CCT' AND DATCVE = T01ESP) WHERE CODUSE='" + Login1.UserName.ToUpper().Trim() + "' AND CODPWD='" + Login1.Password.ToUpper().Trim() + "'"; SQL = "SELECT CODUSE,TRANOM AS NOMEMP,CODEMP, " + " CASE WHEN ISNULL(IDOARE,'N')='N' THEN DATCVE ELSE IDOARE END AS R99PUE, " + " CASE WHEN ISNULL(IDOARE,'N')='N' THEN DATDES ELSE (SELECT T01AL1 FROM UGT01 WHERE T01IDT='CCT' AND T01ESP=IDOARE) END AS R99NPU, " + " ISNULL(T01NU3,0) AS GERENCIA " + " FROM ALIUSERS LEFT OUTER JOIN " + " v_trabaj ON CODEMP=CAST(TRACVE AS DECIMAL(4,0)) LEFT OUTER JOIN " + " UGT01 ON (T01IDT='CCT' AND DATCVE = T01ESP) LEFT OUTER JOIN " + " WEBING80 ON (codemp=IDOCOD) " + " WHERE CODUSE='" + Login1.UserName.ToUpper().Trim() + "' AND CODPWD='" + Login1.Password.ToUpper().Trim() + "'"; objTablas = new BTablas(); dtPruebaUsuarios = objTablas.Query(SQL); if (dtPruebaUsuarios.Rows.Count > 0) { lblMensaje.Visible = true; lblMensaje.Text = "Ingreso Correcto " + dtPruebaUsuarios.Rows[0]["NOMEMP"].ToString(); Session["Usuario"] = dtPruebaUsuarios.Rows[0]["CODUSE"].ToString(); Session["NombreUsu"] = dtPruebaUsuarios.Rows[0]["NOMEMP"].ToString(); Session["CodPlanilla"] = dtPruebaUsuarios.Rows[0]["CODEMP"].ToString(); Session["CodPuesto"] = dtPruebaUsuarios.Rows[0]["R99PUE"].ToString(); Session["Puesto"] = dtPruebaUsuarios.Rows[0]["R99NPU"].ToString(); Session["Gerencia"] = dtPruebaUsuarios.Rows[0]["GERENCIA"].ToString(); Session["indiceOpcion"] = "WUTIL"; SQL = "SELECT A15GER FROM ALI015UTIL WHERE A15USU='" + Login1.UserName.ToUpper().Trim() + "'"; objTablas = new BTablas(); dtPermisosUsuarios = objTablas.Query(SQL); string condiciones = "'N'"; if (dtPermisosUsuarios.Rows.Count > 0) { for (int i = 0; i <= dtPermisosUsuarios.Rows.Count - 1; i++) { if (i == 0) { condiciones = "'" + dtPermisosUsuarios.Rows[i]["A15GER"].ToString().Trim() + "'"; } else { condiciones =condiciones + "," + "'" + dtPermisosUsuarios.Rows[i]["A15GER"].ToString().Trim() + "'"; } } } Session["Condiciones"] = condiciones; Response.Redirect("~/WebMenuPrincipal.aspx"); } else { lblMensaje.Visible = true; lblMensaje.Text = "Usuario no tiene Acceso"; } } else { lblMensaje.Visible = true; lblMensaje.Text = "Ingrese Usuario y Contraseña"; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { A11NSA = Request.QueryString["A11NSA"]; SQL = "SELECT " + "ltrim(rtrim(A12COD)) as A12COD,ltrim(rtrim(MPMDES)) as MPMDES,A12CAS,ltrim(rtrim(M.T01AL1)) as T01AL1,A12CAD,A12IMP,A12IMD,A12PRO,A12CTA,A12CCA,MPMSCO,MPMSDI,MPMUBI,MPMCPR,MPMCDO, " + "CASE WHEN A11OTR IN (0,99) THEN U.T01AL1 ELSE CC.T01AL1 END AS AREA,CC.ODTDES,A11EST,A11STT, (SELECT top 1 TRANOM FROM V_TRABAJ WHERE TRACVE=A11SOL ) AS NOMBRE " + "FROM ALI012UTIL LEFT OUTER JOIN " + "ALMMMAP ON (A12COD=MPMCOD AND A12CTA=MPMCTA AND A12PRO=MPMPRO AND A12CCA=MPMCCA) LEFT OUTER JOIN " + "(SELECT T01ESP,T01AL1,T01AL2,T01NU2 FROM UGT01 WHERE T01IDT='UND' AND T01NU2=1) AS M ON SUBSTRING(CONVERT(VARCHAR(3),MPMUNI),1,2)=substring(M.T01ESP,1,2) " + "LEFT OUTER JOIN ALI011UTIL AS A11 ON A12NSA=A11NSA LEFT OUTER JOIN " + "(SELECT ODTSTT, CAST(ODTCOD AS CHAR(3)) AS ODTCOD,CAST(ODTDPT AS CHAR(5)) AS ODTDPT,ODTDES, ISNULL(T01AL1,'') AS T01AL1 " + "FROM AIODET LEFT JOIN UGT01 ON (CONVERT(VARCHAR(5),ODTDPT) = T01ESP AND T01IDT='CCT')) AS CC ON A11.A11OTR=CC.ODTCOD " + "LEFT OUTER JOIN (SELECT T01ESP,T01AL1 FROM UGT01 WHERE T01IDT='CCT') AS U ON CONVERT(VARCHAR(5),A11.A11ARE)=U.T01ESP " + "WHERE MPMSTT IN ('M','O') AND A12NSA= '" + A11NSA.Trim() + "'"; objTab = new BTablas(); dtRequerimiento = objTab.Query(SQL); txtArea.Text = dtRequerimiento.Rows[0]["AREA"].ToString(); txtOtr.Text = dtRequerimiento.Rows[0]["ODTDES"].ToString(); txtUsu1.Text = dtRequerimiento.Rows[0]["NOMBRE"].ToString(); Label1.Text = "Requerimiento : " + A11NSA; if (((string)(Session["Condiciones"]) != "'N'") && dtRequerimiento.Rows[0]["A11EST"].ToString().Trim() == "1" && dtRequerimiento.Rows[0]["A11STT"].ToString().Trim() == "S") { btnAprobar.Visible = true; btnDesaprueba.Visible = true; } else { btnAprobar.Visible = false; btnDesaprueba.Visible = false; } dgvRequrimientos.DataSource = dtRequerimiento; dgvRequrimientos.DataBind(); } }
/****/ protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { objTab = new BTablas(); dtComboTipoArt = objTab.Query("SELECT MPTARG,MPTDES FROM ALMTALM WHERE MPTTAB = 'CAI' AND MPTARG IN (10,11,12,13)"); cboTipoArt.DataSource = dtComboTipoArt; cboTipoArt.DataTextField = "MPTDES"; cboTipoArt.DataValueField = "MPTARG"; cboTipoArt.DataBind(); objTab = new BTablas(); SQL = "SELECT MPMCOD,MPMDES, " + "LTRIM(RTRIM(T01AL1)) AS T01AL1,MPMSCO,MPMSDI,MPMCPR, " + "MPMCDO,MPMUBI,MPMCCA,MPMPRO,MPMCTA " + "FROM ALMMMAP LEFT OUTER JOIN " + "(SELECT T01ESP,T01AL1,T01AL2,T01NU2 FROM UGT01 WHERE T01IDT='UND' AND T01NU2=1) AS M ON SUBSTRING(CONVERT(VARCHAR(3),MPMUNI),2,2)=M.T01ESP " + "WHERE MPMCTA IN (10,11,12,13) AND MPMSTT IN ('M','O')"; /*cambiamos esto por el servicio elegido*/ //dtArt = objTab.Query(SQL); ServUtiles = new ServiceUtiles.UtilesClient(); dtArt = ServUtiles.ListarArticulosUtiles(SQL); //objSerJava = new ServiceReference1.AlmacenOperacionesWSClient(); /****/ dgvConsulta.DataSource = dtArt; dgvConsulta.DataBind(); Session["DTART"] = dtArt; dv = new DataView(dtArt); Session["DVIEW"] = dv; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { objTab = new BTablas(); SQL = "SELECT CAST(ODTCOD AS CHAR(3)) AS ODTCOD,CAST(ODTDPT AS CHAR(5)) AS ODTDPT,ODTDES, isnull(T01AL1,'') AS T01AL1 " + " FROM AIODET LEFT JOIN UGT01 ON (CAST(ODTDPT AS CHAR(5)) = T01ESP AND T01IDT='CCT') WHERE odtdpt=0 ORDER BY ODTCOD "; dtOtr = objTab.Query(SQL); dgvConsulta.DataSource = dtOtr; dgvConsulta.DataBind(); Session["DTOTR"] = dtOtr; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { lblTitle.Text = "Modulo de Utiles"; switch (HttpContext.Current.Request.Url.LocalPath.ToString()) { case "/Utiles/Utiles/Sistemas/WebCambioContrasenaUtil.aspx": lblTitle.Text = "Cambio de Contraseña"; break; case "/Utiles/Utiles/Sistemas/WebConfiguracionUtil.aspx": lblTitle.Text = "Configuracion de Perfiles"; break; case "/Utiles/Utiles/Transaccion/WebSolicitudUtiles.aspx": lblTitle.Text = "Solicitud de Utiles"; break; case "/Utiles/Utiles/Transaccion/WebAprobacionReqUtiles.aspx": lblTitle.Text = "Aprobacion de Req.Utiles"; break; case "/Utiles/Utiles/Transaccion/WebConsultaSolicitudUtiles.aspx": lblTitle.Text = "Consulta de Requisiciones"; break; case "/Utiles/Utiles/Transaccion/WebConsultaConsumos.aspx": lblTitle.Text = "Consulta de Requisiciones"; break; default: lblTitle.Text = "Modulo de Utiles"; break; } if ((string)(Session["NombreUsu"]) == null || (string)(Session["NombreUsu"]) == "") { Response.Redirect("/WebLogin.aspx"); } else { lblUsuario.Text = (string)(Session["NombreUsu"]); } //ColocaR USUARIO NO OLVIDAR objTablas = new BTablas(); SQL = "SELECT * FROM WEBING71 WHERE IDAPLI='WEBLO'"; dtOpcionesPrincipales = objTablas.Query(SQL); if (dtOpcionesPrincipales.Rows.Count > 0) { MenuItem menuW = new MenuItem(); for (int i = 0; i <= dtOpcionesPrincipales.Rows.Count - 1; i++) { menuW = new MenuItem(); menuW.Value = dtOpcionesPrincipales.Rows[i]["IDOPCI"].ToString().Trim(); menuW.Text = dtOpcionesPrincipales.Rows[i]["IDDESW"].ToString().Trim(); MenuPrincipal.Items.Add(menuW); } } DataTable dtDataTable = null; switch ((string)(Session["indiceOpcion"]).ToString().Trim()) { case "WUTIL": dtDataTable = null; dtDataTable = objTablas.Query("SELECT * FROM WEBING72 WHERE IDOPCI='WUTIL' AND IDOUSU='" + (string)(Session["Usuario"]).ToString().Trim() + "' ORDER BY IDOPCH"); MyMenu.Items.Clear(); if (dtDataTable != null && dtDataTable.Rows.Count > 0) { foreach (DataRow drDataRow in dtDataTable.Rows) { if (Convert.ToInt32(drDataRow["IDOPCH"]) == Convert.ToInt32(drDataRow["IDOPAR"])) { MenuItem miMenuItem = new MenuItem(Convert.ToString(drDataRow["IDODES"]), Convert.ToString(drDataRow["IDOPCH"]), String.Empty, Convert.ToString(drDataRow["IDOURL"])); this.MyMenu.Items.Add(miMenuItem); AddChildItem(ref miMenuItem, dtDataTable); } } } break; case "WARCH": dtDataTable = null; dtDataTable = objTablas.Query("SELECT * FROM WEBING72 WHERE IDOPCI='WARCH' AND IDOUSU='" + (string)(Session["Usuario"]).ToString().Trim() + "' ORDER BY IDOPCH"); MyMenu.Items.Clear(); if (dtDataTable != null && dtDataTable.Rows.Count > 0) { foreach (DataRow drDataRow in dtDataTable.Rows) { if (Convert.ToInt32(drDataRow["IDOPCH"]) == Convert.ToInt32(drDataRow["IDOPAR"])) { MenuItem miMenuItem = new MenuItem(Convert.ToString(drDataRow["IDODES"]), Convert.ToString(drDataRow["IDOPCH"]), String.Empty, Convert.ToString(drDataRow["IDOURL"])); this.MyMenu.Items.Add(miMenuItem); AddChildItem(ref miMenuItem, dtDataTable); } } } break; } } }