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 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 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)
{
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;
}
}
}
