public void loadPlantas()
{
//PLANTAS
Dictionary <string, object> parametersP = new System.Collections.Generic.Dictionary <string, object>();
//parametersP.Add("@ACTION", 2);
DataTable dtPlantas = dsAuditoria.executeStoreProcedureDataTable("spr_get_plants", parametersP);
CommonAudit.FillDropDownList(ref ddlPlanta, dtPlantas);
}
public void LoadPlants()
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
DataTable dt = dsAuditoria.executeStoreProcedureDataTable("spr_get_plants", parameters);
CommonAudit.FillDropDownList(ref DropDownList1, dt);
CommonAudit.FillDropDownList(ref ddlPlants, dt);
}
public void LoadExInt()
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@Action", 2);
parameters.Add("@English", (string)Session["Locale"] == "es-MX" ? 0 : 1);
DataTable dt = dsAuditoria.executeStoreProcedureDataTable("spr_Get_Module", parameters);
CommonAudit.FillDropDownList(ref ddlModulo, dt);
}
//carga niveles
public void cargarNiveles()
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@accion", 2);
parameters.Add("@idNivel", 0);
DataTable dt = dsAuditoria.executeStoreProcedureDataTable("spr_obtenerNiveles", parameters);
CommonAudit.FillDropDownList(ref cboxLevel, dt);
}
public void loadEncuestas()
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@accion", 3);
parameters.Add("@module", 4);
parameters.Add("@english", (string)Session["Locale"] == "es-MX" ? 0 : 1);
parameters.Add("@idEncuesta", 0);
DataTable dt = dsAuditoria.executeStoreProcedureDataTable("spr_obtenerEncuestas", parameters);
CommonAudit.FillDropDownList(ref DDLFilter, dt);
}
protected void ddlPlants_SelectedIndexChanged(object sender, EventArgs e)
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@english", (string)Session["Locale"] == "es-MX" ? 0 : 1);
parameters.Add("@idMaterial", 0);
parameters.Add("@accion", 5);
if (ddlPlants.SelectedIndex <= 0)
{
parameters.Add("@idPlanta", 0);
}
else
{
parameters.Add("@idPlanta", ddlPlants.SelectedValue);
}
DataTable dt = dsAuditoria.executeStoreProcedureDataTable("spr_obtenerMateriales", parameters);
CommonAudit.FillDropDownList(ref ddlEncuenta, dt);
}
