//Métodos de Interfaz
public void IniciarValores()
{
Buscador.Rows.Clear();
Id = 0;
Nombre = string.Empty;
Version = 1.0;
Fecha = DateTime.Today.Date;
Descripcion = string.Empty;
Prioridad = 0;
Urgencia = 0;
Estabilidad = 0;
Estado = true;
Categoria = 0;
Comentario = string.Empty;
TiempoMedio = 0;
TiempoMaximo = 0;
OcurreMedio = 0;
OcurreMaximo = 0;
Autores.Rows.Clear();
Fuentes.Rows.Clear();
Objetivos.Rows.Clear();
Requisitos.Rows.Clear();
DatosEspeci.Clear();
BGrupo.Rows.Clear();
BObjetivos.Rows.Clear();
BFuentes.Rows.Clear();
BRequisitos.Rows.Clear();
}
public void Cargar(int id)
{
DataRow Requisito = ClsBaseDatos.BDTable("Select * from ReqInfo where Id = " + id + ";").Rows[0];
Id = int.Parse(Requisito[0].ToString());
Nombre = Requisito[1].ToString();
Version = (double)Requisito[2];
Fecha = (DateTime)Requisito[3];
Descripcion = Requisito[4].ToString();
TiempoMedio = int.Parse(Requisito[5].ToString());
TiempoMaximo = int.Parse(Requisito[6].ToString());
OcurreMedio = int.Parse(Requisito[7].ToString());
OcurreMaximo = int.Parse(Requisito[8].ToString());
Prioridad = int.Parse(Requisito[9].ToString());
Urgencia = int.Parse(Requisito[10].ToString());
Estabilidad = int.Parse(Requisito[11].ToString());
Estado = ((int)Requisito[12] == 1) ? true : false;
Categoria = int.Parse(Requisito[13].ToString());
Comentario = Requisito[14].ToString();
Autores = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqIAuto r where g.Id = r.IdAutor and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;");
Fuentes = ClsBaseDatos.BDTable("Select g.Id as Id, g.Nombre as Nombre from Grupo g, ReqIFuen r where g.Id = r.IdFuen and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;");
Objetivos = ClsBaseDatos.BDTable("Select o.Id as Id, o.Nombre as Nombre from Objetivos o, ReqIObj r where o.Id = r.IdObj and r.IdReq = " + Id + " Order By Categoria Desc, Nombre;");
Requisitos = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqInfo rn, ReqIReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqInfo + " Order By Categoria Desc, Nombre;");
DataTable TablaAux; DataRow Fila; DatosEspeci.Clear();
TablaAux = ClsBaseDatos.BDTable("Select Descrip from ReqIDatEsp where IdReq = " + Id + ";");
for (int i = 0; i <= (TablaAux.Rows.Count - 1); i++)
{
Fila = TablaAux.Rows[i];
DatosEspeci.Add(new ClsDatDG()
{
Descrip = Fila[0].ToString()
});
}
Requisitos.Rows.Clear();
TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqInfo rn, ReqIReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqInfo + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux);
TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqNFunc rn, ReqIReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqNFun + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux);
TablaAux = ClsBaseDatos.BDTable("Select rn.Id as Id, r.TipoReq as Tipo, rn.Nombre as Nombre from ReqFun rn, ReqIReqR r where rn.Id = r.IdReqr and r.IdReq = " + Id + " and r.TipoReq = " + DefValues.ReqFun + " Order By Categoria Desc, Nombre;"); CargarTablaReq(TablaAux);
BObjetivos = ClsBaseDatos.BDTable("Select Id,Nombre from Objetivos where Id not IN (select idObj from ReqIObj where idReq = " + Id + ") Order By Categoria Desc, Nombre;");
BGrupo = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdAutor from ReqIAuto where idReq = " + Id + ") Order By Categoria Desc, Nombre;");
BFuentes = ClsBaseDatos.BDTable("Select Id,Nombre from Grupo where Id not IN (select IdFuen from ReqIFuen where idReq = " + Id + ") Order By Categoria Desc, Nombre;");
}