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