protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("Entry");
Session["Login77"] = null;
if (!IsPostBack)
{
string LtxtSql = "EXEC SP_ACCESO_WEB 1,'','','','','',0, 0,0,0,'01-01-1','01-01-1'";
Session["D[BX"] = "";
Session["Nit77Cia"] = "";
Session["$VR"] = "";
Session["V$U@"] = "";
Session["P@$"] = "";
Session["NomCiaPpal"] = "";
Session["!dC!@"] = "0";
DdlNit.DataSource = Cnx.DSET(LtxtSql);
DdlNit.DataMember = "Datos";
DdlNit.DataTextField = "RazonSocial";
DdlNit.DataValueField = "CodNit";
ViewState["IniSes"] = "CIA";
ViewState["TablaIdioma"] = Idioma;
DdlNit.DataBind();
}
ScriptManager.RegisterClientScriptBlock(this, GetType(), "none", "<script>myFuncionddlP();</script>", false);
}
protected void BindDDdlDestino(string Tercero)
{
string LtxtSql = string.Format("EXEC SP_PANTALLA_Asignacion 3,'','','WEB','{0}',0,0,0,{1},'01-1-2009','01-01-1900','01-01-1900'", Tercero.ToString().Trim(), Session["!dC!@"]);
DdlBodDest.DataSource = Cnx.DSET(LtxtSql);
DdlBodDest.DataMember = "Datos";
DdlBodDest.DataTextField = "Bodega";
DdlBodDest.DataValueField = "CodUbicaBodega";
DdlBodDest.DataBind();
}
protected void BindBDdl()
{
string LtxtSql = string.Format("EXEC SP_TablasIngenieria 16,'','','','','','','','','AKRte',0,0,0,0,0,{0},'01-01-1','02-01-1','03-01-1'", Session["!dC!@"]);
DdlAeronave.DataSource = Cnx.DSET(LtxtSql);
DdlAeronave.DataMember = "Datos";
DdlAeronave.DataTextField = "Matricula";
DdlAeronave.DataValueField = "CodAeronave";
DdlAeronave.DataBind();
}
protected void BindBDdlBusq()
{
string LtxtSql = string.Format("EXEC SP_TablasGeneral 7,'','','','','','','','CatgrMel','DdlBus',0,0,0,0,0,{0},'01-01-1','02-01-1','03-01-1'", Session["!dC!@"]);
DdlBusq.DataSource = Cnx.DSET(LtxtSql);
DdlBusq.DataMember = "Datos";
DdlBusq.DataTextField = "NomModelo";
DdlBusq.DataValueField = "CodModelo";
DdlBusq.DataBind();
}
protected void BindPn()
{
string LtxtSql = string.Format("EXEC SP_PANTALLA_ADVICE 16,'','','','PN',0,0,0,{0},'01-1-2009','01-01-1900','01-01-1900'", Session["!dC!@"]);
DdlPN.DataSource = Cnx.DSET(LtxtSql);
DdlPN.DataMember = "Datos";
DdlPN.DataTextField = "PN";
DdlPN.DataValueField = "Codigo";
DdlPN.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login77"] == null)
{
if (Cnx.GetProduccion().Trim().Equals("Y"))
{
Response.Redirect("~/FrmAcceso.aspx");
}
}
ViewState["PFileName"] = System.IO.Path.GetFileNameWithoutExtension(Request.PhysicalPath); // Nombre del archivo
if (Session["C77U"] == null)
{
Session["C77U"] = "";
if (Cnx.GetProduccion().Trim().Equals("N"))
{
Session["C77U"] = Cnx.GetUsr(); //00000082|00000133
Session["D[BX"] = Cnx.GetBD(); //|DbNeoDempV2 |DbNeoAda | DbNeoHCT
Session["$VR"] = Cnx.GetSvr();
Session["V$U@"] = Cnx.GetUsSvr();
Session["P@$"] = Cnx.GetPas();
Session["N77U"] = Session["D[BX"];
Session["Nit77Cia"] = Cnx.GetNit(); // 811035879-1 TwoGoWo |800019344-4 DbNeoAda | 860064038-4 DbNeoHCT
Session["!dC!@"] = Cnx.GetIdCia();
Session["77IDM"] = Cnx.GetIdm();
Session["MonLcl"] = Cnx.GetMonedLcl(); // Moneda Local
Session["FormatFecha"] = Cnx.GetFormatFecha(); // 103 formato europeo dd/MM/yyyy | 101 formato EEUU M/dd/yyyyy
}
}
if (!IsPostBack)
{
ModSeguridad();
string LtxtSql = string.Format("EXEC SP_PANTALLA_Status 11,'','','','HK',0,0,0,{0},'01-1-2009','01-01-1900','01-01-1900'", Session["!dC!@"]);
DdlAk.DataSource = Cnx.DSET(LtxtSql);
DdlAk.DataTextField = "Matricula";
DdlAk.DataValueField = "CodAeronave";
DdlAk.DataBind();
BindPn("");
BindSn("");
MultVw.ActiveViewIndex = 0;
}
ScriptManager.RegisterClientScriptBlock(this, GetType(), "none", "<script>myFuncionddl();</script>", false);
}
//*********************Panel de procesar ******************************************
protected void BindCont()
{
string LtxtSql = "";
if (!TxtPrcsPn.Text.Trim().Equals(""))
{
LtxtSql = string.Format("EXEC SP_PANTALLA_Informe_Ingenieria 16,'{0}','','','ContPN',0,0,0,{1},'01-1-2009','01-01-1900','01-01-1900'", TxtPrcsPn.Text.Trim(), Session["!dC!@"]);
DdlPrcsCont.DataSource = Cnx.DSET(LtxtSql);
DdlPrcsCont.DataTextField = "CodContador";
DdlPrcsCont.DataValueField = "CodContador";
DdlPrcsCont.DataBind();
}
}
protected void GrdContdr_RowDataBound(object sender, GridViewRowEventArgs e)
{
Idioma = (DataTable)ViewState["TablaIdioma"];
PerfilesGrid();
string LtxtSql = "EXEC SP_TablasIngenieria 15,'','','','','','','','DdlContdr','',0,0,0,0,0,0,'01-01-1','02-01-1','03-01-1'";
if (e.Row.RowType == DataControlRowType.Footer)
{
DropDownList DdlContdrPP = (e.Row.FindControl("DdlContdrPP") as DropDownList);
DdlContdrPP.DataSource = Cnx.DSET(LtxtSql);
DdlContdrPP.DataTextField = "CodContador";
DdlContdrPP.DataValueField = "Cod";
DdlContdrPP.DataBind();
ImageButton IbtAddNew = (e.Row.FindControl("IbtAddNew") as ImageButton);
DataRow[] Result = Idioma.Select("Objeto= 'IbtAddNew'");
foreach (DataRow row in Result)
{
IbtAddNew.ToolTip = row["Texto"].ToString().Trim();
}
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
ImageButton imgD = e.Row.FindControl("IbtDelete") as ImageButton;
if (imgD != null)
{
DataRow[] Result = Idioma.Select("Objeto='IbtDelete'");
foreach (DataRow RowIdioma in Result)
{
imgD.ToolTip = RowIdioma["Texto"].ToString().Trim();
}
Result = Idioma.Select("Objeto= 'IbtDeleteOnClick'");
foreach (DataRow row in Result)
{
imgD.OnClientClick = string.Format("return confirm('" + row["Texto"].ToString().Trim() + "');");
}
}
}
}
