private void Datos_Org_ENCABEZADO()
{
DB_AP_Registro_Org d_org = new DB_AP_Registro_Org();
DataTable dt = new DataTable();
dt = d_org.DB_Desplegar_ENCABEZADO_ORG(Convert.ToInt32(LblIdInsOrg.Text));
LblOrg.Text = dt.Rows[0][2].ToString();
LblIdCamp.Text = dt.Rows[0][5].ToString();
LblProg.Text = dt.Rows[0][9].ToString();
LblIdReg.Text = dt.Rows[0][7].ToString();
DB_AP_Productor p = new DB_AP_Productor();
dt = p.DB_Seleccionar_ENCABEZADO_PROD(LblIdInsProd.Text, "DATS_PROD");
LblProductor.Text = dt.Rows[0][0].ToString() + " " + dt.Rows[0][1].ToString() + " " + dt.Rows[0][2].ToString();
}
protected void BtnRegistrar_Click(object sender, EventArgs e)
{
DB_AP_Productor InsProd = new DB_AP_Productor();
AP_Productor p = new AP_Productor();
foreach (GridViewRow dgi in GVProdIns.Rows)
{
TextBox tx = (TextBox)dgi.Cells[8].Controls[1];
GVProdIns.Columns[7].Visible = true;
Desplegar_PRODUCTOR_INS();
p.Id_Productor = GVProdIns.Rows[dgi.RowIndex].Cells[7].Text;
p.Observacion = tx.Text;
InsProd.DB_Modificar_OBSERVACION(p);
}
GVProdIns.Columns[7].Visible = true;
Desplegar_PRODUCTOR_INS();
//Session.Add("IdInsOrg", ((Label)contEncabezado21.FindControl("LblId_Org")).Text);
//Response.Redirect("repListaPreliminar.aspx");
}
protected void BtnRegistrar_Click(object sender, EventArgs e)
{
DB_AP_Productor InsProd = new DB_AP_Productor();
AP_Productor p = new AP_Productor();
GVProdIns.Columns[7].Visible = true;
foreach (GridViewRow dgi in GVProdIns.Rows)
{
Desplegar_PRODUCTOR_INS();
CheckBox myCheckBox = (CheckBox)dgi.Cells[8].Controls[1];
if (myCheckBox.Checked != true)
{
p.Id_Productor = GVProdIns.Rows[dgi.RowIndex].Cells[7].Text;
p.Estado = "APROBADO";
InsProd.DB_Modificar_ESTADO(p);
}
}
GVProdIns.Columns[7].Visible = false;
Modificar_INSCRIP_ORG(Convert.ToInt32(((Label)contEncabezado21.FindControl("LblId_Org")).Text));
Desplegar_PRODUCTOR_INS();
}
private void Datos_Org_ENCABEZADO()
{
DB_AP_Registro_Org d_org = new DB_AP_Registro_Org();
DataTable dt = new DataTable();
dt = d_org.DB_Desplegar_ENCABEZADO_ORG(Convert.ToInt32(LblIdInsOrg.Text));
LblOrg.Text = dt.Rows[0][2].ToString();
LblIdCamp.Text = dt.Rows[0][5].ToString();
LblCamp.Text = dt.Rows[0][6].ToString();
LblProg.Text = dt.Rows[0][9].ToString();
LblIdReg.Text = dt.Rows[0][7].ToString();
DB_AP_Productor p = new DB_AP_Productor();
dt = p.DB_Seleccionar_ENCABEZADO_PROD(LblIdInsProd.Text, "DATS_PROD");
LblProductor.Text = dt.Rows[0][0].ToString() + " " + dt.Rows[0][1].ToString() + " " + dt.Rows[0][2].ToString();
DB_EXT_Rendimiento ex = new DB_EXT_Rendimiento();
dt = ex.DB_Reporte_DETALLE_PLANILLA(Convert.ToInt32(LblIdInsOrg.Text), LblIdInsProd.Text, LblProg.Text, "VARIEDADESPROD");
TxtVariedad.Text = dt.Rows[0][0].ToString();
}
private void Datos_Org_ENCABEZADO()
{
DB_AP_Registro_Org d_org = new DB_AP_Registro_Org();
DataTable dt = new DataTable();
dt = d_org.DB_Desplegar_ENCABEZADO_ORG(Convert.ToInt32(LblIdInsOrg.Text));
LblOrg.Text = dt.Rows[0][2].ToString();
LblIdCamp.Text = dt.Rows[0][5].ToString();
LblCamp.Text = dt.Rows[0][6].ToString();
LblProg.Text = dt.Rows[0][9].ToString();
//LblProg.Text = "MAIZ";
LblIdReg.Text = dt.Rows[0][7].ToString();
DB_AP_Productor p = new DB_AP_Productor();
dt = p.DB_Seleccionar_ENCABEZADO_PROD(LblIdInsProd.Text, "DATS_PROD");
LblProductor.Text = dt.Rows[0][0].ToString() + " " + dt.Rows[0][1].ToString() + " " + dt.Rows[0][2].ToString();
LblSup.Text = dt.Rows[0][12].ToString();
LblComunidad.Text = dt.Rows[0][14].ToString();
LblMunicipio.Text = dt.Rows[0][15].ToString();
LblProvincia.Text = dt.Rows[0][16].ToString();
LblDepart.Text = dt.Rows[0][17].ToString();
}
private void Datos_Org_ENCABEZADO()
{
DB_AP_Registro_Org d_org = new DB_AP_Registro_Org();
DataTable dt = new DataTable();
dt = d_org.DB_Desplegar_ENCABEZADO_ORG(Convert.ToInt32(LblIdInsOrg.Text));
LblOrg.Text = dt.Rows[0][2].ToString();
LblIdCamp.Text = dt.Rows[0][5].ToString();
LblProg.Text = dt.Rows[0][9].ToString();
LblIdReg.Text = dt.Rows[0][7].ToString();
DB_AP_Productor p = new DB_AP_Productor();
dt = p.DB_Seleccionar_ENCABEZADO_PROD(LblIdInsProd.Text, "DATS_PROD");
LblProductor.Text = dt.Rows[0][0].ToString() + " " + dt.Rows[0][1].ToString() + " " + dt.Rows[0][2].ToString();
/***********************************************************/
DB_EXT_Fenologia numBol = new DB_EXT_Fenologia();
dt = numBol.DB_Datos_SIEMBRA(Convert.ToInt32(LblIdInsOrg.Text), "ARROZ", "VARIEDADES");
if (dt.Rows.Count > 0)
{
LblVariedad.Text = dt.Rows[0][0].ToString();
}
}
