//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;"); }