private void Llenar_GVORG_REG_CAMP()
{
DB_AP_InscripcionOrg ListOrg = new DB_AP_InscripcionOrg();
GVOrg.DataSource = ListOrg.DB_Desplegar_ORG_REG_CAMP("LISTORGCAMPREG", 0, Convert.ToInt32(LblIdReg.Text), Convert.ToInt32(LblIdCamp.Text), LblProg.Text);
GVOrg.DataBind();
}
private void Desplegar_LISTA_ORGANIZACIONES()
{
DB_AP_InscripcionOrg iorg = new DB_AP_InscripcionOrg();
GVListaOrg.DataSource = iorg.DB_Desplegar_ORG_REG_CAMP("LISTA_OFICIAL_ORG", 0, Convert.ToInt32(DDLRegional.SelectedValue), Convert.ToInt32(DDLCamp.SelectedValue), DDLPrograma.SelectedValue);
GVListaOrg.DataBind();
}
protected void Llenar_ORGANIZACIONES_DESIGNADAS()
{
DB_AP_InscripcionOrg ListOrg = new DB_AP_InscripcionOrg();
DataTable dt = new DataTable();
dt = ListOrg.DB_Desplegar_ORG_REG_CAMP("LISTORGCAMPREG", 0, Convert.ToInt32(LblIdReg.Text), Convert.ToInt32(LblIdCamp.Text), LblProg.Text);
DDLOrgAsig.DataSource = dt;
DDLOrgAsig.DataValueField = "Id_InscripcionOrg";
DDLOrgAsig.DataTextField = "Personeria_Juridica";
DDLOrgAsig.DataBind();
}
private void Llenar_DDLOrganizacion()
{
DB_AP_InscripcionOrg Oreg = new DB_AP_InscripcionOrg();
DataTable dt = new DataTable();
dt = Oreg.DB_Desplegar_ORG_REG_CAMP("LIST_ORG_IDREG", 0, Convert.ToInt32(DDLRegional.SelectedValue), Convert.ToInt32(DDLCamp.SelectedValue), DDLPrograma.SelectedValue);
//DDLSigla.Items.Insert(0, new ListItem("Seleccione Organización", "0", true));
DDLSigla.DataSource = dt;
DDLSigla.DataValueField = "Id_InscripcionOrg";
DDLSigla.DataTextField = "Sigla";
DDLSigla.DataBind();
}
private void Seleccionar_ORG()
{
DB_AP_InscripcionOrg Oreg = new DB_AP_InscripcionOrg();
DataTable dt = new DataTable();
if (DDLSigla.SelectedValue != "")
{
dt = Oreg.DB_Desplegar_ORG_REG_CAMP("SELECT_ORG", Convert.ToInt32(DDLSigla.SelectedValue), Convert.ToInt32(DDLRegional.SelectedValue), Convert.ToInt32(DDLCamp.SelectedValue), DDLPrograma.SelectedValue);
LblDep.Text = dt.Rows[0][3].ToString();
LblPersonJuridi.Text = dt.Rows[0][1].ToString();
}
}
protected void GVLisOrg_RowDataBound(object sender, GridViewRowEventArgs e)
{
DB_AP_InscripcionOrg ino = new DB_AP_InscripcionOrg();
DataTable dt = new DataTable();
dt = ino.DB_Obtener_SUM_HA_NUM_PROD(Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "Id_InscripcionOrg")), "CONTADOR-OFICIAL");
if (e.Row.RowType == DataControlRowType.DataRow)
{
((Label)e.Row.FindControl("LblNumProd")).Text = dt.Rows[0][0].ToString();
}
}
protected void GVOrg_RowDataBound(object sender, GridViewRowEventArgs e)
{
DB_AP_InscripcionOrg io = new DB_AP_InscripcionOrg();
DataTable dt = new DataTable();
if (e.Row.RowType == DataControlRowType.DataRow)
{
string valor = DataBinder.Eval(e.Row.DataItem, "Id_InscripcionOrg").ToString();
int num = Convert.ToInt32(valor);
dt = io.DB_Obtener_SUM_HA_NUM_PROD(num, "CONTADOR-OFICIAL");
e.Row.Cells[6].Text = dt.Rows[0][0].ToString();
dt = io.DB_Obtener_SUM_HA_NUM_PROD(num, "OFICIAL");
if (dt.Rows[0][0].ToString() == "")
{
e.Row.Cells[7].Text = "0";
}
else
{
e.Row.Cells[7].Text = dt.Rows[0][0].ToString();
}
}
}
