public DataTable ListarEquipo() { Cn = ObjCn.getConecta(); SqlDataAdapter da = new SqlDataAdapter("SP_LISTAEQUIPO", Cn); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public DataTable ListarProblemas() { Cn = ObjCn.getConecta(); SqlDataAdapter da = new SqlDataAdapter("SP_LISTAPROBLEMA", Cn); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public DataTable ListarFichaDevolucion() { Cn = ObjCn.getConecta(); SqlDataAdapter da = new SqlDataAdapter("SP_LISTAFICHADEVOLUCION", Cn); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public DataTable ListaCliente() { cn = objCon.getConecta(); SqlDataAdapter da = new SqlDataAdapter("sp_ListaClientes", cn); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public DataTable ListarSolucion(int id) { Cn = ObjCn.getConecta(); Cn.Open(); using (SqlTransaction tr = Cn.BeginTransaction(IsolationLevel.Serializable)) { SqlCommand cmd = new SqlCommand("SP_LISTASOLUCION", Cn, tr); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ProblemaId", SqlDbType.Int).Value = id; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } }
public DataTable ListarContratista() { Cn = ObjCn.getConecta(); SqlDataAdapter da = new SqlDataAdapter("SP_LISTARCONTRATISTA", Cn); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public DataTable ListarCliente() { Cn = ObjCn.getConecta(); SqlDataAdapter da = new SqlDataAdapter("SP_LISTACLIENTES", Cn); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
//listanto contratista public DataTable LISTACONTRATISTA() { cn = objCON.getConecta(); SqlDataAdapter da = new SqlDataAdapter("SP_LISTACONTRATISTA", cn); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public DataTable LlenarAvalas() { cn = objCon.getConecta(); cn.Open(); SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM tblmvTelefonoCliente", cn); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }